A retail company has a web application that experiences intermittent slow response times. The development team suspects a specific database query is the bottleneck. They want to trace the exact query execution time and correlate it with user sessions. What should they implement?

Enable Azure Application Insights with SQL dependency tracking, and use the end-to-end transaction view to analyze the query duration within a specific user session.

Configure Azure Monitor Metrics to collect SQL query performance counters from the database server, and create a dashboard to visualize them.

Enable Azure SQL Analytics to collect query store data, and use the Azure portal to view query performance insights.

Use Azure Monitor Logs to query the AzureDiagnostics table for SQL errors, and create an alert rule for slow queries.

A financial services company must retain application logs for 7 years for regulatory compliance. They also need to stream real-time logs to a third-party SIEM for security monitoring. The SIEM vendor requires logs in a specific JSON format. What should you configure?

Send all logs to a Log Analytics workspace, set the retention to 7 years, and use a logic app to export logs to the SIEM hourly.

Send logs to an Azure Storage account with a 7-year retention policy, and configure a separate export to Azure Event Hubs for the SIEM to consume in real time.

Send logs to a Log Analytics workspace with 7-year retention, and use a diagnostic setting to stream the same logs to Event Hubs for the SIEM to consume in real time.

Send logs to an Azure Event Hubs namespace with a 7-year retention policy, and have the SIEM consume directly from the event hub.

A security analyst needs to find all failed sign-in attempts in the last 24 hours from a specific IP address. The sign-in logs are already being collected in a Log Analytics workspace. What should the analyst do?

Run a KQL query in the Log Analytics workspace that filters the SigninLogs table by time, IP address, and result type.

Use Azure Monitor Metrics to filter the sign-in logs by IP address.

Use Azure Storage Explorer to query the SigninLogs table in the storage account.

Open the Activity Log in the Azure portal and filter by IP address.

Which of the following is a configuration setting you must specify when creating a Log Analytics workspace?

Application Insights resource and instrumentation key

Azure Solutions Architect Expert

Domain 1Objective 1

Design Solutions for Logging and Monitoring AZ-305 Practice Questions (Page 7)

Part of the Design identity, governance, and monitoring solutions domain, which makes up ~30% of our current practice bank. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~15–24 in this domain), expect 5–8 from this objective — we provide 46 practice questions to prepare you well beyond it. (estimate)

46questions here

10free pages

11concepts

Questions 31–35

31application · medium
A retail company has a web application that experiences intermittent slow response times. The development team suspects a specific database query is the bottleneck. They want to trace the exact query execution time and correlate it with user sessions. What should they implement?
Select an answer first
32application · medium
A financial services company must retain application logs for 7 years for regulatory compliance. They also need to stream real-time logs to a third-party SIEM for security monitoring. The SIEM vendor requires logs in a specific JSON format. What should you configure?
Select an answer first
33foundation · easy
Which Azure service is commonly used to route logs to a third-party SIEM solution?
Select an answer first
34application · medium
A security analyst needs to find all failed sign-in attempts in the last 24 hours from a specific IP address. The sign-in logs are already being collected in a Log Analytics workspace. What should the analyst do?
Select an answer first
35foundation · easy
Which of the following is a configuration setting you must specify when creating a Log Analytics workspace?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to AZ-305

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “AZ-305” is a trademark of its owner, used for identification only.