Celebrate 2025 with Discount Offer - Coupon code:
IEHOFF20
Microsoft DP-203 Exam Questions

Microsoft DP-203 Exam Questions

Certification Exams

Downloadable PDF versions

100% Confidential

Updated Regularly

Advanced Features

Number Of Questions: 333

$59.00

Exam Details

Exam Name:

Data Engineering on Microsoft Azure

Exam Code:

DP-203

Total Questions in Exam:

333

Demo Questions

Q1. You use Azure Data Factory to create data pipelines. You are evaluating whether to integrate Data Factory and GitHub for source and version control What are two advantages of the integration? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A.the ability to save without publishing

B. lower pipeline execution times

C. the ability to save pipelines that have validation issues

D. additional triggers

Correct Answer: A, C

Q2. You are building a data flow in Azure Data Factory that upserts data into a table in an Azure Synapse Analytics dedicated SQL pool. You need to add a transformation to the data flow. The transformation must specify logic indicating when a row from the input data must be upserted into the sink. Which type of transformation should you add to the data flow?

A.join

B. select

C. surrogate key

D. alter row

Correct Answer: D

Q3. ou have an Azure subscription that contains a Microsoft Purview account. You need to search the Microsoft Purview Data Catalog to identify assets that have an assetType 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)

Correct Answer: B

Q4. You have an Azure subscription that contains an Azure Data Factory data pipeline named Pipeline1, a Log Analytics workspace named LA1, and a storage account named account1. You need to retain pipeline-run data for 90 days. The solution must meet the following requirements: * The pipeline-run data must be removed automatically after 90 days. * Ongoing costs must be minimized. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A.Configure Pipeline1 to send logs to LA1.

B. From the Diagnostic settings (classic) settings of account1. set the retention period to 90 days.

C. Configure Pipeline1 to send logs to account1.

D. From the Data Retention settings of LA1, set the data retention period to 90 days.

Correct Answer: A, B

$59.00

Reviews

There are no reviews yet.

Be the first to review “Microsoft DP-203 Exam Questions”

Your email address will not be published. Required fields are marked *

IT EXAM HUB is an independent platform and is not affiliated with, sponsored by, or endorsed by SAP SE, Cisco, Amazon, Microsoft, CompTIA, or any other third-party certification provider.

All trademarks, service marks, trade names, product names, and logos appearing on this site are the property of their respective owners. Their use does not imply any affiliation or endorsement by them.

Quick Links

Contact Us

  • info@itexamhub.com
  • @itexamhub
  • itexamhub
  • itexamhub
All Rights Reserved © 2025 itexamhub.com