Microsoft Certified: Azure Database Administrator Associate Practice Exam 2025: Latest Questions

You are deploying an Azure SQL Database for a new application. You need to ensure the database can be accessed from Azure services while still restricting access from the public internet. What should you configure?

You need to migrate an on-premises SQL Server database to Azure SQL Managed Instance with minimal changes to the application. The database uses SQL Server Agent jobs and cross-database queries. Which target should you choose?

You manage an Azure SQL Database. Users report that some queries have become significantly slower after a recent deployment, but you don't have a baseline of query plans. Which feature should you use first to identify regressed queries and recommend fixes?

You need a way to automatically restore an Azure SQL Database to a point in time to recover from accidental data changes. Which capability provides this?

Your organization requires that administrators authenticate to Azure SQL Database using Microsoft Entra ID (Azure AD) only. SQL logins must not be used. What should you do?

You notice high CPU utilization on an Azure SQL Database during business hours. Investigation shows many ad-hoc queries with similar shapes but different literal values. You want to reduce compilation overhead and improve plan reuse with minimal code changes. What should you do?

You must automate recurring index and statistics maintenance for multiple databases hosted in Azure SQL Managed Instance. The solution must run on a schedule without requiring an always-on VM. What should you use?

A team deployed an Azure SQL Database and enabled Private Link. Developers can connect from a VM in the same virtual network, but they cannot connect from their on-premises network over ExpressRoute. The private endpoint exists and is approved. What is the most likely missing configuration?

You run a mission-critical Azure SQL Database with strict RPO and RTO requirements across regions. You need a managed failover mechanism that supports automatic failover of a group of databases with a single read-write listener endpoint. What should you implement?

After migrating to Azure SQL Managed Instance, you observe frequent storage IO waits and slower-than-expected batch load performance. You want to identify whether the bottleneck is tempdb contention and mitigate it using platform-supported settings. What should you do?

You manage an Azure SQL Database. A security policy requires that only Azure AD users can connect to the database, and SQL logins must be prevented. What should you do?

You need to quickly identify long-running queries and blocking sessions in an Azure SQL Managed Instance without installing agents. Which built-in capability should you use?

You are creating an Azure SQL Database using the Azure portal and must ensure the database can restore to any point in time within the last 10 days. Which setting should you configure?

A workload on Azure SQL Database experiences intermittent CPU spikes and timeouts. You need to identify whether the spikes are caused by a regression in a query plan over the last week and remediate quickly. What should you use?

You must ensure that all data written to an Azure SQL Managed Instance is protected by encryption keys that are stored and managed in Azure Key Vault. Which feature should you configure?

You need to automate index and statistics maintenance on an Azure SQL Managed Instance every weekend with minimal operational overhead. What is the most appropriate solution?

A company wants to centrally manage secrets used by SQL logins for an application connecting to Azure SQL Database. The security team requires that secrets are never stored in application configuration files. What should you recommend?

An Azure SQL Database has frequent deadlocks. You need to capture deadlock graphs for later analysis with minimal performance overhead. Which option should you configure?

You are designing a disaster recovery solution for an Azure SQL Database used by a mission-critical application. The requirement is: in the event of a region outage, fail over to another region with an RPO close to zero and an RTO under one minute. What should you implement?

After migrating to Azure SQL Managed Instance, users report slower performance for parameterized queries compared to the on-premises SQL Server. You suspect parameter sensitivity (parameter sniffing) is causing suboptimal cached plans. You need a mitigation that requires minimal application changes. What should you do?

You need to deploy several Azure SQL Managed Instances to the same virtual network. Company policy requires that outbound traffic from the managed instances to on-premises resources must traverse an NVA for inspection. What should you configure to meet the requirement?

You must grant a developer group read-only access to a specific Azure SQL Database. The group must authenticate using Microsoft Entra ID, and you want to avoid managing SQL logins and passwords. What should you do first in the database?

After migrating a workload to Azure SQL Database, you see frequent waits on PAGEIOLATCH_* and high data IO percentage. You want to reduce IO latency without changing the application code. Which action should you take first?

You manage multiple Azure SQL Databases. Your organization wants automated email notifications when a database is approaching its storage limit so you can proactively increase size or clean up data. Which solution should you implement?

You have an Azure SQL Managed Instance that must support regional disaster recovery. The RPO requirement is less than 5 minutes and the RTO requirement is less than 30 minutes. The solution must minimize administrative effort. Which approach should you use?