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.
A company needs to quickly provision a temporary database for testing. Which AWS service should they use?
AAmazon RDS
BAmazon DynamoDB
CAmazon Aurora
DAmazon Redshift
Explanation
Amazon RDS allows for rapid database provisioning and supports temporary instances for testing; others focus on either OLAP or specific use cases.
Q492
What happens when an IAM policy denies access to a specific action?
AAccess is granted if allowed elsewhere
BAccess is denied regardless of others
CAccess is checked only by resources
DAccess can default to full permission
Explanation
In AWS IAM, explicit deny overrides all allows; this ensures tight control over resource access.
Q493
A company needs to migrate a large dataset to AWS. Which service provides a fast and secure way to transfer data at scale?
AAWS Snowball
BAmazon S3
CAWS Glue
DAmazon RDS
Explanation
AWS Snowball is designed for large-scale data transfer, while the others focus on storage or database management.
Q494
You are configuring a Data Pipeline to process data in an S3 bucket daily. What happens if your pipeline fails?
AIt automatically retries the job.
BIt permanently deletes all data.
CIt logs errors but stops.
DIt triggers an alarm to notify you.
Explanation
Data Pipeline can trigger SNS notifications for failures while not automatically deleting or always retrying jobs.
Q495
Which AWS service provides a fully managed data warehouse solution that can scale and handle large analytics workloads?
AAmazon S3
BAWS Redshift
CAWS Lambda
DAmazon Aurora
Explanation
AWS Redshift is specifically designed for data warehousing, while others focus on different aspects of data handling.
Q496
Which AWS service is used to manage permissions and users?
AIAM
BEC2
CS3
DLambda
Explanation
IAM manages permissions; EC2 and S3 are compute/storage services but do not manage users.
Q497
A company needs to store large volumes of data with high durability. Which AWS service is best suited?
AEFS
BS3
CDynamoDB
DRDS
Explanation
S3 offers high durability for large data volumes; EFS is for file storage, not durability at scale.
Q498
What happens when you disable versioning on an S3 bucket?
AAll objects are deleted.
BNew versions are not created.
CPrevious versions are lost.
DOnly metadata is removed.
Explanation
Disabling versioning stops creating new versions, but does not remove existing ones; options A, C, D are incorrect as they misrepresent the behavior.