You have an Azure Data Factory pipeline that is triggered hourly. The pipeline has had 100% success for the past seven days.The pipeline execution fails, and two retries that occur 15 minutes apart also fail. The third failure returns the following error. ErrorCode=UserErrorFileNotFound,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ADL S Gen2 operation failed for: Operation returned an invalid status code 'NotFound'. Account: 'contosoproduksouth'. Filesystem: wwi. Path: 'BIKES/CARBON/year=2021/month=01/day=10/hour=06'. ErrorCode: 'PathNotFound'. Message: 'The specified path does not exist.'. RequestId: '6d269b78-901f-001b-4924-e7a7bc000000'. TimeStamp: 'Sun, 10 Jan 2021 07:45:05What is a possible cause of the error?

From 06:00 to 07:00 on January 10, 2021, the file format of data in wwi/BIKES/CARBON was incorrect.

The parameter used to generate year=2021/month=01/day=10/hour=06 was incorrect.

From 06:00 to 07:00 on January 10, 2021, there was no data in wwi/BIKES/CARBON.

From 06:00 to 07:00 on January 10, 2021, the file format of data in wwi/BIKES/CARBON was incorrect.

The pipeline was triggered too early.

You have an Azure Synapse Analytics job that uses Scala.You need to view the status of the job.What should you do?

From Synapse Studio, select the workspace. From Monitor, select Apache Sparks applications.

From Synapse Studio, select the workspace. From Monitor, select SQL requests.

From Azure Monitor, run a Kusto query against the AzureDiagnostics table.

From Synapse Studio, select the workspace. From Monitor, select Apache Sparks applications.

From Azure Monitor, run a Kusto query against the SparkLoggingEvent_CL table.

You are designing database for an Azure Synapse Analytics dedicated SQL pool to support workloads for detecting ecommerce transaction fraud. Data will be combined from multiple ecommerce sites and can include sensitive financial information such as credit card numbers. You need to recommend a solution that meets the following requirements:Users must be able to identify potentially fraudulent transactions. Users must be able to use credit cards as a potential feature in models. Users must NOT be able to access the actual credit card numbers. What should you include in the recommendation?

Transparent Data Encryption (TDE)

Azure Active Directory (Azure AD) pass-through authentication

You have an Azure data factory.You need to examine the pipeline failures from the last 180 days. What should you use?

Azure Data Factory activity runs in Azure Monitor

the Activity log blade for the Data Factory resource

Pipeline runs in the Azure Data Factory user experience

the Resource health blade for the Data Factory resource

Azure Data Factory activity runs in Azure Monitor

You have an Azure data factory named ADF1.You currently publish all pipeline authoring changes directly to ADF1. You need to implement version control for the changes made to pipeline artifacts. The solution must ensure that you can apply version control to the resources currently defined in the UX Authoring canvas for ADF1. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

From the UX Authoring canvas, run Publish All.

From the UX Authoring canvas, select Set up code repository.

Create an Azure Data Factory trigger.

From the UX Authoring canvas, select Publish.

From the UX Authoring canvas, run Publish All.

You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named SQLPool1. SQLPool1 is currently paused.You need to restore the current state of SQLPool1 to a new SQL pool. What should you do first?

Create a user-defined restore point.

You are creating an Azure Data Factory data flow that will ingest data from a CSV file, cast columns to specified types of data, and insert the data into a table in an Azure Synapse Analytics dedicated SQL pool. The CSV file contains columns named username, comment and date.The data flow already contains the following:• A source transformation• A Derived Column transformation to set the appropriate types of data• A sink transformation to land the data in the poolYou need to ensure that the data flow meets the following requirements;• All valid rows must be written to the destination table.• Truncation errors in the comment column must be avoided proactively.• Any rows containing comment values that will cause truncation errors upon insert must be written to a file in blob storage. Which two actions should you perform? Each correct answer presents part of the solution. NOTE:Each correct selection is worth one point

Add a sink transformation that writes the rows to a file in blob storage.

Add a Conditional Split transformation that separates the rows which will cause truncation errors.

Add a select transformation that selects only the rows which will cause truncation errors.

Add a sink transformation that writes the rows to a file in blob storage.

Add a filter transformation that filters out rows which will cause truncation errors.

Add a Conditional Split transformation that separates the rows which will cause truncation errors.

You have an Azure subscription that contains an Azure Data Lake Storage account named myaccount1. The myaccount1 account contains two containers named container1 and contained. The subscription is linked to an Azure Active Directory (Azure AD) tenant that contains a security group named Group1. You need to grant Group1 read access to contamer1. The solution must use the principle of least privilege. Which role should you assign to Group1?

Storage Blob Data Reader for container1

Storage Table Data Reader for container1

Storage Blob Data Reader for myaccount1

Storage Table Data Reader for myaccount1

You have an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 contains a table named table1. You load 5 TB of data intotable1.You need to ensure that columnstore compression is maximized for table1. Which statement should you execute?

ALTER INDEX ALL on table1 REORGANIZE

ALTER INDEX ALL on table1 REBUILD

DBCC INDEXDEFRAG (pool1,tablel)

