QuestionQ105

VerifiedPrepare data

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.

Choose two
Explanation

OneLake shortcuts to external Delta Lake data should be created in the Tables section of the lakehouse, which lets Fabric automatically sync the folder's metadata and expose it as a queryable managed table through the SQL endpoint. Using the Delta format (rather than CSV or plain Parquet) is what makes this automatic table recognition and metadata sync possible for a shortcut pointed at an S3 bucket.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!