Month End Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmasmnth

A retail company stores order information in an Amazon Aurora table named Orders.

  1. Home
  2. Amazon Web Services
  3. AWS Certified Data Engineer
  4. Data-Engineer-Associate
  5. Data-Engineer-Associate Questions
  6. AWS Certified Data Engineer - Associate (DEA-C01) Practice Questions

A retail company stores order information in an Amazon Aurora table named Orders. The company needs to create operational reports from the Orders table with minimal latency. The Orders table contains billions of rows, and over 100,000 transactions can occur each second.

A marketing team needs to join the Orders data with an Amazon Redshift table named Campaigns in the marketing team's data warehouse. The operational Aurora database must not be affected.

Which solution will meet these requirements with the LEAST operational effort?

A.

Use AW5 Database Migration Service (AWS DMS) Serverless to replicate the Orders table to Amazon Redshift. Create a materialized view in Amazon Redshift to join with the Campaigns table.

B.

Use the Aurora zero-ETL integration with Amazon Redshift to replicate the Orders table. Create a materialized view in Amazon Redshift to join with the Campaigns table.

C.

Use AWS Glue to replicate the Orders table to Amazon Redshift. Create a materialized view in Amazon Redshift to join with the Campaigns table.

D.

Use federated queries to query the Orders table directly from Aurora. Create a materialized view in Amazon Redshift to join with the Campaigns table.

Amazon Web Services Data-Engineer-Associate View All Questions

Amazon Web Services Data-Engineer-Associate Summary

  • Vendor: Amazon Web Services
  • Product: Data-Engineer-Associate
  • Update on: Jan 28, 2026
  • Questions: 231
Price: $52.5  $149.99
Buy Now Data-Engineer-Associate PDF + Testing Engine Pack
Next
A company stores time-series data that is collected from streaming services in an Amazon S3...
A company stores daily records of the financial performance of investment portfolios in .
Previous

Payments We Accept

Your purchase with ExamsVCE is safe and fast. Your products will be available for immediate download after your payment has been received.
The ExamsVCE website is protected by 256-bit SSL from McAfee, the leader in online security.

examsvce payment method

Contact Us

Copyright © 2013-2026 examsvce.com. All Rights Reserved
mcafee secure

TESTED 28 Jan 2026