Amazon AWS
AWS Certified Data Engineer – Associate
DEA-C01
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.
Questions 341–350 of 498
A company needs to automatically scale its EC2 instances based on demand. Which service should they use?
A
Amazon Elastic Load Balancing
B
AWS Auto Scaling
C
Amazon CloudFront
D
AWS Lambda
AWS Auto Scaling adjusts the number of EC2 instances based on usage, unlike the other options.
You are configuring an IAM role with an S3 policy. What happens if the trust policy does not allow the assumed role?
A
Role assumption still occurs
B
Access to S3 is denied
C
Assumption fails with an error
D
Policies will override the trust policy
If the trust policy doesn't allow it, the role cannot be assumed, resulting in an error.
Which service enables you to run SQL queries on data in Amazon S3 without loading it?
A
Amazon Athena
B
Amazon RDS
C
AWS Lambda
D
Amazon Redshift
Amazon Athena allows direct querying of S3 data; others require data loading or are not querying services.
A company needs to secure sensitive data in transit and at rest in S3. Which features should they use together?
A
S3 Versioning and CloudWatch
B
Server-Side Encryption and SSL/TLS
C
Data Lifecycle Policies and Cross-Region Replication
D
IAM Policies and AWS Config
Server-Side Encryption secures data at rest, while SSL/TLS secures it in transit; others do not cover both aspects.
You are configuring a Data Pipeline that connects to an RDS instance, but it fails to access the database. What is the most likely issue?
A
Data Pipeline settings are incorrect
B
RDS instance is stopped
C
Security Group config is improper
D
Connection String is malformed
Improper Security Group settings might block access; others are less likely causes of connection failure.
Which AWS service is used for data lakes?
A
AWS Lake Formation
B
Amazon RDS
C
Amazon ElastiCache
D
AWS Glue
AWS Lake Formation is specifically designed for data lake management, while RDS and ElastiCache focus on databases and caching.
What happens when you disable an IAM user account?
A
They lose all permissions
B
They retain read access
C
They cannot sign in
D
They still have temporary access
Disabling an IAM user account prevents sign-in, although existing permissions can remain.
A company needs to move data from an S3 bucket to Snowflake. What service can facilitate this?
A
AWS Data Pipeline
B
AWS Glue
C
AWS DMS
D
AWS Lambda
AWS Glue is an ETL service perfect for moving data to Snowflake, while other options are less suitable for direct integration.
Which service is primarily used for data warehousing in AWS?
A
Amazon Redshift
B
Amazon S3
C
Amazon RDS
D
AWS Lambda
Amazon Redshift is designed for data warehousing, while the others serve different purposes.
A company needs real-time data streaming capabilities. Which AWS service should they use?
A
Amazon SQS
B
Amazon Kinesis
C
Amazon Glue
D
Amazon RDS
Amazon Kinesis is built for real-time data streaming, whereas the other services focus on queuing or batch processing.