Topic 1 Question 50
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?
Use Apache Airflow to refresh the materialized views.
Use an AWS Lambda user-defined function (UDF) within Amazon Redshift to refresh the materialized views.
Use the query editor v2 in Amazon Redshift to refresh the materialized views.
Use an AWS Glue workflow to refresh the materialized views.
ユーザの投票
コメント(11)
- 正解だと思う選択肢: C
We can schedule the refresh using query scheduler from Query Editor V2.
👍 3d8945a12024/11/07 - 正解だと思う選択肢: B
AWS Lambda allows running code in response to triggers without needing to provision or manage servers. However, creating a UDF within Amazon Redshift to call a Lambda function for this purpose involves writing custom code and managing permissions between Lambda and Redshift.
👍 2rralucard_2024/08/02 - 正解だと思う選択肢: C
You can set autorefresh for materialized views using CREATE MATERIALIZED VIEW. You can also use the AUTO REFRESH clause to refresh materialized views automatically.
👍 2FuriouZ2024/09/23
シャッフルモード