Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Professional Data Engineer Exam - Topic 1 Question 32 Discussion

You have a petabyte of analytics data and need to design a storage and processing platform for it. You must be able to perform data warehouse-style analytics on the data in Google Cloud and expose the dataset as files for batch analysis tools in other cloud providers. What should you do?
D) Store the warm data as files in Cloud Storage, and store the active data in BigQuery. Keep this ratio as 80% warm and 20% active.
A) Store and process the entire dataset in BigQuery.
B) Store and process the entire dataset in Cloud Bigtable.
C) Store the full dataset in BigQuery, and store a compressed copy of the data in a Cloud Storage bucket.

Google Professional Data Engineer Exam - Topic 1 Question 32 Discussion

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

You have a petabyte of analytics data and need to design a storage and processing platform for it. You must be able to perform data warehouse-style analytics on the data in Google Cloud and expose the dataset as files for batch analysis tools in other cloud providers. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: D

by Tracey at May 04, 2022, 07:54 PM

Limited Time Offer

25%

Off

Get Premium Professional Data Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Agustin
10 months ago
Wait, can BigQuery really handle a petabyte efficiently?
upvoted 0 times
...
Eladia
10 months ago
80/20 ratio for warm/active data? Seems a bit off.
upvoted 0 times
...
Edmond
11 months ago
Storing in both BigQuery and Cloud Storage sounds smart!
upvoted 0 times
...
Chanel
11 months ago
I think Cloud Bigtable is better for this use case.
upvoted 0 times
...
Alita
11 months ago
BigQuery is great for analytics!
upvoted 0 times
...
Edison
11 months ago
I recall that storing data in both BigQuery and Cloud Storage could be a good strategy, especially for accessing it from other cloud providers.
upvoted 0 times
...
Veda
11 months ago
I’m a bit confused about the difference between Cloud Bigtable and BigQuery for this scenario. I thought Bigtable was more for real-time analytics?
upvoted 0 times
...
Abel
11 months ago
I remember we discussed how BigQuery is great for analytics, but I'm not sure if it can handle the entire petabyte efficiently.
upvoted 0 times
...
Aliza
11 months ago
I think we practiced a similar question where we had to balance storage and processing. I feel like Cloud Storage might be important here for batch analysis.
upvoted 0 times
...
Larue
11 months ago
Based on the question, I think the best format would be MP3. It's a common audio file type that's widely supported.
upvoted 0 times
...
Gary
11 months ago
I'm a little confused by this question. Manually creating an 'Incident Report' seems like a lot of extra work, so I'm going to rule out option B. I'm leaning towards either A or C, but I'll need to review the details of each approach to decide which one is the best fit.
upvoted 0 times
...

Save Cancel