A company requires that a database can be restored to a state no more than 15 minutes before a failure. Which backup strategy should be used to meet this requirement?

Full backup plus differential backups taken every 12 hours

Full backup plus transaction log backups taken every 15 minutes

Full backup plus file backups taken daily

Which T-SQL statement is used to back up the transaction log of a database?

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

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

BACKUP DATABASE [MyDB] WITH LOG

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

A database administrator needs to restore a SQL Server 2019 database on an Azure VM from a full backup stored in Azure Blob Storage. The restore must be performed using a native tool and the database must be available as quickly as possible. What should the administrator do?

Use Azure Backup to restore the database from the Recovery Services vault.

Download the backup file to the VM's local disk, then restore from disk using SSMS.

Use SSMS to restore the database from URL, selecting the backup file in Blob Storage.

Use the Azure portal to import the database from the Blob Storage backup file.

A financial services company uses Azure SQL Database for a regulatory reporting system. The compliance team requires that database backups be retained for 5 years to meet audit requirements. Automated backup retention is currently set to 30 days. What should you configure to meet the 5-year retention requirement?

Enable geo-redundant backup storage.

Configure long-term retention (LTR) policy for the database with a 5-year retention.

Take manual full backups and store them in Azure Blob Storage.

Increase automated backup retention to 5 years.

Which T-SQL option allows SQL Server to back up a database directly to Azure Blob Storage?

TO DISK = 'https://mystorage.blob.core.windows.net/backups/MyDB.bak'

TO URL = 'https://mystorage.blob.core.windows.net/backups/MyDB.bak'

TO TAPE = 'https://mystorage.blob.core.windows.net/backups/MyDB.bak'

TO AZURE = 'https://mystorage.blob.core.windows.net/backups/MyDB.bak'

Microsoft Certified:Azure Database Administrator Associate

Domain 5Objective 2

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

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 1–5

1foundation · easy
A company requires that a database can be restored to a state no more than 15 minutes before a failure. Which backup strategy should be used to meet this requirement?
Select an answer first
2foundation · easy
Which T-SQL statement is used to back up the transaction log of a database?
Select an answer first
3application · medium
A database administrator needs to restore a SQL Server 2019 database on an Azure VM from a full backup stored in Azure Blob Storage. The restore must be performed using a native tool and the database must be available as quickly as possible. What should the administrator do?
Select an answer first
4application · medium
A financial services company uses Azure SQL Database for a regulatory reporting system. The compliance team requires that database backups be retained for 5 years to meet audit requirements. Automated backup retention is currently set to 30 days. What should you configure to meet the 5-year retention requirement?
Select an answer first
5foundation · easy
Which T-SQL option allows SQL Server to back up a database directly to Azure Blob Storage?
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.