To enable T-SQL-based data cleanup in a Fabric Warehouse, which object type is best suited?

• A. Stored Procedure
• B. View
• C. Table-Values Function
• D. Function

Answer: (A)

Procedural control and transactional safety are essential for data cleanup tasks. A stored procedure lets you encapsulate a sequence of T-SQL statements—such as deletes, updates, inserts for audit trails, and even conditional logic—inside a single executable unit that can accept parameters, manage transactions with BEGIN TRAN and COMMIT/ROLLBACK, and handle errors with TRY…CATCH. This makes it ideal for cleanup workflows that may run repeatedly, be scheduled, and need reliable logging and rollback if something goes wrong. Views are saved queries that present data and don’t perform cleanup or manage state. Table-valued functions return a result set and aren’t designed to modify data or handle transactional control in a cleanup scenario. A generic function (scalar or non-scalar) is intended for computations and cannot safely perform persistent data modifications. So, for T-SQL-based data cleanup in a Fabric Warehouse, a stored procedure is the best fit.