DP-203 practice questions 251–260

1. Question 251 · 370 in bank

   DRAG DROP - You have a project in Azure DevOps that contains a repository named Repo1. Repo1 contains a branch named main. You create a new Azure Synapse workspace named Workspace1. You need to create data processing pipelines in Workspace1. The solution must meet the following requirements: • Pipeline artifacts must be stored in Repo1 • Source control must be provided for pipeline artifacts. • All development must be performed in a feature branch. Which four actions should you perform in sequence in Synapse Studio? 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

   Configure a code repo and select Repo1 Set the main branch as the collaboration branch Create a new brach Create pipeline artifacts and save them in the new branch

   Source: Adapted from community discussion — SinSS

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

2. Question 252 · 370 in bank

   Select 2

   You have an Azure subscription that contains an Azure SQL database named DB1 and a storage account named storage1. The storage1 account contains a file named File1.txt. File1.txt contains the names of selected tables in DB1. You need to use an Azure Synapse pipeline to copy data from the selected tables in DB1 to the files in storage1. The solution must meet the following requirements: • The Copy activity in the pipeline must be parameterized to use the data in File1.txt to identify the source and destination of the copy. • Copy activities must occur in parallel as often as possible. Which two pipeline activities should you include in the pipeline? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • AGet Metadata
   • BLookup
   • CForEach
   • DIf Condition

   Show answer

   Answer: BC

   Explanation

   It's BC. Use the LookUp Activity to read the .txt file. ForEach to Loop though making sure Sequential is off (which off by default) for parallelization

   Source: Adapted from community discussion — FRANCIS_A_M

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

3. Question 253 · 370 in bank

   You have an Azure data factory that connects to a Microsoft Purview account. The data factory is registered in Microsoft Purview. You update a Data Factory pipeline. You need to ensure that the updated lineage is available in Microsoft Purview. What should you do first?

   • ADisconnect the Microsoft Purview account from the data factory.
   • BExecute the pipeline.
   • CExecute an Azure DevOps build pipeline.
   • DLocate the related asset in the Microsoft Purview portal.

   Show answer

   Answer: B

   Explanation

   By executing the pipeline, the Data Factory will generate the lineage information and propagate it to the connected Microsoft Purview account. This will update the lineage in Purview and reflect any changes made in the pipeline.

   Source: Adapted from community discussion — vctrhugo

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

4. Question 254 · 370 in bank

   You have a Microsoft Purview account. The Lineage view of a CSV file is shown in the following exhibit.

   

   How is the data for the lineage populated?

   • Amanually
   • Bby scanning data stores
   • Cby executing a Data Factory pipeline

   Show answer

   Answer: C

   References

   • Microsoft Learn

   Next question

5. Question 255 · 370 in bank

   Select 2

   You have an Azure subscription that contains a Microsoft Purview account named MP1, an Azure data factory named DF1, and a storage account named storage1. MP1 is configured to scan storage1. DF1 is connected to MP1 and contains a dataset named DS1. DS1 references a file in storage1. In DF1, you plan to create a pipeline that will process data from DS1. You need to review the schema and lineage information in MP1 for the data referenced by DS1. Which two features can you use to locate the information? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.

   • Athe search bar in the Microsoft Purview governance portal
   • Bthe Storage browser of storage1 in the Azure portal
   • Cthe search bar in the Azure portal
   • Dthe search bar in Azure Data Factory Studio

   Show answer

   Answer: AD

   Explanation

   From ChatGPT : A. the search bar in the Microsoft Purview governance portal D. the search bar in Azure Data Factory Studio To review the schema and lineage information in MP1 for the data referenced by DS1, you can use the following two features: The search bar in the Microsoft Purview governance portal: You can search for the file in storage1 that is referenced by DS1 in the search bar of the Purview governance portal. Once you locate the file, you can view the schema and lineage information for it. The search bar in Azure Data Factory Studio: You can search for the dataset DS1 in the Azure Data Factory Studio search bar. Once you locate the dataset, you can view the schema and lineage information for the data it references in storage1, which can also be viewed in Purview.

   Source: Adapted from community discussion — Sibaprasad

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

6. Question 256 · 370 in bank

   DRAG DROP - You have an Azure Active Directory (Azure AD) tenant that contains a security group named Group1. You have an Azure Synapse Analytics dedicated SQL pool named dw1 that contains a schema named schema1. You need to grant Group1 read-only permissions to all the tables and views in schema1. The solution must use the principle of least privilege. 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. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select. Select and Place:

   

   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

   Step 1: Create a database user named dw1 that represents Group1 and use the FROM EXTERNAL PROVIDER clause. Step 2: Create a database role named Role1 and grant Role1 SELECT permissions to schema1. Step 3: Assign Role1 to the Group1 database user. Reference: https://docs.microsoft.com/en-us/azure/data-share/how-to-share-from-sql

   Source: Adapted from community discussion — eng1

   

   Next question

7. Question 257 · 370 in bank

   DRAG DROP - You have an Azure Synapse Analytics SQL pool named Pool1 on a logical Microsoft SQL server named Server1. You need to implement Transparent Data Encryption (TDE) on Pool1 by using a custom key named key1. Which five 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. Select and Place:

   

   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

   Step 1: Assign a managed identity to Server1 You will need an existing Managed Instance as a prerequisite. Step 2: Create an Azure key vault and grant the managed identity permissions to the vault Create Resource and setup Azure Key Vault. Step 3: Add key1 to the Azure key vault The recommended way is to import an existing key from a .pfx file or get an existing key from the vault. Alternatively, generate a new key directly in Azure Key Vault. Step 4: Configure key1 as the TDE protector for Server1 Provide TDE Protector key - Step 5: Enable TDE on Pool1 - Reference: https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/transparent-data-encryption-byok-powershell

   References

   • Microsoft Learn

   

   Next question

8. Question 258 · 370 in bank

   You have a data warehouse in Azure Synapse Analytics. You need to ensure that the data in the data warehouse is encrypted at rest. What should you enable?

   • AAdvanced Data Security for this database
   • BTransparent Data Encryption (TDE)
   • CSecure transfer required
   • DDynamic Data Masking

   Show answer

   Answer: B

   Next question

9. Question 259 · 370 in bank

   You are designing a streaming data solution that will ingest variable volumes of data. You need to ensure that you can change the partition count after creation. Which service should you use to ingest the data?

   • AAzure Event Hubs Dedicated
   • BAzure Stream Analytics
   • CAzure Data Factory
   • DAzure Synapse Analytics

   Show answer

   Answer: A

   Explanation

   A is the correct Answer. You can specify the number of partitions at the time of creating an event hub. In some scenarios, you may need to add partitions after the event hub has been created. This article describes how to dynamically add partitions to an existing event hub. Dynamic additions of partitions is available only in premium and dedicated tiers of Event Hubs. https://docs.microsoft.com/en-us/azure/event-hubs/dynamically-add-partitions

   Source: Adapted from community discussion — Canary_2021

   References

   • Microsoft Learn

   Next question

10. Question 260 · 370 in bank

    You are designing a date dimension table in an Azure Synapse Analytics dedicated SQL pool. The date dimension table will be used by all the fact tables. Which distribution type should you recommend to minimize data movement during queries?

    • AHASH
    • BREPLICATE
    • CROUND_ROBIN

    Show answer

    Answer: B

    Next question

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

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