Microsoft
70-776 · Question #45
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…
The correct answer is A. a table-valued function. https://docs.microsoft.com/en-au/azure/data-lake-analytics/data-lake-analytics-u-sql- catalog
Implement Big Data batch processing solutions
Question
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?
Options
- Aa table-valued function
- Ba view
- Cthe extract command
- Dthe output command
How the community answered
(51 responses)- A76% (39)
- B6% (3)
- C14% (7)
- D4% (2)
Explanation
https://docs.microsoft.com/en-au/azure/data-lake-analytics/data-lake-analytics-u-sql- catalog
Topics
#U-SQL#table-valued function#Data Lake Analytics#data encapsulation
Community Discussion
No community discussion yet for this question.