Google Exam Associate Data Practitioner Topic 1 Question 4 Discussion

Actual exam question for Google's Associate Data Practitioner exam

Question #: 4
Topic #: 1

[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?

A1. Online transactions: Cloud Storage
2. Customer feedback: Cloud Storage
3. Social media activity: Cloud Storage

B1. Online transactions: BigQuery
2. Customer feedback: Cloud Storage
3. Social media activity: BigQuery

C1. Online transactions: Bigtable
2. Customer feedback: Cloud Storage
3. Social media activity: CloudSQL for MySQL

D1. Online transactions: Cloud SQL for MySQL
2. Customer feedback: BigQuery
3. Social media activity: Cloud Storage

Show Suggested 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 Aretha at Jan 26, 2025, 11:41 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Huey

4 months ago

I'm feeling a bit like a data detective here, trying to crack the case of the best storage solution. Option B is my pick - it's the data pipeline equivalent of Sherlock Holmes solving a mystery!

upvoted 0 times

...

Maxima

4 months ago

Woah, hold on a second! Why are we even considering Bigtable? That's overkill for this use case. I'd go with option B, it's the most straightforward and efficient choice.

upvoted 0 times

Annelle

3 months ago

Buck: Option B it is then, simple and efficient.

upvoted 0 times

...

Krystal

3 months ago

User 3: Cloud Storage for customer feedback makes sense too.

upvoted 0 times

...

Buck

3 months ago

User 2: Yeah, option B with BigQuery for online transactions and social media activity is the way to go.

upvoted 0 times

...

King

4 months ago

User 1: I agree, Bigtable seems unnecessary for this.

upvoted 0 times

...

Iesha

4 months ago

I prefer option D because using Cloud SQL for MySQL for online transactions seems more secure and reliable.

upvoted 0 times

...

Krystina

4 months ago

I disagree, I believe option B is better as BigQuery can handle large datasets more efficiently.

upvoted 0 times

...

Graciela

4 months ago

I think option A is the best choice because all data can be stored in Cloud Storage for further analysis.

upvoted 0 times

...

Alex

4 months ago

Option D looks good to me. Cloud SQL for the online transactions, BigQuery for the customer feedback, and Cloud Storage for the social media activity. Seems like a well-rounded solution.

upvoted 0 times

Leatha

3 months ago

Cloud Storage is perfect for storing and accessing unstructured data from social media activity.

upvoted 0 times

...

Samira

3 months ago

BigQuery is great for analyzing large datasets like customer feedback.

upvoted 0 times

...

Jenifer

3 months ago

I agree, using Cloud SQL for online transactions makes sense for structured data.

upvoted 0 times

...

Louis

4 months ago

Option D looks good to me. Cloud SQL for the online transactions, BigQuery for the customer feedback, and Cloud Storage for the social media activity. Seems like a well-rounded solution.

upvoted 0 times

...

Kate

4 months ago

I agree, that combination covers all the different types of data sources effectively.

upvoted 0 times

...

Dawne

4 months ago

Option D looks good to me. Cloud SQL for the online transactions, BigQuery for the customer feedback, and Cloud Storage for the social media activity. Seems like a well-rounded solution.

upvoted 0 times

...

Annita

5 months ago

I think option B is the way to go. BigQuery is great for handling large datasets like online transactions and social media activity, while Cloud Storage is perfect for the customer feedback.

upvoted 0 times

Clarinda

4 months ago

Cloud Storage is reliable for storing customer feedback data.

upvoted 0 times

...

Earlean

4 months ago

I agree, BigQuery is definitely powerful for analyzing large datasets.

upvoted 0 times

...