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.

HOTSPOT
You have the following script.
CREATE TABLE UserVisits (username string, url string, time date)
STORED AS TEXTFILE LOCATION “wasb:///Logs”;
CREATE TABLE UserVisitsOrc (username string, url string, time date)
STORED AS ORC;
INSERT INTO TABLE UserVisitsOrc SELECT * FROM UserVisitsUse the drop-down menus to select the answer choice that completes each statement based on the information
presented in the script.
NOTE: Each correct selection is worth one point.
Hot Area:

DRAG DROP
You have data generated by sensors. The data is sent to Microsoft Azure Event Hubs.
You need to have an aggregated view of the data in near real time by using five-minute tumbling windows to
identify short-term trends. You must also have hourly and a daily aggregated views of the data.
Which technology should you use for each task? To answer, drag the appropriate technologies to the correct
tasks. Each technology may be used once, more than once, or not at all. You may need to drag the spilt bar
between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

You are designing a solution that will use Apache HBase on Microsoft Azure HDInsight.
You need to design the row keys for the database to ensure that client traffic is directed over all of the nodes in
the cluster.
What are two possible techniques that you can use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

You are designing an Apache HBase cluster on Microsoft Azure HDInsight.
You need to identify which nodes are required for the cluster.
Which three nodes should you identify? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

DRAG DROP
You work for a telecommunications company that uses Microsoft Azure Stream Analytics.
You have data related to incoming calls.You need to group the data in the following ways:
Group A: Every five minutes for a duration of five minutes
Group B: Every five minutes for a duration of 10 minutes
Which type of window should you use for each group? To answer, drag the appropriate window types to the
correct groups. Each window type 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: