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

You need to configure a connection between VM1 and MIL 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 MIL 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 17
You are evaluating the business goals.
Which feature should you use to provide customers with the required level of access based on their service agreement?
Which feature should you use to provide customers with the required level of access based on their service agreement?
DP-300 Exam Question 18
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table1.
You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container1.
You plan to insert data from the files into Table1 and transform the data. Each row of data in the files will produce one row in the serving layer of Table1.
You need to ensure that when the source data files are loaded to container1, the DateTime is stored as an additional column in Table1.
Solution: You use an Azure Synapse Analytics serverless SQL pool to create an external table that has an additional DateTime column.
Does this meet the goal?
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table1.
You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container1.
You plan to insert data from the files into Table1 and transform the data. Each row of data in the files will produce one row in the serving layer of Table1.
You need to ensure that when the source data files are loaded to container1, the DateTime is stored as an additional column in Table1.
Solution: You use an Azure Synapse Analytics serverless SQL pool to create an external table that has an additional DateTime column.
Does this meet the goal?
DP-300 Exam Question 19
You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked.
You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1.
You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:
* Ensure that VM1 cannot connect to any Azure SQL Server other than SqlSrv1.
* Restrict network connectivity to SqlSrv1.
What should you create on VNet1?
You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1.
You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:
* Ensure that VM1 cannot connect to any Azure SQL Server other than SqlSrv1.
* Restrict network connectivity to SqlSrv1.
What should you create on VNet1?
DP-300 Exam Question 20
You are building a database backup solution for a SQL Server database hosted on an Azure virtual machine.
In the event of an Azure regional outage, you need to be able to restore the database backups. The solution must minimize costs.
Which type of storage accounts should you use for the backups?
In the event of an Azure regional outage, you need to be able to restore the database backups. The solution must minimize costs.
Which type of storage accounts should you use for the backups?
