This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Choose the best response for each of the questions below.
Which platform supports automatic index management?
Azure SQL Managed Instance
Azure SQL Database
SQL Server in an Azure VM
Which statistics option allows statistics to be updated while a query executes against the object the statistics are based on?
Auto Create Incremental Statistics
Auto Create Statistics
Auto Update Statistics Asynchronously
Which DMV shows the status of a plan updated by automatic tuning?
sys.dm_db_tuning_recommendations
sys.dm_db_automatic_tuning_options
sys.query_store_query
Which component of resource governor allows you to configure limits on system resources?
Workload groups
Classifier functions
Resource pools
You must answer all questions before checking your work.
Was this page helpful?