PrepAway - Latest Free Exam Questions & Answers

Which three actions should you perform in sequence?

DRAG DROP
You have an application that uses an Azure SQL Database.
The database becomes corrupt and is not usable.
You must configure point in time recovery to replace the database.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of
actions to the answer area and arrange them in the correct order.
Select and Place:

PrepAway - Latest Free Exam Questions & Answers

Answer:

Explanation:
https://azure.microsoft.com/en-gb/blog/azure-sql-database-point-in-time-restore/

2 Comments on “Which three actions should you perform in sequence?

    1. mslover says:

      1. Open database.
      2. Create a new name.
      3. Perform a restore.

      The restored database requires a new name to start the restore.

      “Restoring a database always creates a new database on the same server as the original database, so the restored database must be given a new name.”

      https://azure.microsoft.com/en-gb/blog/azure-sql-database-point-in-time-restore/

      You can rename the restored database after the restore is complete if this is needed.

      “You can rename the original database and then give the restored database the original name using the ALTER DATABASE command in T-SQL.”

      https://docs.microsoft.com/en-us/azure/sql-database/sql-database-recovery-using-backups#point-in-time-restore




      0



      0

Leave a Reply