Free Microsoft Certified: Azure Database Administrator Associate Practice Test

Your organization is migrating an on-premises SQL Server database to Azure. The database is 500 GB in size and requires minimal downtime during migration. The database uses features compatible with Azure SQL Database. Which migration method should you recommend?

You need to implement Transparent Data Encryption (TDE) for an Azure SQL Database with customer-managed keys. Where should you store the encryption keys?

You are monitoring query performance for an Azure SQL Database. You notice that several queries are experiencing high CPU usage and long execution times. Which tool should you use first to identify the most resource-intensive queries?

Your company needs to automate the creation of weekly full database backups for an Azure SQL Managed Instance and store them in a separate Azure region for compliance purposes. What should you implement?

You are implementing a high availability solution for a mission-critical Azure SQL Database that requires automatic failover with minimal data loss. The solution must support read-scale workloads. Which service tier and feature should you configure?

You need to ensure that only specific Azure virtual machines can connect to your Azure SQL Database. The solution must not require managing IP addresses manually. What should you configure?

A database application is experiencing timeout errors during peak hours. You investigate and find that the DTU utilization reaches 100% frequently. The database is in the Standard S3 tier (100 DTUs). What should you do to resolve this issue with minimal cost increase?

You are implementing Azure Active Directory authentication for Azure SQL Database. Users report they cannot connect using their Azure AD credentials. You verify that Azure AD admin is configured on the server. What is the most likely cause?

Your company requires a complete audit trail of all data access and modifications in an Azure SQL Database for compliance purposes. The audit logs must be retained for 5 years and be tamper-proof. What should you implement?

You need to choose the appropriate Azure SQL deployment option for migrating a 10 TB SQL Server database that uses SQL Server Agent jobs, Database Mail, and cross-database queries. Which option should you select?

You are optimizing a stored procedure that takes 30 seconds to execute. After analyzing the execution plan, you identify a table scan on a large table. The WHERE clause filters on a column that is not indexed. What should you do first?

You need to implement an automated solution that scales an Azure SQL Database up during business hours (8 AM - 6 PM) and scales down during off-hours to reduce costs. What should you use?

An application team reports that queries against a specific table are slow. You check and find that the table has 15 nonclustered indexes. The table experiences frequent INSERT and UPDATE operations. What is the most likely cause of the performance issue?

You are designing a disaster recovery solution for Azure SQL Database. The RTO (Recovery Time Objective) is 1 hour and RPO (Recovery Point Objective) is 10 minutes. The solution must minimize management overhead. What should you implement?

You need to mask sensitive credit card data in an Azure SQL Database for non-production users while allowing production application access to unmasked data. What security feature should you implement?

Your Azure SQL Database is experiencing blocking issues. Multiple sessions are waiting on locks held by other sessions. Which Dynamic Management View (DMV) should you query to identify the blocking chain and the head blocker?

You are planning to deploy an Azure SQL Database that will store healthcare data subject to HIPAA compliance. Which Azure SQL Database feature must you enable to meet encryption-at-rest requirements?

You need to copy an existing Azure SQL Database to a new database in the same logical server for testing purposes. The copy must be transactionally consistent. What should you use?

You are implementing automatic tuning for an Azure SQL Database. The database has highly variable workload patterns. Which automatic tuning options should you enable to improve performance without manual intervention?

Your company needs to implement a solution where developers can create and destroy test databases from a template Azure SQL Database on-demand. The solution must minimize costs and provisioning time. What should you implement?