Question 298 of 307
Single answerYou have created an external table for Apache Hive partitioned data that resides in a Cloud Storage bucket, which contains a large number of files. You notice that queries against this table are slow. You want to improve the performance of these queries. What should you do?
AChange the storage class of the Hive partitioned data objects from Coldline to Standard.
BCreate an individual external table for each Hive partition by using a common table name prefix. Use wildcard table queries to reference the partitioned data.
✓CUpgrade the external table to a BigLake table. Enable metadata caching for the table.
DMigrate the Hive partitioned data objects to a multi-region Cloud Storage bucket.
✓
Correct Answer: C
Upgrade the external table to a BigLake table. Enable metadata caching for the table.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.