DP-200 Practice Test

Question 61

You have an Azure Storage account named storage1 that is configured as shown in the following exhibit. You need to ensure that all calls to an Azure Storage REST API operation on storage1 are made over HTTPS. What should you do?

1. Set Secure transfer required to Enabled.
2. Set Allow Blob public access to Disabled.
3. For the Blob service, create a shared access signature (SAS) that allows HTTPS only.
4. Set Minimum TLS version to Version 1.2.

Question 62

You have an Azure Synapse Analytics dedicated SQL pool that contains the users shown in the following table. User1 executes a query on the database, and the query returns the results shown in the following exhibit. User1 is the only user who has access to the unmasked data. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. Hot Area:

Question 63

Note: This question is a part of series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals. You develop a data ingestion process that will import data to an enterprise data warehouse in Azure Synapse Analytics. The data to be ingested resides in parquet files stored in an Azure Data Lake Gen 2 storage account. You need to load the data from the Azure Data Lake Gen 2 storage account into the Data Warehouse. Solution: 1. Create an external data source pointing to the Azure storage account 2. Create a workload group using the Azure storage account name as the pool name 3. Load the data using the INSERT`¦SELECT statement Does the solution meet the goal?

1. Yes
2. No

Question 64

You develop data engineering solutions for a company. You must integrate the company's on-premises Microsoft SQL Server data with Microsoft Azure SQL Database. Data must be transformed incrementally. You need to implement the data integration solution. Which tool should you use to configure a pipeline to copy data?

1. Use the Copy Data tool with Blob storage linked service as the source
2. Use Azure PowerShell with SQL Server linked service as a source
3. Use Azure Data Factory UI with Blob storage linked service as a source
4. Use the .NET Data Factory API with Blob storage linked service as the source

Question 65

A company runs Microsoft Dynamics CRM with Microsoft SQL Server on-premises. SQL Server Integration Services (SSIS) packages extract data from Dynamics CRM APIs, and load the data into a SQL Server data warehouse. The datacenter is running out of capacity. Because of the network configuration, you must extract on premises data to the cloud over https. You cannot open any additional ports. The solution must implement the least amount of effort. You need to create the pipeline system. Which component should you use? To answer, select the appropriate technology in the dialog box in the answer area. NOTE: Each correct selection is worth one point. Hot Area: