AWS Certified Data Engineer – Associate (DEA-C01) — Question 39

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?

Answer options

• 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.

Correct answer: C

Explanation

The correct option, C, involves using the query editor v2, which is specifically designed for managing queries and operations within Amazon Redshift, making it the simplest choice for refreshing materialized views. Options A and D involve additional services and complexity, while option B requires creating a user-defined function, which adds development overhead compared to the direct approach of utilizing the built-in query editor.