
Ultimate access to all questions.
You have set up an external table in Apache Hive for partitioned data stored in a Cloud Storage bucket, which contains a significant volume of files. However, you observe that the queries executed on this table are performing slowly. In order to enhance the query performance, what actions should you take?
A
Change the storage class of the Hive partitioned data objects from Coldline to Standard.
B
Create an individual external table for each Hive partition by using a common table name prefix. Use wildcard table queries to reference the partitioned data.
C
Upgrade the external table to a BigLake table. Enable metadata caching for the table.
D
Migrate the Hive partitioned data objects to a multi-region Cloud Storage bucket.