DP-600 · Question #30
You have a Fabric tenant that contains a lakehouse. You plan to query sales data files by using the SQL endpoint. The files will be in an Amazon Simple Storage Service (Amazon S3) storage bucket. You
The correct answer is B. Use the Parquet format D. Create a shortcut in the Tables section.. You should use a columnar file format such as Parquet or ORC (Optimized Row Columnar). These formats are highly optimized for analytical queries and provide efficient storage and query In the Tables section of your lakehouse, you define virtual tables that represent external data
Question
You have a Fabric tenant that contains a lakehouse. You plan to query sales data files by using the SQL endpoint. The files will be in an Amazon Simple Storage Service (Amazon S3) storage bucket. You need to recommend which file format to use and where to create a shortcut. Which two actions should you include in the recommendation? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.
Options
- ACreate a shortcut in the Files section.
- BUse the Parquet format
- CUse the CSV format.
- DCreate a shortcut in the Tables section.
- EUse the delta format.
How the community answered
(39 responses)- A13% (5)
- B79% (31)
- C3% (1)
- E5% (2)
Explanation
You should use a columnar file format such as Parquet or ORC (Optimized Row Columnar). These formats are highly optimized for analytical queries and provide efficient storage and query In the Tables section of your lakehouse, you define virtual tables that represent external data sources. These virtual tables can be backed by data stored externally in formats such as Parquet or ORC in Amazon S3.
Topics
Community Discussion
No community discussion yet for this question.