What are the Azure default automatic tuning settings that new logical servers inherit?

ACREATE_INDEX on, DROP_INDEX on, FORCE_LAST_GOOD_PLAN off

BCREATE_INDEX off, DROP_INDEX off, FORCE_LAST_GOOD_PLAN on

CAll three options on

DAll three options off

More Monitor, configure, and optimize database resources Questions

44 questions

Full Microsoft Certified: Azure Database Administrator Associate Practice Test

All topics covered

All Microsoft Certified: Azure Database Administrator Associate Questions

Browse by topic

Related Questions

Which automatic tuning option is supported on Azure SQL Managed Instance?...

easy

Which monitoring technology is the lightweight replacement for SQL Trace and SQL Server Profiler?...

easy

What permission is generally required to query database-scoped dynamic management views for troubles...

easy

How does Intelligent Insights establish a performance baseline for an Azure SQL database?...

medium

A DBA wants to integrate Intelligent Insights with centralized monitoring. Which destinations are su...

medium

View all Monitor, configure, and optimize database resources questions

Educational Content — CertQnA practice questions are written against official exam objectives, covering the same domains tested on the real exam. All content is original and independent — not actual exam questions, not affiliated with any certification vendor. Learn more about our content policy

Discussion

Be the first to share your understanding of this concept

⚠️ Discussion is for concept clarification only. Do not share or request actual exam questions or answers.