Topic 1 Question 283
You 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?
Change the storage class of the Hive partitioned data objects from Coldline to Standard.
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.
Upgrade the external table to a BigLake table. Enable metadata caching for the table.
Migrate the Hive partitioned data objects to a multi-region Cloud Storage bucket.
ユーザの投票
コメント(3)
C. Upgrade the external table to a BigLake table. Enable metadata caching for the table. Check ref - https://cloud.google.com/bigquery/docs/biglake-intro
👍 1GCP0012024/01/07- 正解だと思う選択肢: C
- BigLake Table: BigLake allows for more efficient querying of data lakes stored in Cloud Storage. It can handle large datasets more effectively than standard external tables.
- Metadata Caching: Enabling metadata caching can significantly improve query performance by reducing the time taken to read and process metadata from a large number of files.
👍 1raaad2024/01/09 - 正解だと思う選択肢: C
agree with C
👍 1Sofiia982024/01/10
シャッフルモード