AWS Certified Data Engineer – Associate (DEA-C01) — Question 35

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?

Answer options

• A. Athena query settings
• B. Athena workgroup
• C. Athena data source
• D. Athena query editor

Correct answer: B

Explanation

The correct answer is B, Athena workgroup, as it allows users to manage and configure query execution settings, including integration with Apache Spark. The other options do not provide the necessary infrastructure for Spark to access Athena data, making them unsuitable for this requirement.