DEA-C01 Question 76

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A1

  AWS Glue Data Catalog: This provides a centralized metadata repository for all data sources, including S3, RDS, DynamoDB, and Redshift. AWS Glue crawlers can automatically infer schemas and populate the Data Catalog, minimizing manual effort. Amazon Athena: Athena allows data scientists to query data directly from S3 using standard SQL. For structured data in RDS and Redshift, SQL can be used. For JSON data in S3 and DynamoDB, Athena supports PartiQL, which is a SQL-compatible query language for semi-structured data. Least Operational Overhead: This approach leverages serverless services like AWS Glue and Amazon Athena, which eliminates the need to provision, manage, or scale servers, significantly reducing operational overhead compared to solutions involving managed clusters or data transformations.

• Chose A1

  thena natively supports querying JSON data stored in S3 using standard SQL functions. This eliminates the need for additional data transformation steps using Glue jobs (as required in Option C or D).

• 1

  As chris_spencer mentioned below, now Athena supports querying with PartiQL which technically makes the answer A correct.