DP-300 Exam Question 141
You have an Azure subscription that contains the resources shown in the following table.

You need to configure a connection between VM1 and MI1. The solution must meet the following requirements:
- The connection must be encrypted.
- Network latency must be minimized.
What should you implement?

You need to configure a connection between VM1 and MI1. The solution must meet the following requirements:
- The connection must be encrypted.
- Network latency must be minimized.
What should you implement?
DP-300 Exam Question 142
You have an on-premises Microsoft SQL Server 2022 instance named SQL1.
You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1.
You need to configure a bidirectional disaster recovery solution between SQL1 and SQLMI1.
What should you include in the solution?
You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1.
You need to configure a bidirectional disaster recovery solution between SQL1 and SQLMI1.
What should you include in the solution?
DP-300 Exam Question 143
You have an Azure Synapse Analytics dedicated SQL pool.
You run PDW_SHOWSPACEUSED('dbo.FactInternetSales'); and get the results shown in the following table.

Which statement accurately describes the dbo.FactInternetSales table?
You run PDW_SHOWSPACEUSED('dbo.FactInternetSales'); and get the results shown in the following table.

Which statement accurately describes the dbo.FactInternetSales table?
DP-300 Exam Question 144
You have an Azure SQL database named DB1. You run a query while connected to DB1.
You review the actual execution plan for the query, and you add an index to a table referenced by the query.
You need to compare the previous actual execution plan for the query to the Live Query Statistics.
What should you do first in Microsoft SQL Server Management Studio (SSMS)?
You review the actual execution plan for the query, and you add an index to a table referenced by the query.
You need to compare the previous actual execution plan for the query to the Live Query Statistics.
What should you do first in Microsoft SQL Server Management Studio (SSMS)?
DP-300 Exam Question 145
You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 contains a table named CustomerPII.
You need to record whenever users query the CustomerPII table.
Which two options should you enable? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to record whenever users query the CustomerPII table.
Which two options should you enable? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
