Optimize Performance MB-500 Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   Which of the following is a key benefit of using the Sandbox framework?

   • AAutomatic code deployment
   • BIncreased database storage capacity
   • CImproved user interface responsiveness
   • DReduced risk of breaking production systems
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   What is the primary purpose of creating an index on a table?

   • ATo store additional data
   • BTo enforce data integrity
   • CTo define relationships between tables
   • DTo enhance data retrieval performance
   Reveal Solution Discussion Select an answer first
4. 3expert · hard

   You are developing a new feature that involves executing untrusted code that could potentially cause data corruption. You need to test the feature in a controlled environment without affecting the production data. You also need to capture performance traces to ensure the feature does not introduce bottlenecks. What should you do?

   • AUse the Async framework to run the code asynchronously and hope that it does not affect other processes.
   • BRun the code in a development environment and rely on the debugger to catch issues.
   • CUse the Sandbox framework to execute the untrusted code in an isolated environment, and use Trace Parser to capture traces during the test.
   • DCreate a backup of the production database and run the code against the backup.
   Reveal Solution Discussion Select an answer first
5. 4expert · hard

   A customer reports that a monthly sales report is slow to render, but only when run by the sales manager. Other users running the same report do not experience the issue. You need to diagnose the problem. What should you do first?

   • ACheck the batch job history for the report's data refresh job.
   • BReview the report's data source query for missing indexes.
   • CIncrease the report's timeout value to allow more time for rendering.
   • DCapture a trace of the sales manager's session using Trace Parser.
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A batch job that processes purchase orders is running slowly. You need to identify the specific SQL queries that are causing the delay. You have access to the environment and can reproduce the issue. What should you do?

   • AUse the SQL Server Profiler to capture all queries on the database server.
   • BCheck the batch job's history to see the duration and status.
   • CReview the batch job's code to find the queries manually.
   • DUse Trace Parser to capture a trace while the batch job is running, then analyze the trace to find the slow queries.
   Reveal Solution Discussion Select an answer first