A company generates reports from 30 tables in an Amazon Redshift data warehouse.

Amazon Web Services Data-Engineer-Associate Question Answer

A company generates reports from 30 tables in an Amazon Redshift data warehouse. The data source is an operational Amazon Aurora MySQL database that contains 100 tables. Currently, the company refreshes all data from Aurora to Redshift every hour, which causes delays in report generation.

Which combination of steps will meet these requirements with the LEAST operational overhead? (Select TWO.)

Use AWS Database Migration Service (AWS DMS) to create a replication task. Select only the required tables.

Create a database in Amazon Redshift that uses the integration.

Create a zero-ETL integration in Amazon Aurora. Select only the required tables.

Use query editor v2 in Amazon Redshift to access the data in Aurora.

Create an AWS Glue job to transfer each required table. Run an AWS Glue workflow to initiate the jobs every 5 minutes.

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: Mar 14, 2026
Questions: 289

Price: $52.5 ~~$149.99~~

Buy Now Data-Engineer-Associate PDF + Testing Engine Pack

A data engineer uses AWS Lake Formation to manage access to data that is stored...

A data engineer is using Amazon QuickSight to build a dashboard to report a company’s...

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

A company generates reports from 30 tables in an Amazon Redshift data warehouse.

The Answer Is:

Explanation:

Amazon Web Services Data-Engineer-Associate Summary

Payments We Accept

Contact Us