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.
You are configuring an S3 bucket policy. What will happen if you specify 'Block Public Access' settings and include 'Allow' statements for public access?
APublic access is still blocked
BPublic access is allowed
CBucket gets deleted automatically
DAccess denied to all users
Explanation
Block Public Access settings override any allow statements to maintain security, while the other options conflict with S3 controls.
Q222
A company needs to securely store API keys in AWS. What is the best practice for this?
AStore in S3 with public access
BUse AWS Secrets Manager
CHard code in the application
DUse EC2 instance metadata
Explanation
AWS Secrets Manager is designed for securely storing sensitive information, while the other options expose credentials to security risks.
Q223
Which service can automatically scale resources up or down based on demand?
AAWS Lambda
BAmazon EC2 Auto Scaling
CAmazon S3
DAWS CloudFormation
Explanation
Amazon EC2 Auto Scaling scales instances automatically; Lambda is event-driven, S3 is storage, and CloudFormation manages infrastructure.
Q224
A company needs to store sensitive data and manage access based on user attributes. Which service should they use?
AAmazon RDS
BAWS IAM
CAmazon DynamoDB
DAWS Lake Formation
Explanation
AWS Lake Formation secures data based on attributes; RDS is relational, IAM manages user access, DynamoDB is a NoSQL database.
Q225
You are configuring a VPC. What happens if the route table is missing a default route?
ATraffic will be rejected
BTraffic will be forwarded to all subnets
CVPC will not operate
DInstances will have no internet access
Explanation
Without a default route, instances won't access the internet; rejected traffic and wrong forwarding options are not accurate.
Q226
What service is best for monitoring AWS resources' health?
AAmazon CloudWatch
BAWS Lambda
CAmazon RDS
DAWS CloudFormation
Explanation
Amazon CloudWatch monitors resource health while others perform different tasks.
Q227
A company needs to migrate its local databases to AWS. Which service should they use for a managed database migration?
AAWS Snowball
BAWS Database Migration Service
CAmazon S3
DAmazon EC2
Explanation
AWS Database Migration Service enables managed database migrations, unlike the others.
Q228
You are configuring an IAM policy. What will happen if you attach a policy with 'Deny' action for a resource?
AAccess denied for that resource
BAccess allowed for that resource
CPolicy becomes ineffective
DRequires admin approval
Explanation
IAM policies with 'Deny' explicitly block access to that resource, while others do not apply.
Q229
Which service allows for data workflow automation in AWS?
AAWS Data Pipeline
BAWS QuickSight
CAWS Glue
DAmazon Athena
Explanation
AWS Glue is specifically designed for data ETL workflows, while the others serve different purposes.
Q230
A company needs to migrate a large dataset while ensuring minimal downtime. What is the best AWS service to use?
AAWS Database Migration Service
BAmazon S3
CAWS Snowball
DAmazon RDS
Explanation
AWS Database Migration Service allows for minimal downtime during migrations, unlike the other options.