An administrator opens Query Performance Insight for an Azure SQL Database, but Query Store is disabled. What is the result?

AQuery Performance Insight continues to work by reading only DMVs

BQuery Performance Insight can't be used until Query Store is enabled

CQuery Performance Insight automatically enables Query Store

DOnly deadlock charts are shown

More Secure, optimize, and deploy database solutions Questions

74 questions

Full Microsoft Certified: SQL AI Developer Associate Practice Test

All topics covered

All Microsoft Certified: SQL AI Developer Associate Questions

Browse by topic

Related Questions

A team builds a SQL database project from the command line. What is the default build artifact produ...

easy

What is the main purpose of the target platform setting in a SQL database project's `.sqlproj` file?...

easy

Which `SqlPackage` action incrementally updates an existing database so it matches the schema in a s...

easy

Which view should be checked first for near-real-time resource usage in Azure SQL Database over roug...

easy

A team needs historical Azure SQL Database resource data for approximately the last 14 days. Which v...

medium

View all Secure, optimize, and deploy database solutions 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.