Microsoft Microsoft Certifications DP-203 Questions & Answers

• Question 81:

  HOTSPOT

  You have an Azure Data Factory pipeline that has the activities 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 selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: succeed

  Box 2: failed

  Example:

  Now let's say we have a pipeline with 3 activities, where Activity1 has a success path to Activity2 and a failure path to Activity3. If Activity1 fails and Activity3 succeeds, the pipeline will fail. The presence of the success path alongside the

  failure path changes the outcome reported by the pipeline, even though the activity executions from the pipeline are the same as the previous scenario.

  

  Activity1 fails, Activity2 is skipped, and Activity3 succeeds. The pipeline reports failure.

• Question 82:

  HOTSPOT

  You have an Azure subscription that is linked to a hybrid Azure Active Directory (Azure AD) tenant. The subscription contains an Azure Synapse Analytics SQL pool named Pool1.

  You need to recommend an authentication solution for Pool1. The solution must support multi-factor authentication (MFA) and database-level authentication.

  Which authentication solution or solutions should you include m the recommendation? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Azure AD authentication

  Azure AD authentication has the option to include MFA.

  Box 2: Contained database users

  Azure AD authentication uses contained database users to authenticate identities at the database level.

  Reference:

  https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview

  https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview

• Question 83:

  HOTSPOT

  You need to implement an Azure Databricks cluster that automatically connects to Azure Data Lake Storage Gen2 by using Azure Active Directory (Azure AD) integration.

  How should you configure the new cluster? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Premium

  Credential passthrough requires an Azure Databricks Premium Plan

  Box 2: Azure Data Lake Storage credential passthrough

  You can access Azure Data Lake Storage using Azure Active Directory credential passthrough.

  When you enable your cluster for Azure Data Lake Storage credential passthrough, commands that you run on that cluster can read and write data in Azure Data Lake Storage without requiring you to configure service principal credentials for

  access to storage.

  Reference:

  https://docs.microsoft.com/en-us/azure/databricks/security/credential-passthrough/adls-passthrough

• Question 84:

  HOTSPOT

  You use Azure Data Lake Storage Gen2 to store data that data scientists and data engineers will query by using Azure Databricks interactive notebooks. Users will have access only to the Data Lake Storage folders that relate to the projects

  on which they work.

  You need to recommend which authentication methods to use for Databricks and Data Lake Storage to provide the users with the appropriate access. The solution must minimize administrative effort and development effort.

  Which authentication method should you recommend for each Azure service? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Personal access tokens

  You can use storage shared access signatures (SAS) to access an Azure Data Lake Storage Gen2 storage account directly. With SAS, you can restrict access to a storage account using temporary tokens with fine-grained access control.

  You can add multiple storage accounts and configure respective SAS token providers in the same Spark session.

  Box 2: Azure Active Directory credential passthrough

  You can authenticate automatically to Azure Data Lake Storage Gen1 (ADLS Gen1) and Azure Data Lake Storage Gen2 (ADLS Gen2) from Azure Databricks clusters using the same Azure Active Directory (Azure AD) identity that you use to

  log into Azure Databricks. When you enable your cluster for Azure Data Lake Storage credential passthrough, commands that you run on that cluster can read and write data in Azure Data Lake Storage without requiring you to configure

  service principal credentials for access to storage.

  After configuring Azure Data Lake Storage credential passthrough and creating storage containers, you can access data directly in Azure Data Lake Storage Gen1 using an adl:// path and Azure Data Lake Storage Gen2 using an abfss://

  path:

  Reference:

  https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/azure/adls-gen2/azure-datalake-gen2-sas-access

  https://docs.microsoft.com/en-us/azure/databricks/security/credential-passthrough/adls-passthrough

• Question 85:

  HOTSPOT

  You are implementing an Azure Stream Analytics solution to process event data from devices.

  The devices output events when there is a fault and emit a repeat of the event every five seconds until the fault is resolved. The devices output a heartbeat event every five seconds after a previous event if there are no faults present.

  A sample of the events is shown in the following table.

  

  You need to calculate the uptime between the faults.

  How should you complete the Stream Analytics SQL 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: WHERE EventType='HeartBeat'

  Box 2: ,TumblingWindow(Second, 5)

  Tumbling windows are a series of fixed-sized, non-overlapping and contiguous time intervals.

  The following diagram illustrates a stream with a series of events and how they are mapped into 10-second tumbling windows.

  

