Implementing Analytics Solutions Using Microsoft Fabric — Question 15

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.

Answer options

• 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.

Correct answer: D, E

Explanation

The correct answers are D and E. Creating a shortcut in the Tables section allows for proper integration with SQL queries, while using the delta format is optimal for handling updates and transactions in a lakehouse environment. The other options either do not align with lakehouse best practices or are not suitable for SQL querying in this context.