Answer-first summary for fast verification
Answer: Use AWS Glue to create a data catalog that connects to the data sources using JDBC and ODBC drivers, and use Glue jobs to perform data integration tasks.
Option C is the most suitable choice for this scenario. AWS Glue is a fully managed ETL service that can connect to various data sources using JDBC and ODBC drivers. By creating a data catalog, you can centralize metadata management and ensure efficient data integration. Glue jobs can be used to perform the actual data integration tasks, and you can leverage Glue's security features, such as encryption and access control, to ensure the process is secure.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are working on a data integration project that requires connecting to multiple data sources, including relational databases and NoSQL databases. Which AWS service would you use to establish connections to these data sources, and how would you ensure the integration process is efficient and secure?
A
Use Amazon EKS to deploy a containerized application that connects to the data sources using JDBC and ODBC drivers.
B
Use Amazon ECS to run a containerized application that uses AWS SDKs to connect to the data sources and perform data integration tasks.
C
Use AWS Glue to create a data catalog that connects to the data sources using JDBC and ODBC drivers, and use Glue jobs to perform data integration tasks.
D
Use AWS Lambda to create functions that connect to the data sources using AWS SDKs, and use Step Functions to orchestrate the integration process.
No comments yet.