A global e-commerce company needs to store product catalog data that is updated frequently (multiple times per day) and accessed by users worldwide with low latency. The data has a relational structure (products, categories, inventory) and requires ACID transactions for updates. The company expects a few thousand reads per second and hundreds of writes per second. Which storage solution should they choose?

Firestore in a multi-regional configuration

Bigtable in a multi-regional configuration

Cloud SQL in a single region with read replicas in other regions

Cloud Spanner in a multi-regional configuration

Google CloudAssociate Data Practitioner

Domain 1Objective 2

1.2 Extract and Load Data into Appropriate Google Cloud Storage Systems ASSOCIATE-DATA-PRACTITIONER Practice Questions (Page 3)

Part of the Data Preparation and Ingestion domain, which accounts for ~30% of the ASSOCIATE-DATA-PRACTITIONER exam.

23questions here

5free pages

6concepts

~30%of the exam

Questions 11–15

11foundation · easy
A dataset contains customer records with a fixed set of columns such as customer_id, name, and email. Each row has the same attributes, and the data is stored in a table. How should this data be classified?
Select an answer first
12foundation · easy
A team needs to load data from Salesforce into BigQuery on a recurring schedule. Which Google Cloud service is the most appropriate for this task?
Select an answer first
13foundation · easy
A data pipeline writes temporary intermediate results that can be regenerated if lost. The team wants to minimize storage costs. Which Cloud Storage location type is most cost-effective?
Select an answer first
14application · medium
A mobile app company needs to store user profile data (name, email, preferences) and support real-time updates when users change their settings. The data is accessed by the app with low latency, and the company expects a few thousand reads/writes per second. They do not need complex SQL queries. Which storage solution is most appropriate?
Select an answer first
15expert · hard
A global e-commerce company needs to store product catalog data that is updated frequently (multiple times per day) and accessed by users worldwide with low latency. The data has a relational structure (products, categories, inventory) and requires ACID transactions for updates. The company expects a few thousand reads per second and hundreds of writes per second. Which storage solution should they choose?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to ASSOCIATE-DATA-PRACTITIONER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Google Cloud. “ASSOCIATE-DATA-PRACTITIONER” is a trademark of its owner, used for identification only.

1.2 Extract and Load Data into Appropriate Google Cloud Storage Systems ASSOCIATE-DATA-PRACTITIONER Practice Questions (Page 3)

Questions 11–15

A dataset contains customer records with a fixed set of columns such as customer_id, name, and email. Each row has the same attributes, and the data is stored in a table. How should this data be classified?

A team needs to load data from Salesforce into BigQuery on a recurring schedule. Which Google Cloud service is the most appropriate for this task?

A data pipeline writes temporary intermediate results that can be regenerated if lost. The team wants to minimize storage costs. Which Cloud Storage location type is most cost-effective?

Keep studying — Data Preparation and Ingestion