DRAG DROP
You plan to deploy a Microsoft Azure Data Factory pipeline to run an end-to-end data processing workflow.
You need to recommend which Azure Data Factory features must be used to meet the following requirements:
Track the run status of the historical activity.
Enable alerts and notifications on events and metrics.
Monitor the creation, updating, and deletion of Azure resources.Which features should you recommend? To answer, drag the appropriate features to the correct requirements.
Each feature 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:

HOTSPOT
You have four on-premises Microsoft SQL Server data sources as described in the following table.

You plan to create three Azure data factories that will interact with the data sources as described in the
following table

You need to deploy Microsoft Data Management Gateway to support the Azure Data Factory deployment. The
solution must use new servers to host the instances of Data Management Gateway.
What is the minimum number of new servers and date management gateways you should you deploy? To
answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

HOTSPOT
You have a pipeline that contains an input dataset in Microsoft Azure Table Storage and an output dataset in
Azure Blob storage.

You have the following JSON data.
Use the drop-down menus to select the answer choice that completes each statement based on the information
presented in the JSON data.
NOTE: Each correct selection is worth one point.
Hot Area:

You have a Microsoft Azure Data Factory pipeline.
You discover that the pipeline fails to execute because data is missing.
You need to rerun the failure in the pipeline.
Which cmdlet should you use?

You need to automate the creation of a new Microsoft Azure data factory.
What are three possible technologies that you can use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

DRAG DROP
Your company has a Microsoft Azure environment that contains an Azure HDInsight Hadoop cluster and an
Azure SQL data warehouse. The Hadoop cluster contains text files that are formatted by using UTF-8 character
encoding.
You need to implement a solution to ingest the data to the SQL data warehouse from the Hadoop cluster. The
solution must provide optimal read performance for the data after ingestion.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of
actions to the answer area and arrange them in the correct order.
Select and Place:

A company named Fabrikam, Inc. has a web app. Millions of users visit the app daily.
Fabrikam performs a daily analysis of the previous day’s logs by scheduling the following Hive query.
CREATE EXTERNAL TABLE IF NOT EXISTS UserActivity (…) Partitioned BY (LogDate string) Location MSCK
REPAIR TABLE UserActivity;
Select … From UserActivity where LogDate = “{date}”;
You need to recommend a solution to gather the log collections from the web app.
What should you recommend?

You have an Apache Storm cluster.
The cluster will ingest data from a Microsoft Azure event hub.
The event hub has the characteristics described in the following table.

You are designing the Storm application topology.
You need to ingest data from all of the partitions. The solution must maximize the throughput of the data
ingestion.
Which setting should you use?

DRAG DROP
You manage a Microsoft Azure HDInsight Hadoop cluster. All of the data for the cluster is stored in Azure
Premium Storage.
You need to prevent all users from accessing the data directly. The solution must allow only the HDInsight
service to access the data.
Which five actions should you perform in sequence? To answer, move the appropriate actions from the list ofactions to the answer area and arrange them in the correct order.
Select and Place:

You have a Microsoft Azure subscription that contains an Azure Data Factory pipeline.
You have an RSS feed that is published on a public website.
You need to configure the RSS feed as a data source for the pipeline.
Which type of linked service should you use?