DP-300 Drag & Drop — 10 Questions

Question 1

Drag and drop the steps to configure transparent data encryption (TDE) for an Azure SQL Database using a customer-managed key in Azure Key Vault in the correct order.

Accepted Answer

Create Azure Key Vault and key, then grant Key Vault permissions to the Azure SQL Database server, then enable TDE with customer-managed key, then select the key and save.. First set up Key Vault with a key, grant permissions, then enable TDE with customer-managed key, select the key, and save.

Answer

Grant Key Vault permissions to the Azure SQL Database server, then create Azure Key Vault and key, then enable TDE with customer-managed key, then select the key and save.

Answer

Enable TDE with customer-managed key, then create Azure Key Vault and key, then grant Key Vault permissions to the Azure SQL Database server, then select the key and save.

Answer

Create Azure Key Vault and key, then enable TDE with customer-managed key, then grant Key Vault permissions to the Azure SQL Database server, then select the key and save.

Question 2

Drag and drop the steps to configure a SQL Server Agent job in Azure SQL Managed Instance to run a maintenance task in the correct order.

Accepted Answer

Connect to the instance, create a job, define steps, schedule, then enable and start.. Connect to the instance, create a job, define steps, schedule, then enable and start.

Answer

Create a job, define steps, schedule, connect to the instance, then enable and start.

Answer

Connect to the instance, define steps, create a job, schedule, then enable and start.

Answer

Connect to the instance, create a job, schedule, define steps, then enable and start.

Question 3

Drag and drop the steps to migrate an on-premises SQL Server database to Azure SQL Database using the Data Migration Assistant (DMA) in the correct order.

Accepted Answer

Assess database compatibility, then fix compatibility issues, then deploy Azure SQL Database, then migrate schema and data. First assess and fix issues, then deploy the target, then migrate schema, then data.

Answer

Deploy Azure SQL Database, then assess database compatibility, then fix compatibility issues, then migrate schema and data

Answer

Assess database compatibility, then deploy Azure SQL Database, then fix compatibility issues, then migrate schema and data

Answer

Migrate schema and data, then assess database compatibility, then fix compatibility issues, then deploy Azure SQL Database

Question 4

Drag and drop the steps to restore an Azure SQL Database to a point in time in the correct order.

Accepted Answer

Select the source database, then choose Restore type as Point-in-time, then specify the point in time, then name the new database, then click Create.. The restore process starts by selecting the database, then choosing the restore type, specifying the point in time, naming the new database, and finally creating it.

Answer

Select the source database, then name the new database, then choose Restore type as Point-in-time, then specify the point in time, then click Create.

Answer

Select the source database, then choose Restore type as Point-in-time, then click Create, then name the new database, then specify the point in time.

Answer

Select the source database, then specify the point in time, then choose Restore type as Point-in-time, then name the new database, then click Create.

Question 5

Drag and drop the steps to configure an Azure SQL Managed Instance link for disaster recovery in the correct order.

Accepted Answer

Create a secondary managed instance, then create the link, then configure the secondary as readable, then monitor replication, then initiate failover when needed.. The link requires a secondary instance first, then establishing the link, configuring as readable, monitoring, and failing over when needed.

Answer

Create the link, then create a secondary managed instance, then configure as readable, then monitor, then failover.

Answer

Create a secondary managed instance, then create the link, then monitor, then failover, then configure as readable.

Answer

Create a secondary managed instance, then configure as readable, then create the link, then monitor, then failover.

Question 6

Drag and drop the steps to configure geo-replication for an Azure SQL Database in the correct order.

Accepted Answer

Create secondary server in another region, then configure the secondary database, then initiate replication, then verify the replication link.. Geo-replication requires a secondary server in another region, then configuring the secondary database, initiating replication, and verifying the link. Failover is a separate step.

Answer

Create secondary server in another region, then initiate replication, then configure the secondary database, then verify the replication link.

Answer

Initiate replication, then create secondary server in another region, then configure the secondary database, then verify the replication link.

Answer

Create secondary server in another region, then configure the secondary database, then verify the replication link, then initiate replication.

Question 7

Drag and drop the steps to troubleshoot a high CPU usage issue in Azure SQL Database in the correct order.

Accepted Answer

Identify high CPU queries, then Analyze execution plans, then Check for missing indexes, then Implement fixes, then Monitor performance.. Start by identifying high CPU queries, analyze plans, check for missing indexes, implement fixes, then monitor.

Answer

Identify high CPU queries, then Check for missing indexes, then Analyze execution plans, then Implement fixes, then Monitor performance.

Answer

Analyze execution plans, then Identify high CPU queries, then Check for missing indexes, then Implement fixes, then Monitor performance.

Answer

Identify high CPU queries, then Analyze execution plans, then Implement fixes, then Check for missing indexes, then Monitor performance.

Question 8

Drag and drop the steps to configure automatic tuning for an Azure SQL Database in the correct order.

Accepted Answer

Select the Azure SQL Database, then navigate to Automatic tuning settings, then enable the desired options, then save changes.. Automatic tuning is configured via the portal by selecting the database, navigating to automatic tuning, enabling options, and saving.

Answer

Navigate to Automatic tuning settings, then select the Azure SQL Database, then enable the desired options, then save changes.

Answer

Select the Azure SQL Database, then enable the desired options, then navigate to Automatic tuning settings, then save changes.

Answer

Enable the desired options, then select the Azure SQL Database, then navigate to Automatic tuning settings, then save changes.

Question 9

Drag and drop the steps to configure a failover group for an Azure SQL Database in the correct order.

Accepted Answer

Step 1: Create a secondary Azure SQL Database server; Step 2: Create a failover group; Step 3: Add databases to the failover group; Step 4: Configure the failover policy; Step 5: Test failover.. Failover groups require a secondary server, then creating the group, adding databases, configuring policy, and testing.

Answer

Step 2: Create a failover group; Step 1: Create a secondary Azure SQL Database server; Step 3: Add databases to the failover group; Step 4: Configure the failover policy; Step 5: Test failover.

Answer

Step 1: Create a secondary Azure SQL Database server; Step 2: Create a failover group; Step 4: Configure the failover policy; Step 3: Add databases to the failover group; Step 5: Test failover.

Answer

Step 1: Create a secondary Azure SQL Database server; Step 3: Add databases to the failover group; Step 2: Create a failover group; Step 4: Configure the failover policy; Step 5: Test failover.

Question 10

Drag and drop the steps to configure an Azure SQL Database elastic pool in the correct order.

Accepted Answer

Create the elastic pool, then add databases to the pool, then configure per-database limits, then monitor pool performance, then scale the pool as needed.. First create the pool, then add databases, configure per-database limits, monitor, and scale.

Answer

Add databases to an existing pool first, then create the elastic pool, then configure per-database limits, then monitor, then scale.

Answer

Create the elastic pool, then configure per-database limits, then add databases, then monitor, then scale.

Answer

Create the elastic pool, then add databases, then monitor, then configure per-database limits, then scale.