How should I use these Data Store Management practice questions?

Read each scenario carefully and choose your answer before revealing the explanation. Then check why your choice was right or wrong. Repeat until the reasoning feels automatic.

Can I practise just Data Store Management questions in a focused session?

Yes — use the session launcher on this page to start a 10-, 20-, 30- or 50-question session drawn entirely from the Data Store Management domain.

DEA-C01 · topic practice

Data Store Management practice questions

Use this page to practise Data Store Management questions for this certification. Focus on how the exam tests data store management in scenario format — understanding the why behind each answer builds more durable knowledge than memorising options.

Courseiva uses original exam-style practice questions designed for learning and revision. The goal is to understand the concepts, recognise exam patterns, and improve through explanations — not memorise copied exam dumps.

Reviewed byJohnson Ajibi· MSc IT Security

20 questionsDomain: Data Store Management

Practice 10 questions Browse domain →

What the exam tests

What to know about Data Store Management

Data Store Management questions on this certification test your ability to deploy and manage data store management concepts in scenario-based situations.

Core Data Store Management concepts and how they apply in real-world cloud scenarios.

How to deploy data store management correctly and verify the outcome.

Troubleshooting data store management issues by interpreting error output and system state.

Cloud best practices and Data Store Management design trade-offs tested by this certification.

Watch out for

Common Data Store Management exam traps

▸Selecting the most expensive service when a simpler managed option meets the requirement.
▸Forgetting that cloud resources must be explicitly secured — defaults are rarely secure.
▸Choosing a global service fix when the issue is region-specific.
▸Overlooking cost implications of cross-region data transfer in architecture questions.

Practice set

Data Store Management questions

20 questions · select your answer, then reveal the explanation

Question 1mediummultiple choice

Read the full Data Store Management explanation →

A company has an Amazon RDS for MySQL DB instance with read replicas. The primary DB instance fails. What is the correct procedure to promote a read replica to become the new primary?

Trap 1: Modify the read replica to be a Multi-AZ deployment and failover…

Modifying to Multi-AZ does not promote the replica; it creates a standby in another AZ.

Trap 2: RDS automatically fails over to the read replica within 5 minutes.

RDS does not automatically fail over to a read replica; you must manually promote.

Trap 3: Delete the primary and the read replica will automatically become…

Deleting the primary does not promote the replica; the replica remains a replica.

Study all Data Store Management common traps →

A
Modify the read replica to be a Multi-AZ deployment and failover will occur.
Why wrong: Modifying to Multi-AZ does not promote the replica; it creates a standby in another AZ.
B
RDS automatically fails over to the read replica within 5 minutes.
Why wrong: RDS does not automatically fail over to a read replica; you must manually promote.
C
Manually promote the read replica to a standalone DB instance.
This is the correct procedure to make the read replica the new primary.
D
Delete the primary and the read replica will automatically become the primary.
Why wrong: Deleting the primary does not promote the replica; the replica remains a replica.

Data Store Management practice questions

What to know about Data Store Management

Common Data Store Management exam traps

Data Store Management questions

A company has an Amazon RDS for MySQL DB instance with read replicas. The primary DB instance fails. What is the correct procedure to promote a read replica to become the new primary?

A data engineering team uses Amazon Redshift for analytics. They notice that queries on a large fact table are slow. The table is distributed using DISTSTYLE ALL. Which design change would most likely improve query performance?

A company uses Amazon DynamoDB for a gaming application. They need to store player session data that expires after 24 hours. Which DynamoDB feature should they use to automatically delete expired items?

Which TWO actions should a data engineer take to encrypt data at rest in an Amazon S3 bucket? (Select TWO.)

A data engineer is designing a data lake on Amazon S3. The data must be immutable and support high-throughput streaming ingestion. Which THREE features should the engineer consider? (Select THREE.)

An e-commerce application uses Amazon ElastiCache for Redis to cache product catalog data. The cache currently uses lazy loading. The team wants to ensure that frequently accessed product data is always fresh. Which caching strategy should they implement?

Refer to the exhibit. A data engineer has attached this bucket policy to an S3 bucket. What is the effect of this policy?

Exhibit

Refer to the exhibit. A data engineer runs the above AWS CLI command to view the table metadata in the AWS Glue Data Catalog. The data is stored as CSV in S3 with partitions by year and month. When querying the table using Amazon Athena, no data is returned. What is the most likely cause?

Which THREE storage classes in Amazon S3 are designed for infrequently accessed data with millisecond retrieval times? (Select THREE.)

A company stores time-series sensor data in Amazon S3. They need to query the data using SQL with minimal latency and no infrastructure management. Which service should they use?

A data engineer needs to migrate an on-premises MySQL database to Amazon RDS for MySQL with minimal downtime. Which approach should they use?

A company uses Amazon DynamoDB with on-demand capacity. They notice higher than expected costs due to a sudden spike in read traffic from a reporting job. The reporting job scans the entire table daily. What is the most cost-effective way to reduce costs while maintaining the same reporting output?

A data engineer has set up an Amazon S3 lifecycle policy to transition objects to Glacier Instant Retrieval after 30 days. After 60 days, objects should transition to Deep Archive. However, objects are not transitioning to Deep Archive. What is the most likely cause?

A data engineer attaches the above IAM policy to an IAM user. The user tries to download an object from my-bucket using the AWS CLI without specifying SSE headers. The object is stored with SSE-S3. Will the download succeed?

Exhibit

A company is designing a data lake on Amazon S3. Which TWO strategies improve query performance for Amazon Athena?

A company is migrating a legacy data warehouse to Amazon Redshift. They need to choose a distribution style to minimize data movement during joins. Which THREE factors should they consider?

A company runs a multi-AZ Amazon RDS for PostgreSQL instance. They need to run a one-time analytical query that will take several hours and consume significant I/O. The query should not impact the primary workload. What should the data engineer do?

A company is migrating its on-premises MySQL database to Amazon RDS for MySQL. They want to minimize downtime and ensure data consistency. Which AWS service should be used for the migration?

Track your progress over time

Start a Data Store Management only practice session

Related DEA-C01 topic practice pages

Data Ingestion and Transformation practice questions

Data Operations and Support practice questions

Data Security and Governance practice questions

Data Store Management practice questions

DEA-C01 fundamentals practice questions

DEA-C01 scenario practice questions

DEA-C01 troubleshooting practice questions

Frequently asked questions

Track your progress

Study resources

Exam traps to avoid