Venture into the uncharted territories of certification, armed with the DP-203 dumps as your trusted companion. Through thick and thin, the DP-203 dumps provide a trail of enlightening practice questions. The PDFs echo the tales of old, radiating wisdom, while the VCE format dances with dynamism, bringing learning to life. The study guide, woven with the DP-203 dumps, crafts a tapestry of understanding. Our 100% Pass Guarantee stands tall, a lighthouse guiding you amidst the vast ocean of information.
Secure top scores in the DP-203 exam with our free, state-of-the-art PDF and Exam Questions
Question 1:
HOTSPOT
You have an Azure subscription.
You need to deploy an Azure Data Lake Storage Gen2 Premium account. The solution must meet the following requirements:
1.
Blobs that are older than 365 days must be deleted.
2.
Administrator efforts must be minimized.
3.
Costs must be minimized
What should you use? To answer, select the appropriate options in the answer area. NOTE Each correct selection is worth one point.
Hot Area:
Correct Answer:
Question 2:
HOTSPOT
You are designing an Azure Stream Analytics solution that receives instant messaging data from an Azure event hub.
You need to ensure that the output from the Stream Analytics job counts the number of messages per time zone every 15 seconds.
How should you complete the Stream Analytics query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Box 1: timestamp by
Box 2: TUMBLINGWINDOW
Tumbling window functions are used to segment a data stream into distinct time segments and perform a function against them, such as the example below. The key differentiators of a Tumbling window are that they repeat, do not overlap,
and an event cannot belong to more than one tumbling window.
Question 3:
HOTSPOT
You are building an Azure Synapse Analytics dedicated SQL pool that will contain a fact table for transactions from the first half of the year 2020.
You need to ensure that the table meets the following requirements:
1.
Minimizes the processing time to delete data that is older than 10 years
2.
Minimizes the I/O for queries that use year-to-date values
How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Box 1: PARTITION
RANGE RIGHT FOR VALUES is used with PARTITION.
Part 2: [TransactionDateID]
Partition on the date column.
Example: Creating a RANGE RIGHT partition function on a datetime column
The following partition function partitions a table or index into 12 partitions, one for each month of a year\’s worth of values in a datetime column.
CREATE PARTITION FUNCTION [myDateRangePF1] (datetime)
AS RANGE RIGHT FOR VALUES (\’20030201\’, \’20030301\’, \’20030401\’, \’20030501\’, \’20030601\’, \’20030701\’, \’20030801\’, \’20030901\’, \’20031001\’, \’20031101\’, \’20031201\’);
Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-partition-function-transact-sql
Question 4:
You have an Azure Synapse Analystics dedicated SQL pool that contains a table named Contacts. Contacts contains a column named Phone. You need to ensure that users in a specific role only see the last four digits of a phone number when querying the Phone column.
What should you include in the solution?
A. a default value
B. dynamic data masking
C. row-level security (RLS)
D. column encryption
E. table partitions
Correct Answer: B
Dynamic data masking helps prevent unauthorized access to sensitive data by enabling customers to designate how much of the sensitive data to reveal with minimal impact on the application layer. It\’s a policy-based security feature that hides the sensitive data in the result set of a query over designated database fields, while the data in the database is not changed.
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview
Question 5:
HOTSPOT
You are implementing Azure Stream Analytics windowing functions.
Which windowing function should you use for each requirement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point
Hot Area:
Correct Answer:
Question 6:
DRAG DROP
You are designing an Azure Data Lake Storage Gen2 structure for telemetry data from 25 million devices distributed across seven key geographical regions. Each minute, the devices will send a JSON payload of metrics to Azure Event Hubs.
You need to recommend a folder structure for the data. The solution must meet the following requirements:
1.
Data engineers from each region must be able to build their own pipelines for the data of their respective region only.
2.
The data must be processed at least once every 15 minutes for inclusion in Azure Synapse Analytics serverless SQL pools.
How should you recommend completing the structure? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to
view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Correct Answer:
Box 1: {regionID}/raw
Data engineers from each region must be able to build their own pipelines for the data of their respective region only.
Box 2: {YYYY}/{MM}/{DD}/{HH}
Date Format [optional]: if the date token is used in the prefix path, you can select the date format in which your files are organized. Example: YYYY/MM/DD
Time Format [optional]: if the time token is used in the prefix path, specify the time format in which your files are organized. Currently the only supported value is HH.
Box 3: {deviceID}
Reference: https://github.com/paolosalvatori/StreamAnalyticsAzureDataLakeStore/blob/master/README.md
Question 7:
HOTSPOT – (Topic 3)
You have an Azure subscription that contains the following resources:
1.
An Azure Active Directory (Azure AD) tenant that contains a security group named Group1.
2.
An Azure Synapse Analytics SQL pool named Pool1.
You need to control the access of Group1 to specific columns and rows in a table in Pool1
Which Transact-SQL commands should you use? To answer, select the appropriate options in the answer area.
NOTE: Each appropriate options in the answer area.
Hot Area:
Correct Answer:
Description automatically generated Box 1: GRANT You can implement column-level security with the GRANT T-SQL statement.
Box 2: CREATE SECURITY POLICY Implement Row Level Security by using the CREATE SECURITY POLICY Transact-SQL statement
Question 8:
You have an Azure Data Factory pipeline that is triggered hourly.
The pipeline has had 100% success for the past seven days.
The pipeline execution fails, and two retries that occur 15 minutes apart also fail. The third failure returns the following error.
ErrorCode=UserErrorFileNotFound,\’Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ADLS Gen2 operation failed for: Operation returned an invalid statuscode \’NotFound\’. Account: \’contosoproduksouth\’. Filesystem: wwi. Path: \’BIKES/CARBON/year=2021/month=01/day=10/hour=06\’. ErrorCode: \’PathNotFound\’. Message: \’The specified pathdoes not exist.\’. RequestId: \’6d269b78-901f-001b-4924-e7a7bc000000\’. TimeStamp: \’Sun, 10 Jan 2021 07:45:05
What is a possible cause of the error?
A. From 06.00 to 07:00 on January 10.2021 there was no data in w1/bikes/CARBON.
B. The parameter used to generate year.2021/month=0/day=10/hour=06 was incorrect
C. From 06:00 to 07:00 on January 10,2021 the file format of data wi/BiKES/CARBON was incorrect
D. The pipeline was triggered too early.
Correct Answer: B