exam questions

Exam AZ-301 All Questions

View all questions & answers for the AZ-301 exam

Exam AZ-301 topic 2 question 36 discussion

Actual exam question from Microsoft's AZ-301
Question #: 36
Topic #: 2
[All AZ-301 Questions]

HOTSPOT -
You configure the Diagnostics settings for an Azure SQL database as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
learnazure63
Highly Voted 5 years ago
answers are correct. https://docs.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?tabs=azure-portal#streaming-export-destinations box-1 stream to event hub "View service health by streaming data to Power BI: Use Event Hubs, Stream Analytics, and Power BI to transform your diagnostics data into near real-time insights on your Azure services." box-2 azure sql analytics "Data streamed to a Log Analytics workspace can be consumed by SQL Analytics. SQL Analytics is a cloud only monitoring solution that provides intelligent monitoring of your databases that includes performance reports, alerts, and mitigation recommendations. "
upvoted 19 times
...
Ncam_Charlie
Highly Voted 5 years, 3 months ago
Option A is not correct because it says “clear Send to Log Analytics”, which means you are deselecting this option. If you deselect the option, then you are effectively saying do not use Log Analytics.
upvoted 10 times
000zest
5 years, 1 month ago
This. Also it says "Send to Log Analytics". When it asks for real time data, Stream would make more sense in the context of performaning "real time reporting"
upvoted 2 times
...
...
glam
Most Recent 4 years, 4 months ago
box-1 stream to event hub box-2 azure sql analytics
upvoted 4 times
...
sanketshah
4 years, 6 months ago
box-1 stream to event hub box-2 azure sql analytics correct answer
upvoted 3 times
...
macco455
4 years, 9 months ago
By using Event Hubs, Stream Analytics, and Power BI, you can easily transform your metrics and diagnostics data into near real-time insights on your Azure services. For an overview of how to set up an event hub, process data with Stream Analytics, and use Power BI as an output, see Stream Analytics and Power BI ANSWER IS CORRECT!!
upvoted 3 times
...
dethblow
5 years ago
SQL Health Check collects data from the following sources using the agent that you have enabled: Windows Management Instrumentation (WMI) Registry Performance counters SQL Server dynamic management view results Box 2 Data is collected on the SQL Server and forwarded to Log Analytics every seven days. https://docs.microsoft.com/en-us/azure/azure-monitor/insights/sql-assessment
upvoted 1 times
...
jcarlos
5 years, 1 month ago
Box 1: event hub is not supported as data source for Power BI dataset. Creating a dataset from an Event hub would require to create a data flow artifact which would lead to not real time monitoring. On the other hand, Blobs (storaga account) are supported as data source for a Power BI dataset. I would say answer for Box 1 is Select Archive to Storage account (The first two answer are "Clear ..." which seem to be not a valid option) https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources Box 2: Azure SQL Analytics https://docs.microsoft.com/en-us/azure/azure-monitor/platform/powerbi#overview (It can directly read all the diagnostic information from log analytics workspace)
upvoted 2 times
thoma
5 years ago
Box 1 SQL Database and Managed Instance diagnostics telemetry can be exported to 1. Log Analytics and SQL Analytics 2. Event Hubs 3. Azure Storage
upvoted 2 times
...
...
SaurabhAzure
5 years, 4 months ago
Even Option 1(Log Analytics) can be the correct answer: https://docs.microsoft.com/en-us/azure/azure-monitor/platform/powerbi#overview. We can feed Log Analytics workspace data to power BI I agree Option D is also correct but A is correct as well.
upvoted 1 times
Vaneck
5 years, 3 months ago
Answer is good https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-power-bi-dashboard
upvoted 2 times
tartar
4 years, 9 months ago
1. Event hub 2. Azure sql analytics
upvoted 3 times
...
...
chaudh
5 years ago
Log Analytics is not real-time
upvoted 4 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...