70-475 Exam
exam 70 475 : Oct 2021 Edition
Cause all that matters here is passing the Microsoft microsoft 70 475 exam. Cause all that you need is a high score of 70 475 exam Designing and Implementing Big Data Analytics Solutions exam. The only one thing you need to do is downloading Exambible exam 70 475 exam study guides now. We will not let you down with our money-back guarantee.
Q1. HOTSPOT
You implement DB2.
You need to configure the tables in DB2 to host the data from DB1. The solution must meet the requirements for DB2.
Which type of table and history table storage should you use for the table? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one pint.
Answer:
Q2. HOTSPOT
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:
Q3. DRAG DROP
You need to implement rls_table1.
Which code should you execute? 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.
Answer:
Topic 2, Mix Questions
76. 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.
A. Apache Storm
B. Apache HBase
C. Apache Hadoop
D. Apache Spark
Answer: C
Q4. DRAG DROP
You plan to deploy a Microsoft Azure Data Factory pipeline to run an end-to-end data processing workflow.
You need to recommend winch Azure Data Factory features must be used to meet the Following requirements:
Track the run status of the historical activity.
Enable alerts and notifications on events and metrics.
Monitor (he creation, updating, and deletion of Azure resources.
Which features should you recommend? 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.
Answer:
Q5. 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
Q6. DRAG DROP
You need to implement rls_table1.
Which code should you execute? 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.
Answer:
Topic 2, Mix Questions
76. 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.
A. Apache Storm
B. Apache HBase
C. Apache Hadoop
D. Apache Spark
Answer: C
Q7. You are designing a solution based on the lambda architecture.
You need to recommend which technology to use for the serving layer. What should you recommend?
A. Apache Storm
B. Kafka
C. Microsoft Azure DocumentDB
D. Apache Hadoop
Answer: B
Q8. 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
Q9. HOTSPOT
You implement DB2.
You need to configure the tables in DB2 to host the data from DB1. The solution must meet the requirements for DB2.
Which type of table and history table storage should you use for the table? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one pint.
Answer:
Q10. 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