4 questions across 1 exam
CASE STUDY: Contoso migrating 500 servers to Azure. RTO 2h, RPO 15m, GDPR compliance, 10Gbps ExpressRoute required. QUESTION: You are designing the database architecture using Azure SQL Database. Which TWO features/tiers should you combine to meet the RPO and RTO requirements? (Select TWO)
You are migrating an on-premises SQL Server database to Azure. The application relies heavily on SQL Server Agent jobs, cross-database queries, and CLR integration. You need a PaaS solution with native VNet integration. Which service should you choose?
You are designing a highly available Azure Database for PostgreSQL solution. It must survive a zone failure with zero data loss (RPO=0) and automatic failover. Which TWO configurations should you select? (Select TWO)
An enterprise needs to migrate a 80 TB relational database to Azure. The database requires rapid scaling of compute and storage independently, and near-instantaneous database backups regardless of size. Which Azure SQL deployment option should you recommend?
Full answers, grading, and explanations on why each answer is correct.
Expert