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:

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:

Answer:

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



Leave a Reply 2

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


JDH

JDH

I think the Database Name should be the 2nd option not the 3rd.

mslover

mslover

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