You administer SQL Server on an Azure VM. You need to back up a database to Azure Blob Storage using SSMS. You have already created a storage account and a container. What is the next step in the SSMS backup wizard?

Select 'Disk' as the backup destination and enter the container URL.

Select 'URL' as the backup destination and provide the container URL and a SQL Server credential.

Mount the Blob Storage container as a local drive and back up to that drive.

Create a shared access signature (SAS) token and use it as the backup destination.

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

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

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

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

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

Which Azure SQL Database feature is used to retain backups for up to 10 years to meet regulatory compliance?

Long-term retention (LTR) policy

Point-in-time restore (PITR) retention

A company uses Azure SQL Database for a reporting application. The database has automated backups with a 35-day retention period. A user accidentally deleted a critical report at 11:45 AM. The administrator needs to restore the database to 11:44 AM, but the restore must not affect the current production database. What should the administrator do?

Use the Azure portal to export the production database as a .bacpac and import it back to the same database.

Perform a point-in-time restore to a new database with the time set to 11:44 AM, then point the reporting application to the new database.

Perform an in-place restore of the production database to 11:44 AM.

Restore the latest automated backup to the production database and then re-enter the deleted report.

A database is 2 TB and a full backup takes 4 hours. The business requirement is to minimize the time needed to restore the database after a disaster. Which backup strategy best meets this requirement?

Full backup plus file/filegroup backups taken weekly

Full backup plus differential backups taken daily

Full backup plus transaction log backups taken every hour

Microsoft Certified:Azure Database Administrator Associate

Domain 5Objective 2

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

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 6–10

6application · medium
You administer SQL Server on an Azure VM. You need to back up a database to Azure Blob Storage using SSMS. You have already created a storage account and a container. What is the next step in the SSMS backup wizard?
Select an answer first
7foundation · easy
Which T-SQL statement is used to restore a full database backup?
Select an answer first
8foundation · easy
Which Azure SQL Database feature is used to retain backups for up to 10 years to meet regulatory compliance?
Select an answer first
9expert · hard
A company uses Azure SQL Database for a reporting application. The database has automated backups with a 35-day retention period. A user accidentally deleted a critical report at 11:45 AM. The administrator needs to restore the database to 11:44 AM, but the restore must not affect the current production database. What should the administrator do?
Select an answer first
10foundation · easy
A database is 2 TB and a full backup takes 4 hours. The business requirement is to minimize the time needed to restore the database after a disaster. Which backup strategy best meets this requirement?
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.