You administer a Microsoft Azure SQL Database data..
/ Interview Question Microsoft Azure • Managing Data in Azure SQL Database / by admin / Leave a comment
– You administer a Microsoft Azure SQL Database data base in the US Central region named contosodb.
– Contosodb runs on a Standard tier within the S1 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. Options:
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.
Answer: B, D 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.
http://msdn.microsoft.com/en-us/library/azure/dn741339.aspx