Data Engineering on Microsoft Azure (DP-203) Certification Sample Questions

The purpose of this Sample Question Set is to provide you with information about the Data Engineering on Microsoft Azure exam. These sample questions will make you very familiar with both the type and the difficulty level of the questions on the DP-203 certification test. To get familiar with real exam environment, we suggest you try our Sample Data Engineering on Microsoft Azure Certification Practice Exam. This sample practice exam gives you the feeling of reality and is a clue to the questions asked in the actual Microsoft Certified - Azure Data Engineer Associate certification exam.

These sample questions are simple and basic questions that represent likeness to the real Microsoft DP-203 exam questions. To assess your readiness and performance with real time scenario based questions, we suggest you prepare with our Premium Data Engineering on Microsoft Azure Certification Practice Exam. When you solve real time scenario based questions practically, you come across many difficulties that give you an opportunity to improve.

Microsoft DP-203 Sample Questions:

01. You have an Azure Synapse Analytics workspace. You need to monitor wait stats that relate to the SQL Server OS state on each node of the dedicated SQL pools. Which view should you use?

a) sys.dm_pdw_wait_stats

b) sys.dm_pdw_waits

c) sys.dm_pdw_nodes

d) sys.dm_pdw_os_threads

02. Which Azure Data Factory components should you use to connect to a data source?

a) a dataset

b) an activity

c) a pipeline

d) a linked service

e) an aggregation

03. Your source data contains normalized data that represents items sold. You create a data flow activity in an Azure Synapse Analytics pipeline. You need to denormalize the source data. The solution must substitute product Ids for the actual product name before writing data to a sink.

Which type of task should you add to the data flow activity?

a) derived column

b) lookup

c) aggregate

d) flatten

04. You have an Azure Databricks workspace that contains a Delta Lake dimension table named Table1. Table1 is a Type 2 slowly changing dimension (SCD) table. You need to apply updates from a source table to Table1. Which Apache Spark SQL operation should you use?

a) CREATE

b) UPDATE

c) ALTER

d) MERGE

05. You are building an Azure Stream Analytics pipeline. You need to ensure that data in the pipeline is analyzed using fixed five-minute windows. Which windowing function should you use?

a) TumblingWindow

b) HoppingWindow

c) SlidingWindow

d) SessionWindow

06. You need to configure a source control solution for Azure Data Factory. What should you use?

a) VSS

b) Microsoft Visual Studio Online

c) Git

d) SVN

07. You have an Azure Stream Analytics solution that receives data from multiple thermostats in a building. You need to write a query that returns the average temperature per device every five minutes. Which windowing function should you use?

a) TumblingWindow

b) HoppingWindow

c) SlidingWindow

d) SessionWindow

08. You are writing a data import task in Azure Data Factory. You need to increase the number of rows per REST sink. What should you change?

a) requestInternal to 10,000

b) writeBatchSize to 1,000

c) requestInterval to 500

d) writeBatchSize to 100,000

09. You monitor an Azure Stream Analytics job and discover that the Backlogged Input Events metrics shows non-zero values for the last few hours. What should you do to improve job performance without changing the query?

a) Increase the number of the Streaming Units (SU).

b) Increase the settings for late events.

c) Move the job to the dedicated Stream Analytics cluster.

d) Repartition the input stream.

10. You have an Azure Data Factory pipeline named Pipeline1. Which two types of triggers can you use to start Pipeline1?

Each correct answer presents a complete solution.

a) tumbling window

b) custom event

c) SharePoint list

d) Twitter post

Answers:

Question: 01 Answer: a	Question: 02 Answer: d	Question: 03 Answer: b	Question: 04 Answer: d	Question: 05 Answer: a
Question: 06 Answer: c	Question: 07 Answer: a	Question: 08 Answer: d	Question: 09 Answer: a	Question: 10 Answer: a, b

Note: For any error in Microsoft Certified - Azure Data Engineer Associate (DP-203) certification exam sample questions, please update us by writing an email on feedback@edusum.com.

Data Engineering on Microsoft Azure (DP-203) Certification Sample Questions

Microsoft DP-203 Sample Questions:

Answers:

Blogs