Microsoft DP-203 Exam Dumps - Latest Data Engineering on Microsoft Azure Practice Test

Question # 1

You have an Azure subscription that contains a Microsoft Purview account.You need to search the Microsoft Purview Data Catalog to identify assets that have anassetType property of Table or View Which query should you run?

A. assetType IN (Table', 'View')
B. assetType:Table OR assetType:View
C. assetType - (Table or view)
D. assetType:(Table OR View)

Show Answer

Question # 2

You have an Azure subscription that contains an Azure data factory named ADF1.From Azure Data Factory Studio, you build a complex data pipeline in ADF1.You discover that the Save button is unavailable and there are validation errors thatprevent the pipeline from being published.You need to ensure that you can save the logic of the pipeline.Solution: You enable Git integration for ADF1.

A. Yes
B. No

Show Answer

Question # 3

Note: The question is part of a series of questions that present the same scenario. Eachquestion in the series contains a unique solution that might meet the stated goals. Somequestion sets might have more than one correct solution, while others might not have acorrect solution.After you answer a question in this section, you will NOT be able to return to it As a resultthese questions will not appear in the review screen. You have an Azure Data LakeStorage account that contains a staging zone.You need to design a dairy process to ingest incremental data from the staging zone,transform the data by executing an R script, and then insert the transformed data into adata warehouse in Azure Synapse Analytics.Solution: You use an Azure Data Factory schedule trigger to execute a pipeline thatexecutes a mapping data low. and then inserts the data into the data warehouse.Does this meet the goal?

A. Yes
B. No

Show Answer

Question # 4

You are creating an Apache Spark job in Azure Databricks that will ingest JSON-formatteddata.You need to convert a nested JSON string into a DataFrame that will contain multiple rows.Which Spark SQL function should you use?

A. explode
B. filter
C. coalesce
D. extract

Show Answer

Question # 5

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 DimCustomerby 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 correctanswer presents part of the solution. NOTE: Each correct selection is worth one point.

A. [HistoricalSalesPerson] [nvarchar] (256) NOT NULL
B. [EffectiveEndDate] [datetime] NOT NULL
C. [PreviousModifiedDate] [datetime] NOT NULL
D. [RowID] [bigint] NOT NULL
E. [EffectiveStartDate] [datetime] NOT NULL

Show Answer

Question # 6

You have an Azure Synapse Analytics dedicated SQL pool.You plan to create a fact table named Table1 that will contain a clustered columnstoreindex.You need to optimize data compression and query performance for Table1.What is the minimum number of rows that Table1 should contain before you createpartitions?

A. 100.000
B. 600,000
C. 1 million
D. 60 million

Show Answer

Question # 7

You have the Azure Synapse Analytics pipeline shown in the following exhibit. You need to add a set variable activity to the pipeline to ensure that after the pipeline’s completion, the status of the pipeline is always successful.What should you configure for the set variable activity?

A. a success dependency on the Business Activity That Fails activity
B. a failure dependency on the Upon Failure activity
C. a skipped dependency on the Upon Success activity
D. a skipped dependency on the Upon Failure activity

Show Answer

Question # 8

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 statedgoals. Some question sets might have more than one correct solution, while othersmight not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As aresult, these questions will not appear in the review screen.You have an Azure Data Lake Storage account that contains a staging zone.You need to design a daily process to ingest incremental data from the staging zone,transform the data by executing an R script, and then insert the transformed data into adata warehouse in Azure Synapse Analytics.Solution: You schedule an Azure Databricks job that executes an R notebook, and theninserts the data into the data warehouse.Does this meet the goal?

A. Yes
B. No

Show Answer

Question # 9

You are implementing a star schema in an Azure Synapse Analytics dedicated SQL pool.You plan to create a table named DimProduct. DimProduct must be a Type 3 slowly changing dimension (SCO) table that meets thefollowing requirements:• The values in two columns named ProductKey and ProductSourceID will remain thesame.• The values in three columns named ProductName, ProductDescription, and Color canchange.You need to add additional columns to complete the following table definition.

A. Option A
B. Option B
C. Option C
D. Option D
E. Option E
F. Option F

Show Answer

Question # 10

You plan to use an Apache Spark pool in Azure Synapse Analytics to load data to an AzureData Lake Storage Gen2 account.You need to recommend which file format to use to store the data in the Data Lake Storageaccount. The solution must meet the following requirements:• Column names and data types must be defined within the files loaded to the Data LakeStorage account.• Data must be accessible by using queries from an Azure Synapse Analytics serverlessSQL pool.• Partition elimination must be supported without having to specify a specific partition.What should you recommend?

A. Delta Lake
B. JSON
C. CSV
D. ORC

Show Answer