Home » Microsoft » DP-200 v.2 » What should you use?
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
Correct Answer: D
Explanation/Reference:
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
