DEA-C01 · Question #27
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 effo
The correct answer is B. Use an AWS Lambda user-defined function (UDF) within Amazon Redshift to refresh the. 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.
Question
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?
Options
- AUse Apache Airflow to refresh the materialized views.
- BUse an AWS Lambda user-defined function (UDF) within Amazon Redshift to refresh the
- CUse the query editor v2 in Amazon Redshift to refresh the materialized views.
- DUse an AWS Glue workflow to refresh the materialized views.
How the community answered
(25 responses)- A12% (3)
- B76% (19)
- C8% (2)
- D4% (1)
Explanation
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.
Topics
Community Discussion
No community discussion yet for this question.