Free Preparation Discussions
MENU
Microsoft DP-203 Exam
- Topic 1: Monitor and Optimize Data Storage and Data Processing/ Implement physical data storage structures
- Topic 2: Design metastores in Azure Synapse Analytics and Azure Databricks/ Transform data by using Azure Synapse Pipelines
- Topic 3: Implement different table geometries with Azure Synapse Analytics pools/ Design data encryption for data at rest and in transit
- Topic 4: Identify when partitioning is needed in Azure Data Lake Storage Gen2/ Design and develop slowly changing dimensions
- Topic 5: Design a folder structure that represents the levels of data transformation/ Optimize and troubleshoot data storage and data processing
- Topic 6: Implement file and folder structures for efficient querying and data pruning/ Design a data storage structure
- Topic 7: Deliver data in a relational star schema/ Design slowly changing dimensions
- Topic 8: Configure error handling for the transformation/ Design and Develop Data Processing
- Topic 9: Design and develop a batch processing solution/ Implement logical data structures
- Topic 10: Optimize pipelines for analytical or transactional purposes/ Transform data by using Stream Analytics
- Topic 11: Design and develop a stream processing solution/ Implement a dimensional hierarchy
Free Microsoft DP-203 Exam Actual Questions
The questions for DP-203 were last updated On May. 31, 2023
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?
You have a Microsoft Purview account. The Lineage view of a CSV file is shown in the following exhibit.
How is the data for the lineage populated?
You have an Azure SQL database named DB1 and an Azure Data Factory data pipeline named pipeline.
From Data Factory, you configure a linked service to DB1.
In DB1, you create a stored procedure named SP1. SP1 returns a single row of data that has four columns.
You need to add an activity to pipeline to execute SP1. The solution must ensure that the values in the columns are stored as pipeline variables.
Which two types of activities can you use to execute SP1? (Refer to Data Engineering on Microsoft Azure documents or guide for Answers/Explanation available at Microsoft.com)
the two types of activities that you can use to execute SP1 areStored ProcedureandLookup.
https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-stored-procedure
You have a Microsoft Purview account. The Lineage view of a CSV file is shown in the following exhibit.
How is the data for the lineage populated?
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?
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Submit Cancel