Q39 — AWS DEA-C01 Ch.1

Question 39 of 100 | ← Chapter 1

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.

Correct Answer: C. Use the query editor v2 in Amazon Redshift to refresh the materialized views.

Explanation

对于需要在AmazonRedshift中自动化刷新物化视图的任务，考虑到“最少努力”的原则，最直接和简便的方法是使用AmazonRedshift内置的工具。选项C提到的“使用AmazonRedshift中的查询编辑器v2来刷新物化视图”正是这样一种方法，因为它不需要引入额外的服务或工具，可以直接在Redshift环境中完成操作，因此是最省力的解决方案。其他选项如ApacheAirflow、AWSLambdaUDF或AWSGlue工作流虽然也可以实现相同的功能，但它们需要额外的设置和配置，不符合“最少努力”的要求。因此，答案是C。