Don't forget to create account on our site to get access to more material made only for free registered user.  

Azure 70-532 Azure 70 533

Question : 10 You need to recommend a solution to meet the SQL Database restore requirement. Which of the following should you recommend?

  1.   You should recommend Azure SQL Database Active Geo-Replication.

  2.   You should recommend SQL Server Log Shipping.

  3.    You should recommend Microsoft Azure SQL Database Point in Time Restore.

  4.   You should recommend SQL Server Database Mirroring.

  5.   You should recommend SQL Server Data Synchronization.

Correct Answer : 3 Exp:  What is Point in Time Restore?

The Azure SQL Database service protects all databases with an automated backup system. These backups are retained for 7 days for Basic, 14 days for Standard and 35 days for Premium. Point-in-time restore is a self-service capability, allowing customers to restore a Basic, Standard or Premium database from these backups to any point within the retention period. Point-in-time restore always creates a new database. 

The database backups are taken automatically with no need to opt-in and no additional charges. You only incur additional cost if you use the restore capability. The new database created by restore is charged at normal database rates.  

Together, the automated backup system and point-in-time restore provide a zero-cost, zero-admin way to protect databases from accidental corruption or deletion, whatever the cause.

Understanding Automatic Backups : 

All Basic, Standard, and Premium databases are protected by automatic backups. Full backups are taken every week, differential backups every day, and log backups every 5 minutes. The first full backup is scheduled immediately after a database is created. Normally this completes within 30 minutes but it can take longer. If a database is "born big", for example if it is created as the result of database copy or restore from a large database, then the first full backup may take longer to complete. After the first full backup all further backups are scheduled automatically and managed silently in the background. Exact timing of full and differential backups is determined by the system to balance overall load. 

Backup files are stored locally in the same data center as your databases with local redundancy. When you restore a database, the required backup files are retrieved and applied. The latest weekly and daily backups are also copied to the paired region in the same geo-political area for disaster recovery purpose. These geo-redundant copies are used to enable geo-restore 


You have no rights to post comments