• Question 86:

  HOTSPOT

  You are building an Azure Data Factory solution to process data received from Azure Event Hubs, and then ingested into an Azure Data Lake Storage Gen2 container.

  The data will be ingested every five minutes from devices into JSON files. The files have the following naming pattern.

  /{deviceType}/in/{YYYY}/{MM}/{DD}/{HH}/{deviceID}_{YYYY}{MM}{DD}HH}{mm}.json

  You need to prepare the data for batch data processing so that there is one dataset per hour per deviceType. The solution must minimize read times.

  How should you configure the sink for the copy activity? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: @trigger().startTime

  startTime: A date-time value. For basic schedules, the value of the startTime property applies to the first occurrence. For complex schedules, the trigger starts no sooner than the specified startTime value.

  Box 2: /{YYYY}/{MM}/{DD}/{HH}_{deviceType}.json

  One dataset per hour per deviceType.

  Box 3: Flatten hierarchy

  - FlattenHierarchy: All files from the source folder are in the first level of the target folder. The target files have autogenerated names.

  Reference: https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers https://docs.microsoft.com/en-us/azure/data-factory/connector-file-system

• Question 87:

  HOTSPOT

  You have an Azure Data Factory instance named ADF1 and two Azure Synapse Analytics workspaces named WS1 and WS2.

  ADF1 contains the following pipelines:

  1.

  P1: Uses a copy activity to copy data from a nonpartitioned table in a dedicated SQL pool of WS1 to an Azure Data Lake Storage Gen2 account

  2.

  P2: Uses a copy activity to copy data from text-delimited files in an Azure Data Lake Storage Gen2 account to a nonpartitioned table in a dedicated SQL pool of WS2

  You need to configure P1 and P2 to maximize parallelism and performance.

  Which dataset settings should you configure for the copy activity if each pipeline? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Set the Copy method to PolyBase

  While SQL pool supports many loading methods including non-Polybase options such as BCP and SQL BulkCopy API, the fastest and most scalable way to load data is through PolyBase. PolyBase is a technology that accesses external data

  stored in Azure Blob storage or Azure Data Lake Store via the T-SQL language.

  Box 2: Set the Copy method to Bulk insert

  Polybase not possible for text files. Have to use Bulk insert.

  Reference:

  https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/load-data-overview

• Question 88:

  HOTSPOT

  You have an Azure Storage account that generates 200,000 new files daily. The file names have a format of {YYYY}/{MM}/{DD}/{HH}/{CustomerID}.csv.

  You need to design an Azure Data Factory solution that will load new data from the storage account to an Azure Data Lake once hourly. The solution must minimize load times and costs.

  How should you configure the solution? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Incremental load

  Box 2: Tumbling window

  Tumbling windows are a series of fixed-sized, non-overlapping and contiguous time intervals. The following diagram illustrates a stream with a series of events and how they are mapped into 10-second tumbling windows.

  

• Question 89:

  HOTSPOT

  You are building an Azure Stream Analytics job to retrieve game data.

  You need to ensure that the job returns the highest scoring record for each five-minute time interval of each game.

  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: TopOne OVER(PARTITION BY Game ORDER BY Score Desc) TopOne returns the top-rank record, where rank defines the ranking position of the event in the window according to the specified ordering. Ordering/ranking is based on

  event columns and can be specified in ORDER BY clause.

  Box 2: Hopping(minute,5)

  Hopping window functions hop forward in time by a fixed period. It may be easy to think of them as Tumbling windows that can overlap and be emitted more often than the window size. Events can belong to more than one Hopping window

  result set. To make a Hopping window the same as a Tumbling window, specify the hop size to be the same as the window size.

  

• Question 90:

  HOTSPOT

  You configure version control for an Azure Data Factory instance as 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 selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: adf_publish

  The Publish branch is the branch in your repository where publishing related ARM templates are stored and updated. By default, it's adf_publish.

  Box 2: / dwh_batchetl/adf_publish/contososales

  Note: RepositoryName (here dwh_batchetl): Your Azure Repos code repository name. Azure Repos projects contain Git repositories to manage your source code as your project grows. You can create a new repository or use an existing

  repository that's already in your project.

  Reference:

  https://docs.microsoft.com/en-us/azure/data-factory/source-control