DP-300 Exam Question 126
Drag and Drop Question
You have an on-premises Microsoft SQL Server failover cluster that contains three nodes.
You need to rename a SQL Server instance in the cluster. The solution must minimize downtime for the cluster.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You have an on-premises Microsoft SQL Server failover cluster that contains three nodes.
You need to rename a SQL Server instance in the cluster. The solution must minimize downtime for the cluster.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
DP-300 Exam Question 127
SIMULATION
You need to rebuild the index for PK_Address_AddressID in the SalesLT.Address table in db1.
The solution must meet the following requirements:
- Ensure that 30 percent of the index page is reserved for future updates and inserts.
- Minimize page splits.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
You need to rebuild the index for PK_Address_AddressID in the SalesLT.Address table in db1.
The solution must meet the following requirements:
- Ensure that 30 percent of the index page is reserved for future updates and inserts.
- Minimize page splits.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
DP-300 Exam Question 128
Hotspot Question
You have the projects shown in the following table.
You need to recommend an Azure database solution for each project. The solution must meet the following requirements:
- Project2 must minimize malware threats to the underlying operating system that hosts the migrated database.
- Administrative effort must be minimized where possible.
What should you recommend using for each project? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have the projects shown in the following table.
You need to recommend an Azure database solution for each project. The solution must meet the following requirements:
- Project2 must minimize malware threats to the underlying operating system that hosts the migrated database.
- Administrative effort must be minimized where possible.
What should you recommend using for each project? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
DP-300 Exam Question 129
Drag and Drop Question
You have an Azure key vault named Vault1 and a SQL server on Azure Virtual Machines instance named SQL1. SQL1 hosts a database named DB1.
You need to configure Transparent Data Encryption (TDE) on DB1 to use a key in Vault1.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You have an Azure key vault named Vault1 and a SQL server on Azure Virtual Machines instance named SQL1. SQL1 hosts a database named DB1.
You need to configure Transparent Data Encryption (TDE) on DB1 to use a key in Vault1.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
DP-300 Exam Question 130
You have an Azure subscription that contains an Azure SQL database named db1.
You need to implement SQL insights for db1.
Which two resources should you create first? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to implement SQL insights for db1.
Which two resources should you create first? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.