Microsoft Design and Implement Big Data Analytics Solutions - 70-475 Exam Practice Test
You are designing an application that will perform real-time processing by using Microsoft Azure Stream Analytics.
You need to identify the valid outputs of a Stream Analytics job.
What are three possible outputs that you can use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
You need to identify the valid outputs of a Stream Analytics job.
What are three possible outputs that you can use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Correct Answer: A,B,E
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You have four on-premises Microsoft SQL Server data sources as described in the following table.
You plan to create three Azure data factories that will interact with the data sources as described in the following table.
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.
You plan to create three Azure data factories that will interact with the data sources as described in the following table.
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.
Correct Answer:
Explanation
Box 1: 3
Box 2: 3
Considerations for using gateway
You need to implement a solution that meets the data refresh requirement for DB1.
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.
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.
Correct Answer:
Explanation
Azure Data Factory can be used to orchestrate the execution of stored procedures. This allows more complex pipelines to be created and extends Azure Data Factory's ability to leverage the computational power of SQL Data Warehouse.
From scenario:
Relecloud has a Microsoft SQL Server database named DB1 that stores information about the advertisers.
DB1 is hosted on a Microsoft Azure virtual machine.
Relecloud identifies the following requirements for DB1:
* Data generated by the streaming analytics platform must be stored in DB1.
* The advertisers in DB1 must be stored in a table named Table1 and must be refreshed nightly.
You have a large datacenter.
You plan to track the hardware failure notifications that occur in the datacenter. You expect to collect approximated 2 TB of data each month. You need to recommend a solution that meets the following requirements:
* Operators must be informed by email as soon as a hardware failure occurs.
* All event data associated with a hardware failure must be preserved for 24 months.
The solution must minimize costs.
You plan to track the hardware failure notifications that occur in the datacenter. You expect to collect approximated 2 TB of data each month. You need to recommend a solution that meets the following requirements:
* Operators must be informed by email as soon as a hardware failure occurs.
* All event data associated with a hardware failure must be preserved for 24 months.
The solution must minimize costs.
Correct Answer:
Your Microsoft Azure subscription contains several data sources that use the same XML schema. You plan to process the data sources in parallel.
You need to recommend a compute strategy to minimize the cost of processing the data sources. What should you recommend including in the compute strategy?
You need to recommend a compute strategy to minimize the cost of processing the data sources. What should you recommend including in the compute strategy?
Correct Answer: D
Vote an answer
You have an Apache Hadoop system that contains 5 TB of data.
You need to create queries to analyze the data in the system. The solution must ensure that the queries execute as quickly as possible.
Which language should you use to create the queries?
You need to create queries to analyze the data in the system. The solution must ensure that the queries execute as quickly as possible.
Which language should you use to create the queries?
Correct Answer: C
Vote an answer
You have an Apache Hive cluster in Microsoft Azure HDInsight. The cluster contains 10 million data files.
You plan to archive the data.
The data will be analyzed monthly.
You need to recommend a solution to move and store the data. The solution must minimize how long it takes to move the data and must minimize costs.
Which two services should you include in the recommendation? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You plan to archive the data.
The data will be analyzed monthly.
You need to recommend a solution to move and store the data. The solution must minimize how long it takes to move the data and must minimize costs.
Which two services should you include in the recommendation? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Correct Answer: A,E
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You have the following Hive query.
CREATE TABLE UserVisits (username string, urlvisited string, time date); LOAD DATA INPATH 'wasb:///Logs' OVERWRITE INTO TABLE UserVisits; 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.
CREATE TABLE UserVisits (username string, urlvisited string, time date); LOAD DATA INPATH 'wasb:///Logs' OVERWRITE INTO TABLE UserVisits; 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.
Correct Answer:
Explanation
