Crucial Exams

AWS Certified Data Engineer Associate DEA-C01 Practice Question

A data engineer needs an AWS Glue crawler to ingest and catalog tables that reside in an Amazon RDS for MySQL database located in a private subnet. The solution must avoid hard-coding credentials and should require the least manual work once configured. Which approach enables the crawler to connect to the database and populate the AWS Glue Data Catalog?

  • Enable the Amazon RDS Data API on the instance and provide the API endpoint to the crawler so it can enumerate tables through the Data API.

  • Attach an IAM role that grants the crawler access to the RDS instance; Glue crawlers will log in to the database automatically without a connection.

  • Create an AWS Glue connection of type JDBC that points to the RDS endpoint, reference credentials stored in AWS Secrets Manager, specify the VPC subnet and security group in the connection, and select this connection when configuring the crawler.

  • Export the RDS database snapshot to Amazon S3 and direct the crawler to the exported files so no network connection to the database is required.

AWS Certified Data Engineer Associate DEA-C01
Data Store Management
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot