DRAG DROP
You plan to create for an alert for a Microsoft Azure Data Factory pipeline.
You need to configure the alert to trigger when the total number of failed runs exceeds five within a three-hour
period.
How should you configure the window size and the threshold in the JSON file? 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.
Select and Place:

You have a Microsoft Azure SQL data warehouse named DW1 that is used only from Monday to Friday.
You need to minimize Data Warehouse Unit (DWU) usage during the weekend.
What should you do?

DRAG DROP
You have an Apache Hive database in a Microsoft Azure HDInsight cluster.
You create an Azure Data Factory named DF1.
You need to transform the data in the Hive database and to output the data to Azure Blob storage.
Which three cmdlets should you run in sequence? To answer, move the appropriate cmdlets from the list of
cmdlets to the answer area and arrange them in the correct order.
Select and Place:

HOTSPOT
You are creating a series of activities for a Microsoft Azure Data Factory. The first activity will copy an input
dataset named Dataset1 to an output dataset named Dataset2. The second activity will copy a dataset named
Dataset3 to an output dataset named Dataset4.
Dataset1 is located in Azure Table Storage. Dataset2 is located in Azure Blob storage. Dataset3 is located in an
Azure Data Lake store. Dataset4 is located in an Azure SQL data warehouse.
You need to configure the inputs for the second activity. The solution must ensure that Dataset3 is copied after
Dataset2 is created.
How should you complete the JSON code for the second activity? To answer, select the appropriate options in
the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

You have a Microsoft Azure Data Factory that recently ran several activities in parallel.
You receive alerts indicating that there are insufficient resources.
From the Activity Windows list in the Monitoring and Management app, you discover the statuses described in
the following table.

Which activity cannot complete because of insufficient resources?

You need to define an input dataset for a Microsoft Azure Data Factory pipeline.
Which properties should you include when you define the dataset?

DRAG DROP
You have an on-premises Microsoft SQL Server instance named Instance1 that contains a database named
DB1.
You have a Data Management Gateway named Gateway1.
You plan to create a linked service in Azure Data Factory for DB1.
You need to connect to DB1 by using standard SQL Server Authentication. You must use a username of User1
and a password of P@$$w0rd89.
How should you complete the JSON code? 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.
Select and Place:

You have an on-premises Microsoft SQL Server instance.
You plan to copy a table from the instance to a Microsoft Azure Storage account.
You need to ensure that you can copy the table by using Azure Data Factory.
Which service should you deploy?

You have a Microsoft Azure SQL data warehouse. You have an Azure Data Lake Store that contains data from
ORC, RC, Parquet, and delimited text files.
You need to load the data to the data warehouse in the least amount of time possible.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

HOTSPOT
You are designing a fact table that has 100 million rows and 1,800 partitions. The partitions are defined based
on a column named OrderDayKey. The fact table will contain:
Data from the last five years
A clustered columnstore index
A column named YearMonthKey that stores the year and the month
Multiple transformations will be performed on the fact table during the loading process. The fact table will be
hash distributed on a column named OrderId.
You plan to load the data to a staging table and to perform transformations on the staging table. You will then
load the data from the staging table to the final fact table.
You need to design a solution to load the data to the fact table. The solution must minimize how long it takes to
perform the following tasks:
Load the staging table.
Transfer the data from the staging table to the fact table.
Remove data that is older than five years.
Query the data in the fact table.
How should you configure the tables? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area: