To limit data in a lakehouse shortcut to CustomerID 100, which step should be taken when creating the shortcut?

To limit data in a lakehouse shortcut to CustomerID 100, which step should be taken when creating the shortcut?

• A. Add a filter activity after the copy data activity in a data pipeline.
• B. Select the CustomerKey=100 folder under the FactSales folder in Tables.
• C. Select the CustomerKey=100 folder under the FactSales folder in Files.
• D. Add a report-level filter for CustomerKey = 100.

Answer: (B)

When you want a lakehouse shortcut to bring back only a specific slice of data, you limit data by choosing a pre-filtered data location at the source. Selecting the CustomerKey=100 folder under the FactSales folder in Tables points the shortcut to a table-like object that already contains only that customer’s data, so the shortcut returns just that subset. This keeps data size small and avoids pulling in unnecessary records. Other options apply filtering after data is loaded or point to raw files that aren’t pre-filtered, so they wouldn’t limit what the shortcut pulls in at creation time.

When you want a lakehouse shortcut to bring back only a specific slice of data, you limit data by choosing a pre-filtered data location at the source. Selecting the CustomerKey=100 folder under the FactSales folder in Tables points the shortcut to a table-like object that already contains only that customer’s data, so the shortcut returns just that subset. This keeps data size small and avoids pulling in unnecessary records.

Other options apply filtering after data is loaded or point to raw files that aren’t pre-filtered, so they wouldn’t limit what the shortcut pulls in at creation time.