Question

A Fabric Analytics Engineer maintains a data warehouse where a nightly load must delete and reinsert fact rows for a specific date range, then log the operation. Different pipelines call this logic with varying start and end dates, and the team wants a single reusable object that accepts these dates as inputs, performs multiple sequential DML statements, and can be executed (not queried in a SELECT). Which warehouse object best meets these requirements?

Accepted Answer

A stored procedure that accepts @StartDate and @EndDate parameters and runs the DELETE, INSERT, and logging statements

Answer

A view that filters the fact table between the two dates

Answer

An inline table-valued function that returns the filtered rows for the date range

Answer

A scalar user-defined function that takes the dates and returns a row count