20+ practice questions focused on Data Store Management — one of the most tested topics on the AWS Certified Data Engineer Associate DEA-C01 exam. Each question includes a detailed explanation so you learn why the right answer is correct.
Start Data Store Management PracticeA 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?
Explanation: DISTSTYLE ALL copies the entire table to every node, which is inefficient for large fact tables because it wastes storage and network bandwidth during data loading and query execution. Changing to DISTSTYLE KEY on a column used in frequent joins collocates related rows on the same slice, reducing the need to broadcast or redistribute data across the network during joins, which directly improves query performance.
Which TWO actions should a data engineer take to encrypt data at rest in an Amazon S3 bucket? (Select TWO.)
Explanation: Options C and D are correct because both configure server-side encryption at rest for objects stored in the S3 bucket: SSE-KMS (C) encrypts objects with AWS KMS customer master keys, giving key management, auditability via CloudTrail, and granular access control, while enabling default encryption with SSE-S3 (D) applies AES-256 encryption managed by Amazon S3 to every object put into the bucket without requiring per-request headers. Both satisfy the requirement to encrypt data at rest in Amazon S3. Option A is wrong because S3 Transfer Acceleration only speeds up uploads over AWS edge locations and does not encrypt data. Option B is not among the marked correct answers here even though client-side encryption can protect data, and Option E is wrong because a bucket policy denying unencrypted PUT requests only enforces that encryption headers are present; it does not itself encrypt data at rest.
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.)
Explanation: Option B is correct because S3 Lifecycle policies can transition aging data to Amazon S3 Glacier storage classes, which supports the data lake's long-term retention and cost-efficiency needs while keeping data durable and immutable once archived. Option C is correct because the S3 Multipart Upload API allows large objects to be uploaded in parallel parts, which is essential for high-throughput streaming ingestion and for efficiently handling large data files. Option D is correct because S3 Object Lock in governance mode enforces immutability by preventing object deletion or overwrite for a defined retention period, directly satisfying the immutability requirement. Option A is not correct because S3 Transfer Acceleration speeds up uploads over long distances using edge locations, but it does not provide immutability or specifically enable high-throughput streaming ingestion. Option E is not correct because Cross-Region Replication copies objects to another region for durability and compliance, but it is not required for immutability or high-throughput ingestion and can actually complicate immutability guarantees if not carefully configured.
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?
Explanation: Using a Global Secondary Index (GSI) with a sort key tailored to the reporting query pattern allows the reporting job to query only the relevant items instead of scanning the entire table. This reduces the read capacity units consumed per operation, directly lowering costs under on-demand capacity, which charges per RCU consumed. The reporting output remains identical because the GSI returns the same data filtered by the query pattern.
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?
Explanation: Amazon S3 lifecycle policies have a minimum object size requirement for transitions to certain storage classes. Objects must be at least 128 KB to transition to S3 Glacier Instant Retrieval. Since the policy first transitions objects to Glacier Instant Retrieval after 30 days, objects smaller than 128 KB cannot undergo that transition, and subsequent transitions to Deep Archive will also fail. The 30-day minimum interval requirement is met (30 days between transitions), so option D is not the cause. Versioning (A) does not prevent transitions, and Deep Archive (B) is supported in all commercial AWS regions. Therefore, the most likely cause is that objects are smaller than 128 KB.
+15 more Data Store Management questions available
Practice all Data Store Management questions1. Baseline your knowledge
Start with 10 questions to gauge your current understanding of Data Store Management. This tells you whether you need a concept refresher or just practice.
2. Review every explanation
For each question — right or wrong — read the full explanation. Understanding why an answer is correct is more valuable than knowing the answer itself.
3. Focus on exam traps
Data Store Management questions on the DEA-C01 frequently use trap wording. Look for subtle differences in answers that test your precision, not just general knowledge.
4. Reach 80% consistently
Do repeated sessions until you score 80%+ three times in a row. Then move to mixed-mode practice to test cross-topic recall under realistic conditions.
The exact number varies per candidate. Data Store Management is tested as part of the AWS Certified Data Engineer Associate DEA-C01 blueprint. Practicing with targeted Data Store Management questions ensures you can handle any format or difficulty that appears.
Yes. Courseiva provides free DEA-C01 practice questions across all exam topics and domains. The platform includes topic-based practice, mock exams, missed-question review, bookmarked questions, and readiness tracking — no account required.
Difficulty is subjective, but Data Store Management is a high-priority exam concept tested in multiple ways — direct recall, scenario analysis, and command-output interpretation. Consistent practice is the best way to build confidence.
Launch a full Data Store Management practice session with instant scoring and detailed explanations.
Start Data Store Management Practice →