Google Associate Data Practitioner Exam - Topic 3 Question 21 Discussion

Actual exam question for Google's Associate Data Practitioner exam

Question #: 21
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?

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 Erasmo at Mar 05, 2026, 02:35 AM

Limited Time Offer

25%

27 days ago

I remember we discussed how BigQuery is great for analyzing large datasets, especially for online transactions.

upvoted 0 times

...