Which T-SQL statement is used to perform a full database backup?

BACKUP DATABASE [MyDB] TO DISK = 'C:\Backup\MyDB.bak'

CREATE DATABASE [MyDB] AS COPY OF [MyDB]

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

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

A retail company uses an Azure SQL Database for its order processing system. The database is about 500 GB. The business has a recovery point objective (RPO) of 15 minutes and a recovery time objective (RTO) of 2 hours. A developer accidentally deletes a large batch of orders. You need to restore the database to a point just before the deletion. What is the most efficient way to meet the RPO and RTO?

Restore the latest full backup and then apply all transaction log backups.

Restore the database to a point in time using the Azure portal.

Copy the database using the Azure portal and then delete the unwanted data.

Use the Azure CLI to restore the database from a geo-redundant backup.

You administer an Azure SQL Managed Instance. A user accidentally drops a table, and you need to restore the database to a point 10 minutes before the drop. The database is currently using automated backups with a 7-day retention. What should you do first?

Restore the database from a geo-redundant backup.

Take a manual full backup using SSMS and then restore it.

Restore the database using the Azure portal's point-in-time restore option.

Use T-SQL RESTORE with the FROM DATABASE_SNAPSHOT option.

What is required to back up a SQL Server database to Azure Blob Storage using T-SQL?

An Azure Active Directory admin for the SQL Server

A shared access signature (SAS) token

A certificate installed on the SQL Server

A SQL Server login with sysadmin privileges

A company has an Azure SQL Database with automated backups configured for 35 days. At 10:00 AM, an application bug corrupts data. The corruption is discovered at 2:00 PM. You need to restore the database to a state as close as possible to the moment before the corruption. What should you do?

Restore to a point in time of 9:59 AM using the Azure portal.

Restore the latest automated backup and then apply transaction log backups manually.

Restore from the latest geo-redundant backup.

Use the Azure CLI to restore the database to the current time.

Microsoft Certified:Azure Database Administrator Associate

Domain 5Objective 2

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

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 21–25

21foundation · easy
Which T-SQL statement is used to perform a full database backup?
Select an answer first
22application · medium
A retail company uses an Azure SQL Database for its order processing system. The database is about 500 GB. The business has a recovery point objective (RPO) of 15 minutes and a recovery time objective (RTO) of 2 hours. A developer accidentally deletes a large batch of orders. You need to restore the database to a point just before the deletion. What is the most efficient way to meet the RPO and RTO?
Select an answer first
23application · medium
You administer an Azure SQL Managed Instance. A user accidentally drops a table, and you need to restore the database to a point 10 minutes before the drop. The database is currently using automated backups with a 7-day retention. What should you do first?
Select an answer first
24foundation · easy
What is required to back up a SQL Server database to Azure Blob Storage using T-SQL?
Select an answer first
25application · medium
A company has an Azure SQL Database with automated backups configured for 35 days. At 10:00 AM, an application bug corrupts data. The corruption is discovered at 2:00 PM. You need to restore the database to a state as close as possible to the moment before the corruption. What should you do?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back 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.