SIMULATION - You have a web app that connects to an Azure SQL Database named db1. You need to configure db1 to send Query Store runtime statistics to Azure Log Analytics. To complete this task, sign in to the Microsoft Azure portal.
Suggested Answer:See explanation below.
To enable streaming of diagnostic telemetry for a single or a pooled database, follow these steps: 1. Go to Azure SQL database resource. 2. Select Diagnostics settings. 3. Select Turn on diagnostics if no previous settings exist, or select Edit setting to edit a previous setting. You can create up to three parallel connections to stream diagnostic telemetry. 4. Select Add diagnostic setting to configure parallel streaming of diagnostics data to multiple resources. 5. Enter a setting name for your own reference. 6. Select a destination resource for the streaming diagnostics data: Archive to storage account, Stream to an event hub, or Send to Log Analytics. 7. For the standard, event-based monitoring experience, select the following check boxes for database diagnostics log telemetry: QueryStoreRuntimeStatistics 8. For an advanced, one-minute-based monitoring experience, select the check box for Basic metrics. 9. Select Save. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure
Provided simulation step-by-step guidance is correct.
I reproduced it in my subscription:
1.Log in to AZ portal and navigate to the AZ SQL database
2. All resources and make sure that there is a Log Analytics Workspace, if no => create one
3. Under Monitoring -> Diagnosstic settings
4. + Add diagnostic setting
5. Give the diagnostic setting a name
6. Check Query Store Runtime Statistics
7. Check basic
8. Check Send to Log Analytics workspace and select the Log Analytics Workspace (if now space exists, you have to 1 create new one and return back here, as no option to creaet one directly from this step)
9. Save
not sure if you're correct. Examtopics Members comment on AZ-400 general discussion differently.. see: https://www.examtopics.com/exams/microsoft/az-400/
NO LAB on 6/21 - 9 am IST -
1 Case study , 6 new Q
1 YES NO series was new - 3 Q - I answered all No , because 2 will No and 1 Y
JOB A depends JOB B
JOB B on JOB C
JOB C on JOB D
who is dependent , who can run parallel
3 yes/ no
1. Sign in to the Azure portal
2. Select the Azure SQL Database
3. Configure Log Analytics integration > Diagnostic Settings
4. Enable Query Store data collection
Right?
Configure this from the Diagnostic settings of the SQL database
https://docs.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?tabs=azure-portal#configure-the-streaming-export-of-diagnostic-telemetry
Yeah, because Microsoft make more money if you do :)
upvoted 4 times
...
...
...
This section is not available anymore. Please use the main Exam Page.AZ-400 Exam Questions
Log in to ExamTopics
Sign in:
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.
yana_b
Highly Voted 1 year, 8 months agophantom31
11 months, 1 week agopeekingpicker
1 year, 7 months agoSTH
Highly Voted 3 years, 1 month agociscogeek
1 year, 11 months agodeltarj
3 years agoGeraldod
1 year, 6 months agoChristian_garcia_martin
Most Recent 3 months agochakanirban
10 months, 1 week agorenzoku
1 year, 9 months agoGovcomm
2 years, 9 months agordemontis
3 years agoapek88
3 years, 7 months agobimbokeem
3 years, 8 months agok8smaster
3 years, 9 months agoSTH
3 years, 1 month agoham56141
2 years, 3 months ago