Secure, optimize, and deploy database solutions Questions
Practice questions for Secure, optimize, and deploy database solutions topic in Microsoft Certified: SQL AI Developer Associate. 74 questions covering this domain.
A CI/CD pipeline runs `SqlPackage` against Azure SQL Database. Which authentication method is recommended for automated environments when available?
An application cancels a long-running statement inside an explicit transaction and leaves the session sleeping with open locks. Which setting can redu...
A team needs historical Azure SQL Database resource data for approximately the last 14 days. Which view should they query from the `master` database?
An Azure Function must react to row changes in Azure SQL Database by using the Azure SQL trigger binding. Which SQL feature does the trigger rely on?
Which Data API builder configuration area is used to define field mappings, permissions, and relationships for a specific entity?
Which statement best distinguishes change tracking from change data capture?
A readable secondary replica executes many queries and the team wants Query Store data for that workload. Where is the Query Store data persisted when...
Which type of statements does Query Store collect plans for by design?
Which statement about change data capture is correct?
Which `SqlPackage` action incrementally updates an existing database so it matches the schema in a source `.dacpac`?
An administrator opens Query Performance Insight for an Azure SQL Database, but Query Store is disabled. What is the result?
A team builds a SQL database project from the command line. What is the default build artifact produced by the project?
Which view should be checked first for near-real-time resource usage in Azure SQL Database over roughly the past hour?
A developer wants a single JSON configuration file to expose database objects through automatic REST, GraphQL, and MCP endpoints. Which Microsoft tool...
A user needs to query database-scoped dynamic management views for troubleshooting. Which permission is required at the database scope?
A query suddenly regresses after the optimizer chooses a worse plan. Which Query Store capability can help restore the known good behavior without cha...
A release engineer wants a deployment artifact that contains schema for declarative publish operations, not a portability package with table data. Whi...
What is the main purpose of the target platform setting in a SQL database project's `.sqlproj` file?
A DBA wants Query Store to collect wait statistics in addition to plans and runtime stats. Which setting should be enabled?
Which Intelligent Query Processing feature in SQL Server 2022/2025 mitigates parameter sniffing by maintaining multiple plans for a single query param...
Sign in to see all 74 questions
Create a free account to browse all questions — completely free during our launch phase.