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.

View 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.

View Answer

Q3. 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.

View Answer

Q4. Which technology should you recommend to meet the technical requirement for analyzing

A. Azure Stream Analytics

B. Azure Data Lake Analytics

C. Azure Machine Learning

D. Azure HDInsight Storm clusters

View Answer

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.

View Answer

Q6. 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.

View Answer

Q7. 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.

View Answer

Q8. HOTSPOT 

Your company has 2000 servers.

You plan to aggregate all of the log files from the servers in a central repository that uses Microsoft Azure HDInsight. Each log file contains approximately one million records. All of the files use the .log file name extension.

The following is a sample of the entries in the log files.

2021-02-03 20:26:41 SampleClass3 (ERROR) verbose detail for id 1527353937

In Apache Hive, you need to create a data definition and a query capturing tire number of records that have an error level of [ERROR].

What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

View Answer

Q9. 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.

View Answer

Q10. HOTSPOT

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.

View Answer