A company currently uses Athena CTAS SQL to perform ETL tasks but must switch to Apache Spark for analytics. Which feature will allow the company to use Spark to access Athena?
Choose an answer
Tap an option to check your answer.
Correct answer: Athena workgroup.
Why this is the answer
An Athena workgroup is the correct feature because it allows you to manage query execution, control costs, and define data sources for Athena. By configuring a workgroup, you can specify the data catalog and query engine settings that Spark can then leverage to interact with Athena tables. This enables Spark to read data from and write data to Athena, facilitating the transition of ETL tasks. Athena query settings are part of a workgroup but not the overarching feature. Athena data source refers to the underlying data location (e.g., S3), not the integration mechanism. Athena query editor is a UI tool for writing and running queries, not for programmatic integration with Spark.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed