Microsoft Microsoft Certifications DP-300 Questions & Answers

• Question 161:

  Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while

  others might not have a correct solution.

  After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

  You have an Azure Data Lake Storage account that contains a staging zone.

  You need to design a daily process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics.

  Solution: You use an Azure Data Factory schedule trigger to execute a pipeline that executes an Azure Databricks notebook, and then inserts the data into the data warehouse.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

  If you need to transform data in a way that is not supported by Data Factory, you can create a custom activity, not an Azure Databricks notebook, with your own data processing logic and use the activity in the pipeline. You can create a custom activity to run R scripts on your HDInsight cluster with R installed.

  Reference: https://docs.microsoft.com/en-US/azure/data-factory/transform-data

• Question 162:

  Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

  After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

  You have an Azure Data Lake Storage account that contains a staging zone.

  You need to design a daily process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics.

  Solution: You use an Azure Data Factory schedule trigger to execute a pipeline that copies the data to a staging table in the data warehouse, and then uses a stored procedure to execute the R script.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

  If you need to transform data in a way that is not supported by Data Factory, you can create a custom activity with your own data processing logic and use the activity in the pipeline. You can create a custom activity to run R scripts on your HDInsight cluster with R installed.

  Reference: https://docs.microsoft.com/en-US/azure/data-factory/transform-data

• Question 163:

  You have the following Azure Data Factory pipelines:

  1.

  Ingest Data from System1

  2.

  Ingest Data from System2

  3.

  Populate Dimensions

  4.

  Populate Facts

  Ingest Data from System1 and Ingest Data from System2 have no dependencies. Populate Dimensions must execute after Ingest Data from System1 and Ingest Data from System2. Populate Facts must execute after the Populate Dimensions pipeline. All the pipelines must execute every eight hours.

  What should you do to schedule the pipelines for execution?

  A. Add a schedule trigger to all four pipelines.

  B. Add an event trigger to all four pipelines.

  C. Create a parent pipeline that contains the four pipelines and use an event trigger.

  D. Create a parent pipeline that contains the four pipelines and use a schedule trigger.

  Correct Answer: D

  Reference: https://www.mssqltips.com/sqlservertip/6137/azure-data-factory-control-flow-activities-overview/

• Question 164:

  You have an Azure Data Factory pipeline that performs an incremental load of source data to an Azure Data Lake Storage Gen2 account.

  Data to be loaded is identified by a column named LastUpdatedDate in the source table.

  You plan to execute the pipeline every four hours.

  You need to ensure that the pipeline execution meets the following requirements:

  1.

  Automatically retries the execution when the pipeline run fails due to concurrency or throttling limits.

  2.

  Supports backfilling existing data in the table. Which type of trigger should you use?

  A. tumbling window

  B. on-demand

  C. event

  D. schedule

  Correct Answer: A

  The Tumbling window trigger supports backfill scenarios. Pipeline runs can be scheduled for windows in the past. Incorrect Answers:

  D: Schedule trigger does not support backfill scenarios. Pipeline runs can be executed only on time periods from the current time and the future.

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

• Question 165:

  You have an Azure Data Factory that contains 10 pipelines.

  You need to label each pipeline with its main purpose of either ingest, transform, or load. The labels must be available for grouping and filtering when using the monitoring experience in Data Factory.

  What should you add to each pipeline?

  A. an annotation

  B. a resource tag

  C. a run group ID

  D. a user property

  E. a correlation ID

  Correct Answer: A

  Azure Data Factory annotations help you easily filter different Azure Data Factory objects based on a tag. You can define tags so you can see their performance or find errors faster.

  Reference: https://www.techtalkcorner.com/monitor-azure-data-factory-annotations/

