HOTSPOT
You have a Microsoft Azure Data Lake Analytics service.
You have a file named Employee.tsv that contains data on employees. Employee.tsv contains seven columns
named EmpId, Start, FirstName, LastName, Age, Department, and Title.
You need to create a Data Lake Analytics jobs to transform Employee.tsv, define a schema for the data, and
output the data to a CSV file. The outputted data must contain only employees who are in the sales department.
The Age column must allow NULL.How should you complete the U-SQL code segment? To answer, select the appropriate options in the answer
area.
NOTE: Each correct selection is worth one point.
Hot Area:

DRAG DROP
You need to copy data from Microsoft Azure SQL Database to Azure Data Lake Store by using Azure Data
Factory.
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.
Select and Place:

You are using Cognitive capabilities in U-SQL to analyze images that contain different types of objects.
You need to identify which objects might be people.
Which two reference assemblies should you use? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

HOTSPOT
You have a Microsoft Azure Data Lake Analytics service.
You have a tab-delimited file named UserActivity.tsv that contains logs of user sessions. The file does not have
a header row.
You need to create a table and to load the logs to the table. The solution must distribute the data by a column
named SessionId.
How should you complete the U-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

You need to use the Cognition.Vision.FaceDetector() function in U-SQL to analyze images.
Which attribute can you detect by using the function?

You are developing an application by using the Microsoft .NET SDK. The application will access data from a
Microsoft Azure Data Lake folder.
You plan to authenticate the application by using service-to-service authentication.
You need to ensure that the application can access the Data Lake folder.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

You have a file in a Microsoft Azure Data Lake Store that contains sales data. The file contains sales amounts
by salesperson, by city, and by state.
You need to use U-SQL to calculate the percentage of sales that each city has for its respective state.
Which code should you use?

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?