An online gaming platform uses Cloud Spanner for player data. During a new game launch, the platform experiences a massive spike in read traffic for player profiles. The team wants to reduce the load on Spanner and improve response times. They are considering adding a cache layer. What is the most important consideration when choosing between Memorystore for Redis and Memorystore for Memcached?

Memcached is the only option that can be used as a cache.

Memcached provides stronger consistency than Redis.

Redis is a relational database, while Memcached is a NoSQL database.

Redis supports advanced data structures and persistence, while Memcached is simpler and more memory-efficient.

A company is migrating a critical application from on-premises PostgreSQL to Google Cloud. The application has a mix of OLTP and OLAP workloads. The team is evaluating Cloud SQL for PostgreSQL and AlloyDB for PostgreSQL. The application requires high performance for both transactional and analytical queries, and the team has limited operational resources. What is the most important consideration in this decision?

AlloyDB provides better performance for analytical queries, but Cloud SQL is simpler to manage.

AlloyDB is a NoSQL database, making it unsuitable for this application.

Cloud SQL is the only option that supports PostgreSQL.

Cloud SQL provides better performance for analytical queries than AlloyDB.

Google CloudProfessional Data Engineer

Domain 3Objective 1

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

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 11–15

11expert · hard
An online gaming platform uses Cloud Spanner for player data. During a new game launch, the platform experiences a massive spike in read traffic for player profiles. The team wants to reduce the load on Spanner and improve response times. They are considering adding a cache layer. What is the most important consideration when choosing between Memorystore for Redis and Memorystore for Memcached?
Select an answer first
12foundation · easy
A mobile application needs to store user-generated content such as profile pictures and videos, with the ability to apply lifecycle policies to archive old content. Which Google Cloud service is most appropriate?
Select an answer first
13expert · hard
A company is migrating a critical application from on-premises PostgreSQL to Google Cloud. The application has a mix of OLTP and OLAP workloads. The team is evaluating Cloud SQL for PostgreSQL and AlloyDB for PostgreSQL. The application requires high performance for both transactional and analytical queries, and the team has limited operational resources. What is the most important consideration in this decision?
Select an answer first
14foundation · easy
A team needs to store unstructured data such as images and videos, with lifecycle policies to move older data to cheaper storage. Which Google Cloud managed service is most appropriate?
Select an answer first
15foundation · easy
A data engineer needs to run serverless SQL analytics over data stored in an external data lake in Cloud Storage, without loading the data into a separate warehouse. Which Google Cloud service should be used?
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 3)

Questions 11–15

A mobile application needs to store user-generated content such as profile pictures and videos, with the ability to apply lifecycle policies to archive old content. Which Google Cloud service is most appropriate?

A team needs to store unstructured data such as images and videos, with lifecycle policies to move older data to cheaper storage. Which Google Cloud managed service is most appropriate?

A data engineer needs to run serverless SQL analytics over data stored in an external data lake in Cloud Storage, without loading the data into a separate warehouse. Which Google Cloud service should be used?

Keep studying — Storing the data