Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 50 discussion

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.
Show Suggested Answer Hide Answer
Suggested Answer: B ūüó≥ÔłŹ

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
pypelyncar
1 week, 4 days ago
Selected Answer: C
the company can automate the refresh schedules for materialized views with minimal effort. This approach leverages the built-in capabilities of Amazon Redshift, reducing the need for additional services, configurations, or custom code. It aligns with the principle of using the simplest and most straightforward solution that meets the requirements, minimizing operational overhead and complexity
upvoted 1 times
...
d8945a1
1 month, 2 weeks ago
Selected Answer: C
We can schedule the refresh using query scheduler from Query Editor V2.
upvoted 2 times
...
Christina666
2 months, 1 week ago
Selected Answer: C
Amazon Redshift can automatically refresh materialized views with up-to-date data from its base tables when materialized views are created with or altered to have the autorefresh option. For more details, refer to the documentation here, https://docs.aws.amazon.com/redshift/latest/dg/materialized-view-refresh.html.
upvoted 1 times
...
agg42
2 months, 3 weeks ago
Selected Answer: C
https://docs.aws.amazon.com/redshift/latest/mgmt/query-editor-v2-schedule-query.html
upvoted 2 times
...
FuriouZ
2 months, 4 weeks ago
Selected Answer: 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.
upvoted 1 times
...
GiorgioGss
3 months ago
Selected Answer: C
https://docs.aws.amazon.com/redshift/latest/dg/materialized-view-refresh.html
upvoted 1 times
...
kj07
3 months, 1 week ago
You can set AUTO REFRESH option on creation. So I will vote with C.
upvoted 1 times
...
confusedyeti69
3 months, 1 week ago
Selected Answer: C
Lambda requires code and configuring permissions. A and D are additional overheads as well. Vote C
upvoted 1 times
...
damaldon
3 months, 2 weeks ago
B. https://docs.aws.amazon.com/redshift/latest/dg/materialized-view-UDFs.html
upvoted 1 times
...
rralucard_
4 months, 2 weeks ago
Selected Answer: 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.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...