Get Your CertDEA-C01PlayCompete
‹ All DEA-C01 questions

DEA-C01 Practice Question 96: Glue Data Catalog Hive Metastore

AWS Certified Data Engineer – Associate (DEA-C01) · Test 10 · question 6 of 10

Data Store Managementeasy

A team runs transient Amazon EMR clusters that are created for each job and terminated afterward. Hive table definitions created on one cluster are lost when it terminates, and analysts also want to query the same tables from Amazon Athena. Which change solves both problems?

Select one answer
Show answer and explanation

Answer:

  • C. Configure Hive on the clusters to use the AWS Glue Data Catalog as its metastore.

AWS recommends using the Glue Data Catalog as the Hive metastore *"when you require a persistent metastore or a metastore shared by different clusters, services, applications, or AWS accounts."* The Data Catalog *"provides a unified metadata repository across a variety of data sources and data formats, integrating with Amazon EMR as well as Amazon RDS, Amazon Redshift, Redshift Spectrum, Athena, and any application compatible with the Apache Hive metastore"* (option C). Table definitions survive cluster termination and are visible to Athena.

- A is wrong because HDFS on the primary node disappears when the cluster terminates, and other services cannot read it. - B is wrong because re-running scripts recreates definitions on every start but does not create a shared catalog that Athena can use, and it can drift from the actual tables. - D is wrong because a custom DynamoDB table is not a Hive metastore, so neither Hive nor Athena would read schemas from it without custom integration.

Reference: Using the AWS Glue Data Catalog as the metastore for Hive

Practice Test 10 ›

Study guides for DEA-C01

AWS Developer Associate exam guide: DVA-C02 to DVA-C03AWS Developer Associate exam: DVA-C02 ends 30 November 2026 and DVA-C03 starts 1 December. What changes, which to sit, format, price and study plan.
How AWS Certification Exams Work: Scoring and RenewalHow AWS certification exams work: levels, booking, question types, unscored questions, scaled scores, pass marks, validity and how recertification works.
What Is Amazon RDS? Multi-AZ, Read Replicas and BackupsWhat is Amazon RDS? Engines, Multi-AZ, read replicas, backups, RDS Proxy, Aurora and pricing explained, with the traps that AWS exams set around each one.
Microsoft Fabric certification: DP-700 vs DP-600Microsoft Fabric certification means two exams, DP-600 and DP-700. Their roles, skills, format, cost in India, and which one to take first.
Databricks Data Engineer Associate vs AWS DEA-C01Databricks Data Engineer Associate vs AWS Certified Data Engineer – Associate - format, cost, topics and which one to take for your job, as of 2026.
Which AWS certification should you get? 2026 roadmapWhich AWS certification to get first, by role and experience, with each exam's status in October 2026, what is changing, and prices in USD and INR.
What Is AWS Glue? Data Catalog, Crawlers and ETL JobsWhat is AWS Glue? The Data Catalog, crawlers, ETL jobs and DPUs, workflows, streaming, job bookmarks, Flex and Data Quality, plus the traps AWS exams set.