DP-203 practice questions 331–340

1. Question 331 · 370 in bank

   You have an Azure Data Lake Storage Gen2 account named account1 that contains a container named container1. You plan to create lifecycle management policy rules for container1. You need to ensure that you can create rules that will move blobs between access tiers based on when each blob was accessed last. What should you do first?

   • AConfigure object replication
   • BCreate an Azure application
   • CEnable access time tracking
   • DEnable the hierarchical namespace

   Show answer

   Answer: C

   Explanation

   Answer is correct. Customers stores huge amount of data in Azure blob storage. Sometimes this data is accessed frequently and other times infrequently. Last access time tracking integrates with the lifecycle of Azure blob storage to allow automatic tiering and deletion of data based on when individual blobs are accessed last.

   Source: Adapted from community discussion — cloud_lady

   References

   • azure.microsoft.com documentation

   Next question

2. Question 332 · 370 in bank

   You have an Azure subscription that contains the resources shown in the following table.

   

   Diagnostic logs from ADF1 are sent to LA1. ADF1 contains a pipeline named Pipeline1 that copies data from DB1 to Dw1. You need to perform the following actions: • Create an action group named AG1. • Configure an alert in ADF1 to use AG1. In which resource group should you create AG1?

   • ARG1
   • BRG2
   • CRG3
   • DRG4

   Show answer

   Answer: C

   Explanation

   To create an action group (AG1) and configure an alert in Azure Data Factory (ADF1) to use AG1, you should create AG1 in the same resource group as ADF1. This ensures that the alert configuration and action group are within the same scope for easier management and integration.

   Source: Adapted from community discussion — JamieMcD

   Next question

3. Question 333 · 370 in bank

   HOTSPOT - You have an Azure data factory named DF1 that contains 10 pipelines. The pipelines are executed hourly by using a schedule trigger. All activities are executed on an Azure integration runtime. You need to ensure that you can identify trends in queue times across the pipeline executions and activities The solution must minimize administrative effort. How should you configure the Diagnostic settings for DF1? 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

   1. To identify trends in queue times, you should focus on the Pipeline activity run logs rather than the Pipeline run logs. Pipeline activity run logs allows you to track the queue times for individual activities within the pipeline. While Pipeline run logs logs may provide some information about queue times, they do not provide granular details for each activity within the pipeline.

   Source: Adapted from community discussion — vk8880

   References

   • Microsoft Learn

   

   Next question

4. Question 334 · 370 in bank

   HOTSPOT - You have an Azure subscription that contains the resources shown in the following table.

   

   You need to ensure that you can run Spark notebooks in ws1.The solution must ensure that you can retrieve secrets from kv1 by using UAMI1. What should you do? 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

   In the Azure Portal --> Add a role-based access control (RBAC) role to kv1 In Synapse Studio --> Create a linked service to kv1

   Source: Adapted from community discussion — hassexat

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

5. Question 335 · 370 in bank

   HOTSPOT - You have an Azure Data Factory pipeline shown in the following exhibit.

   

   The execution log for the first pipeline run is shown in the following exhibit.

   

   The execution log for the second pipeline run is shown in the following exhibit.

   

   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

   Explanation

   ExamTopics team, please, do one of the following: 1) clearly explain and provide the support link or material for the answer you chose, or 2) correct the answers selected. As stated in answers below in this discussion, the response are N-Y-N or N-N-N, but there's nothing that can point us to the answer given in the resolution.

   Source: Adapted from community discussion — y154707

   

   Next question

6. Question 336 · 370 in bank

   You are monitoring an Azure Stream Analytics job. The Backlogged Input Events count has been 20 for the last hour. You need to reduce the Backlogged Input Events count. What should you do?

   • ADrop late arriving events from the job.
   • BAdd an Azure Storage account to the job.
   • CIncrease the streaming units for the job.
   • DStop the job.

   Show answer

   Answer: C

   Explanation

   Correct. "Backlogged Input Events Number of input events that are backlogged. A non-zero value for this metric implies that your job isn't able to keep up with the number of incoming events. If this value is slowly increasing or consistently non-zero, you should scale out your job." https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-monitoring

   Source: Adapted from community discussion — MinionVII

   References

   • Microsoft Learn

   Next question

7. Question 337 · 370 in bank

   Select 2

   You have several Azure Data Factory pipelines that contain a mix of the following types of activities: • Power Query • Notebook • Copy • Jar Which two Azure services should you use to debug the activities? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • AAzure Machine Learning
   • BAzure Data Factory
   • CAzure Synapse Analytics
   • DAzure HDInsight
   • EAzure Databricks

   Show answer

   Answer: BE

   Explanation

   The Copy activity is native to Azure Data Factory, so you would use Azure Data Factory to debug it. The Notebook and Jar activities are related to Databricks jobs, so you would use Azure Databricks to debug them. Power Query is more associated with data wrangling and transformation, and while it can be used in various services, in the context of Azure Data Factory, you'd likely be debugging within Azure Data Factory or Azure Synapse Analytics. However, given the other activities listed, Azure Data Factory is the more probable choice for this scenario. Therefore, the correct answers are: B. Azure Data Factory E. Azure Databricks

   Source: Adapted from community discussion — Sdevi49

   Next question

8. Question 338 · 370 in bank

   You have an Azure Synapse Analytics dedicated SQL pool named pool1. You need to perform a monthly audit of SQL statements that affect sensitive data. The solution must minimize administrative effort. What should you include in the solution?

   • Aworkload management
   • Bsensitivity labels
   • Cdynamic data masking
   • DMicrosoft Defender for SQL

   Show answer

   Answer: B

   Explanation

   D. Microsoft Defender for SQL Here’s why: Microsoft Defender for SQL: This service provides advanced threat protection and security capabilities for your SQL databases. It includes features like vulnerability assessments, advanced threat detection, and auditing capabilities. By enabling Microsoft Defender for SQL, you can automatically monitor and audit SQL statements that affect sensitive data, ensuring compliance and security with minimal administrative effort1. Other Options: Workload Management (A): This is more about managing and optimizing resource allocation and performance rather than auditing SQL statements. Sensitivity Labels (B): These are used to classify and protect sensitive data, but they do not provide auditing capabilities. Dynamic Data Masking ©: This feature helps to obfuscate sensitive data in query results but does not audit SQL statements.

   Source: Adapted from community discussion — f2a9aa5

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

9. Question 339 · 370 in bank

   HOTSPOT - You have an Azure data factory. You execute a pipeline that contains an activity named Activity1. Activity1 produces the following output.

   

   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

   Explanation

   At last an answer from Examtopics team that makes sense with the problem stated and is not based on an alternate wacky multiverse where all the rules and good practices of Azure are broken.

   Source: Adapted from community discussion — y154707

   

   Next question

10. Question 340 · 370 in bank

    HOTSPOT - You have an Azure Data Lake Storage Gen2 account named account1 that contains a container named Container1. Container1 contains two folders named FolderA and FolderB. You need to configure access control lists (ACLs) to meet the following requirements: • Group1 must be able to list and read the contents and subfolders of FolderA. • Group2 must be able to list and read the contents of FolderA and FolderB. • Group2 must be prevented from reading any other folders at the root of Container1. How should you configure the ACL permissions for each group? 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

    

    Next question

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

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