DP-300 Free Practice Test

- (Exam Topic 5)
You have a Microsoft SQL Server 2019 database named DB1 that uses the following database-level and instance-level features.
Clustered columnstore indexes
Automatic tuning
Change tracking
PolyBase
You plan to migrate DB1 to an Azure SQL database.
What feature should be removed or replaced before DB1 can be migrated?

1. A. Clustered columnstore indexes
2. B. PolyBase
3. C. Change tracking
4. D. Automatic tuning

Correct Answer: B
This table lists the key features for PolyBase and the products in which they're available.

Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-versioned-feature-summary

- (Exam Topic 5)
You have an Azure subscription.
You plan to migrate 10 on-premises Microsoft SQL Server instances to Azure.
You need to ensure that the migrated environment can be managed by using multiserver administration and supports master/target (MSX/TSX) jobs. The solution must minimize administrative effort.
Which SQL deployment options should you select as the master server (MSX) and the target server (TSX)? 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)
What should you use to migrate the PostgreSQL database?

1. A. Azure Data Box
2. B. AzCopy
3. C. Azure Database Migration Service
4. D. Azure Site Recovery

Correct Answer: C
Reference:
https://docs.microsoft.com/en-us/azure/dms/dms-overview

- (Exam Topic 5)
You have a new Azure subscription.
You create an Azure SQL Database instance named DB1 on an Azure SQL Database server named Server1. You need to ensure that users can connect to DB1 in the event of an Azure regional outage. In the event of an outage, applications that connect to DB1 must be able to connect without having to update the connection strings.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE:Each correct selection is worth one point.

1. A. From the properties of DB1. configure geo-replication.
2. B. From the properties of Server1 add a failover group.
3. C. Create a new Azure SQL Database server named Server2.
4. D. From the properties of Server1 configure retention for DB1
5. E. Create a new Azure SQL Database instance named DB2.

Correct Answer: BC
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview?tabs=azure-powershell https://docs.microsoft.com/en-us/azure/azure-sql/database/failover-group-add-single-database-tutorial?tabs=azur

- (Exam Topic 5)
You have a on-premises Microsoft SQL Server named SQL1 that hosts five databases.
You need to migrate the databases to an Azure SQL managed instance. The solution must minimize downtime and prevent data loss.
What should you use?

1. A. log shipping
2. B. Always On availability groups
3. C. Database Migration Assistant
4. D. Backup and Restore

Correct Answer: C