070-475試験無料問題集「Microsoft Design and Implement Big Data Analytics Solutions 認定」
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 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 a Microsoft Azure deployment that contains the following services:
* Azure Data Lake
* Azure Cosmos DB
* Azure Data Factory
* Azure SQL Database
You load several types of data to Azure Data Lake.
You need to load data from Azure SQL Database to Azure Data Lake.
Solution: You use a stored procedure.
Does this meet the goal?
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 a Microsoft Azure deployment that contains the following services:
* Azure Data Lake
* Azure Cosmos DB
* Azure Data Factory
* Azure SQL Database
You load several types of data to Azure Data Lake.
You need to load data from Azure SQL Database to Azure Data Lake.
Solution: You use a stored procedure.
Does this meet the goal?
正解：A
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
You have structured data that resides in Microsoft Azure Blob Storage.
You need to perform a rapid interactive analysis of the data and to generate visualizations of the data.
What is the best type of Azure HDInsight cluster to use to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.
You need to perform a rapid interactive analysis of the data and to generate visualizations of the data.
What is the best type of Azure HDInsight cluster to use to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.
正解：B
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
Your company has several thousand sensors deployed.
You have a Microsoft Azure Stream Analytics job that receives two data streams Input1 and Input2 from an Azure event hub. The data streams are portioned by using a column named SensorName. Each sensor is identified by a field named SensorID.
You discover that Input2 is empty occasionally and the data from Input1 is ignored during the processing of the Stream Analytics job.
You need to ensure that the Stream Analytics job always processes the data from Input1.
How should you modify the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have a Microsoft Azure Stream Analytics job that receives two data streams Input1 and Input2 from an Azure event hub. The data streams are portioned by using a column named SensorName. Each sensor is identified by a field named SensorID.
You discover that Input2 is empty occasionally and the data from Input1 is ignored during the processing of the Stream Analytics job.
You need to ensure that the Stream Analytics job always processes the data from Input1.
How should you modify the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
Explanation
Box 1: LEFT OUTER JOIN
LEFT OUTER JOIN specifies that all rows from the left table not meeting the join condition are included in the result set, and output columns from the other table are set to NULL in addition to all rows returned by the inner join.
Box 2: ON I1.SensorID= I2.SensorID
References: https://docs.microsoft.com/en-us/stream-analytics-query/join-azure-stream-analytics
You have a Microsoft Azure HDInsight cluster for analytics workloads. You have a C# application on a local computer.
You plan to use Azure Data Factory to run the C# application in Azure.
You need to create a data factory that runs the C# application by using HDInsight.
In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
You plan to use Azure Data Factory to run the C# application in Azure.
You need to create a data factory that runs the C# application by using HDInsight.
In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
正解：
You have a data warehouse that contains the sales data of several customers.
You plan to deploy a Microsoft Azure data factory to move additional sales data to the data warehouse.
You need to develop a data factory job that reads reference data from a table in the source data.
Which type of activity should you add to the control flow of the job?
You plan to deploy a Microsoft Azure data factory to move additional sales data to the data warehouse.
You need to develop a data factory job that reads reference data from a table in the source data.
Which type of activity should you add to the control flow of the job?
正解：D
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
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 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.
正解：A,D
解答を投票する
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.
正解：
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?
正解：D
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)