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?A.B.C.D.
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 have a Microsoft Azure Data Lake Analytics service.You need to store a list of multiple-character string values in a single column and to use a CROSS APPLY EXPLODE expression to output the values.Which type of data should you use in a U-SQL query?
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?
HOTSPOT -You have a Microsoft Azure Data Lake Analytics service.You have a file named Emloyee.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 job 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:
Note: This question is part of series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You are troubleshooting a slice in Microsoft Azure Data Factory for a dataset that has been in a waiting state for the last three days. The dataset should have been ready two days ago.The dataset is being produced outside the scope of Azure Data Factory. The dataset is defined by using the following JSON code.You need to modify the JSON code to ensure that the dataset is marked as ready whenever there is data in the data store.Solution: You add conditions to the policy.Does this meet the goal?