• Question 166:

  Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while

  others might not have a correct solution.

  After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

  You have an Azure Data Lake Storage account that contains a staging zone.

  You need to design a daily process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics.

  Solution: You use an Azure Data Factory schedule trigger to execute a pipeline that executes mapping data flow, and then inserts the data into the data warehouse.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

  If you need to transform data in a way that is not supported by Data Factory, you can create a custom activity, not a mapping flow,5 with your own data processing logic and use the activity in the pipeline. You can create a custom activity to run R scripts on your HDInsight cluster with R installed.

  Reference: https://docs.microsoft.com/en-US/azure/data-factory/transform-data

• Question 167:

  You need to trigger an Azure Data Factory pipeline when a file arrives in an Azure Data Lake Storage Gen2 container.

  Which resource provider should you enable?

  A. Microsoft.EventHub

  B. Microsoft.EventGrid

  C. Microsoft.Sql

  D. Microsoft.Automation

  Correct Answer: B

  Event-driven architecture (EDA) is a common data integration pattern that involves production, detection, consumption, and reaction to events. Data integration scenarios often require Data Factory customers to trigger pipelines based on events happening in storage account, such as the arrival or deletion of a file in Azure Blob Storage account. Data Factory natively integrates with Azure Event Grid, which lets you trigger pipelines on such events.

  Reference: https://docs.microsoft.com/en-us/azure/data-factory/how-to-create-event-trigger

• Question 168:

  You have an Azure SQL Database managed instance named SQLMI1. A Microsoft SQL Server Agent job runs on SQLMI1.

  You need to ensure that an automatic email notification is sent once the job completes.

  What should you include in the solution?

  A. From SQL Server Configuration Manager (SSMS), enable SQL Server Agent

  B. From SQL Server Management Studio (SSMS), run sp_set_sqlagent_properties

  C. From SQL Server Management Studio (SSMS), create a Database Mail profile

  D. From the Azure portal, create an Azure Monitor action group that has an Email/SMS/Push/Voice action

  Correct Answer: C

  To send a notification in response to an alert, you must first configure SQL Server Agent to send mail.

  Using SQL Server Management Studio; to configure SQL Server Agent to use Database Mail:

  1.

  In Object Explorer, expand a SQL Server instance.

  2.

  Right-click SQL Server Agent, and then click Properties.

  3.

  Click Alert System.

  4.

  Select Enable Mail Profile.

  5.

  In the Mail system list, select Database Mail.

  6.

  In the Mail profile list, select a mail profile for Database Mail.

  7.

  Restart SQL Server Agent.

  Note: Prerequisites include:

  1.

  Enable Database Mail.

  2.

  Create a Database Mail account for the SQL Server Agent service account to use.

  3.

  Create a Database Mail profile for the SQL Server Agent service account to use and add the user to the DatabaseMailUserRole in the msdb database.

  4.

  Set the profile as the default profile for the msdb database.

  Reference:

  https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/configure-sql-server-agent-mail- to-use-database-mail

• Question 169:

  You plan to move two 100-GB databases to Azure.

  You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations.

  What should you use?

  A. two Azure SQL Databases in an elastic pool

  B. two databases hosted in SQL Server on an Azure virtual machine

  C. two databases in an Azure SQL Managed instance

  D. two single Azure SQL databases

  Correct Answer: D

  Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single server and share a set number of resources at a set price.

  Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview

• Question 170:

  You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Server 2016 database named DB1.

  You plan to deploy additional instances of App1 to separate Azure regions. Each region will have a separate instance of App1 and DB1. The separate instances of DB1 will sync by using Azure SQL Data Sync.

  You need to recommend a database service for the deployment. The solution must minimize administrative effort.

  What should you include in the recommendation?

  A. Azure SQL Managed instance

  B. Azure SQL Database single database

  C. Azure Database for PostgreSQL

  D. SQL Server on Azure virtual machines

  Correct Answer: B

  Azure SQL Database single database supports Data Sync.

  Incorrect Answers:

  A: Azure SQL Managed instance does not support Data Sync.

  Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison