A company uses Amazon Redshift as its data aws video
data-engineer video for a company uses Amazon Redshift as its data warehouse solution. The company runs certain complex queries repeatedly over a large amount
Answer
Full Certification Question
A company uses Amazon Redshift as its data warehouse solution. The company runs certain complex queries repeatedly over a large amount of data and hence uses Amazon Redshift materialized views. The company wants these materialized views to refresh automatically per a defined schedule. Which of the following represents an optimal solution that can automate the process with the LEAST effort?