The AWS Certified Data Engineer – Associate (DEA-C01) exam validates your skills in data engineering on AWS. It is suitable for those who want to demonstrate their ability to design and implement data solutions.
What happens when an AWS CloudFormation stack fails during creation?
AAll resources are created.
BResources get deleted automatically.
CThe stack enters a rollback state.
DNo action is taken.
Explanation
A failed stack creation triggers a rollback to restore the previous state, while options A, B, and D do not occur.
Q292
Which AWS service would you use for real-time stream processing?
AAmazon Kinesis
BAmazon S3
CAWS Lambda
DAmazon RDS
Explanation
Amazon Kinesis is designed specifically for real-time stream processing, while the others serve different purposes.
Q293
You are configuring an S3 bucket policy. What is a principal?
AAn IAM group
BAn AWS service
CAn entity accessing the resource
DA storage tier in S3
Explanation
A principal represents an entity making requests to access resources, while the others do not define an accessing entity.
Q294
A company's data warehouse on Redshift experiences slow query performance. What could be the reason?
AUnderutilized node types
BToo few nodes in the cluster
CUsing Spectrum only
DRead replicas not enabled
Explanation
Too few nodes in the Redshift cluster can lead to slow query performance, while the others do not directly cause such an issue.
Q295
Which AWS service is used for serverless event-driven computing?
AAWS Lambda
BAWS EC2
CAWS RDS
DAWS DynamoDB
Explanation
AWS Lambda is specifically designed for serverless compute, while the others serve different purposes.
Q296
A company needs to run containerized applications. Which service should they use?
AAmazon S3
BAWS ECS
CAWS RDS
DAWS CloudFormation
Explanation
AWS ECS (Elastic Container Service) is designed for managing containers, while the others do not offer this capability.
Q297
What happens when an Amazon S3 bucket policy denies all access?
AAll operations are blocked
BRead operations continue
CWrite operations are still allowed
DOnly specific accounts can access
Explanation
A policy that denies all access blocks every operation, while the other options incorrectly suggest partial or selective access.
Q298
Which service is primarily used for managing a NoSQL database in AWS?
ADynamoDB
BRDS
CRedshift
DS3
Explanation
DynamoDB is designed for NoSQL; RDS supports SQL databases, Redshift is for analytics, and S3 is for storage.
Q299
A company needs a reliable data transfer mechanism between AWS and their on-premises data center. Which AWS service should they use?
AAmazon Direct Connect
BAWS VPN
CAWS Storage Gateway
DAWS Snowball
Explanation
Amazon Direct Connect provides a dedicated link for reliable transfers; VPN is less stable, Storage Gateway is for backup, and Snowball is for bulk transfer.
Q300
What happens when you exceed the read capacity units in DynamoDB?
AThrottling occurs
BData is lost
CCost increases
DQuery results become outdated
Explanation
Throttling limits request rates without data loss; costs do not automatically increase without provisioning changes, and query results remain accurate.