A company runs a business-critical SQL Server database in Azure. The compliance team requires that the database be restorable to any point within the last 30 days, and that a copy of the database be retained for 7 years for audit purposes. The database is currently configured with automated backups and a default retention of 7 days. What should you do to meet both requirements with minimal administrative effort?

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

Enable geo-redundant backup storage and set automated backup retention to 7 years.

Take a manual full backup every day and store it in Azure Blob Storage for 7 years.

Increase automated backup retention to 30 days and configure long-term retention (LTR) for 7 years.

Which T-SQL clause is used to restore a database from a backup stored in Azure Blob Storage?

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

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

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

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

In Azure SQL Database, what does point-in-time restore (PITR) use to restore a database to a specific time?

Differential backups taken by the user

Transaction log backups taken by the user

A small business runs SQL Server 2019 on an Azure VM. The database is used for order processing and the business can tolerate up to 1 hour of data loss. They want to perform a one-time full backup to Azure Blob Storage using a native tool, without installing additional software. What should you do?

Use SQL Server Management Studio (SSMS) to back up the database to a URL that points to an Azure Blob Storage container.

Use the COPY_ONLY option with T-SQL to back up to a local disk, then manually upload to Blob Storage.

Use the Azure portal to export the database to a .bacpac file stored in Blob Storage.

Use Azure Backup to back up the SQL Server VM to a Recovery Services vault.

In SQL Server, which feature allows you to retain database backups for years to meet compliance requirements?

Maintenance Plan with backup cleanup

Backup to URL with a retention policy

Backup to Azure Blob Storage with lifecycle management

Microsoft Certified:Azure Database Administrator Associate

Domain 5Objective 2

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

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 11–15

11application · medium
A company runs a business-critical SQL Server database in Azure. The compliance team requires that the database be restorable to any point within the last 30 days, and that a copy of the database be retained for 7 years for audit purposes. The database is currently configured with automated backups and a default retention of 7 days. What should you do to meet both requirements with minimal administrative effort?
Select an answer first
12foundation · easy
Which T-SQL clause is used to restore a database from a backup stored in Azure Blob Storage?
Select an answer first
13foundation · easy
In Azure SQL Database, what does point-in-time restore (PITR) use to restore a database to a specific time?
Select an answer first
14application · medium
A small business runs SQL Server 2019 on an Azure VM. The database is used for order processing and the business can tolerate up to 1 hour of data loss. They want to perform a one-time full backup to Azure Blob Storage using a native tool, without installing additional software. What should you do?
Select an answer first
15foundation · easy
In SQL Server, which feature allows you to retain database backups for years to meet compliance requirements?
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.