DEA-C01 Data Store Management Practice Test 18 — 15 Questions

Question 1

An IAM role 'DataLakeRole' has the above S3 bucket policy attached to an S3 bucket. The role is assumed by an AWS Glue job. The Glue job is failing with 'Access Denied' errors when trying to list objects in the bucket. Which action should be added to the policy to fix the issue?

Accepted Answer

Add s3:ListBucket action for the bucket ARN (arn:aws:s3:::my-data-lake).. The Glue job is failing with 'Access Denied' when trying to list objects, which requires the s3:ListBucket permission on the bucket itself (not on objects). Option B correctly adds s3:ListBucket for the bucket ARN (arn:aws:s3:::my-data-lake), which grants permission to list the contents of the bucket. Without this action, even if other permissions exist, the ListObjectsV2 API call used by AWS Glue to enumerate objects will be denied.

Answer

Add s3:ListObjects action for the bucket ARN.

Answer

Add s3:GetObjectVersion action for the object ARN.

Answer

Add s3:ListBucket action for the object ARN (arn:aws:s3:::my-data-lake/*).

Question 2

The exhibit shows the output of describe-table for a DynamoDB table. The application is experiencing throttling errors when reading data. What is the MOST likely cause?

Accepted Answer

The table's provisioned read capacity is too low.. The describe-table output shows the table has provisioned read capacity set to 5, but the application is experiencing throttling errors. Throttling occurs when read requests exceed the provisioned read capacity units (RCUs). Increasing the read capacity or implementing retries with exponential backoff would resolve this. The throttling is directly caused by insufficient provisioned read capacity for the workload.

Answer

The sort key is not used correctly for queries.

Answer

The table has a hot partition due to the HASH key.

Answer

The table size is too large, causing slow reads.

Question 3

A company is using Amazon S3 to store sensitive data. They need to automatically transition objects to S3 Glacier Deep Archive after 90 days and delete them after 7 years. Which S3 lifecycle configuration action should be used?

Accepted Answer

Transition. Option A is correct because the S3 lifecycle 'Transition' action is specifically designed to move objects between storage classes. To automatically move objects to S3 Glacier Deep Archive after 90 days, you define a transition rule with a 'Days' value of 90 and a 'StorageClass' of 'DEEP_ARCHIVE'. This action directly meets the requirement for transitioning data to a colder storage tier.

Answer

AbortIncompleteMultipartUpload

Answer

Expiration

Answer

NoncurrentVersionExpiration

Question 4

A data engineer is designing a data store for a time-series application that requires sub-millisecond read latency for the latest data and high ingestion rates. Which AWS service is most suitable?

Accepted Answer

Amazon Timestream. Option A is correct because Amazon Timestream is a fast, scalable, serverless time-series database. Option B is wrong because Amazon RDS is not optimized for time-series workloads. Option C is wrong because Amazon DynamoDB is a key-value store, not purpose-built for time-series. Option D is wrong because Amazon ElastiCache is a caching layer, not a primary datastore for time-series.

Answer

Amazon DynamoDB

Answer

Amazon ElastiCache for Redis

Answer

Amazon RDS for PostgreSQL

Question 5

A company is migrating an on-premises Hadoop cluster to AWS. The data is stored in HDFS and needs to be accessible by both Amazon EMR and Amazon Redshift Spectrum. Which storage solution is most cost-effective and scalable?

Accepted Answer

Amazon Simple Storage Service (S3). Option B is correct because Amazon S3 is a cost-effective, scalable object store that can be accessed by both EMR and Redshift Spectrum. Option A is wrong because EBS is limited to a single EC2 instance. Option C is wrong because EFS is a file system, not as cost-effective for large-scale data. Option D is wrong because Amazon FSx for HDFS is designed for HDFS compatibility but is more expensive than S3.

Answer

Amazon FSx for HDFS

Answer

Amazon Elastic Block Store (EBS)

Answer

Amazon Elastic File System (EFS)

Question 6

A data engineer needs to store JSON documents that are frequently updated and require ACID transactions. Which AWS database service is most appropriate?

Accepted Answer

Amazon DynamoDB. Option A is correct because Amazon DynamoDB supports JSON documents and ACID transactions via DynamoDB Transactions. Option B is wrong because Amazon S3 is not a database and does not support transactions. Option C is wrong because Amazon DocumentDB is a MongoDB-compatible database but ACID transactions are limited. Option D is wrong because Amazon Neptune is a graph database, not optimized for JSON documents.

Answer

Amazon Neptune

Answer

Amazon DocumentDB

Answer

Amazon S3

Question 7

A company is using Amazon RDS for MySQL and needs to reduce read latency for a global user base. Which AWS feature should be implemented?

Accepted Answer

Read Replicas. Option D is correct because Read Replicas can be promoted to stand-alone instances and reduce read latency. Option A is wrong because Multi-AZ is for high availability, not read scaling. Option B is wrong because Auto Scaling adjusts capacity, not read latency. Option C is wrong because cross-region replication latency is high.

Answer

Multi-AZ deployment

Answer

Aurora Auto Scaling

Answer

Cross-Region Replication

Question 8

A data engineer is troubleshooting an Amazon Redshift cluster that is experiencing slow query performance. The engineer notices that the disk space is heavily utilized and queries are spilling to disk. What is the most cost-effective solution to improve performance?

Accepted Answer

Resize the cluster to a larger node type or add nodes. When queries spill to disk due to heavy disk utilization, the root cause is insufficient memory or compute capacity relative to the workload. Resizing the cluster (adding nodes or moving to a larger node type) directly increases available memory and CPU, reducing or eliminating disk spill and improving query performance. This is the most cost-effective solution because it scales resources proportionally without requiring manual tuning or schema changes.

Answer

Run VACUUM command to reclaim space

Answer

Change distribution style to KEY

Answer

Apply compression encoding to tables

Question 9

A company needs to store streaming data from IoT devices with a retention period of 7 days for real-time analysis. Which AWS service is most suitable?

Accepted Answer

Amazon Kinesis Data Streams. Amazon Kinesis Data Streams is the most suitable service because it is designed for real-time ingestion and processing of streaming data, such as IoT device telemetry, with a default retention period of 24 hours, extendable up to 365 days. The requirement for a 7-day retention period for real-time analysis aligns perfectly with Kinesis Data Streams' ability to retain data for exactly that duration, allowing consumers to process records in near real-time using the Kinesis Client Library (KCL) or AWS Lambda.

Answer

Amazon DynamoDB

Answer

Amazon Kinesis Data Firehose

Answer

Amazon S3

Question 10

A company has an Amazon S3 bucket with versioning enabled. They want to automatically delete noncurrent versions of objects after 30 days. Which lifecycle rule action should be used?

Accepted Answer

NoncurrentVersionExpiration. The NoncurrentVersionExpiration lifecycle action is specifically designed to remove noncurrent object versions after a specified number of days. Since versioning is enabled and the requirement is to delete noncurrent versions after 30 days, this action directly meets the goal without affecting current versions or other lifecycle aspects.

Answer

Expiration

Answer

NoncurrentVersionTransition

Answer

AbortIncompleteMultipartUpload

Question 11

A data engineer is designing a data lake on Amazon S3. The data is frequently accessed by multiple analytics services, and the company needs to enforce fine-grained access control based on data tags. Which combination of AWS services should be used?

Accepted Answer

AWS Lake Formation with tag-based access control. AWS Lake Formation with tag-based access control (TBAC) is the correct choice because it provides fine-grained, attribute-based access control (ABAC) at the column, row, and cell level across a data lake on S3. By assigning LF-tags to Data Catalog resources and defining permissions based on those tags, you can enforce granular access policies that scale without managing individual user-to-resource mappings. This directly meets the requirement for tag-driven, fine-grained access for multiple analytics services.

Answer

S3 Block Public Access settings

Answer

S3 Access Points with bucket policies

Answer

S3 Object Lambda with IAM policies

Question 12

Which TWO of the following are benefits of using Amazon DynamoDB Accelerator (DAX)? (Choose TWO.)

Accepted Answer

Provides microsecond read latency. Amazon DynamoDB Accelerator (DAX) is an in-memory cache that sits between your application and DynamoDB, providing microsecond response times for read-heavy workloads. It achieves this by caching frequently accessed data in memory, reducing the latency from single-digit milliseconds to microseconds for eventually consistent reads.

Answer

Improves write throughput

Answer

Provides data durability across Availability Zones

Answer

Reduces storage costs

Question 13

Which THREE of the following are valid storage classes in Amazon S3? (Choose THREE.)

Accepted Answer

S3 Standard. S3 Standard is a valid storage class designed for frequently accessed data with low latency and high throughput. It offers 99.999999999% durability and 99.99% availability, making it suitable for a wide range of use cases like cloud applications, dynamic websites, and content distribution.

Answer

S3 Archive

Answer

S3 Cold

Question 14

Which TWO of the following are best practices for Amazon Redshift table design? (Choose TWO.)

Accepted Answer

Choose sort keys based on query patterns. Options B and D are correct. Using sort keys for query performance and distribution keys for data distribution are best practices. Option A is wrong because compression encoding should be applied, not avoided. Option C is wrong because COPY is the preferred method. Option E is wrong because distribution keys should be chosen carefully, not set to ALL by default.

Answer

Use INSERT statements for large data loads

Answer

Avoid compression encoding to reduce CPU overhead

Answer

Set distribution style to ALL for all tables

Question 15

A company is using Amazon S3 to store sensitive data. To meet compliance requirements, they need to automatically transition objects to S3 Glacier Deep Archive after 90 days and delete them after 7 years. What is the MOST cost-effective way to configure this?

Accepted Answer

Configure an S3 Lifecycle policy to transition objects to Glacier Deep Archive after 90 days and expire them after 7 years.. Option C is correct because a lifecycle policy can transition objects based on age and delete them after a specified period. Option A is wrong because manual deletion is error-prone and not automated. Option B is wrong because S3 Intelligent-Tiering does not delete objects. Option D is wrong because S3 Object Lock is for retention, not lifecycle management.

Answer

Manually move objects to Glacier Deep Archive and delete them using a script.

Answer

Use S3 Intelligent-Tiering to automatically move objects to Glacier Deep Archive and set expiration.

Answer

Enable S3 Object Lock with a retention period of 7 years and use a lifecycle policy to transition to Glacier Deep Archive.

DEA-C01 Data Store Management Practice Test 18 — 15 Questions

Exhibit

DEA-C01 Data Store Management Practice Test 18 — 15 Questions

Exhibit