070-475試験無料問題集「Microsoft Design and Implement Big Data Analytics Solutions 認定」

You plan to use Microsoft Azure IoT Hub to capture data from medical devices that contain sensors.
You need to ensure that each device has its own credentials. The solution must minimize the number of required privileges.
Which policy should you apply to the devices?

解説: (GoShiken メンバーにのみ表示されます)
Your company has a data visualization solution that contains a customized Microsoft Azure Stream Analytics solution. The solution provides data to a Microsoft Power BI deployment.
Every 10 seconds, you need to query for instances that have more than three records.
How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value 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.
正解:

Explanation

Box 1: TumblingWindow(second, 10)
Tumbling Windows define a repeating, non-overlapping window of time.
Example: Calculate the count of sensor readings per device every 10 seconds SELECT sensorId, COUNT(*) AS Count FROM SensorReadings TIMESTAMP BY time GROUP BY sensorId, TumblingWindow(second, 10) Box 2: [Count] >= 3 Count(*) returns the number of items in a group.
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 need to recommend a data handling solution to support the planned changes to the dashboard. The solution must meet the privacy requirements.
What is the best recommendation to achieve the goal? More than one answer choice may achieve the goal.
Select the BEST answer.

You plan to deploy a Hadoop cluster that includes a Hive installation.
Your company identifies the following requirements for the planned deployment:
* During the creation of the cluster nodes, place JAR files in the clusters.
* Decouple the Hive metastore lifetime from the cluster lifetime.
* Provide anonymous access to the cluster nodes.
You need to identify which technology must be used for each requirement.
Which technology should you identify for each requirement? To answer, drag the appropriate technologies to the correct requirements. Each technology 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.
正解:

Explanation
You plan to design a solution to gather data from 5,000 sensors that are deployed to multiple machines. The sensors generate events that contain data on the health status of the machines.
You need to create a new Microsoft Azure event hub to collect the event data.
Which command should you run? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解:
Note: This 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.
You plan to deploy a Microsoft Azure SQL data warehouse and a web application.
The data warehouse will ingest 5 TB of data from an on-premises Microsoft SQL Server database daily. The web application will query the data warehouse.
You need to design a solution to ingest data into the data warehouse.
Solution: You use SQL Server Integration Services (SSIS) to transfer data from SQL Server to Azure SQL Data Warehouse.
Does this meet the goal?

解説: (GoShiken メンバーにのみ表示されます)
You plan to analyze the execution logs of a pipeline to identify failures by using Microsoft power BI.
You need to automate the collection of monitoring data for the planned analysis.
What should you do from Microsoft Azure?

解説: (GoShiken メンバーにのみ表示されます)
Note: This 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 states goals. Some question sets might have more than one correct solution, while the 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.
You have an Apache Spark system that contains 5 TB of data.
You need to write queries that analyze the data in the system. The queries must meet the following requirements:
* Use static data typing.
* Execute queries as quickly as possible.
* Have access to the latest language features.
Solution: You write the queries by using Python.

You need to recommend a data transfer solution to support the business goals.
What should you recommend?