Microsoft Certified: Azure Database Administrator Associate Intermediate Practice Exam: Medium Difficulty 2025

Your organization is migrating an on-premises SQL Server database to Azure SQL Database. The database contains several stored procedures that use SQL Server Agent jobs for scheduled maintenance tasks. You need to ensure these scheduled tasks continue to run in Azure with minimal code changes. What should you implement?

You are configuring security for an Azure SQL Database that will be accessed by a web application running in Azure App Service. The security team requires that no SQL credentials be stored in application code or configuration files. The solution must use Azure AD authentication and follow the principle of least privilege. What should you configure?

You manage an Azure SQL Database that experiences variable workload patterns throughout the day. During business hours (8 AM to 6 PM), the database requires high compute resources, but usage drops significantly during off-hours. You need to optimize costs while maintaining performance during peak hours. What should you recommend?

You are monitoring an Azure SQL Database and notice that certain queries are running slower than expected. After reviewing Query Performance Insight, you identify that several queries have high CPU usage due to missing indexes. You want to implement a solution that automatically creates and drops indexes based on workload patterns. What should you enable?

Your company has implemented Transparent Data Encryption (TDE) on an Azure SQL Database using a customer-managed key stored in Azure Key Vault. The security team reports that they need to rotate the TDE protector key every 90 days. The database must remain online during the rotation. What steps should you take?

You need to implement a backup strategy for an Azure SQL Managed Instance that meets the following requirements: Point-in-time restore capability for up to 21 days, long-term retention of monthly backups for 5 years, and the ability to restore to a different Azure region. What should you configure?

You are implementing row-level security (RLS) for an Azure SQL Database used by a multi-tenant application. Each tenant should only see their own data based on a TenantID column. Users authenticate using Azure AD and their tenant membership is stored in the database. What is the correct approach to implement this security requirement?

Your Azure SQL Database is experiencing blocking issues during peak hours. You need to identify which queries are causing blocks and which sessions are being blocked. You want to automate the collection of this information for analysis. What should you implement?

You need to automate the deployment of index maintenance tasks across 50 Azure SQL Databases in an elastic pool. The maintenance should run weekly during off-peak hours and handle index fragmentation differently based on fragmentation level. What solution should you implement?

You are designing a high availability solution for a mission-critical Azure SQL Database. The solution must provide automatic failover with minimal data loss (RPO < 5 seconds) and minimal downtime (RTO < 30 seconds) in case of regional failure. The application must be able to read from a secondary replica. What should you configure?