AWS Certified Data Engineer Associate DEA-C01 Practice Question

Stored procedures in Amazon Redshift are written in PL/pgSQL, run inside the cluster, and support control-of-flow statements such as IF, WHILE, and FOR loops as well as EXCEPTION handling and explicit transaction blocks. This allows complex, stateful ETL tasks-including creating objects, iterating over a list, and logging results-to be executed where the data lives. Python UDFs are limited to row-level calculations and cannot manage DDL, loops over result sets, or multi-statement transactions. The Redshift Data API and EventBridge can schedule or invoke queries, but the procedural logic would still need to be embedded in individual SQL statements or external code, increasing network traffic and losing in-cluster transaction control.