DP-300 Certification Practice Question #175

Question

You have an Azure SQL database.
You are reviewing a slow performing query as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

The execution plan in the exhibit displays real-time execution progress (such as "Estimated query progress: 100%" and operator progress details like "392 of 446 (87%)"), which identifies the display as Live Query Statistics. The Key Lookup operator in the plan indicates that the optimizer had to retrieve additional columns from the clustered index (table) because they were not covered by the nonclustered index used in the index seek. According to official Microsoft documentation, "the use of a Key Lookup operator in a query plan indicates that the query might benefit from performance tuning," which is typically achieved by creating a covering index.

More DP-300 practice questions