Microsoft Azure Data Fundamentals DP-900 Practice Question

The TRUNCATE TABLE statement removes all rows from a table in a minimally logged operation, which is faster and uses fewer resources than deleting rows one by one. It does not delete the table definition, so the table, its indexes, and permissions remain available for future inserts. DROP TABLE would remove both the data and the table structure, which is not acceptable because the table must stay in place. DELETE FROM removes rows but is fully logged and therefore slower and more resource-intensive for large tables, though it does keep the table structure. ALTER TABLE REBUILD reorganizes storage structures and does not delete data at all. Therefore, TRUNCATE TABLE SalesFact; is the correct choice.