You are implementing a database on Azure SQL Database. The database will be used by a website hosted in Azure. The database has the following requirements: - Latency between the application and the da

Question

Options

• AEnable Geo-Restore.
• BDeploy a Standard Tier database.
• CDeploy a Basic Tier database.
• DEnable Standard Geo-Replication.
• EDeploy a Premium Tier database.

• A
  59% (22)
• B
  14% (5)
• D
  5% (2)
• E
  22% (8)

Explanation

You should deploy a Basic Tier database and enable Geo-Restore. Geo-Restore is the least expensive recovery solution and the only recovery solution supported at the Basic Tier. Geo- Restore supports point- in-time recovery for up to seven days and a recovery point objective (RPO) of one hour. It supports resilience against failure of a single region because the backup is stored in geo-redundant storage. Geo- Restore should not be used for mission-critical databases that are governed by a service level agreement (SLA) because a restore might take up to 24 hours depending on the number of databases being restored. You do not need to deploy a Standard Tier database. You would deploy a Standard Tier database if Standard Geo-Replication was required. At the Standard Tier, point-in-time recovery is supported for up to 14 days. Standard Geo-Replication has an RPO of five seconds. Standard Geo-Replication is a more expensive option and not required for this scenario. You do not need to deploy a Premium Tier database. A Premium Tier database supports Active Geo- Replication, which supports load balancing for read-only workloads and up to four secondary copies of the database. A Premium Tier database supports Standard Geo-Replication and Geo-Restore, but Premium Tier features are not required by this scenario and would be a more expensive option.

No community discussion yet for this question.