Question

Your team maintains a curated dataset of vendor invoices stored in an external Azure Data Lake Storage Gen2 account managed by the finance department. As the Analytics Engineer, you need to make this data queryable from your Fabric lakehouse SQL analytics endpoint. Requirements: the data must NOT be duplicated into OneLake, changes made by finance in the source must be reflected automatically, and no scheduled copy jobs should be created. Which approach meets all requirements?

Accepted Answer

Create a OneLake shortcut in the lakehouse Tables or Files area pointing to the ADLS Gen2 location

Answer

Build a Dataflow Gen2 that reads from the ADLS Gen2 source and loads the data into a lakehouse table

Answer

Use a Copy activity in a Data Factory pipeline scheduled to run hourly against the ADLS Gen2 account

Answer

Export the invoice data to CSV files and manually upload them into the lakehouse Files section