Explanation:
The correct answer is C. Upgrading the external table to a BigLake table and enabling metadata caching is the most effective way to improve query performance for Apache Hive partitioned data in a Cloud Storage bucket. BigLake tables handle large datasets more efficiently than standard external tables, and metadata caching reduces the time taken to read and process metadata from a large number of files, thus significantly improving query performance.
Ultimate access to all questions.
No comments yet.
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.