- (Exam Topic 1)
You need to provide an implementation plan to configure data retention for ResearchDB1. The solution must meet the security and compliance requirements.
What should you include in the plan?

1. A. Configure the Deleted databases settings for ResearchSrvOL
2. B. Deploy and configure an Azure Backup server.
3. C. Configure the Advanced Data Security settings for ResearchDBL
4. D. Configure the Manage Backups settings for ResearchSrvOL

Correct Answer: D
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/long-term-backup-retention-configure

- (Exam Topic 1)
What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?

1. A. Configure SalesSQLDb1 as writable.
2. B. Update the connection strings of SalesSQLDb1App1.
3. C. Update the firewall rules of SalesSQLDb1.
4. D. Update the users in SalesSQLDb1.

Correct Answer: B
Scenario: SalesSQLDb1 uses database firewall rules and contained database users.

- (Exam Topic 5)
You have 10 Azure virtual machines that have SQL Server installed.
You need to implement a backup strategy to ensure that you can restore specific databases to other SQL Server instances. The solution must provide centralized management of the backups.
What should you include in the backup strategy?

1. A. Automated Backup in the SQL virtual machine settings
2. B. Azure Backup
3. C. Azure Site Recovery
4. D. SQL Server Agent jobs

Correct Answer: B
Azure Backup provides an Enterprise class backup capability for SQL Server on Azure VMs. All backups are stored and managed in a Recovery Services vault. There are several advantages that this solution provides, especially for Enterprises.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/backup-restore#azbackup

- (Exam Topic 5)
You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1.
You plan to migrate DB1 to an Azure SQL Database managed instance.
What should you use to minimize downtime and data loss during the migration?

1. A. database mirroring
2. B. distributed availability groups
3. C. Always On Availability Group
4. D. Azure Database Migration Service

Correct Answer: D

- (Exam Topic 5)
You have an Azure SQL database named DB 1 in the General Purpose service tier. You need to monitor DB 1 by using SQL Insights.
What should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Solution:
Box 1 = Azure Monitor Agent Box 2 = An Azure SQL database
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A