Domain 2.1: Relational Data
4 questions across 1 exam
Exams covering this topic
All questions (4)
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?
Practice these questions with detailed guidance
Full answers, grading, and explanations on why each answer is correct.
Expert