Explanation:
Amazon Redshift Query Editor v2 has a built-in query scheduling feature that allows you to schedule REFRESH MATERIALIZED VIEW statements directly within the Redshift environment — no external services, custom Lambda functions, or Airflow DAGs required. This is the simplest and most direct solution with the least configuration effort.
Ultimate access to all questions.
A company uses Amazon Redshift for its data warehouse. The company must automate refresh schedules for Amazon Redshift materialized views. Which solution will meet this requirement with the LEAST effort?
A
Use Apache Airflow to refresh the materialized views.
B
Use an AWS Lambda user-defined function (UDF) within Amazon Redshift to refresh the materialized views.
C
Use the query editor v2 in Amazon Redshift to refresh the materialized views.
D
Use an AWS Glue workflow to refresh the materialized views.
No comments yet.