nerdexam
AmazonAmazon

DEA-C01 · Question #225

DEA-C01 Question #225: Real Exam Question with Answer & Explanation

Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #225. The question stem and answer options stay visible for context.

Data Ingestion and Transformation

Question

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?

Options

  • AUse AWS Database Migration Service (AWS DMS) Serverless to replicate the Orders table to
  • BUse the Aurora zero-ETL integration with Amazon Redshift to replicate the Orders table. Create a
  • CUse AWS Glue to replicate the Orders table to Amazon Redshift. Create a materialized view in
  • DUse federated queries to query the Orders table directly from Aurora. Create a materialized view

Unlock DEA-C01 to see the answer

You've previewed enough free DEA-C01 questions. Unlock DEA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Aurora zero-ETL integration#Amazon Redshift#Data replication#Analytical reporting
Full DEA-C01 PracticeBrowse All DEA-C01 Questions