A data engineer wants to use a large language model (LLM) to generate a SQL query from a natural language request. What is the most important factor in crafting an effective prompt?

Using as many technical terms as possible

Providing clear and specific instructions with context

Avoiding examples in the prompt

Keeping the prompt as short as possible

What is a primary benefit of using Cloud Data Fusion for data preparation?

It provides a visual, code-free environment for building pipelines

It automatically scales to handle petabyte-scale data

It is optimized for real-time stream processing

It eliminates the need for data validation

When prompting an LLM to generate a SQL query, which element is most likely to improve the accuracy of the generated query?

Asking the model to generate multiple queries and pick the best

Using a very long and detailed prompt

Including the database schema in the prompt

Avoiding any mention of the desired output format

Google CloudProfessional Data Engineer

Domain 1Objective 2

1.2 Designing for Reliability and Fidelity PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 2)

Part of the Designing data processing systems domain, which accounts for ~22% of the PROFESSIONAL-DATA-ENGINEER exam. Google Cloud does not publish an official question count, but from its 120-minute exam (~50–80 total, ~11–18 in this domain), expect 3–5 from this objective — we provide 27 practice questions to prepare you well beyond it. (estimate)

27questions here

6free pages

11concepts

~22%of the exam

Questions 6–10

6foundation · easy
A data engineer needs to orchestrate a complex workflow that includes multiple data processing steps with dependencies and retries. Which Google Cloud service is designed for this?
Select an answer first
7foundation · easy
A data engineer wants to use a large language model (LLM) to generate a SQL query from a natural language request. What is the most important factor in crafting an effective prompt?
Select an answer first
8foundation · easy
A data pipeline processes events and writes results to BigQuery. To ensure that reprocessing a batch of events does not create duplicate records, which design principle should be applied?
Select an answer first
9foundation · easy
What is a primary benefit of using Cloud Data Fusion for data preparation?
Select an answer first
10foundation · easy
When prompting an LLM to generate a SQL query, which element is most likely to improve the accuracy of the generated query?
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.

1.2 Designing for Reliability and Fidelity PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 2)

Questions 6–10

A data engineer needs to orchestrate a complex workflow that includes multiple data processing steps with dependencies and retries. Which Google Cloud service is designed for this?

A data engineer wants to use a large language model (LLM) to generate a SQL query from a natural language request. What is the most important factor in crafting an effective prompt?

A data pipeline processes events and writes results to BigQuery. To ensure that reprocessing a batch of events does not create duplicate records, which design principle should be applied?

What is a primary benefit of using Cloud Data Fusion for data preparation?

When prompting an LLM to generate a SQL query, which element is most likely to improve the accuracy of the generated query?

Keep studying — Designing data processing systems