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?

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 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?

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?

You are designing an Internet of Thing: (IoT) solution intended to identify trends. The solution requires the real-time analysis of data originating from sensors. The results of the analysis will be stored in a SQL database.
You need to recommend a data processing solution that uses the Transact-SQL language.
Which data processing solution should you recommend?

Your company has thousands of Internet-connected sensors.
You need to recommend a computing solution to perform a real-time analysis of the date generated by the
sensors.
Which computing solution should you include in the recommendation?

You are designing a solution based on the lambda architecture.
You need to recommend which technology to use for the serving layer.
What should you recommend?

You have structured data that resides in Microsoft Azure Blob storage.
You need to perform a rapid interactive analysis of the data and to generate visualizations of the data.
What is the best type of Azure HDInsight cluster to use to achieve the goal? More than one answer choice may
achieve the goal. Choose the BEST answer.

A company named Fabrikam, Inc. has a Microsoft Azure web app. Billions of users visit the app daily.
The web app logs all user activity by using text files in Azure Blob storage. Each day, approximately 200 GB of
text files are created.
Fabrikam uses the log files from an Apache Hadoop cluster on Azure HDInsight.You need to recommend a solution to optimize the storage of the log files for later Hive use.
What is the best property to recommend adding to the Hive table definition to achieve the goal? More than one
answer choice may achieve the goal. Select the BEST answer.