Home Microsoft Exams Google Cloud Exams

Loading page

Curious about new developments and updates? Follow our social media.

Get a free certification question every week.

Microsoft Exams

AZ-104 Administrator
AZ-204 Developer
AZ-900 Fundamentals
All Microsoft Exams

Google Cloud Exams

Associate Data Practitioner
All Google Cloud Exams

Terms Privacy Cookies About

© 2026 StudyCerts. All rights reserved.

Loading page

Bigquery Dataform Sql Elt Pipeline | professional-cloud-data-engineer | StudyCerts

Home
Google Cloud Exams
Professional Cloud Data Engineer
Preparing and cleaning data (e.g., Dataform, Dataflow, and Cloud Data Fusion, prompting LLMs for query generation)
An analytics engineering team at an enterprise organization …

Professional Cloud Data Engineer

professional-cloud-data-engineer

Advanced

Prepare and test your skills

Track Readiness

Description
Sample Question
Free Trial
Practice Test

Advanced

Prepare and test your skills

Track Readiness

Description
Sample Question
Free Trial
Practice Test

Bigquery Dataform Sql Elt Pipeline

Section: Preparing and cleaning data (e.g., Dataform, Dataflow, and Cloud Data Fusion, prompting LLMs for query generation)

Worked example. The correct answer is already marked and every option is explained below, so there is nothing to select here. To answer questions yourself, start the free trial.

An analytics engineering team at an enterprise organization has ingested raw transactional data directly into staging tables in BigQuery. The team consists primarily of SQL developers who need to build a scalable in-warehouse data transformation pipeline.

The solution must satisfy the following technical requirements:

Define modular data models and manage table dependencies using SQL
Enforce data quality rules through native data testing and assertions
Provide built-in Git integration for collaborative version control and CI/CD
Execute all transformation workloads directly within BigQuery compute slots without provisioning separate compute infrastructure

Which Google Cloud service should the team implement?

Dataform

Cloud Data Fusion

Cloud Composer

Dataflow

Explanations

Related questions

Keep the momentum going with these hand-picked practice scenarios

AdvancedProfessional Cloud Data Engineer

A data engineering team is designing an automated data preparation pipeline in Google Cloud. They are using Vertex AI to prompt a Large Language Model (LLM) to extract structured business entities from semi-structured source specifications, generate BigQuery SQL transformation scripts, and produce Dataform data quality assertion rules. The automated pipeline requires deterministic, production-grade output. It must eliminate hallucinations, strictly enforce dialect-specific query optimizations (such as rewriting multiple-reference CTEs into temporary tables), output code in an easily parseable format, and ensure no semantic drift or unverified business assumptions are introduced into the transformation logic. Which prompt engineering strategy should the team implement to formulate the most effective and reliable system prompt for the LLM?

Preparing and cleaning data (e.g., Dataform, Dataflow, and Cloud Data Fusion, prompting LLMs for query generation)

AdvancedProfessional Cloud Data Engineer

An enterprise is designing a centralized data preparation and cleaning architecture using Cloud Data Fusion. Data files from multiple external partners are uploaded to separate Cloud Storage buckets, and each dataset requires distinct data quality validation rules, formatting directives, and output destinations. Creating and maintaining individual static pipelines for dozens of source feeds has caused significant operational overhead and deployment delays. The data engineering team requires a single, maintainable pipeline structure that dynamically determines its input source, validation checks, and output target during each scheduled execution. How should you configure the Cloud Data Fusion pipeline to support these dynamic validation and cleaning requirements?

AdvancedProfessional Cloud Data Engineer

An enterprise data engineering team is designing a multi-environment architecture on Google Cloud for their data processing platform, which includes Dataflow pipelines and BigQuery analytical warehouses across Development, Staging, and Production environments. The system must satisfy the following security and operational requirements: Sensitive personally identifiable information (PII) and confidential datasets must reside exclusively in Production and be isolated from lower environments. Long-lived downloaded service account keys must be prohibited across all environments to prevent credential leakage. CI/CD deployment pipelines and data engineers must adhere to the principle of least privilege, with complete non-repudiation and audit logging of privileged operations. Pipeline deployment runners must not have direct read access to production confidential data. Which combination of environment isolation, service account management, and IAM posture should the team implement?

AdvancedProfessional Cloud Data Engineer

An enterprise financial organization is designing an automated ingestion and processing architecture to stream high-volume transaction records from Pub/Sub into BigQuery. The architecture must satisfy the following technical requirements: Ingest records directly into BigQuery storage while strictly guaranteeing exactly-once processing semantics. Isolate and extract individual malformed or schema-mismatched rows into a dead-letter collection without failing the entire streaming pipeline. Maintain high throughput without relying on legacy streaming buffer inserts. Which ingestion pathway and processing approach should the organization implement?

AdvancedProfessional Cloud Data Engineer

A data engineer is designing security controls for an enterprise Looker deployment that queries a central data warehouse. The implementation must satisfy the following governance requirements: Model-Level Access: Users must only be allowed to see and query specific LookML models assigned to their department. Row-Level Security: Within a shared sales Explore, users must only view records associated with their assigned sales region. Field-Level Security: Sensitive financial metrics (such as gross profit margin) within the shared Explore must only be visible to authorized finance personnel. Which combination of Looker access controls and LookML configurations should the data engineer implement?

IntermediateProfessional Cloud Architect

An enterprise is planning to migrate its core application workloads from an on-premises data center to Google Cloud. In their current on-premises environment, the company incurs large upfront capital expenditures (CapEx) to procure hardware sized for peak annual traffic, resulting in low average hardware utilization throughout most of the year. The leadership team wants to understand the financial implications of moving to a cloud consumption model and how this shift affects Total Cost of Ownership (TCO) and organizational financial agility. Which statement accurately describes the economic impact of transitioning from fixed-cost infrastructure to a cloud variable-cost structure?

Want more questions like this?

Get a free certification question every week.

Are you ready for the Professional Cloud Data Engineer?

50 questions in the full practice test

No account required · Instant results

More Preparing and cleaning data (e.g., Dataform, Dataflow, and Cloud Data Fusion, prompting LLMs for query generation) practice questions

Get a free certification question with a full explanation every week.

Professional Cloud Data Engineer

Provider: Google Cloud
Passing score: 70%
Questions: 50
Duration: 90 minutes

Other sections in this exam

Designing data processing systems
Ingesting and processing the data
Storing the data
Preparing and using data for analysis
Maintaining and automating data workloads

Ask Scout

Still curious? Scout, our AI tutor, can explain this concept further and answer your follow-up questions.

Preparing and cleaning data (e.g., Dataform, Dataflow, and Cloud Data Fusion, prompting LLMs for query generation)

Multi-environment use cases (development vs. production)

Identifying the services (e.g., Dataflow, Apache Beam, Dataproc, Cloud Data Fusion, BigQuery, Pub/Sub, Apache Spark, Hadoop ecosystem, and Apache Kafka)

Publishing reports and visualizations

Cost optimization/resource optimization (CapEx/OpEx)