AWS Certified Data Engineer Associate · Free Practice Question Medium
Question 3
A financial services company is planning to consolidate various data sources for a centralized analytics platform on AWS. These data sources include a mix of on-premises relational databases and cloud-based storage systems, which must be connected via JDBC and ODBC. The company aims to analyze this data for financial trends and to improve customer service. Which AWS services should the company utilize to facilitate the integration of these data sources via JDBC and ODBC connections? (Select TWO)
- A AWS Glue
-
B
Amazon Redshift
-
C
Amazon Kinesis Data Streams
-
D
Amazon S3
-
E
AWS Direct Connect
Reveal correct answers
Correct answers: A, B
Explanation
AWS Glue - This service is ideal for integrating various data sources as it provides a managed ETL (extract, transform, load) environment that can connect to databases using JDBC. AWS Glue can be used to catalog, clean, enrich, and move data from multiple sources into a centralized repository, making it suitable for the scenario where data needs to be consolidated from different databases and storage systems for analysis.
Amazon Redshift - As a data warehouse, Amazon Redshift allows for complex queries across large datasets and can integrate data from various sources via JDBC and ODBC connections. Redshift supports direct data loading from several sources and can be used to perform deep analytical queries, which are essential for identifying financial trends and customer insights from the consolidated data.
Other Choices:
Amazon S3 - While S3 is a versatile object storage service, it does not directly support JDBC or ODBC connections for data integration. It is typically used as a storage destination rather than a service that facilitates direct integration of data sources via JDBC or ODBC.
Amazon Kinesis Data Streams - Kinesis Data Streams is mainly used for real-time data streaming and would not typically be used for integrating data via JDBC or ODBC. It is better suited for scenarios that require real-time data capture and processing, such as streaming log or event data.
AWS Direct Connect - AWS Direct Connect provides a dedicated network connection from on-premises to AWS, which might be useful for transferring large amounts of data more securely and reliably. However, it does not facilitate the actual integration of data via JDBC or ODBC connections, nor does it involve any direct data processing capabilities.
A. AWS Glue is a fully managed extract, transform, and load (ETL) service that makes it easy to prepare and load data for analytics. It supports JDBC and ODBC connections, making it an ideal choice for integrating various data sources, including on-premises relational databases and cloud-based storage systems, for centralized analytics on AWS.
B. Amazon Redshift is a fully managed data warehouse service that is optimized for analytics. It supports JDBC and ODBC connections, making it a suitable choice for integrating data sources for centralized analytics on AWS. Redshift can handle large volumes of data and is designed for high-performance analytics queries.
C. Amazon Kinesis Data Streams is a platform for streaming data on AWS and is not directly related to facilitating JDBC and ODBC connections for data integration. It is more focused on real-time data processing and analytics rather than integrating data sources via JDBC and ODBC.
D. Amazon S3 is an object storage service that is not directly related to facilitating JDBC and ODBC connections for data integration. While it can be used to store data, it does not provide the necessary functionality for connecting different data sources via JDBC and ODBC.
E. AWS Direct Connect is a service that provides a dedicated network connection between an on-premises data center and AWS. While it can be used to establish a secure and reliable connection between on-premises systems and AWS, it is not specifically designed for facilitating JDBC and ODBC connections for data integration.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
