Answer-first summary for fast verification
Answer: Use the Parquet format., Create a shortcut in the Tables section.
For querying sales data files using the SQL endpoint with files stored in an Amazon S3 storage bucket, the recommended actions are: 1. **Using the Parquet format**: Parquet is a columnar storage file format optimized for complex queries and efficient data storage. It supports complex data types and is ideal for large datasets, making it the preferred choice for SQL querying. 2. **Creating a shortcut in the Tables section**: This allows the SQL endpoint to recognize and access the data as a table. Creating a shortcut in the Tables section makes the data accessible through SQL queries, ensuring efficient data access and query performance.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are working with a Fabric tenant that includes a lakehouse configuration. Your objective is to query sales data files located in an Amazon Simple Storage Service (Amazon S3) storage bucket using the SQL endpoint. To achieve this, you need to provide recommendations on the optimal file format to use for the data files and where to create a shortcut to access them efficiently. Which two actions should you recommend? Each correct answer presents a part of the solution. NOTE: Each correct answer is worth one point.
A
Create a shortcut in the Files section.
B
Use the Parquet format.
C
Use the CSV format.
D
Create a shortcut in the Tables section.
E
Use the delta format.
No comments yet.