Within a Fabric lakehouse environment, where should a data analyst create a shortcut to access data stored in an external Amazon S3 bucket via the SQL endpoint?

Prepare for the Fabric Analytics Engineer Associate Test with comprehensive materials. Explore flashcards, multiple choice questions, and detailed explanations. Get ready for your success!

Multiple Choice

Within a Fabric lakehouse environment, where should a data analyst create a shortcut to access data stored in an external Amazon S3 bucket via the SQL endpoint?

Explanation:
Shortcuts to external data in a Fabric lakehouse are treated as file-level references. Creating the link in the File section places a direct, file-oriented pointer to the S3 bucket that the SQL endpoint can read from just like any other file path. This makes the external data accessible for queries without importing it as a lakehouse table, enabling you to specify formats (Parquet, CSV, etc.) and schemas at the file level. The Table area is for actual lakehouse tables, not external pointers. The object storage and blob areas relate to configuring storage connections rather than hosting the file-based shortcut itself. By placing the shortcut in the File section, you align with how the SQL endpoint expects to access external data as a file source.

Shortcuts to external data in a Fabric lakehouse are treated as file-level references. Creating the link in the File section places a direct, file-oriented pointer to the S3 bucket that the SQL endpoint can read from just like any other file path. This makes the external data accessible for queries without importing it as a lakehouse table, enabling you to specify formats (Parquet, CSV, etc.) and schemas at the file level. The Table area is for actual lakehouse tables, not external pointers. The object storage and blob areas relate to configuring storage connections rather than hosting the file-based shortcut itself. By placing the shortcut in the File section, you align with how the SQL endpoint expects to access external data as a file source.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy