Microsoft 70-475 - Designing and Implementing Big Data Analytics Solutions Exam
Page: 3 / 9
Total 42 questions
Question #11 (Topic: Topic 2)
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.
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.
A. Nimbus
B. Zookeeper
C. Region
D. Supervisor
E. Falcon
F. Head
Answer: B,C,F
Question #12 (Topic: Topic 2)
A Company named Fabrikam, Inc. has a web app. Millions of users visit the app daily.
Fabrikam performs a daily analysis of the previous days logs by scheduling the following
Hive query.
[Microsoft-70-475-7.0/Microsoft-70-475-13_2.png]
You need to recommend a solution to gather the log collections from the web app.
What should you recommend?
Fabrikam performs a daily analysis of the previous days logs by scheduling the following
Hive query.
[Microsoft-70-475-7.0/Microsoft-70-475-13_2.png]
You need to recommend a solution to gather the log collections from the web app.
What should you recommend?
A. Generate a single directory that contains multiple files for each day. Name the file by using the syntax of {date}_{randomsuffix}.txt.
B. Generate a directory that is named by using the syntax of "LogDate={date} and generate a set of files for that day.
C. Generate a directory each day that has a single file.
D. Generate a single directory that has a single file for each day.
Answer: A
Question #13 (Topic: Topic 2)
You are designing an Internet of Things (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?
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?
A. Microsoft Azure Stream Analytics
B. Microsoft Azure HDInsight Spark clusters
C. Microsoft Azure Event Hubs
D. Microsoft Azure HDInsight Hadoop clusters
Answer: C
Question #14 (Topic: Topic 2)
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 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?
A. web
B. OData
C. Azure Search
D. Azure Data Lake Store
Answer: A
Question #15 (Topic: Topic 2)
Your company has 2000 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 tire number of
records that have an error 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.
[Microsoft-70-475-7.0/Microsoft-70-475-15_2.png]
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 tire number of
records that have an error 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.
[Microsoft-70-475-7.0/Microsoft-70-475-15_2.png]
Answer: [Microsoft-70-475-7.0/Microsoft-70-475-15_3.png]
