AWS Certified Data Analytics – Specialty — Question 144

A data analyst runs a large number of data manipulation language (DML) queries by using Amazon Athena with the JDBC driver. Recently, a query failed after it ran for 30 minutes. The query returned the following message: java.sql.SQLException: Query timeout
The data analyst does not immediately need the query results. However, the data analyst needs a long-term solution for this problem.
Which solution will meet these requirements?

Answer options

• A. Split the query into smaller queries to search smaller subsets of data
• B. In the settings for Athena, adjust the DML query timeout limit
• C. In the Service Quotas console, request an increase for the DML query timeout
• D. Save the tables as compressed .csv files

Correct answer: C

Explanation

The correct answer is C because requesting an increase in the DML query timeout through the Service Quotas console directly addresses the problem of query timeouts for long-running queries. Option A, while potentially helping, does not provide a long-term solution. Option B changes the settings only for the current environment and may not address systemic issues, while option D does not relate to query timeout issues.