Question 580
A production service can't correlate SQL failures with client-facing request latency. How should the team validate the selected design?
Explanation
Correct Answer
Application Insights complements database-level metrics by connecting application requests to dependencies. The observation “A sample slow API request can be traced to its database call and error details” directly confirms the chosen action worked for this situation: A production service can't correlate SQL failures with client-facing request latency.
Incorrect Answers
Logic Apps orchestrate external actions; the SQL change signal and connector privileges must be governed. This observation would not establish that the required result occurred for A production service can't correlate SQL failures with client-facing request latency. The confirming test is: A sample slow API request can be traced to its database call and error details.
CES can stream database changes to consumers; availability and supported scenarios vary by platform. This observation would not establish that the required result occurred for A production service can't correlate SQL failures with client-facing request latency. The confirming test is: A sample slow API request can be traced to its database call and error details.
DACPAC deployment synchronizes model schema under controlled configuration, not arbitrary unreviewed scripts. This observation would not establish that the required result occurred for A production service can't correlate SQL failures with client-facing request latency. The confirming test is: A sample slow API request can be traced to its database call and error details.