최신 070-475 무료덤프 - Microsoft Design and Implement Big Data Analytics Solutions

You need to implement a security solution for Microsoft Azure SQL database. The solution must meet the following requirements:
* Ensure that users can see the data from their respective department only.
* Prevent administrators from viewing the data.
Which feature should you use for each requirement? To answer, drag the appropriate features to the correct requirements. Each feature 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.

You have a Microsoft Azure data factory.
You assign administrative roles to the users in the following table.

You discover that several new data factory instances were created.
You need to ensure that only User5 can create a new data factory instance.
Which two roles should you change? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

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?

You are creating a retail analytics system for a company that manufactures equipment.
The company manufactures thousands of loT devices that report their status over the Internet You need to recommend a solution to visualize notifications from the devices on a mobile-ready dashboard.
Which three actions should you recommend be performed in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

You have data pushed to Microsoft Azure Blob storage every few minutes.
You want to use an Azure Machine Learning web service to score the data hourly.
You plan to deploy the data factory pipeline by using a Microsoft.NET application.
You need to create an output dataset for the web service.
Which three properties should you define? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

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.

You are building a streaming data analysis solution that will process approximately 1 TB of data weekly.
You plan to use Microsoft Azure Stream Analytics to create alerts on real-time data. The data must be preserved for deeper analysis at a later date.
You need to recommend a storage solution for the alert data. The solution must meet the following requirements:
* Support scaling up without any downtime
* Minimize data storage costs.
What should you recommend using to store the data?

You are designing a partitioning scheme for ingesting real-time data by using Kafka. Kafka and Apache Storm will be integrated. You plan to use four event processing servers that each run as a Kafka consumer. Each server will have a two quad-core processor. You need to identify the minimum number of partitions required to ensure that the load is distributed evenly. How many should you identify?

You plan to create a Microsoft Azure Data Factory pipeline that will connect to an Azure HDInsight cluster that uses Apache Spark.
You need to recommend which file format must be used by the pipeline. The solution must meet the following requirements:
* Store data in the columnar format
* Support compression
Which file format should you recommend?

You plan to deploy Microsoft Azure HDInsight clusters for business analytics and data pipelines. The clusters must meet the following requirements:
* Business users must use a language that is similar to SQL.
* The authoring of data pipelines must occur in a dataflow language.
You need to identify which language must be used for each requirement.
Which languages should you identify? To answer, drag the appropriate languages to the correct requirements.
Each language 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.