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.
Which service is best for automating infrastructure deployment?
AAWS CloudFormation
BAWS Elastic Beanstalk
CAWS CodeDeploy
DAWS Lambda
Explanation
AWS CloudFormation allows for automated infrastructure deployment via templates; others are for different purposes.
Q242
A company needs a highly available database setup. What should they use?
ARDS with Multi-AZ
BS3 with versioning
CDynamoDB
DEFS for shared files
Explanation
RDS with Multi-AZ provides a redundant, highly available setup, unlike the other options.
Q243
What happens when an IAM user is deleted?
AAll associated resources are deleted
BUser's permissions are deactivated
CAccess keys become invalid
DUser can log in again later
Explanation
Access keys become invalid when the IAM user is deleted; other options are incorrect as they misunderstand permissions and resource management.
Q244
Which service provides a managed NoSQL database in AWS?
ADynamoDB
BRDS
CS3
DRedshift
Explanation
DynamoDB is AWS's managed NoSQL database; RDS is for SQL, S3 is storage, and Redshift is data warehousing.
Q245
A company needs to transform streaming data before analyzing it. Which service should they use?
AAWS Glue
BAmazon Redshift
CKinesis Data Firehose
DS3 Batch Operations
Explanation
Kinesis Data Firehose can transform streaming data in real-time; AWS Glue is for batch jobs, Redshift is for storage, and S3 is for object storage.
Q246
What happens when a user is assigned two IAM policies that have conflicting permissions?
AOne policy overrides the other
BPermissions are both applied
CDeny takes precedence over allow
DUser cannot access any resources
Explanation
In IAM, a deny permission always overrides allow permissions; options A and B are incorrect, and D is too extreme.
Q247
Which AWS service simplifies data archiving?
AS3 Glacier
BAWS Lambda
CAWS Step Functions
DAmazon RDS
Explanation
S3 Glacier is designed specifically for archiving data, while the others serve different purposes.
Q248
A company needs to analyze data with machine learning. Which service should they use?
AAmazon Redshift
BAWS Glue
CAmazon SageMaker
DAmazon CloudFront
Explanation
Amazon SageMaker is specifically built for machine learning tasks, unlike the other options.
Q249
What happens when a security group is deleted?
AInstances lose their original settings
BRules are permanently removed now
CFurther traffic is automatically allowed
DNetwork access remains unchanged
Explanation
Deleting a security group permanently removes its rules, affecting associated instances, while other options are incorrect interpretations.
Q250
Which service provides serverless compute for backend processes?
AAWS Lambda
BAmazon EC2
CAmazon RDS
DAWS CloudFormation
Explanation
AWS Lambda allows running code without provisioning servers, while EC2 is a managed server, RDS is for databases, and CloudFormation is for provisioning resources.