Sample Questions from Azure Administrator (AZ-104)

Preview a few questions below — answers are revealed when you take the exam.

1. A team needs to migrate an on-premises SQL Server database to Azure SQL Database. They want to ensure minimal downtime and data loss during the migration. What approach should they take?

   • Use Azure Database Migration Service to perform an online migration with minimal downtime and data loss.
   • Export the database to a BACPAC file and import it into Azure SQL Database, ensuring minimal downtime and data loss.
   • Use Azure Site Recovery to replicate the on-premises SQL Server database to Azure SQL Database, ensuring minimal downtime and data loss.
   • Manually copy the database files to Azure Blob Storage and restore them into Azure SQL Database, ensuring minimal downtime and data loss.

2. Consider the situation where an Azure virtual machine (VM) is experiencing high CPU utilization. Which method solves it best?

   • Increase the VM size to a higher tier with more CPU resources.
   • Add more data disks to the VM to distribute the workload.
   • Configure auto-scaling to automatically adjust the number of VM instances based on CPU utilization.
   • Implement a load balancer to distribute traffic across multiple VMs.

3. Which option best evaluates the security posture of an Azure subscription?

   • Use Azure Security Center to assess and improve the security posture of the subscription.
   • Manually review all security configurations and policies within the subscription.
   • Rely on third-party security tools to evaluate the security posture of the subscription.
   • Use Azure Monitor to track security-related events and incidents within the subscription.

4. How should a professional assess the performance of an Azure App Service?

   • Use Azure Monitor to collect and analyze performance metrics such as CPU usage, memory usage, and request duration.
   • Manually review the application logs to identify performance bottlenecks.
   • Rely on user feedback to assess the performance of the application.
   • Use Azure Application Insights to track user interactions and identify performance issues.

5. What strategy should be applied when designing a disaster recovery plan for an Azure-hosted application?

   • Implement Azure Site Recovery to replicate the application to a secondary region for disaster recovery.
   • Manually back up the application data to Azure Blob Storage and restore it in case of a disaster.
   • Use Azure Traffic Manager to distribute traffic across multiple regions and ensure high availability.
   • Rely on Azure Backup to create regular backups of the application data for disaster recovery.