HOTSPOT
You plan to implement a Microsoft Azure Stream Analytics job to track the data from IoT devices. You will have
the following two jobs:
– Job1 will contain a query that has one non-partitioned step.
– Job2 will contain a query that has two steps. One of the steps is partitioned.
What is the maximum number of streaming units that will be consumed per job? 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 Lake Store and an Azure Active Directory tenant.You are developing an application that will access the Data Lake Store by using end-user credentials.
You need to ensure that the application uses end-user authentication to access the Data Lake Store.
What should you create?

DRAG DROP
You need to create a dataset in Microsoft Azure Data Factory that meets the following requirements:
Receives data from Azure Data Factory
Uses Azure Blob storage
Writes data to a blob storage path based on the current year and month
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:

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: