🔥 40% Off Crucial Exams Memberships — This Week Only

3 days, 13 hours remaining!
Crucial Exams

AWS Certified Data Engineer Associate DEA-C01 Practice Question

A data engineering team created a materialized view in Amazon Redshift that joins the internal fact_sales table with an external product_dim table stored in Amazon S3 through a Spectrum external schema. After the product_dim data files are overwritten each night, analysts notice that the view returns stale data. The team must keep results current in the most cost-effective way without copying the external table into Redshift. What should they do?

  • Replace the materialized view with a late-binding view so it always reads the latest external data.

  • Convert the product_dim external table into a regular Redshift table so the view can refresh automatically.

  • Run ALTER MATERIALIZED VIEW … AUTO REFRESH YES to enable incremental refresh on the existing view.

  • Schedule the REFRESH MATERIALIZED VIEW command to run after the nightly S3 load completes.

AWS Certified Data Engineer Associate DEA-C01
Data Store Management
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot