You need to choose a backup solution

You are managing an application. The application uses data that is stored in an Azure SQL database.
You must be able to reset the application to the state that existed on any day in the previous 35 days.
You need to choose a backup solution.
What should you do?

You are managing an application. The application uses data that is stored in an Azure SQL database.
You must be able to reset the application to the state that existed on any day in the previous 35 days.
You need to choose a backup solution.
What should you do?

A.
Run SQL replication on the SQL database once a day.

B.
Use Microsoft Azure SQL Database Point in Time Restore

C.
Use the SQL Server Data Tier Application Framework to build a data tier application (DAC) file once a day.

D.
Use the bcp utility to export data to an Azure page blob once a day.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Kok Leong

Kok Leong

Answer should be B. Point in time restore.