Answer – B and C
The AWS Documentation mentions the following
To use an external MySQL database or Amazon Aurora as your Hive metastore, you override the default configuration values for the metastore in Hive to specify the external database location, either on an Amazon RDS MySQL instance or an Amazon Aurora instance.
By default, Hive records metastore information in a MySQL database on the master node`s file system. But 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 RDS or Amazon Aurora.
So to use an external MySQL database as your Hive metastore, you override the default configuration values for the metastore in Hive to specify the external database locationon an Amazon RDS MySQL instance.
Since the way to accomplish this is clearly given in the documentation , all other options are incorrect.
For more information on how to store the Hive metadata, please refer to the below URL
https://aws.amazon.com/premiumsupport/knowledge-center/export-metastore-from-emr-to-rds/