DEA-C01 Exam QuestionsBrowse all questions from this exam

DEA-C01 Exam - Question 45


A company uses Amazon Athena to run SQL queries for extract, transform, and load (ETL) tasks by using Create Table As Select (CTAS). The company must use Apache Spark instead of SQL to generate analytics.

Which solution will give the company the ability to use Spark to access Athena?

Show Answer
Correct Answer: B

To use Apache Spark in Amazon Athena, you need to create an Amazon Athena workgroup that is configured to use the Spark engine. This setup enables Spark to access and interact with the data managed by Athena, thereby allowing for the execution of Spark-based analytics and ETL tasks.

Discussion

8 comments
Sign in to comment
GiorgioGssOption: B
Mar 19, 2024

https://docs.aws.amazon.com/athena/latest/ug/notebooks-spark-getting-started.html "To use Apache Spark in Amazon Athena, you create an Amazon Athena workgroup that uses a Spark engine."

damaldon
Mar 6, 2024

B. is the correct answer. To use Apache Spark in Amazon Athena, you create an Amazon Athena workgroup that uses a Spark engine. https://docs.aws.amazon.com/athena/latest/ug/notebooks-spark-getting-started.html

rralucard_Option: C
Feb 2, 2024

https://docs.aws.amazon.com/athena/latest/ug/notebooks-spark.html

blackgamerOption: B
Mar 30, 2024

https://docs.aws.amazon.com/athena/latest/ug/notebooks-spark-getting-started.html

lalitjhawar
May 28, 2024

C. Athena data source The Athena data source is a specific connector or library that allows Apache Spark to interact with data stored in Amazon Athena. This connector enables Spark to read data from Athena tables directly into Spark DataFrames or RDDs (Resilient Distributed Datasets), allowing you to perform analytics and transformations using Spark's capabilities.

pypelyncarOption: C
Jun 10, 2024

The Athena data source acts as a bridge between Athena and other analytics engines, such as Apache Spark. By using the Athena data source connector, you can access data stored in various formats (e.g., CSV, JSON, Parquet) and locations (e.g., Amazon S3, Apache Hive Metastore) through Spark applications

kj07
Mar 14, 2024

B is the correct answer. https://aws.amazon.com/blogs/big-data/explore-your-data-lake-using-amazon-athena-for-apache-spark/ You need an Athena workgroup as a prerequisite to use Apache Spark.

androloginOption: B
Jul 11, 2024

https://docs.aws.amazon.com/athena/latest/ug/notebooks-spark-getting-started.html To get started with Apache Spark on Amazon Athena, you must first create a Spark enabled workgroup. After you switch to the workgroup, you can create a notebook or open an existing notebook. When you open a notebook in Athena, a new session is started for it automatically and you can work with it directly in the Athena notebook editor.