Prepare and test your skills

Prepare and test your skills

Free sample question with answers and detailed explanation below. The Cloud Digital Leader practice bank has an additional 3,070 practice questions.Try 10 free realistic questions: instant score, no credit card, and no account required.
A retail organization recently acquired a competitor and wants to integrate its data ecosystem to accelerate business decision-making and cross-functional collaboration. The organization has the following requirements:
Which Google Cloud solution should the organization implement?
Transfer Appliance is a hardware-based data movement solution that provides physical, rackable storage devices to ship large volumes of data from an on-premises facility to Google Cloud. BigQuery Migration Service is a comprehensive suite of tools designed to help organizations plan, assess, translate SQL queries, and migrate legacy data warehouses or lakehouses into BigQuery.
This solution would be the right choice if the organization needed to perform an initial offline migration of petabytes of archival data from an on-premises data center with slow internet connectivity and translate legacy SQL scripts into BigQuery.
While BigQuery Migration Service helps consolidate legacy data estates into BigQuery after an acquisition, unlocking ongoing real-time value and cross-functional collaboration requires Dataflow for unified streaming pipelines and BigQuery sharing for governed dataset distribution.
Dataflow is a fully managed, serverless data processing service that executes unified batch and streaming data pipelines at scale using the open-source Apache Beam programming model. BigQuery sharing (formerly Analytics Hub) is a data exchange capability built into BigQuery that enables organizations to securely share data and insights at scale across organizational boundaries using a robust security and privacy framework.
Unlike batch-only transfer tools or point-to-point migration utilities, combining Dataflow with BigQuery sharing addresses both real-time data transformation and enterprise-wide data distribution. It empowers organizations to turn raw, disparate data streams into actionable intelligence while fostering seamless collaboration across teams.
Storage Transfer Service is a managed data movement tool that transfers files and objects between object storage systems, such as moving data from AWS S3 or on-premises storage into Cloud Storage. Dataform is a collaborative development environment that helps data teams build, version control, test, and orchestrate SQL pipelines directly inside BigQuery.
ELT), rather than acting as a unified batch and streaming execution engine for live application events.This combination would be the ideal choice if the organization wanted to copy file backups from an external cloud provider into Cloud Storage and allow data analysts to collaboratively manage version-controlled SQL table transformations inside BigQuery.
Organizations frequently use Dataform downstream of ingestion tools to curate tables in BigQuery, whereas Dataflow is required when workloads demand unified batch and real-time stream processing across diverse sources.
BigQuery Data Transfer Service is a data integration tool that automates data movement into BigQuery on a scheduled or ad hoc basis without requiring engineers to write custom code. Sensitive Data Protection is a security and privacy service designed to automatically discover, classify, mask, and redact sensitive information across enterprise datasets.
This approach would be appropriate if the company needed to automate nightly, code-free imports of advertising campaign reports into BigQuery while automatically scanning and redacting customer credit card numbers to meet regulatory compliance.
In a comprehensive cloud data ecosystem, Sensitive Data Protection often complements Dataflow and BigQuery sharing by ensuring that sensitive customer attributes are de-identified before datasets are shared across organizational boundaries.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated