Domain 2.1: Relational Data Storage

You are migrating an on-premises SQL Server database to Azure. The database is currently 12 TB in size and is expected to grow by 2 TB annually. The application relies heavily on SQL Server Agent jobs, cross-database queries, and legacy Common Language Runtime (CLR) assemblies. The business requires a fully managed PaaS solution to minimize administrative overhead. Which Azure data service should you recommend?

You are designing a disaster recovery solution for a mission-critical application backed by Azure SQL Database. The requirements are: - The database must automatically fail over to a secondary region if the primary region experiences an outage. - The application connection string must NOT need to be updated after a failover. - You must be able to offload read-only reporting queries to the secondary region. Which TWO features must you configure? (Select TWO)

You are designing an architecture for a new web application that uses Azure Database for PostgreSQL - Flexible Server. The application requires high availability with an SLA of 99.99%. In the event of an infrastructure failure, the database must fail over automatically with zero data loss (RPO = 0) and minimal downtime. Which high availability configuration should you recommend?

A company is migrating a third-party vendor application to Azure. The vendor explicitly states that the application requires sysadmin access to the database server, the ability to install custom third-party agents on the underlying operating system, and support for SQL Server Distributed Transaction Coordinator (MSDTC). Which database solution MUST you use?

A financial services company is migrating a legacy on-premises application to Azure. The application relies on a SQL Server database. The database heavily utilizes SQL Server Common Language Runtime (SQL CLR) integration, Service Broker, and cross-database transactions. The company wants to minimize administrative overhead for OS patching and backups, but cannot rewrite the application code. Which data storage solution should you recommend?

An e-commerce company is designing the database architecture for their new product catalog. The database is expected to grow rapidly and may exceed 50 TB within the first year. The application requires extremely fast storage scaling and the ability to nearly instantaneously scale out read workloads to multiple compute nodes during holiday sales. Which Azure SQL Database service tier should you recommend?

A global SaaS provider uses Azure Database for PostgreSQL - Flexible Server for their core application. The business requires a disaster recovery architecture that meets the following constraints: 1. The database must be replicated to a secondary Azure region. 2. In the event of a primary region failure, the application must be able to fail over to the secondary region. 3. During normal operations, the secondary region database must be accessible for read-only analytical queries to offload reporting workloads. Which TWO features should you configure to meet these requirements? (Select TWO)

You are designing the high availability architecture for a mission-critical application backed by Azure SQL Database. The application requires: - Automatic failover to a secondary region if the primary region goes down. - The application connection string must NOT require updating after a failover occurs. - Multiple databases must fail over together simultaneously. Which feature should you implement?

CASE STUDY: Tailspin Toys Tailspin Toys is a global manufacturing company with 50,000 employees across 30 countries. They currently operate a mix of on-premises infrastructure (500 servers across 5 data centers) and Azure (20 subscriptions with 100+ VMs and various PaaS services). Their annual IT budget is $50 million, with plans to migrate 70% of workloads to Azure within 2 years. Business Requirements: The company needs to reduce IT costs by 30%, improve disaster recovery (current RTO: 24 hours -> target: 2 hours), enhance security posture to meet ISO 27001 and SOC 2 compliance, and enable remote work for 80% of employees. All solutions must support future growth of 20% annually. Technical Constraints: Some legacy applications cannot be modified and must run on Windows Server 2012. Network connectivity requires 10 Gbps throughput to Azure with <20ms latency. GDPR compliance mandates that EU customer data must remain in European Azure regions. Tailspin Toys has a 15 TB on-premises SQL Server database that supports their core ERP system. You need to migrate this database to Azure. The solution must support the 2-hour RTO requirement, minimize administrative overhead, and support databases larger than 10 TB. Which data storage solution should you recommend?

You are designing the migration of an on-premises SQL Server database to Azure. The database relies heavily on SQL Server Agent jobs for nightly batch processing, uses Service Broker for message queuing, and requires cross-database queries. You want to minimize administrative overhead and avoid managing the underlying operating system. Which Azure data service should you recommend?

A retail company has an e-commerce application backed by an Azure SQL Database. During the holiday shopping season, read-heavy reporting queries run by the analytics team are causing performance degradation for customer transactions. You need to design a solution to isolate the reporting workload from the transactional workload without changing the application code for the transactional system. Which feature should you implement?

You are designing a high-availability architecture for an Azure Database for PostgreSQL Flexible Server. The application requires zero data loss (RPO = 0) and automatic failover in the event of a datacenter outage within the primary Azure region. The solution must minimize failover time. Which high availability configuration should you recommend?

You are migrating an on-premises SQL Server database to Azure. The database is 2 TB in size. The application relies heavily on SQL Server Agent jobs for nightly batch processing and uses cross-database queries between three different databases on the same instance. You need to recommend a PaaS database solution that minimizes migration effort and administrative overhead. Which service should you recommend?

A retail company is designing a new e-commerce platform. The backend relational database will be hosted on Azure SQL Database. The database is expected to grow rapidly, reaching 40 TB within the first year. The application requires highly consistent, sub-millisecond latency for reads and writes. Additionally, the architecture must support nearly instantaneous database backups and fast restores, regardless of the database size. Which Azure SQL Database service tier should you recommend?

You are designing a disaster recovery solution for a mission-critical application backed by Azure SQL Managed Instance. 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 primary region failure, the database failover must happen automatically without requiring connection string changes in the application code. Which TWO features must you configure? (Select TWO)

You are designing the architecture for an open-source application that requires a PostgreSQL database. The application will be deployed in the 'East US' region. You must ensure the database remains available even if an entire datacenter (Availability Zone) within the region goes offline. The solution must provide synchronous replication to ensure zero data loss (RPO = 0) during a zone failure, and automatic failover. Which Azure database service and configuration should you recommend?

A SaaS company hosts 500 separate Azure SQL Databases for its customers. The databases have unpredictable usage patterns; some are idle while others spike randomly. The company wants to optimize costs while ensuring performance during spikes. Which deployment option should you recommend?

You are migrating a legacy on-premises SQL Server application to Azure. The application relies heavily on SQL Server Agent jobs, cross-database queries, and CLR (Common Language Runtime) integration. The business requires a fully managed PaaS service to reduce OS maintenance overhead. Which service should you recommend?

You are designing a high-availability architecture for an Azure SQL Database. The application requires read-scale out to offload reporting queries, and it must automatically failover to a secondary region if the primary region goes offline. The application connection string cannot be changed during a failover. Which THREE features should you implement? (Select THREE)

You are designing an Azure Database for PostgreSQL Flexible Server solution. The application experiences heavy read traffic from reporting dashboards, which is impacting the performance of transactional writes. You need to improve the performance of the transactional workload. What should you recommend?