You have a pipeline that contains an input dataset in Microsoft Azure Table Storage and an output dataset in Azure Blob storage. You have the following JSON data.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON data.
Answer:
Question
Hotspot Question
You have a Microsoft Azure SQL data warehouse named DW1.
A department in your company creates an Azure SQL database named DB1. DB1 is a data mart.
Each night, you need to insert new rows Into 9.000 tables in DB1 from changed data in DW1. The solution must minimize costs.
What should you use to move the data from DW1 to DB1, and then to import the changed data to DB1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Question
Your company has thousands of Internet-connected sensors.
You need to recommend a computing solution to perform a real-time analysis of the data generated by the sensors.
Which computing solution should you include in the recommendation?
A. Microsoft Azure Stream Analytics
B. Microsoft Azure Notification Hubs
C. Microsoft Azure Cognitive Services
D. a Microsoft Azure HDInsight HBase cluster
Answer: A
Question
Hotspot Question
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.
Answer:
Question
Hotspot Question
You have a Microsoft Azure Stream Analytics solution.
You need to identify which types of windows must be used to group lite following types of events:
Events that have random time intervals and are captured in a single fixed-size window
Events that have random time intervals and are captured in overlapping windows Which window type should you identify for each event type? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Question
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.
Your company has multiple databases that contain millions of sales transactions.
You plan to implement a data mining solution to identity purchasing fraud.
You need to design a solution that mines 10 terabytes (TB) of sales data. The solution must meet the following requirements:
· Run the analysis to identify fraud once per week.
· Continue to receive new sales transactions while the analysis runs.
· Be able to stop computing services when the analysis is NOT running.
Solution: You create a Cloudera Hadoop cluster on Microsoft Azure virtual machines.
Does this meet the goal?
A. Yes
B. No
Answer: A
Question
A company named Fabrikam, Inc. has a Microsoft Azure web app. Billions of users visit the app daily.
The web app logs all user activity by using text files in Azure Blob storage. Each day, approximately 200 GB of text files are created.
Fabrikam uses the log files from an Apache Hadoop cluster on Azure DHlnsight.
You need to recommend a solution to optimize the storage of the log files for later Hive use.
What is the best property to recommend adding to the Hive table definition to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.
A. STORED AS RCFILE
B. STORED AS GZIP
C. STORED AS ORC
D. STORED AS TEXTFILE
Answer: A
Question
You have a Microsoft Azure Data Factory pipeline.
You discover that the pipeline fails to execute because data is missing.
You need to rerun the failure in the pipeline.
Which cmdlet should you use?
A. Set-AzureAutomationJob
B. Resume-AzureDataFactoryPipeline
C. Resume-AzureAutomationJob
D. Set-AzureDataFactotySliceStatus
Answer: B
Pics cannot be showed here but you can view the 70-475 Questions Full Version at here: http://www.pass4surevce.com/?s=70-475 All questions here are the latest and free!
New 70-475 questions:
Question
Hotspot Question
You have a pipeline that contains an input dataset in Microsoft Azure Table Storage and an output dataset in Azure Blob storage. You have the following JSON data.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON data.
Answer:
Question
Hotspot Question
You have a Microsoft Azure SQL data warehouse named DW1.
A department in your company creates an Azure SQL database named DB1. DB1 is a data mart.
Each night, you need to insert new rows Into 9.000 tables in DB1 from changed data in DW1. The solution must minimize costs.
What should you use to move the data from DW1 to DB1, and then to import the changed data to DB1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Question
Your company has thousands of Internet-connected sensors.
You need to recommend a computing solution to perform a real-time analysis of the data generated by the sensors.
Which computing solution should you include in the recommendation?
A. Microsoft Azure Stream Analytics
B. Microsoft Azure Notification Hubs
C. Microsoft Azure Cognitive Services
D. a Microsoft Azure HDInsight HBase cluster
Answer: A
Question
Hotspot Question
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.
Answer:
Question
Hotspot Question
You have a Microsoft Azure Stream Analytics solution.
You need to identify which types of windows must be used to group lite following types of events:
Events that have random time intervals and are captured in a single fixed-size window
Events that have random time intervals and are captured in overlapping windows Which window type should you identify for each event type? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Question
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.
Your company has multiple databases that contain millions of sales transactions.
You plan to implement a data mining solution to identity purchasing fraud.
You need to design a solution that mines 10 terabytes (TB) of sales data. The solution must meet the following requirements:
· Run the analysis to identify fraud once per week.
· Continue to receive new sales transactions while the analysis runs.
· Be able to stop computing services when the analysis is NOT running.
Solution: You create a Cloudera Hadoop cluster on Microsoft Azure virtual machines.
Does this meet the goal?
A. Yes
B. No
Answer: A
Question
A company named Fabrikam, Inc. has a Microsoft Azure web app. Billions of users visit the app daily.
The web app logs all user activity by using text files in Azure Blob storage. Each day, approximately 200 GB of text files are created.
Fabrikam uses the log files from an Apache Hadoop cluster on Azure DHlnsight.
You need to recommend a solution to optimize the storage of the log files for later Hive use.
What is the best property to recommend adding to the Hive table definition to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.
A. STORED AS RCFILE
B. STORED AS GZIP
C. STORED AS ORC
D. STORED AS TEXTFILE
Answer: A
Question
You have a Microsoft Azure Data Factory pipeline.
You discover that the pipeline fails to execute because data is missing.
You need to rerun the failure in the pipeline.
Which cmdlet should you use?
A. Set-AzureAutomationJob
B. Resume-AzureDataFactoryPipeline
C. Resume-AzureAutomationJob
D. Set-AzureDataFactotySliceStatus
Answer: B
Pics cannot be showed here but you can view the 70-475 Questions Full Version at here: http://www.pass4surevce.com/?s=70-475 All questions here are the latest and free!