You haw an Azure data factory named ADF1.You currently publish all pipeline authoring changes directly to ADF1. You need to implement version control for the changes made to pipeline artifacts. The solution must ensure that you can apply version control to the resources currently defined m the UX Authoring canvas for ADF1.Which two actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.

From the UX Authoring canvas, select Set up code repository

Create an Azure Data Factory trigger

From the UX Authoring canvas, select Set up code repository

From the UX Authoring canvas, run Publish All.

From the UX Authoring canvas, select Publish

You haw an Azure data factory named ADF1.You currently publish all pipeline authoring changes directly to ADF1. You need to implement version control for the changes made to pipeline artifacts. The solution must ensure that you can apply version control to the resources currently defined m the UX Authoring canvas for ADF1. Which two actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.

From the UX Authoring canvas, select Set up code repository

From the UX Authoring canvas, run Publish All.

Create an Azure Data Factory trigger

From the UX Authoring canvas, select Set up code repository

From the UX Authoring canvas, run Publish All.

From the UX Authoring canvas, select Publish

You have an Azure Data Lake Storage Gen2 account that contains two folders named Folder and Folder2. You use Azure Data Factory to copy multiple files from Folder1 to Folder2. You receive the following error.What should you do to resolve the error.

Enable fault tolerance to skip incompatible rows.

Lower the degree of copy parallelism

Change the Copy activity setting to Binary Copy

You are designing a folder structure for the files m an Azure Data Lake Storage Gen2 account. The account has one container that contains three years of data. You need to recommend a folder structure that meets the following requirements:• Supports partition elimination for queries by Azure Synapse Analytics serverless SQL pooh• Supports fast data retrieval for data from the current month• Simplifies data security management by departmentWhich folder structure should you recommend?

\Depdftment\DataSource\YYY\MM\DataFile_YYYYMMDD.parquet

\YYY\MM\DD\Department\DataSource\DataFile_YYYMMMDD.parquet

\Depdftment\DataSource\YYY\MM\DataFile_YYYYMMDD.parquet

\DD\MM\YYYY\Department\DataSource\DataFile_DDMMYY.parquet

\DataSource\Department\YYYYMM\DataFile_YYYYMMDD.parquet

You are designing an Azure Synapse Analytics workspace.You need to recommend a solution to provide double encryption of all the data at rest. Which two components should you include in the recommendation? Each coned answer presents part of the solution NOTE: Each correct selection is worth one point.

an Azure virtual network that has a network security group (NSG)

an Azure key vault that has purge protection enabled

an Azure virtual network that has a network security group (NSG)

You need to design a solution that will process streaming data from an Azure Event Hub and output the data to Azure Data Lake Storage. The solution must ensure that analysts can interactively query the streaming data. What should you use?

Structured Streaming in Azure Databricks

event triggers in Azure Data Factory

Azure Stream Analytics and Azure Synapse notebooks

Structured Streaming in Azure Databricks

Azure Queue storage and read-access geo-redundant storage (RA-GRS)

You have an Azure Synapse Analytics dedicated SQL pool named pool1. You plan to implement a star schema in pool1 and create a new table named DimCustomer by using the following code. You need to ensure that DimCustomer has the necessary columns to support a Type 2 slowly changing dimension (SCD). Which two columns should you add? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

[HistoricalSalesPerson] [nvarchar] (256) NOT NULL

[EffectiveEndDate] [datetime] NOT NULL

[HistoricalSalesPerson] [nvarchar] (256) NOT NULL

[EffectiveEndDate] [datetime] NOT NULL

[PreviousModifiedDate] [datetime] NOT NULL

[EffectiveStartDate] [datetime] NOT NULL

You have an Azure Data Factory pipeline named Pipeline1!. Pipelinel contains a copy activity that sends data to an Azure Data Lake Storage Gen2 account. Pipeline 1 is executed by a schedule trigger. You change the copy activity sink to a new storage account and merge the changes into the collaboration branch. After Pipelinel executes, you discover that data is NOT copied to the new storage account. You need to ensure that the data is copied to the new storage account. What should you do?

Publish from the collaboration branch.

Configure the change feed of the new storage account.

You have an Azure Synapse Analytics dedicated SQL pool named Pool1 that contains a table named Sales. Sales has row-level security (RLS) applied. RLS uses the following predicate filter. A user named SalesUser1 is assigned the db_datareader role for Pool1. Which rows in the Sales table are returned when SalesUser1 queries the table?

only the rows for which the value in the User_Name column is SalesUser1

only the rows for which the value in the SalesRep column is Manager

only the rows for which the value in the SalesRep column is SalesUser1

Microsoft DP-203 Practice Test 6 - Free Online Exam Questions 201-240

Question 1 / 40

DRAG DROP

You have an Azure Data Lake Storage Gen2 account that contains a JSON file for customers. The file contains two attributes named FirstName and LastName. You need to copy the data from the JSON file to an Azure Synapse Analytics table by using Azure Databricks. A new column must be created that concatenates the FirstName and LastName values. You create the following components:

A destination table in Azure Synapse

An Azure Blob storage container

A service principal

In which order should you perform the actions? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Become a Premium Member for full access

Unlock Premium Member

Microsoft DP-203 Practice Test 6

Question

Microsoft DP-203 Practice Tests

Practice Tests