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:

HOTSPOT
You have a Microsoft Azure Stream Analytics solution.
You need to identify which types of windows must be used to group the following types of events:
Events that have random time intervals and are captured in a single fixed-size window
Events that have random time intervals and are captured in overlapping windows
Which window type should you identify for each event type? To answer, select the appropriate options in the
answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

DRAG DROP
You have a web app that accepts user input, and then uses a Microsoft Azure Machine Learning model to
predict a characteristic of the user.
You need to perform the following operations:
Track the number of web app users from month to month.
Track the number of successful predictions made during the last minute.
Create a dashboard showcasing the analytics for the predictions and the web app usage.
Which lambda layer should you query for each operation? To answer, drag the appropriate layers to the correct
operations. Each layer 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
Your company has 2,000 servers.
You plan to aggregate all of the log files from the servers in a central repository that uses Microsoft Azure
HDInsight. Each log file contains approximately one million records. All of the files use the .log file name
extension.
The following is a sample of the entries in the log files.
2017-02-03 20:26:41 SampleClass3 [ERROR] verbose detail for id 1527353937
In Apache Hive, you need to create a data definition and a query capturing the number of records that have anerror level of [ERROR].
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

HOTSPOT
You are designing a solution based on the lambda architecture.
The solution has the following layers:
Batch
Speed
Serving
You are planning the data ingestion process and the query execution.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Note: The question is part of a series of questions that present the same scenario. Each question in the series
contains a unique solution that might meet the stated goals. Some question sets might have more than one
correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will
not appear in the review screen.
Your company has multiple databases that contain millions of sales transactions.
You plan to implement a data mining solution to identify purchasing fraud.
You need to design a solution that mines 10 terabytes (TB) of sales date. The solution must meet the following
requirements:
Run the analysis to identify fraud once per week.
Continue to receive new sales transactions while the analysis runs.
Be able to stop computing services when the analysis is NOT running.
Solution: You create a Microsoft Azure HDInsight cluster.
Does this meet the goal?