DP-203 practice questions 131–140

1. Question 131 · 370 in bank

   HOTSPOT - You have an Azure data factory that contains the linked service 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

   Explanation

   According to Microsoft, AutoResolveIntegrationRuntime will attempt to use the sink location to get an IR in the same region (or the closest available) to execute the Copy activity, not the source location. I would go with the region of data factory, since that is the default option when the sink's location is not detectable. Source: https://learn.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime#azure-ir-location

   Source: Adapted from community discussion — peches

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

2. Question 132 · 370 in bank

   HOTSPOT - In Azure Data Factory, you have a schedule trigger that is scheduled in Pacific Time. Pacific Time observes daylight saving time. The trigger has the following JSON file.

   

   Use the drop-down menus to select the answer choice that completes each statement based on the information presented. 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

   1. two times 2. will automatically adjust "For time zones that observe daylight saving, trigger time will auto-adjust for the twice a year change, if the recurrence is set to Days or above. To opt out of the daylight saving change, please select a time zone that does not observe daylight saving, for instance UTC." https://learn.microsoft.com/en-us/azure/data-factory/how-to-create-schedule-trigger?tabs=data-factory#azure-data-factory-and-synapse-portal-experience

   Source: Adapted from community discussion — ludaka

   References

   • Microsoft Learn

   

   Next question

3. Question 133 · 370 in bank

   You have an Azure Synapse Analytics dedicated SQL pool. You need to create a pipeline that will execute a stored procedure in the dedicated SQL pool and use the returned result set as the input for a downstream activity. The solution must minimize development effort. Which type of activity should you use in the pipeline?

   • AU-SQL
   • BStored Procedure
   • CScript
   • DNotebook

   Show answer

   Answer: C

   Explanation

   For me the correct answer is C. The store procedure activity doesn't return any data. In the description of the script activity is written that it can be used for : "Run stored procedures. If the SQL statement invokes a stored procedure that returns results from a temporary table, use the WITH RESULT SETS option to define metadata for the result set. " https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-script

   Source: Adapted from community discussion — ludaka

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

4. Question 134 · 370 in bank

   Select 2

   You have an Azure SQL database named DB1 and an Azure Data Factory data pipeline named pipeline1. 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 pipeline1 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? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • AScript
   • BCopy
   • CLookup
   • DStored Procedure

   Show answer

   Answer: AC

   Explanation

   When the stored procedure has Output parameters, instead of using stored procedure activity, use lookup activity and Script activity. Stored procedure activity does not support calling SPs with Output parameter yet. https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-script

   Source: Adapted from community discussion — Azure_2023

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

5. Question 135 · 370 in bank

   Select 2

   You have an Azure data factory named ADF1. You currently publish all pipeline authoring changes directly to ADF1. You need to implement version control for the changes made to pipeline artifacts. The solution must ensure that you can apply version control to the resources currently defined in the Azure Data Factory Studio for ADF1. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • AFrom the Azure Data Factory Studio, run Publish All.
   • BCreate an Azure Data Factory trigger.
   • CCreate a Git repository.
   • DCreate a GitHub action.
   • EFrom the Azure Data Factory Studio, select Set up code repository.
   • FFrom the Azure Data Factory Studio, select Publish.

   Show answer

   Answer: CE

   Next question

6. Question 136 · 370 in bank

   You have an Azure data factory named ADF1 that contains a pipeline named Pipeline1. Pipeline1 must execute every 30 minutes with a 15-minute offset. You need to create a trigger for Pipeline1. The trigger must meet the following requirements: • Backfill data from the beginning of the day to the current time. • If Pipeline1 fails, ensure that the pipeline can re-execute within the same 30-minute period. • Ensure that only one concurrent pipeline execution can occur. • Minimize development and configuration effort. Which type of trigger should you create?

   • Aschedule
   • Bevent-based
   • Cmanual
   • Dtumbling window

   Show answer

   Answer: D

   References

   • Microsoft Learn

   Next question

7. Question 137 · 370 in bank

   You have an Azure Data Lake Storage Gen2 account named account1 and an Azure event hub named Hub1. Data is written to account1 by using Event Hubs Capture. You plan to query account by using an Apache Spark pool in Azure Synapse Analytics. You need to create a notebook and ingest the data from account1. The solution must meet the following requirements: • Retrieve multiple rows of records in their entirety. • Minimize query execution time. • Minimize data processing. Which data format should you use?

   • AParquet - O. Avro
   • BORC
   • CJSON

   Show answer

   Answer: A

   Explanation

   Answer is B, here is why: Avro and Parquet are both binary compressed file formats which makes them preferred over CSV which stores the data as strings (much larger files). Now the difference between Parquet and Avro is the format, as Parquet is column based while Avro provides row based store. Since the requirement is to retrieve rows in their entirety, it is better to use Avro. Scenarios where we only retrieve a subset of columns for analysis would favour the use of Parquet.

   Source: Adapted from community discussion — jongert

   Next question

8. Question 138 · 370 in bank

   You have an Azure Blob Storage account named blob1 and an Azure Data Factory pipeline named pipeline1. You need to ensure that pipeline1 runs when a file is deleted from a container in blob1. The solution must minimize development effort. Which type of trigger should you use?

   • Aschedule
   • Bstorage event
   • Ctumbling window
   • Dcustom event

   Show answer

   Answer: B

   Explanation

   "A Storage Event trigger in Azure Data Factory is designed to initiate a pipeline in response to an event happening in Azure Blob Storage, such as the deletion of a file" So B.

   Source: Adapted from community discussion — vernillen

   References

   • Microsoft Learn

   Next question

9. Question 139 · 370 in bank

   HOTSPOT - You have Azure Data Factory configured with Azure Repos Git integration. The collaboration branch and the publish branch are set to the default values. You have a pipeline named pipeline1. You build a new version of pipeline1 in a branch named feature1. From the Data Factory Studio, you select Publish. The source code of which branch will be built, and which branch will contain the output of the Azure Resource Manager (ARM) template? To answer, select the appropriate options in the answer area. 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

   Correct, publish branch contains only ADF related code in JSON format. All the source code can be found in the collaboration branch which is by default the main branch. https://learn.microsoft.com/en-us/azure/data-factory/source-control

   Source: Adapted from community discussion — jongert

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

10. Question 140 · 370 in bank

    DRAG DROP - You have an Azure subscription that contains an Azure data factory. You are editing an Azure Data Factory activity JSON. The script needs to copy a file from Azure Blob Storage to multiple destinations. The solution must ensure that the source and destination files have consistent folder paths. How should you complete the script? 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

    References

    • Microsoft Learn

    

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DP-203 practice, question 131. 370 questions available.