A team is building an EMR Cluster and also wants to install Hive as an application on the EMR cluster. They need the hive metastore to persist even after the EMR Cluster is terminated. Which of the following can help fulfil this requirement? Choose 2 answers from the options given below

Answer options:

A.Create a MySQL RDS database to store the metastore records
B.Create a DynamoDB table to store the metastore records
C.Modify the JDBC configuration in the hive-site.xml file in the configuration for the cluster
D.Modify the JDBC configuration in the Hue configuration setup

Answer – A and C
The AWS Documentation mentions the following
By default, Hive records metastore information in a MySQL database on the master node`s file system. The metastore contains a description of the table and the underlying data on which it is built, including the partition names, data types, and so on. When a cluster terminates, all cluster nodes shut down, including the master node. When this happens, local data is lost because node file systems use ephemeral storage. If you need the metastore to persist, you must create an external metastore that exists outside the cluster.
You have two options for an external metastore:
AWS Glue Data Catalog (Amazon EMR version 5.8.0 or later only).
Amazon RDS or Amazon Aurora.
For more information on hive metastore, please refer to the below URL
https://docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-metastore-external-hive.html