Database backup and geo-replication in Azure - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Geo-Replication Purpose

What is the primary benefit of enabling geo-replication for an Azure SQL Database?

A It provides a backup copy of the database in a different region for disaster recovery.

B It automatically scales the database compute resources based on usage.

C It encrypts the database data at rest and in transit.

D It compresses the database backups to save storage space.

💡 Hint

Think about what happens if the main region fails.

Geo-replication creates a readable secondary database in a different region to provide disaster recovery in case the primary region becomes unavailable.

❓ Configuration

intermediate

Configuring Automated Backups

Which Azure SQL Database setting controls the retention period for automated backups?

A Backup Retention Period

B Failover Group Configuration

C Backup Storage Redundancy

D Geo-Replication Mode

💡 Hint

It defines how long backups are kept before deletion.

The Backup Retention Period setting specifies how many days automated backups are stored, allowing point-in-time restore within that window.

❓ Architecture

advanced

Designing for High Availability with Geo-Replication

You need to design an Azure SQL Database solution that ensures minimal downtime during a regional outage. Which architecture best achieves this?

A Use geo-backups stored in the same region as the primary database.

B Use active geo-replication with readable secondary databases in multiple regions and configure automatic failover groups.

C Deploy a single database with zone-redundant configuration within one region.

D Use only automated backups with a 7-day retention period and restore manually if needed.

💡 Hint

Consider automatic failover and multiple regions.

Active geo-replication with failover groups provides automatic failover to a secondary region, minimizing downtime during outages.

❓ security

advanced

Securing Geo-Replicated Databases

Which practice ensures data security when using geo-replication for Azure SQL Databases?

A Store geo-replicated backups in public blob storage without access controls.

B Disable encryption to improve replication speed.

C Use unencrypted backups for faster restore times.

D Enable Transparent Data Encryption (TDE) on both primary and secondary databases.

💡 Hint

Think about protecting data at rest.

Transparent Data Encryption (TDE) encrypts data at rest on both primary and secondary databases, ensuring data security during geo-replication.

❓ service_behavior

expert

Behavior of Failover in Geo-Replication

During a failover event in an Azure SQL Database failover group, what happens to the DNS endpoint used by applications?

A The DNS endpoint is deleted and must be recreated after failover.

B The DNS endpoint remains pointed to the original primary database until manually updated.

C The DNS endpoint automatically redirects to the new primary database in the secondary region.

D The DNS endpoint switches to a random database in any region.

💡 Hint

Consider how applications maintain connectivity without changes.

The failover group DNS endpoint automatically redirects to the new primary database after failover, allowing applications to connect without changing connection strings.