Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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.