You have a Microsoft Azure Data Lake Analytics service.
You need to write a U-SQL query to extract from a CSV file all the users who live in Boston, and then to save
the results in a new CSV file.
Which U-SQL script should you use?

You ingest data into a Microsoft Azure event hub.
You need to export the data from the event hub to Azure Storage and to prepare the data for batch processing
tasks in Azure Data Lake Analytics.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

You plan to use Microsoft Azure Data factory to copy data daily from an Azure SQL data warehouse to an
Azure Data Lake Store.
You need to define a linked service for the Data Lake Store. The solution must prevent the access token from
expiring.
Which type of authentication should you use?

You have a Microsoft Azure Data Lake Analytics service.
You plan to configure diagnostic logging.
You need to use Microsoft Operations Management Suite (OMS) to monitor the IP addresses that are used to
access the Data Lake Store.
What should you do?

You have a Microsoft Azure Data Lake Analytics service.
You have a CSV file that contains employee salaries.
You need to write a U-SQL query to load the file and to extract all the employees who earn salaries that are
greater than $100,000. You must encapsulate the data for reuse.
What should you use?

You plan to add a file from Microsoft Azure Data Lake Store to Azure Data Catalog.
You run the Data Catalog tool and select Data Lake Store as the data source.
Which information should you enter in the Store Account field to connect to the Data Lake Store?

You plan to use Microsoft Azure Event Hubs to ingest data. You plan to use Azure Stream Analytics to analyze
the data in real time and to send the output directly to Azure Data Lake Store.
You discover duplicate records in the output data.
What is a possible cause of the duplicate records?

DRAG DROP
You have a Microsoft Azure Stream Analytics solution that captures website visits and user interactions on the
website.
You have the sample input data described in the following table.

You have the sample output described in the following table.

How should you complete the script? 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.
Select and Place:

You have a Microsoft Azure SQL data warehouse that contains information about community events.
An Azure Data Factory job writes an updated CSV file in Azure Blob storage to Community/{date}/events.csv
daily.
You plan to consume a Twitter feed by using Azure Stream Analytics and to correlate the feed to the community
events.
You plan to use Stream Analytics to retrieve the latest community events data and to correlate the data to the
Twitter feed data.
You need to ensure that when updates to the community events data is written to the CSV files, the Stream
Analytics job can access the latest community events data.
What should you configure?

You plan to use Microsoft Azure Event Hubs to ingest sensor data. You plan to use Azure Stream Analytics to
analyze the data in real time and to send the output directly to Azure Data Lake Store.
You need to write events to the Data Lake Store in batches.
What should you use?