An e-commerce platform is experiencing high latency on product detail pages during flash sales. The product data is stored in Cloud SQL, and the same product information is read repeatedly by many users. The team wants to reduce the load on the database and improve response times without changing the application's data model. What is the most direct solution?

Use Cloud CDN to cache the product pages

Implement a cache layer using Memorystore for Redis

Move the product data to Bigtable

Add more read replicas to Cloud SQL

A multinational bank is building a new customer account management system. The system must support millions of customers, each with a single account record. The bank requires strong consistency for balance updates and the ability to serve reads and writes from multiple regions with low latency. They also need to run complex SQL queries for reporting. The team is evaluating Cloud Spanner and Cloud Bigtable. Which consideration is most important in this decision?

Bigtable supports SQL queries, making it suitable for the reporting requirement.

Bigtable provides lower latency for point reads, but Spanner is required for strong consistency across regions.

Spanner is a NoSQL database, which is not suitable for account management.

Bigtable is a relational database, making it the better choice for strong consistency.

When estimating storage costs for a database, which factor has the most direct impact on the cost?

The amount of data stored and the storage class

The geographic region of the users

The number of queries executed per day

The number of users accessing the data

A healthcare company must retain patient medical records for 10 years to comply with regulations. The records are accessed rarely (a few times per year) for audits. The company has a predictable storage volume and wants to minimize costs. They are considering using Cloud Storage with a lifecycle policy to transition objects to colder storage classes. Which combination of storage class and commitment type is most cost-effective?

Coldline class with on-demand pricing

Nearline class with committed use discounts

Standard class with on-demand pricing

Archive class with committed use discounts

A data engineer needs to delete objects that are no longer needed to reduce storage costs. What is the most appropriate method to ensure only objects that meet specific criteria are deleted?

Use a lifecycle policy with a deletion rule

Set the bucket's default storage class to Archive

Google CloudProfessional Data Engineer

Domain 3Objective 1

3.1 Selecting Storage Systems PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 5)

Part of the Storing the data domain, which accounts for ~20% of the PROFESSIONAL-DATA-ENGINEER exam. Google Cloud does not publish an official question count, but from its 120-minute exam (~50–80 total, ~10–16 in this domain), expect 3–4 from this objective — we provide 35 practice questions to prepare you well beyond it. (estimate)

35questions here

7free pages

12concepts

~20%of the exam

Questions 21–25

21application · medium
An e-commerce platform is experiencing high latency on product detail pages during flash sales. The product data is stored in Cloud SQL, and the same product information is read repeatedly by many users. The team wants to reduce the load on the database and improve response times without changing the application's data model. What is the most direct solution?
Select an answer first
22expert · hard
A multinational bank is building a new customer account management system. The system must support millions of customers, each with a single account record. The bank requires strong consistency for balance updates and the ability to serve reads and writes from multiple regions with low latency. They also need to run complex SQL queries for reporting. The team is evaluating Cloud Spanner and Cloud Bigtable. Which consideration is most important in this decision?
Select an answer first
23foundation · easy
When estimating storage costs for a database, which factor has the most direct impact on the cost?
Select an answer first
24application · medium
A healthcare company must retain patient medical records for 10 years to comply with regulations. The records are accessed rarely (a few times per year) for audits. The company has a predictable storage volume and wants to minimize costs. They are considering using Cloud Storage with a lifecycle policy to transition objects to colder storage classes. Which combination of storage class and commitment type is most cost-effective?
Select an answer first
25foundation · easy
A data engineer needs to delete objects that are no longer needed to reduce storage costs. What is the most appropriate method to ensure only objects that meet specific criteria are deleted?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PROFESSIONAL-DATA-ENGINEER

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. “PROFESSIONAL-DATA-ENGINEER” is a trademark of its owner, used for identification only.

3.1 Selecting Storage Systems PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 5)

Questions 21–25

When estimating storage costs for a database, which factor has the most direct impact on the cost?

A data engineer needs to delete objects that are no longer needed to reduce storage costs. What is the most appropriate method to ensure only objects that meet specific criteria are deleted?

Keep studying — Storing the data