Microsoft Design and Implement Big Data Analytics Solutions - 70-475 FREE EXAM DUMPS QUESTIONS & ANSWERS
You need to recommend a permanent Azure Storage solution for the activity data. The solution must meet the technical requirements.
What is the best recommendation to achieve the goal? More than one answer choice may achieve the goal.
Select the BEST answer.
What is the best recommendation to achieve the goal? More than one answer choice may achieve the goal.
Select the BEST answer.
Correct Answer: B
Vote an answer
A company named Fabricam, Inc, has a web app hosted in Microsoft Azure. Millions of users visit the app daily.
All of the user visits are logged in Azure Blob storage. Data analysts at Fabrikam built a dashboard that processes the user visit logs.
Fabrikam plans to use an Apache Hadoop cluster on Azure HDInsight to process queries. The queries will access the data only once.
You need to recommend a query execution strategy.
What is the best to recommend using to achieve the goal?
More than one answer choice may achieve the goal. Select the
All of the user visits are logged in Azure Blob storage. Data analysts at Fabrikam built a dashboard that processes the user visit logs.
Fabrikam plans to use an Apache Hadoop cluster on Azure HDInsight to process queries. The queries will access the data only once.
You need to recommend a query execution strategy.
What is the best to recommend using to achieve the goal?
More than one answer choice may achieve the goal. Select the
Correct Answer: B
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
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: B,C,D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
The settings used for slice processing are described in the following table.

If the slice processing fails, you need to identify the number of retries that will be performed before the slice execution status changes to failed.
How many retries should you identify?

If the slice processing fails, you need to identify the number of retries that will be performed before the slice execution status changes to failed.
How many retries should you identify?
Correct Answer: D
Vote an answer
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 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.
Correct Answer: A,C,E
Vote an answer
You have raw data in Microsoft Azure Blob storage. Each data file is 10 KB and is the XML format.
You identify the following requirements for the data:
* The data must be converted into a flat data structure by using a C# MapReduce job.
* The data must be moved to an Azure SQL database, which will then be used to visualize the data.
* Additional stored procedures must run against the data once the data is in the database.
You need to create the workflow for the Azure Data Factory pipeline.
Which activity type should you use for each requirement? To answer, drag the appropriate workflow components to the correct requirements. Each workflow component may be used once, more than once, or not at all. You may need to drag the split bar between the panes or scroll to view content.
NOTE: Each correct selection is worth one point.

You identify the following requirements for the data:
* The data must be converted into a flat data structure by using a C# MapReduce job.
* The data must be moved to an Azure SQL database, which will then be used to visualize the data.
* Additional stored procedures must run against the data once the data is in the database.
You need to create the workflow for the Azure Data Factory pipeline.
Which activity type should you use for each requirement? To answer, drag the appropriate workflow components to the correct requirements. Each workflow component may be used once, more than once, or not at all. You may need to drag the split bar between the panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

Box 1: HDinsightMapReduce
The HDInsight MapReduce activity in a Data Factory pipeline invokes MapReduce program on your own or on-demand HDInsight cluster.
Box 2: HDInsightStreaming
Box 3: SQLServerStoredProcedure
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 plan to implement a new data warehouse.
You have the following information regarding the data warehouse:
* The first data files for the data warehouse will be available in a few days.
* Most queries that will be executed against the data warehouse are ad-hoc.
* The schemas of data files that will be loaded to the data warehouse change often.
* One month after the planned implementation, the data warehouse will contain 15 TB of data.
You need to recommend a database solution to support the planned implementation.
Solution: You recommend an Apache Spark system.
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 plan to implement a new data warehouse.
You have the following information regarding the data warehouse:
* The first data files for the data warehouse will be available in a few days.
* Most queries that will be executed against the data warehouse are ad-hoc.
* The schemas of data files that will be loaded to the data warehouse change often.
* One month after the planned implementation, the data warehouse will contain 15 TB of data.
You need to recommend a database solution to support the planned implementation.
Solution: You recommend an Apache Spark system.
Does this meet the goal?
Correct Answer: A
Vote an answer