DEA-C01 · Question #137
A data engineer maintains a materialized view that is based on an Amazon Redshift database. The view has a column named load_date that stores the date when each row was loaded. The data engineer needs
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #137. The question stem and answer options stay visible for context.
Question
A data engineer maintains a materialized view that is based on an Amazon Redshift database. The view has a column named load_date that stores the date when each row was loaded. The data engineer needs to reclaim database storage space by deleting all the rows from the materialized view. Which command will reclaim the MOST database storage space?
Options
- ADELETE FROM materialized_view_name where 1=1
- BTRUNCATE materialized_view_name
- CVACUUM table_name where load_date<=current_date materializedview
- DDELETE FROM materialized_view_name where load_date<=current_date
Unlock DEA-C01 to see the answer
You've previewed enough free DEA-C01 questions. Unlock DEA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.