AWS Certified Data Engineer Associate DEA-C01 Practice Question
A company must catalog tables in an on-premises PostgreSQL database reachable through AWS Direct Connect into a dedicated VPC. Database credentials are in AWS Secrets Manager. The data engineer will configure an AWS Glue crawler that runs as a managed service without launching additional compute resources. Which configuration enables the crawler to connect?
Launch an AWS Glue development endpoint inside the VPC, establish an SSH tunnel to the database, and direct the crawler to use the endpoint.
Provision an AWS Database Migration Service replication instance with a source endpoint for the database and have the crawler connect through the DMS endpoint.
Define an S3 connection in AWS Glue, upload the PostgreSQL JDBC driver to the bucket, and assign this connection to the crawler.
Create an AWS Glue connection of type JDBC that specifies the database's JDBC URL, references the Secrets Manager secret, and selects a private subnet and security group in the same VPC.
The crawler can reach a JDBC data store only through an AWS Glue connection of type JDBC. When the connection is created, you supply the JDBC URL, reference a Secrets Manager secret for the user name and password, and select a VPC, subnet, and security group that have network access to the target database. At run time, Glue automatically deploys an elastic network interface in the specified subnet; no additional endpoints or servers are needed. The other options either use the wrong connection type, add unnecessary infrastructure, or rely on services (DMS, dev endpoints) that Glue crawlers cannot use as JDBC targets.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is an AWS Glue connection of type JDBC?
Open an interactive chat with Bash
Why is AWS Secrets Manager used in this setup?
Open an interactive chat with Bash
How does AWS Glue use a VPC, subnet, and security group to connect to an on-premises database?
Open an interactive chat with Bash
AWS Certified Data Engineer Associate DEA-C01
Data Store Management
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .