Microsoft Azure Data Engineer (DP-203) Exam Dumps 2023

Microsoft Azure Data Engineer (DP-203) Practice Tests 2023. Contains 1350+ exam questions to pass the exam in first attempt.

SkillCertPro offers real exam questions for practice for all major IT certifications.

Below are the free 10 sample questions.

Question 1:

Which component enables you to perform code free transformations in Azure Synapse Analytics?

A. Mapping data flow
B. Copy activity
C. Studio

Answer: A

Explanation:

You can natively perform data transformations with Azure Data Factory code free using the Mapping Data Flow task

Question 2:

Your boss wants to monitor the ADF pipeline performance for last 6 months. Then how would you do it

A. Create a diagnostic setting, route the pipeline data to Log analytics
B. Use ADF Activity dashboard

Answer: A

Explanation:

Azure monitoring and Log analytics stores data more than 45 days while activity dashboard stores only last 45 days activities.

Question 3:

When a partition key reaches its provisioned storage limit, requests to create new resources will return a HTTP Status Code

A. 500
B. 403(Forbidden)
C. 404

Answer: B

Explanation:

Azure Cosmos DB will automatically add partitions, and may also return a 403 if:

An authorization token has expired

A programmatic element (UDF, Stored Procedure, and Trigger) has been flagged for repeated violations

Question 4:

You are designing a customer table with sensitive information in it. you want to hide the Age details from LowPreviUser. Below is the table definition.
CREATE TABLE Customer
(
CustId varachar (20),
CustName varchar (200),
CustAge varchar (9) not null,
CustPhone varchar (12) null
)
Complete the following snippet
GRANT ——————Customer (CustId, CustName,CustPhone) TO LowPrivUser ;

 A. SELECT ON
 B. MASK ON
 C. ALTER ON
 D. PREVILEGE

Answer: A

Explanation:

Select On Gives permission to run the SELECT queries only on CustId ,CustName and CustPhone columns to hide the age from LowPreviUser

Question 5:

As a data engineer, you need to partially mask the numbers of an SSN column. You would need to make sure only last 4 digits are visible. What do you recommend?

A. ALTER TABLE [dbo] . [Student] ALTER COLUMN SSN ADD MASKED WITH FUNCTION = ‘PARTIAL ( 0,“XXX-XX-“, 4)‘);
B. ALTER TABLE [dbo] . [Student] ALTER COLUMN SSN ADD MASKED WITH FUNCTION = ‘PARTIAL ( 0,“XXX-XX-“, 0)‘);
C. ALTER TABLE [dbo] . [Student] ALTER COLUMN SSN ADD MASKED WITH FUNCTION = ‘PARTIAL ( 0,“XXX-XX-“, 4)‘);
D. ALTER TABLE [dbo] . [Student] ALTER COLUMN SSN ADD MASKED WITH FUNCTION = ‘PARTIAL ( 4,“XXX-XX-“, 0)‘);

Answer: C

Explanation:

syntax for partial  masking is partial (prefix, [padding], suffix)

Question 6:

As a data engineer for a transportation company, you have been asked to design the streaming pipeline to collect the telemetry data about driver driving patterns and display on dashboard to analyze the safety. You have decided to go with Azure Event Hubs, Stream analytics and Power BI based solution. Here are the options to setup the system. Arrange the 5 actions that you should perform in the right sequence.
A- Start the Stream analytics job
B- Configure Power BI as the output for the Stream analytics Job
C- Build the Power BI dashboard to visualize the traffic data on a map
D- Build the Stream analytics query to aggregate the data based on locality
E- Copy the aggregated data into Synapse SQL Pool
F- Configure the Event Hubs as the input for Stream analytics job

A. F, B, D, A, C
B. A, B, C, D, E
C. G, A, B, D, C

Answer: A

Explanation:

First, we need to configure Input, Output and then stream analytics query and then need s to start streaming job. Finally need to build power bi dashboard to visualize the data.

Question 7:

As a data engineer for a retail company, there are three types of data the company wants to store in Azure Blob Storage. Select the storage tiers that you should recommend for storing data for generating quarterly sales reports.

A. Hot tier
B. Cold tier
C. Archive report

Answer: B

Explanation:

Cold storage requires data to be stored for at least 30 days. Since in this case data is accessed quarterly to generate quarterly report. Cold tier is used.

Question 8:

When creating a new cluster in the Azure Data bricks workspace, what happens behind the scenes?

A. Azure Databricks provisions a dedicated VM that processes all jobs, bas
B. Azure Databricks provisions a dedicated VM that processes all jobs, based on your VM type and size selection.
C. Azure Databricks creates a cluster of driver and worker nodes, based on your VM type and size selections.
D. When an Azure Databricks workspace is deployed, you are allocated a pool of VMs. Creating a cluster draws from this pool.

Answer: C

Explanation:

At the time of cluster creation, you specify the types and sizes of the virtual machines (VMs) to use for both the Driver and Worker nodes, but Azure Data bricks manages all other aspects of the cluster.

Question 9:

You are hired as data engineer and you need to monitor the performance of the ADF pipeline for the last month. How would you do in azure portal?

A. both A and B
B. Create diagnostic setting, route the pipeline data to Log Analytics
C. Use the ADF pipeline activity dashboard

Answer: A

Explanation:

Activity dashboard stores the activities for last 45 days.

Question 10:

You are planning to migrate your applications from on premise to Microsoft Azure. You have created 3 virtual networks to segregate Web, App and database layers virtual machines in Azure. You have created 30 virtual machines across 3 virtual networks and assigned private IP address for your virtual machines. You planned to use Azure Bastion service to remote login into your Azure VMs.
How many Azure Bastion services you must consider in your design keeping costs minimal?

A. 3
B. 1
C. 30

Answer: A

Explanation:

As there are 3 virtual networks, 3 Azure Bastion services required to keep cost minimum.