DP-300 Named Practice Questions

You have two on-premises servers that run Windows Server 2019 and host a Microsoft SQL Server 2017 Always On availability group named AG1. AG1 contains a single database named DB1. You have an Azure subscription. The subscription contains a virtual machine named VM1 that runs Linux. You need to migrate DB1 to a SQL Server 2019 instance on VM1. The solution must minimize the downtime of DB1 during the migration. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Match each item to its target.

Correct answer: To prepare for the migration = Create a SQL Server 2019 Always On availability group on VM1.; To perform the migration, use = Azure Migrate

You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines. The virtual machine hosts a database named DB1. You need to monitor DB1 by using Extended Events. The solution must meet the following requirements: • Capture raw event data and store the data in Azure Storage. • Minimize the performance impact of capturing extended events. How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Match each item to its target.

Correct answer: ADD TARGET package0 = event_file; EVENT_RETENTION_MODE = ALLOW_MULTIPLE_EVENT_LOSS

You have an instance of SQL Server on Azure Virtual Machines named SQL1. SQL1 contains a database named DB1. You need to enable Transparent Data Encryption (TDE) for DB1. Which three objects should you create in sequence? To answer, move the appropriate objects from the list of objects to the answer area and arrange them in the correct order.

Match each item to its target.

Correct answer: 1 = a master key in the master database; 2 = a certificate in the master database; 3 = a database encryption key in DB1

You have an Azure SQL database named db1 on a server named server1. The Intelligent Insights diagnostics log identifies that several tables are missing indexes. You need to ensure that indexes are created for the tables. What should you do?

• AA. RuntheDBCC SQLPERF command.
• BB. Run thedbcc dbreindexcommand.
• CC. Modify the automatic tuning settings for db1.
• DD. Modify the Query Store settings for db1.

You have an Azure SQL database named DB1 that contains a table named Orders. The Orders table contains a row for each sales order. Each sales order includes the name of the user who placed the order. You need to implement row-level security (RLS). The solution must ensure that the users can view only their respective sales orders. 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.

Match each item to its target.

Correct answer: Create = A security policy in the Orders table; Control access to the rows by using = A table-valued function