Which three actions should you perform?

Posted by: Pdfprep Category: DP-200 Tags: , ,

You need to implement event processing by using Stream Analytics to produce consistent JSON documents.

Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

You need to ensure that the missing indexes for REPORTINGDB are added.

What should you use?
A . SQL Database Advisor
B . extended events
C . Query Performance Insight
D . automatic tuning

Answer: D

Explanation:

Automatic tuning options include create index, which identifies indexes that may improve performance of your workload, creates indexes, and automatically verifies that performance of queries has improved.

Scenario:

REPORTINGDB stores reporting data and contains server columnstore indexes.

Migrate SALESDB and REPORTINGDB to an Azure SQL database.

References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automatic-tuning

Leave a Reply

Your email address will not be published.