DP-203AssociateMicrosoftAll questions freePage 16 of 37

DP-203 practice questions 151–160

Data Engineering on Microsoft Azure370 questions across 37 pages are complete and free, with no account or card.

Start practising Review syllabus domains

Questions 151–160 · 370 available

Free practiceExam guide

Official study references

370 questions in this bank

Free access · progress saved on this device

Question 151 · 370 in bank
You have an Azure Data Factory pipeline named P1. You need to schedule P1 to run at 10:15 AM, 12:15 PM, 2:15 PM, and 4:15 PM every day. Which frequency and interval should you configure for the scheduled trigger?
Show answer
Answer: B
Explanation
Correct me if I am wrong guys, but if option B is correct does that mean you have to create 4 separate triggers with the Frequency: Day and Interval: 1? If that is the case then I am more inclined to B, since D will still run even after 4:15PM. If we want it to run only for the 4 times specified above then B is a more accurate answer.
Source: Adapted from community discussion — Delphin_8150
References
Microsoft Learn
Microsoft Learn
Permanent link to question 151 Report an issue
Question 152 · 370 in bank
You are designing a statistical analysis solution that will use custom proprietary Python functions on near real-time data from Azure Event Hubs. You need to recommend which Azure service to use to perform the statistical analysis. The solution must minimize latency. What should you recommend?
Show answer
Answer: B
Explanation
My answer will be B Stream Analytics supports "extending SQL language with JavaScript and C# user-defined functions (UDFs)". There is no mention of Python support; hence Stream Analytics is not correct. https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-introduction Azure Databricks supports near real-time data from Azure Event Hubs. And includes support for R, SQL, Python, Scala, and Java. So I will go for option B.
Source: Adapted from community discussion — kolakone
References
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Microsoft Learn
Permanent link to question 152 Report an issue
Question 153 · 370 in bank
You are creating an Azure Data Factory pipeline. You need to add an activity to the pipeline. The activity must execute a Transact-SQL stored procedure that has the following characteristics: • Returns the number of sales invoices for a current date • Does NOT require input parameters Which type on activity should you use?
Show answer
Answer: D
Explanation
The Stored Procedure Activity does not allow to return an output, so Lookup is the correct one. Refer to: https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-stored-procedure
Source: Adapted from community discussion — Alongi
References
Microsoft Learn
Microsoft Learn
Permanent link to question 153 Report an issue
Question 154 · 370 in bank
HOTSPOT - You have an Azure Synapse Analytics workspace that contains three pipelines and three triggers named Trigger1, Trigger2, and Trigger3. Trigger3 has the following definition.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Permanent link to question 154 Report an issue
Question 155 · 370 in bank
DRAG DROP - You have an Azure Databricks deployment and a local file named /tmp/file1 that contains the following code.
You need to read /tmp/file1 into a data frame by using Scala. How should you complete the code? 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.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Explanation
The multiline option is necessary when reading JSON files that span multiple lines per record. In the given example, each JSON object in the array is spread over several lines, which is typical for nested or complex JSON structures. Without enabling the multiline option, Spark would expect each JSON record to be on a single line, and it would not be able to correctly parse the provided file.
Source: Adapted from community discussion — evangelist
References
Microsoft Learn
Permanent link to question 155 Report an issue
Question 156 · 370 in bank
You 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?
Show answer
Answer: B
References
Microsoft Learn
Permanent link to question 156 Report an issue
Question 157 · 370 in bank
You have an Azure subscription that contains an Azure Synapse Analytics account. The account is integrated with an Azure Repos repository named Repo1 and contains a pipeline named Pipeline1. Repo1 contains the branches shown in the following table.
From featuredev, you develop and test changes to Pipeline1. You need to publish the changes. What should you do first?
Show answer
Answer: A
Permanent link to question 157 Report an issue
Question 158 · 370 in bank
HOTSPOT - You have an Azure data factory that has the Git repository settings shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct answer is worth one point.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Permanent link to question 158 Report an issue
Question 159 · 370 in bank
HOTSPOT - You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named Pool1 and a storage account. The storage account contains a blob container. The blob container contains multiple CSV files. You plan to load the files into Pool1 by using the following code.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Permanent link to question 159 Report an issue
Question 160 · 370 in bank
DRAG DROP - You have an Azure subscription that contains an Azure Data Factory account named ADF1 and an Azure Data Lake Storage Gen2 account named storage1. ADF1 contains the objects shown in the following table.
You need to configure DailyIngestion to perform the following actions: • Ingest 2,000 small files into storage1 once every 24 hours. • Output one large file once every 24 hours. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Explanation
Add a Copy data activity: This is required to copy the data from the source files (2,000 small files) to the target (1 large file). It’s the primary activity for this task. Configure datasets and parameters: The SourceFiles dataset must point to the 2,000 small files, and the TargetFile dataset must point to the location for the large file. Dynamic parameters ensure scalability and reusability. Configure Copy behavior: The Copy behavior setting in the Copy Data activity allows you to specify how files are handled. In this case, choose "Merge files" to combine all small files into one large file.
Source: Adapted from community discussion — a6cb3b0
Permanent link to question 160 Report an issue