nerdexam
Microsoft

AZ-500 · Question #258

Your organization has a Microsoft SQL Server 2019 database. The database is hosted on an Azure virtual machine (VM). There is a web application that uses the database as its data store. The page…

The correct answer is C. Create a SQL Server Profiler trace. To identify which stored procedures are being called by a web application and causing slow performance, you should use SQL Server Profiler.

Submitted by ashley.k· Mar 6, 2026Secure compute, storage, and databases

Question

Your organization has a Microsoft SQL Server 2019 database. The database is hosted on an Azure virtual machine (VM). There is a web application that uses the database as its data store. The page speed of customers shopping is cart is noticeably slow. What will you do if you want tp know what stored is being called when customers access this page?

Options

  • AChoose Display Estimated Execution Plan from the Query menu.
  • BChoose Include Actual Execution Plan from the Query menu.
  • CCreate a SQL Server Profiler trace
  • DCall the SET SHOWPLAN TEXT statement in Query Analyzer.

How the community answered

(35 responses)
  • A
    9% (3)
  • B
    3% (1)
  • C
    71% (25)
  • D
    17% (6)

Why each option

To identify which stored procedures are being called by a web application and causing slow performance, you should use SQL Server Profiler.

AChoose Display Estimated Execution Plan from the Query menu.

Display Estimated Execution Plan shows the predicted execution plan for a single query without actually running it and does not capture real-time stored procedure calls made by an application.

BChoose Include Actual Execution Plan from the Query menu.

Include Actual Execution Plan shows the execution plan for a single query after it runs, but it is not designed to capture all stored procedure calls made by a web application across multiple user interactions.

CCreate a SQL Server Profiler traceCorrect

SQL Server Profiler allows you to capture and analyze database events in real-time or log them for later analysis, making it ideal for identifying which stored procedures are being executed and their performance characteristics when a specific application page is accessed.

DCall the SET SHOWPLAN TEXT statement in Query Analyzer.

Calling the SET SHOWPLAN TEXT statement provides a text-based estimated execution plan for a single query and, like other SHOWPLAN options, does not capture real-time execution of stored procedures across an application workload.

Concept tested: SQL Server performance monitoring and profiling

Source: https://learn.microsoft.com/en-us/sql/tools/sql-server-profiler/sql-server-profiler

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full AZ-500 Practice