Google Cloud Associate Data Practitioner — Question 55

Your retail company collects customer data from various sources:
Online transactions: Stored in a MySQL database
Customer feedback: Stored as text files on a company server
Social media activity: Streamed in real-time from social media platforms
You are designing a data pipeline to extract this data. Which Google Cloud storage system(s) should you select for further analysis and ML model training?

Answer options

• A. 1. Online transactions: Cloud Storage 2. Customer feedback: Cloud Storage 3. Social media activity: Cloud Storage
• B. 1. Online transactions: BigQuery 2. Customer feedback: Cloud Storage 3. Social media activity: BigQuery
• C. 1. Online transactions: Bigtable 2. Customer feedback: Cloud Storage 3. Social media activity: CloudSQL for MySQL
• D. 1. Online transactions: Cloud SQL for MySQL 2. Customer feedback: BigQuery 3. Social media activity: Cloud Storage

Correct answer: B

Explanation

The correct answer is B because BigQuery is ideal for analyzing online transactions and social media activity due to its ability to handle large datasets and perform complex queries efficiently. Cloud Storage is suitable for storing customer feedback, which may not require the same level of analytical processing as the other data types.