A company uses Amazon Redshift and needs to automate refresh schedules for materialized views. Which solution will accomplish this with the least effort?
Choose an answer
Tap an option to check your answer.
Correct answer: Use the query editor v2 in Amazon Redshift to refresh the materialized views..
Why this is the answer
The Amazon Redshift query editor v2 offers a built-in scheduler that allows you to automate the execution of SQL queries, including REFRESH MATERIALIZED VIEW statements. This is the least effort solution because it's integrated directly into Redshift's management console, requiring no external services or complex setup. Using Apache Airflow or an AWS Glue workflow would involve setting up and managing external orchestration tools, which is more effort. While both can schedule tasks, they introduce additional infrastructure and configuration overhead compared to the native Redshift scheduler. An AWS Lambda UDF within Redshift cannot directly refresh materialized views; UDFs are for custom functions within queries, not for scheduling administrative tasks.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed