Domain 2 · 26% of Exam

Data Store Management

Domain 2 tests your ability to choose and configure appropriate data stores, design data models, manage data lifecycles, and optimize storage for cost and performance.

About This Domain

Domain 2 — Data Store Management — accounts for 26% of the DEA-C01 certification exam. This domain evaluates your understanding of data lake design with s3, lake formation, and the glue data catalog, data warehouse operations with redshift, redshift spectrum, and serverless, nosql data stores with dynamodb, streams, and export-to-s3, and related concepts. Domain 2 tests your ability to choose and configure appropriate data stores, design data models, manage data lifecycles, and optimize storage for cost and performance. To pass this section you need practical knowledge of how these services and patterns work together in real-world architectures.

What You'll Be Tested On

  • Data lake design with S3, Lake Formation, and the Glue Data Catalog
  • Data warehouse operations with Redshift, Redshift Spectrum, and Serverless
  • NoSQL data stores with DynamoDB, streams, and export-to-S3
  • Relational databases with RDS, Aurora, read replicas, and snapshots
  • Data modeling and schema design for analytics workloads
  • Storage optimization with S3 lifecycle policies, intelligent tiering, and compression

Key AWS Services in This Domain

Study Strategy for Domain 2

This domain represents 26% of the total exam, making it a significant scoring area. Balance theoretical study with hands-on practice. Use practice quizzes to identify weak spots and review the topics where you score below 75%.

Exam Tips for Domain 2

💡

Understand when to use a data lake (S3 + Athena) vs a data warehouse (Redshift) vs a lakehouse (Redshift Spectrum).

💡

S3 partitioning by date or key prefixes dramatically improves Athena and Redshift Spectrum query performance.

💡

Lake Formation LF-Tags provide scalable, tag-based fine-grained access control across data lake resources.

💡

DynamoDB Streams combined with Lambda or Kinesis enables real-time data replication to analytics stores.

Frequently Asked Questions

How many questions on the DEA-C01 exam come from Domain 2?

Domain 2 (Data Store Management) makes up 26% of the DEA-C01 exam. The exam has 65 scored questions, so approximately 17 questions will come from this domain.

What services should I focus on for Domain 2?

The key services for this domain include S3, Redshift, Lake Formation, DynamoDB, RDS, Athena, AWS Glue. Make sure you understand how each service works, its use cases, and how they integrate with one another.

How should I prepare for Data Store Management questions?

Start by reviewing the key topics listed above, then practice with domain-specific questions. Focus on understanding real-world scenarios rather than memorizing facts. Use our practice quizzes to test your knowledge and review explanations for any questions you get wrong.

What's the best order to study the DEA-C01 domains?

Many candidates start with the highest-weighted domains first. For the DEA-C01 exam, the domains in order of weight are: Data Ingestion and Transformation (34%), Data Store Management (26%), Data Operations and Support (22%), Data Security and Governance (18%). However, start with whichever domain aligns best with your existing experience.

Practice Domain 2 Questions

Test your knowledge of Data Store Management with practice questions from our DEA-C01 question bank.

Start Practice Quiz →

Other DEA-C01 Domains