You administer a Microsoft Azure SQL Database database in the US Central region named contosodb.
Contosodb runs on a Standard tier within the SI performance level.
You have multiple business-critical applications that use contosodb.
You need to ensure that you can bring contosodb back online in the event of a natural disaster in the US
Central region. You want to achieve this goal with the least amount of downtime.
Which two actions should you perform? Each correct answer presents part of the solution.
A.
Upgrade to S2 performance level.
B.
Use active geo-replication.
C.
Use automated Export.
D.
Upgrade to Premium tier.
E.
Use point in time restore.
F.
Downgrade to Basic tier.
Explanation:
B: The Active Geo-Replication feature implements a mechanism to provide database redundancy within
the same Microsoft Azure region or in different regions (geo-redundancy).
One of the primary benefits of Active Geo-Replication is that it provides a database-level disaster recovery
solution. Using Active Geo-Replication, you can configure a user database in the Premium service tier to
replicate transactions to databases on different Microsoft Azure SQL Database servers within the same or
different regions. Cross-region redundancy enables applications to recover from a permanent loss of a
datacenter caused by natural disasters, catastrophic human errors, or malicious acts.
D: Active Geo-Replication is available for databases in the Premium service tier only.Active Geo-Replication for Azure SQL Databasehttp://msdn.microsoft.com/en-us/library/azure/dn741339.aspx
Now the geo replication can be done in all tiers?
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-geo-replication-overview
yes all tiers can now do geo replication