Knowledge check

1.

Which platform supports automatic index management?

Azure SQL Managed Instance

Azure SQL Database

SQL Server in an Azure VM

2.

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

3.

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

4.

Which component of resource governor allows you to configure limits on system resources?

Workload groups

Classifier functions

Resource pools

Check your knowledge