Goldman Sachs Interview Question

I was asked the difference between truncate and delete to test my SQL knowledge for a BI analyst role.

Interview Answer

Anonymous

Sep 3, 2025

Since when BI Analysts, operating on data warehouses Update, Insert into, Truncate, or delete records? In best case, we drop temporary tables. Seemed irrelevant.