A data engineer is configuring an AWS Glue connection to a PostgreSQL database in a VPC. The database is in a private subnet, and the Glue job runs in the same VPC but in a different subnet. The engineer has configured the connection with the correct VPC, subnet, and security group. However, the job still fails with a connection timeout. What is the most likely missing configuration?

The security group attached to the Glue connection does not allow outbound traffic to the database's security group.

The connection's 'Network options' do not include the database's subnet.

The JDBC URL uses 'localhost' instead of the database's private IP address.

The connection's 'Authentication' is set to 'No authentication', but the database requires a password.

What is the role of the AWS Glue Data Catalog in the AWS data ecosystem?

It is a file system that stores data in S3 for analytics.

It is a data integration service that performs ETL jobs on a schedule.

It is a fully managed data warehouse service used for running SQL queries.

It is a persistent metadata store that holds table definitions and locations for data stored in AWS.

How can you make a dataset stored in Amazon S3 queryable with Amazon Athena?

By directly running a SELECT query on the S3 bucket using Athena.

By copying the data into an Amazon Redshift cluster and querying it there.

By creating a table in the AWS Glue Data Catalog that points to the S3 location.

By creating an AWS Glue ETL job to transform the data into a queryable format.

How does a data catalog enable data consumption from source systems?

By creating direct network connections to each source system for real-time queries.

By physically copying data from source systems into the catalog's storage.

By automatically transforming data into a common format like Parquet for all users.

By providing a unified view of data assets through metadata, allowing users to query them without knowing their physical location.

AWSCertified Data Engineer - Associate

Domain 2Objective 2

Task 2.2: Understand Data Cataloging Systems DEA-C01 Practice Questions (Page 4)

Part of the Content Domain 2: Data Store Management domain, which accounts for 26% of the DEA-C01 exam. AWS does not publish an official question count, but from its 130-minute exam (~50–85 total, ~13–22 in this domain), expect 3–6 from this objective — we provide 22 practice questions to prepare you well beyond it. (estimate)

22questions here

5free pages

7concepts

26%of the exam

Questions 16–20

16expert · medium
A data engineer is configuring an AWS Glue connection to a PostgreSQL database in a VPC. The database is in a private subnet, and the Glue job runs in the same VPC but in a different subnet. The engineer has configured the connection with the correct VPC, subnet, and security group. However, the job still fails with a connection timeout. What is the most likely missing configuration?
Select an answer first
17foundation · easy
What is the role of the AWS Glue Data Catalog in the AWS data ecosystem?
Select an answer first
18foundation · easy
How can you make a dataset stored in Amazon S3 queryable with Amazon Athena?
Select an answer first
19foundation · easy
How does a data catalog enable data consumption from source systems?
Select an answer first
20foundation · easy
Which AWS Glue component is responsible for automatically discovering the schema of data stored in Amazon S3?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DEA-C01

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by AWS. “DEA-C01” is a trademark of its owner, used for identification only.

Task 2.2: Understand Data Cataloging Systems DEA-C01 Practice Questions (Page 4)

Questions 16–20

What is the role of the AWS Glue Data Catalog in the AWS data ecosystem?

How can you make a dataset stored in Amazon S3 queryable with Amazon Athena?

How does a data catalog enable data consumption from source systems?

Which AWS Glue component is responsible for automatically discovering the schema of data stored in Amazon S3?

Keep studying — Content Domain 2: Data Store Management