Crucial Exams

AWS Certified Data Engineer Associate DEA-C01 Practice Question

A company stores operational data in an Amazon RDS for PostgreSQL instance and maintains an Amazon Redshift cluster for analytics. Data engineers must allow analysts to join current transactional tables with fact tables that already reside in Redshift, with minimal latency and without creating additional ETL pipelines or duplicating the data. Which approach meets these requirements?

  • Enable Redshift Spectrum and use AWS Glue jobs to copy the RDS tables to Amazon S3 on a frequent schedule, then create external tables for querying.

  • Set up AWS Database Migration Service with ongoing replication to load the RDS tables into staging tables in Redshift and merge them during queries.

  • Configure Amazon Redshift federated queries to connect to the RDS PostgreSQL instance and create views that reference the remote tables.

  • Deploy an Amazon MSK cluster to capture change data from RDS and stream it into Redshift using Amazon Kinesis Data Firehose.

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