An application performs millions of small random reads per second and writes are infrequent. Which storage system characteristic is most important to evaluate first?

Data lifecycle management features

Write throughput and consistency

A data engineering team is designing a data lake on Google Cloud. They have a mix of structured and semi-structured data (Parquet, Avro, JSON) stored in Cloud Storage. They want to run both ad-hoc SQL analytics and machine learning pipelines on this data. They also need to enforce fine-grained access control at the row and column level. The team is considering BigQuery and BigLake. What is the most important factor in choosing between them?

BigLake is a data warehouse, while BigQuery is a data lake.

BigQuery cannot handle semi-structured data like JSON.

BigLake provides a unified interface for querying data in Cloud Storage with fine-grained security, while BigQuery requires data to be loaded.

BigQuery is the only option that can query data in Cloud Storage.

Google CloudProfessional Data Engineer

Domain 3Objective 1

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

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 1–5

1foundation · easy
A workload requires high IOPS and low latency for random access to data. Which storage system characteristic is most important to plan for?
Select an answer first
2foundation · easy
An application performs millions of small random reads per second and writes are infrequent. Which storage system characteristic is most important to evaluate first?
Select an answer first
3foundation · easy
A team needs a fully managed relational database that supports MySQL, PostgreSQL, or SQL Server, with automatic backups and scaling, but does not require the extreme performance of AlloyDB. Which Google Cloud service is most appropriate?
Select an answer first
4foundation · easy
A web application needs a database that supports real-time synchronization of data between clients and the server, with offline support for mobile users. Which Google Cloud service is best suited for this?
Select an answer first
5expert · hard
A data engineering team is designing a data lake on Google Cloud. They have a mix of structured and semi-structured data (Parquet, Avro, JSON) stored in Cloud Storage. They want to run both ad-hoc SQL analytics and machine learning pipelines on this data. They also need to enforce fine-grained access control at the row and column level. The team is considering BigQuery and BigLake. What is the most important factor in choosing between them?
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 1)

Questions 1–5

A workload requires high IOPS and low latency for random access to data. Which storage system characteristic is most important to plan for?

An application performs millions of small random reads per second and writes are infrequent. Which storage system characteristic is most important to evaluate first?

A team needs a fully managed relational database that supports MySQL, PostgreSQL, or SQL Server, with automatic backups and scaling, but does not require the extreme performance of AlloyDB. Which Google Cloud service is most appropriate?

A web application needs a database that supports real-time synchronization of data between clients and the server, with offline support for mobile users. Which Google Cloud service is best suited for this?

Keep studying — Storing the data