DP-300 Free Practice Test

- (Exam Topic 5)
You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1.
You plan to perform an online migration of DB1 to an Azure SQL managed instance by using the Azure Database Migration Service.
You need to create a backup of DB1 that is accessible to the Azure Database Migration Service.
What should you run for the backup and where should you store the backup? To answer, select the appropriate options in the answer area.
NOTE:Each correct selection is worth one point.

Solution:
Graphical user interface, application, Word Description automatically generated
Reference:
https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 5)
You have an on-premises Microsoft SQL Server 2016 instance that hosts a database named db1. You have an Azure subscription that contains an Azure SQL managed instance named Mil.
You plan to perform an online migration of db1 to MM by using Azure Database Migration Service.
You need to create the backups for the migration. The solution must minimize the number of backup files created.
Which type of backups should you create, and how should you store the backups? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 2)
Based on the PaaS prototype, which Azure SQL Database compute tier should you use?

1. A. Business Critical 4-vCore
2. B. Hyperscale
3. C. General Purpose v-vCore
4. D. Serverless

Correct Answer: A
There are CPU and Data I/O spikes for the PaaS prototype. Business Critical 4-vCore is needed. Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/reserved-capacity-overview

- (Exam Topic 5)
You have an Azure subscription that contains the resources shown in the following table.

App1 experiences transient connection errors and timeouts when it attempts to access db1 after extended periods of inactivity. You need to modify db1 to resolve the issues experienced by App1 as soon as possible, without considering immediate costs. What should you do?

1. A. Increase the number Of vCores allocated to db1.
2. B. Disable auto-pause delay for dbl.
3. C. Decrease the auto-pause delay for db1.
4. D. Enable automatic tuning for db1.

Correct Answer: D

- (Exam Topic 5)
You have an Azure SQL database named DB1.
You need to encrypt DB1. The solution must meet the following requirements;
• Encrypt data in motion.
• Support comparison operators.
• Provide randomized encryption.
What should you include in the solution?

1. A. Always Encrypted
2. B. column-level encryption
3. C. Transparent Data Encryption (TDE)
4. D. Always Encrypted with secure enclaves

Correct Answer: A