You administer an Azure SQL Database that runs in the S0 service tier. The database stored mission-criticaldata.
You must meet the following requirements:
minimize costs associated with hosting the database in Azure
minimize downtime in the event of an outage
protect the database from unplanned events
What should you do?
A.
Implement a secondary database in the paired region.
B.
Ensure that a secondary databases are online and readable at all times.
C.
Create a continuously replicated copy.
D.
Use backups in a geo-redundant Azure storage (GRS) location.
Explanation:
https://docs.microsoft.com/en-us/azure/storage/storage-redundancy#geo-redundant-storage
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automated-backups
0
0
Doesn’t S0 uses a GRS backup by default?
0
0
Yes
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automated-backups
“SQL Database automatically creates database backups and uses Azure read-access geo-redundant storage (RA-GRS) to provide geo-redundancy. ”
So this answer is crap?
0
0
minimize costs associated with hosting the database in Azure
So should be B
0
0
Geo-redundant backups are available to all service tiers, just the retention period is 7 days for Basic. However the recovery time and recovery point objective are not what you would use for “mission critical” data.
From a “business continuity” perspective the recommendation is for a mission critical database to be replicated.
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-business-continuity
Geo-replication is available to all tiers now, so that would be my answer, given the “mission critical” caveat.
https://azure.microsoft.com/en-us/blog/azure-sql-database-now-supports-powerful-geo-replication-features-on-all-service-tiers/
The actual answers are all very vague though, at a guess A because of the paired region meeting the “unplanned events” condition.
0
0
minimize costs is the first requirement. so maybe still go D…
0
0
Besides, part of new 243Q 70-533 dumps are available here:
https://drive.google.com/open?id=0B-ob6L_QjGLpfnV3MVl6X3pXOWw1Z3YtQUpJRVRiTkNkbGNFbVBNRXhjSkw3bWk1WHdYcW8
Best Regards!
0
0