Microsoft 70-475 - Designing and Implementing Big Data Analytics Solutions Exam
Page: 2 / 9
Total 42 questions
Question #6 (Topic: Topic 2)
You have the following script.
[Microsoft-70-475-7.0/Microsoft-70-475-8_4.png]
Use 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.
[Microsoft-70-475-7.0/Microsoft-70-475-9_2.png]
[Microsoft-70-475-7.0/Microsoft-70-475-8_4.png]
Use 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.
[Microsoft-70-475-7.0/Microsoft-70-475-9_2.png]
Answer: [Microsoft-70-475-7.0/Microsoft-70-475-9_3.png]
Question #7 (Topic: Topic 2)
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 DHlnsight.
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.
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 DHlnsight.
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.
A. STORED AS RCFILE
B. STORED AS GZIP
C. STORED AS ORC
D. STORED AS TEXTFILE
Answer: A
Question #8 (Topic: Topic 2)
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.
[Microsoft-70-475-7.0/Microsoft-70-475-10_2.png]
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.
[Microsoft-70-475-7.0/Microsoft-70-475-10_2.png]
Answer: [Microsoft-70-475-7.0/Microsoft-70-475-10_3.png]
Question #9 (Topic: Topic 2)
You have four on-premises Microsoft SQL Server data sources as described in the
following table.
[Microsoft-70-475-7.0/Microsoft-70-475-10_4.png]
You plan to create three Azure data factories that will interact with the data sources as
described in the following table.
[Microsoft-70-475-7.0/Microsoft-70-475-11_2.png]
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 data management gateways you should
you deploy? 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-11_3.png]
following table.
[Microsoft-70-475-7.0/Microsoft-70-475-10_4.png]
You plan to create three Azure data factories that will interact with the data sources as
described in the following table.
[Microsoft-70-475-7.0/Microsoft-70-475-11_2.png]
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 data management gateways you should
you deploy? 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-11_3.png]
Answer: [Microsoft-70-475-7.0/Microsoft-70-475-11_4.png]
Question #10 (Topic: Topic 2)
You have a Microsoft Azure Stream Analytics solution.
You need to identify which types of windows must be used to group lite 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.
[Microsoft-70-475-7.0/Microsoft-70-475-12_2.png]
You need to identify which types of windows must be used to group lite 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.
[Microsoft-70-475-7.0/Microsoft-70-475-12_2.png]
Answer: [Microsoft-70-475-7.0/Microsoft-70-475-12_3.png]
