DEA-C01 Domain 3: Data Operations and Support

A company needs to optimize Redshift query performance. Which option meets the requirement with the LEAST implementation effort? optimize Redshift query performance.

Multiple choice — select one answer

Answer choices

  1. a. AWS Glue Data Catalog lineage or third-party
  2. b. Sort keys, distribution keys, and RA3 sizing
  3. c. Hive-style partitions (year/month/day)
  4. d. Glue job bookmarks, CloudWatch alarms, and Step Functions

Architectural breakdown & explanation

Physical design affects warehouse performance.

Correct answer(s): b. Sort keys, distribution keys, and RA3 sizing

Exam domain: Domain 3: Data Operations and Support (22% weight on the official guide).

Official documentation & study links

Practice this certification

This page is one question from the AWS Certified Data Engineer – Associate bank. Run a full timed practice exam with domain-weighted random questions in your browser.