Which view should be checked first for near-real-time resource usage in Azure SQL Database over roughly the past hour?

Asys.resource_stats

Bsys.dm_db_resource_stats

Csys.dm_exec_cached_plans

Dsys.database_query_store_options

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

An administrator opens Query Performance Insight for an Azure SQL Database, but Query Store is disab...

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.