Correct Answer: To create readable secondary databases in different regions for disaster recovery and read scaling
Active Geo-Replication provides a continuous, asynchronous replication of database transactions to up to four readable secondary databases in different regions, making it ideal for...
Correct Answer
To create readable secondary databases in different regions for disaster recovery and read scaling
Why This Answer Is Correct
Active Geo-Replication provides a continuous, asynchronous replication of database transactions to up to four readable secondary databases in different regions, making it ideal for robust disaster recovery and regional read scaling.
This question evaluates your knowledge of Azure SQL Database — a core concept tested in Microsoft Certified: Azure Administrator Associate (AZ-104). Understanding Azure SQL Database is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.
A financial application requires a relational database that supports high availability and automated backups. The database must be fully managed to reduce operational overhead. Which service fits these requirements?
Which Azure SQL deployment option provides the highest degree of compatibility with an on-premises SQL Server and includes access to the underlying OS?
What are the two primary purchasing models for Azure SQL Database?
An administrator wants to manage a group of several Azure SQL Databases together to share a single set of resources (like CPU and RAM). Which feature should they use?
Which Azure SQL feature automatically scales compute based on workload demand and bills for compute used per second?