You need to write a U-SQL query to load the file and to…

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 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?

A.
a table-valued function

B.
a view

C.
the extract command

D.
the output command

Explanation:
https://docs.microsoft.com/en-au/azure/data-lake-analytics/data-lake-analytics-u-sql-catalog



Leave a Reply 0

Your email address will not be published. Required fields are marked *