Google Cloud Professional Data Engineer PDE — Topic 1 Question 283

Question

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?

Accepted Answer

Correct answer: C. The correct answer is C. Option C: Upgrade the external table to a BigLake table. Enable metadata caching for the table.

Google Cloud Professional Data Engineer PDE — Question 283