Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
You've configured an external table in Apache Hive for partitioned data stored in a Cloud Storage bucket, which contains many files. However, queries on this table are performing slowly. What steps can you take to improve the query performance?
A
Migrate the Hive partitioned data objects to a multi-region Cloud Storage bucket.
B
Change the storage class of the Hive partitioned data objects from Coldline to Standard.
C
Upgrade the external table to a BigLake table. Enable metadata caching for the table.
D
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.
