ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Data Engineer All Questions

View all questions & answers for the Professional Data Engineer exam
Go to Exam

Exam Professional Data Engineer topic 1 question 283 discussion

Actual exam question from Google's Professional Data Engineer
Question #: 283
Topic #: 1
[All Professional Data Engineer Questions]

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?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by GCP001 at Jan. 7, 2024, 4:17 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
raaad
Highly Voted 9 months, 3 weeks ago
Selected Answer: 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.
upvoted 8 times
AllenChen123
9 months, 1 week ago
Agree. https://cloud.google.com/bigquery/docs/biglake-intro#metadata_caching_for_performance
upvoted 4 times
AllenChen123
9 months, 1 week ago
And https://cloud.google.com/bigquery/docs/external-data-cloud-storage#upgrade-external-tables-to-biglake-tables
upvoted 5 times
...
...
...
hanoverquay
Most Recent 7 months, 2 weeks ago
Selected Answer: C
vote C
upvoted 1 times
...
JyoGCP
8 months, 1 week ago
Selected Answer: C
Option C
upvoted 1 times
...
Matt_108
9 months, 2 weeks ago
Selected Answer: C
Option C
upvoted 1 times
...
Sofiia98
9 months, 3 weeks ago
Selected Answer: C
agree with C
upvoted 1 times
...
GCP001
9 months, 3 weeks ago
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
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago