Database backup and geo-replication in Azure - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the main purpose of database backup in cloud services?

Database backup creates a copy of your data to protect against accidental loss, corruption, or disasters. It helps you restore your database to a previous state if needed.

beginner

Explain geo-replication in the context of cloud databases.

Geo-replication means copying your database to multiple locations around the world. This improves availability and disaster recovery by allowing users to access data from the nearest location.

intermediate

What is the difference between automated backups and manual backups in Azure SQL Database?

Automated backups happen regularly without user action and are stored for a retention period. Manual backups are user-initiated exports or copies that you control directly.

intermediate

How does geo-replication help in reducing latency for users?

By placing copies of the database closer to users in different regions, geo-replication reduces the time it takes for data to travel, making access faster and improving user experience.

advanced

What is the role of the recovery point objective (RPO) in database backup strategies?

RPO defines the maximum acceptable amount of data loss measured in time. It helps decide how often backups or replications should happen to meet business needs.

What does geo-replication primarily improve in cloud databases?

A Database schema design

B User interface design

C Data availability and disaster recovery

D Cost of storage

Geo-replication copies data across regions to improve availability and disaster recovery.

Which backup type in Azure SQL Database happens automatically without user intervention?

A Manual backup

B Automated backup

C On-demand export

D Snapshot backup

Automated backups are scheduled and managed by Azure without user action.

What does the recovery point objective (RPO) measure?

A Maximum data loss allowed in time

B Maximum downtime allowed

C Backup storage size

D Network latency

RPO defines how much data loss in time is acceptable after a failure.

Why is geo-replication useful for users in different geographic locations?

A It reduces latency by serving data from nearby regions

B It increases the size of the database

C It changes the database schema automatically

D It encrypts data for security

Serving data from closer regions reduces delay and improves speed.

Which of the following is NOT a benefit of database backups?

A Data recovery after accidental deletion

B Disaster recovery support

C Protection against data corruption

D Improved query performance

Backups protect data but do not directly improve query performance.

Describe how geo-replication works and why it is important for cloud databases.

Think about how having data in different places helps users and protects data.

Explain the difference between automated and manual backups in Azure SQL Database and when you might use each.

Consider who controls the backup timing and why.