PdfPrep.com

You are implementing automatic tuning mode for Azure SQL databases

HOTSPOT

You are implementing automatic tuning mode for Azure SQL databases.

Automatic tuning is configured as shown in the following table.

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Automatic tuning options can be independently enabled or disabled per database, or they can be configured on SQL Database servers and applied on every database that inherits settings from the server. SQL Database servers can inherit Azure defaults for Automatic tuning settings. Azure defaults at this time are set to FORCE_LAST_GOOD_PLAN is enabled, CREATE_INDEX is enabled, and DROP_INDEX is disabled.

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

Exit mobile version