Which T-SQL statement is used to restore a transaction log backup?

BACKUP LOG [MyDB] FROM DISK = 'C:\Backup\MyDB_log.bak'

RESTORE DATABASE [MyDB] FROM DISK = 'C:\Backup\MyDB_log.bak'

RESTORE LOG [MyDB] FROM DISK = 'C:\Backup\MyDB_log.bak' WITH NORECOVERY

RESTORE TRANSACTION [MyDB] FROM DISK = 'C:\Backup\MyDB_log.bak'

You need to restore a SQL Server database from a backup stored in Azure Blob Storage using SSMS. The backup file is in a container named 'backups'. You have a credential named 'AzureCred'. What should you do in the Restore Database task?

Use the 'From database' option and select the original database.

Download the backup file to a local folder and then restore from that folder.

Select 'URL' as the source and specify the backup file URL and the credential.

Select 'Device' as the source and browse to the container.

Microsoft Certified:Azure Database Administrator Associate

Domain 5Objective 2

Plan and Perform Backup and Restore of a Database DP-300 Practice Questions (Page 6)

Part of the Plan and configure a high availability and disaster recovery (HA/DR) environment domain, which accounts for 20–25% of the DP-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~8–16 in this domain), expect 3–5 from this objective — we provide 28 practice questions to prepare you well beyond it. (estimate)

28questions here

6free pages

10concepts

20–25%of the exam

Questions 26–28

26foundation · easy
Which T-SQL statement is used to restore a transaction log backup?
Select an answer first
27application · medium
You need to restore a SQL Server database from a backup stored in Azure Blob Storage using SSMS. The backup file is in a container named 'backups'. You have a credential named 'AzureCred'. What should you do in the Restore Database task?
Select an answer first
28foundation · easy
Which SQL Server restore option is used to restore a database to a specific point in time?
Select an answer first

Finished these 3 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to DP-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-300” is a trademark of its owner, used for identification only.

Plan and Perform Backup and Restore of a Database DP-300 Practice Questions (Page 6)

Questions 26–28

Which T-SQL statement is used to restore a transaction log backup?

You need to restore a SQL Server database from a backup stored in Azure Blob Storage using SSMS. The backup file is in a container named 'backups'. You have a credential named 'AzureCred'. What should you do in the Restore Database task?

Which SQL Server restore option is used to restore a database to a specific point in time?

Keep studying — Plan and configure a high availability and disaster recovery (HA/DR) environment