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?
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.
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."
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
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
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.
https://docs.aws.amazon.com/athena/latest/ug/notebooks-spark-getting-started.html
https://docs.aws.amazon.com/athena/latest/ug/notebooks-spark.html
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.
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.