Domain 2.1: Design a data storage solution for relational data

A retail enterprise is migrating a massive 80 TB on-premises SQL Server data warehouse to Azure. The database experiences highly unpredictable workloads, requiring rapid scaling of compute resources independent of storage. The company requires a fully managed PaaS solution. They do not use any legacy SQL Server features like CLR or cross-database distributed transactions. Which Azure SQL deployment option should you recommend?

You are designing the disaster recovery strategy for a mission-critical application backed by Azure SQL Database. The business requires an RPO (Recovery Point Objective) of less than 5 seconds and an RTO (Recovery Time Objective) of less than 1 hour. In the event of a regional outage, the database failover must happen automatically without requiring application connection strings to be updated. Which feature should you implement?

A media company is building a global content management system using Azure Database for PostgreSQL - Flexible Server. The application has a heavy read-to-write ratio (90% reads, 10% writes). Users in Europe and Asia are experiencing high latency when reading data, as the primary database is located in East US. You need to improve read performance for global users while maintaining high availability for the primary database in East US. Which TWO features should you configure? (Select TWO)

You are assessing an on-premises SQL Server 2014 database for migration to Azure. The application relies heavily on SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), and cross-database distributed transactions using Microsoft Distributed Transaction Coordinator (MSDTC). The company wants to minimize code changes during the migration. Which target architecture should you recommend?