Connect Business Tools to AWS Athena
Question
A Business Intelligence team have stored their data in S3 and are currently also using AWS Athena.
They want to connect their business tools to AWS Athena.
How can they accomplish this? Choose 2 answers from the options given below.
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D.Answer - A and B.
This is given in the AWS Documentation.
########
Connecting to Amazon Athena with ODBC and JDBC Drivers.
To explore and visualize your data with business intelligence tools, download, install, and configure an ODBC (Open Database Connectivity) or JDBC (Java Database Connectivity) driver.
Topics.
Using Athena with the JDBC Driver.
Connecting to Amazon Athena with ODBC.
########
Since this is clearly mentioned in the documentation, all other options are invalid.
For more information on using BI tools with AWS Athena, please refer to the below URL.
https://docs.aws.amazon.com/athena/latest/ug/athena-bi-tools-jdbc-odbc.htmlThe correct answers are A. Use JDBC drivers and B. Use ODBC Driver.
AWS Athena is a serverless interactive query service that enables users to query data in S3 using standard SQL. Business intelligence (BI) tools like Tableau, Power BI, and QlikView can connect to Athena using JDBC and ODBC drivers.
JDBC (Java Database Connectivity) is a Java API that provides a standard way of connecting to databases. JDBC drivers allow BI tools written in Java to connect to Athena and query data stored in S3. AWS provides a JDBC driver for Athena that can be downloaded and installed on the BI tool's server.
ODBC (Open Database Connectivity) is a standard API that provides a way of connecting to databases using SQL. ODBC drivers allow BI tools written in any programming language that supports ODBC to connect to Athena and query data stored in S3. AWS provides an ODBC driver for Athena that can be downloaded and installed on the BI tool's server.
Using JDBC and ODBC drivers, BI teams can connect their business tools to Athena and query data stored in S3 using standard SQL. This enables them to analyze their data and gain insights that can help them make better business decisions.
