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 store sensitive data securely. Which AWS service should they use?
AAmazon RDS
BAWS IAM
CAWS Secrets Manager
DAmazon CloudFront
Explanation
AWS Secrets Manager is designed to securely store confidential information, while RDS is for database management, IAM handles permissions, and CloudFront is a CDN.
Q312
You are configuring an AWS Lambda function with a 25-second long execution time. What happens if it exceeds this limit?
AFunction continues processing until it finishes
BFunction is terminated and returns an error
CFunction automatically retries execution
DFunction runs forever until stopped
Explanation
AWS Lambda has a maximum timeout limit; exceeding it causes immediate termination and an error, while the other options are incorrect.
Q313
Which service is used for data warehousing in AWS?
AAmazon Redshift
BAmazon RDS
CAmazon DynamoDB
DAmazon S3
Explanation
Amazon Redshift is specifically designed for data warehousing, while the others serve different database purposes.
Q314
A company needs to optimize its SQL queries on Amazon RDS. What can be used?
AAmazon CloudWatch
BAWS Lambda
CAmazon Aurora
DAWS DMS
Explanation
Amazon Aurora provides advanced optimizations; the others do not directly optimize SQL queries.
Q315
What happens when you delete an AWS Glue job?
AJob becomes inactive
BData is lost
CJob parameters are retained
DJob cannot be recreated
Explanation
AWS Glue job parameters are retained and can be recreated; deletion only affects job execution.
Q316
Which AWS service is primarily used for serverless compute?
AAWS Lambda
BAmazon EC2
CAWS Fargate
DAmazon RDS
Explanation
AWS Lambda allows you to run code without provisioning servers, while the rest involve managing infrastructure.
Q317
A company needs to process streaming data with low latency and autoscaling. Which service should they use?
AAmazon S3
BAmazon Kinesis
CAWS Glue
DAmazon EMR
Explanation
Amazon Kinesis is designed for real-time data processing, whereas the others are not optimal for low-latency stream processing.
Q318
You are configuring an S3 bucket policy. What happens when you deny permissions to 's3:PutObject'?
AUpload objects is allowed.
BNo uploads are permitted.
COnly public uploads are allowed.
DUpload succeeds under certain conditions.
Explanation
Denying 's3:PutObject' prevents any uploads, regardless of source or conditions.
Q319
Which service provides serverless data processing?
AAWS Glue
BAmazon RDS
CEC2 Instances
DAmazon EMR
Explanation
AWS Glue is specifically designed for ETL processes while other options are not serverless for such tasks.
Q320
A company needs to control access based on multiple conditions. Which service should they use?
AAWS IAM
BAmazon S3
CAWS CloudTrail
DAmazon CloudFront
Explanation
AWS IAM supports granular access control policies, unlike the other options.