70-475 Exam
Advanced Guide: microsoft 70 475
Act now and download your Microsoft exam 70 475 test today! Do not waste time for the worthless Microsoft 70 475 exam tutorials. Download Rebirth Microsoft Designing and Implementing Big Data Analytics Solutions exam with real questions and answers and begin to learn Microsoft microsoft 70 475 with a classic professional.
Q1. DRAG DROP
Your company has a Microsoft Azure environment that contains an Azure HDInsight Hadoop cluster and an Azure SQL data warehouse. The Hadoop cluster contains text files that are formatted by using UTF-8 character encoding.
You need to implement a solution to ingest the data to the SQL data warehouse from the
Hadoop cluster. The solution must provide optimal read performance for the data after ingestion.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Q2. You are designing a solution that will use Apache HBase on Microsoft Azure HDInsight.
You need to design the row keys for the database to ensure that client traffic is directed over all of the nodes in the cluster.
What are two possible techniques that you can use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. padding
B. trimming
C. hashing
D. salting
Answer: C
Q3. DRAG DROP
You need to implement a solution that meets the data refresh requirement tor DB1.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Q4. 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
Q5. HOTSPOT
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:
Q6. DRAG DROP
You have data generated by sensors. The data is sent to Microsoft Azure Event Hubs.
You need to have an aggregated view of the data in near real-time by using five minute tumbling windows to identity short-term trends. You must also have hourly and a daily aggregated views of the data.
Which technology should you use for each task? To answer, drag the appropriate technologies to the correct tasks. Each technology 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:
Q7. DRAG DROP
You need to create a query that identifies the trending topics.
How should you complete the query? 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:
Q8. HOTSPOT
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:
Q9. HOTSPOT
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:
Q10. 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: