Administering Microsoft Azure SQL Solutions Questions and Answers
Question 49
Which windowing function should you use to perform the streaming aggregation of the sales data?
Options:
A.
Sliding
B.
Hopping
C.
Session
D.
Tumbling
Answer:
D
Explanation:
Explanation:
Scenario: The sales data, including the documents in JSON format, must be gathered as it arrives and analyzed online by using Azure Stream Analytics. The analytics process will perform aggregations that must be done continuously, without gaps, and without overlapping.
Tumbling window functions are used to segment a data stream into distinct time segments and perform a function against them, such as the example below. The key differentiators of a Tumbling window are that they repeat, do not overlap, and an event cannot belong to more than one tumbling window.
Which counter should you monitor for real-time processing to meet the technical requirements?
Options:
A.
SU% Utilization
B.
CPU% utilization
C.
Concurrent users
D.
Data Conversion Errors
Answer:
B
Explanation:
Explanation:
Scenario: Real-time processing must be monitored to ensure that workloads are sized properly based on actual usage patterns.
To monitor the performance of a database in Azure SQL Database and Azure SQL Managed Instance, start by monitoring the CPU and IO resources used by your workload relative to the level of database performance you chose in selecting a particular service tier and performance level.