DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ29

Plan and implement data platform resources

You have an Azure SQL database.

You are reviewing a slowly performing query, as shown in the following exhibit.

Question Image

Select

Select the answer that correctly completes the sentence.

The exhibit shows . The operator in the execution plan indicates that the query would benefit from performance tuning.
Explanation

Live Query Statistics shows runtime operator progress and actual rows while a query is executing. A Key Lookup performs additional clustered-index retrievals after a nonclustered index seek; creating an appropriate covering index can eliminate those repeated lookups and improve performance.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!