Summer Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ac4s65

A data engineer manages a provisioned Amazon Redshift cluster that stores petabytes of data.

Amazon Web Services Data-Engineer-Associate Full Course Access
Amazon Web Services Data-Engineer-Associate View All Questions

A data engineer manages a provisioned Amazon Redshift cluster that stores petabytes of data. The cluster receives continuous data ingestion from multiple sources. As data volume grows, the query performance has degraded. The current table design uses the AUTO distribution style and default sort keys. The data engineer needs to optimize the query performance for recent transactions.

Which solution will meet these requirements?

A.

Offload historical data to Amazon S3. Use Amazon Redshift Spectrum to query the data directly. Retain frequently accessed data in Amazon Redshift.

B.

Decrease the number of nodes of the current node type in the Amazon Redshift cluster.

C.

Change the data distribution style of the Amazon Redshift tables to ALL for all the tables that contain historical data.

D.

Switch from columnar storage to row-based storage. Use Amazon Redshift ML for the complex queries.

Data-Engineer-Associate PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now Data-Engineer-Associate pdf
Get 65% Discount on All Products, Use Coupon: "ac4s65"
Next
A media company wants to improve a system that recommends media content to customer based...
A company uses AWS Glue Apache Spark jobs to handle extract, transform, and load (ETL)...
Previous