In Unity catalog part we have this question:
A data engineer needs to copy an external table from their default Hive metastore to the Unity Catalog metastore.
Which of the following are required to upgrade the table to be managed by Unity Catalog? Select three responses.
- The data engineer must have workspace administrator level privileges.
- The data engineer must be granted CREATE EXTERNAL TABLE permission on the external location of the table to be upgraded.
- The data engineer must create their own Hive metastore.
- The data engineer must have the file path to an external location that references the storage credential.
- The data engineer must have a storage credential with an IAM role that authorizes Unity Catalog to access the tables’ location path.
1st, 3rd and 5th responses are the correct ones accoring to the correction,
why ? do we need to create our own hive metastore and have administrator privliges to do that ?
Can we have two hive metastore ?
Thank you !