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
Mob_nav_barsMENU

Google Associate Data Practitioner Exam - Topic 3 Question 13 Discussion

Actual exam question for Google's Associate Data Practitioner exam
Question #: 13
Topic #: 3
[All Associate Data Practitioner Questions]

Your retail company collects customer data from various sources:

You are designing a data pipeline to extract this dat

a. Which Google Cloud storage system(s) should you select for further analysis and ML model training?

Show Suggested Answer Hide Answer
Suggested Answer: B

Online transactions: Storing the transactional data in BigQuery is ideal because BigQuery is a serverless data warehouse optimized for querying and analyzing structured data at scale. It supports SQL queries and is suitable for structured transactional data.

Customer feedback: Storing customer feedback in Cloud Storage is appropriate as it allows you to store unstructured text files reliably and at a low cost. Cloud Storage also integrates well with data processing and ML tools for further analysis.

Social media activity: Storing real-time social media activity in BigQuery is optimal because BigQuery supports streaming inserts, enabling real-time ingestion and analysis of data. This allows immediate analysis and integration into dashboards or ML pipelines.


by Amie at Jul 03, 2025, 11:58 AM

Limited Time Offer

25%

Off

Get Premium Associate Data Practitioner Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Rolland
4 days ago
I practiced a similar question where we had to choose between Cloud SQL and BigQuery for structured data. I think it depends on the use case.
upvoted 0 times
...
Dulce
10 days ago
I’m not sure if Cloud Storage is the best choice for everything. I think BigQuery might be more efficient for customer feedback analysis.
upvoted 0 times
...
Ming
15 days ago
I remember we discussed how BigQuery is great for analyzing large datasets, especially for online transactions.
upvoted 0 times
...
Johnna
21 days ago
This is a tricky one. There are a lot of factors to consider, like the volume, velocity, and variety of the data sources. I'll need to carefully evaluate the trade-offs between the different storage options to determine the best fit for each data type. Hopefully, I can come up with a solid solution.
upvoted 0 times
...
Ma
26 days ago
Okay, I think I've got a good strategy for this. Online transactions likely need the high performance and scalability of BigQuery, while customer feedback and social media activity could be well-suited for Cloud Storage. I'll double-check the details, but I'm feeling confident about this approach.
upvoted 0 times
...
Tamra
1 month ago
Hmm, I'm a bit unsure about this one. There are a lot of storage options to choose from, and I want to make sure I pick the right ones for each data source. I'll need to review the key features and capabilities of Cloud Storage, BigQuery, Bigtable, and Cloud SQL to make an informed decision.
upvoted 0 times
...
Na
1 month ago
This seems like a straightforward question about choosing the right Google Cloud storage options for different types of customer data. I'll need to carefully consider the characteristics and use cases of each storage option to determine the best fit.
upvoted 0 times
...
Mari
3 months ago
Ah, the age-old debate: SQL or NoSQL? I say, let's go with the one that can handle the most data - BigQuery all the way, baby!
upvoted 0 times
...
Cecil
3 months ago
That makes sense, thanks for explaining.
upvoted 0 times
...
Argelia
3 months ago
I think BigQuery would be more suitable for analyzing customer feedback and social media activity.
upvoted 0 times
...
Cecil
3 months ago
Why do you think that?
upvoted 0 times
...
William
3 months ago
Hold up, why are we using Cloud SQL for MySQL for social media data? Isn't that a bit overkill? BigQuery or Cloud Storage would be a better fit, I reckon.
upvoted 0 times
Delsie
2 months ago
I think we should reconsider our choice and go with either BigQuery or Cloud Storage for social media activity.
upvoted 0 times
...
Maile
2 months ago
BigQuery or Cloud Storage would definitely be a better fit for that type of data.
upvoted 0 times
...
Rosalind
2 months ago
I agree, using Cloud SQL for MySQL for social media data does seem like overkill.
upvoted 0 times
...
...
Argelia
4 months ago
I disagree, I believe option B is the best choice.
upvoted 0 times
...
Buck
4 months ago
Hmm, I'm not sure about Bigtable for online transactions. Isn't that more for time-series data? I'd go with Cloud SQL for that.
upvoted 0 times
Alise
3 months ago
Yeah, Cloud SQL would probably provide better performance and scalability for handling online transaction data.
upvoted 0 times
...
Sherill
3 months ago
I agree, Bigtable might not be the best choice for online transactions. Cloud SQL seems more suitable for that.
upvoted 0 times
...
...
Rosalyn
4 months ago
I think option B is the way to go. BigQuery for online transactions and social media data, and Cloud Storage for customer feedback. Seems like a good mix of managed services.
upvoted 0 times
Antonette
2 months ago
User 2: Cloud Storage is also reliable for storing customer feedback data.
upvoted 0 times
...
Jessenia
3 months ago
User 1: I agree, BigQuery is great for analyzing large datasets quickly.
upvoted 0 times
...
...
Cecil
4 months ago
I think we should go with option A.
upvoted 0 times
...

Save Cancel