1.1 Prepare and Process Data ASSOCIATE-DATA-PRACTITIONER Practice Questions (Page 2)

Questions 6–10

1. 6expert · hard

   A company has a hybrid cloud architecture with data stored in both on-premises and Google Cloud. They need to continuously sync data from on-premises to Cloud Storage for analytics. The data changes frequently, and the company wants to minimize the amount of data transferred over the network. Which tool should they use?

   • Agsutil rsync with the -d flag to synchronize only changed files.
   • BTransfer Appliance for periodic bulk transfers.
   • CBigQuery Data Transfer Service to load data directly into BigQuery.
   • DStorage Transfer Service with a scheduled transfer from an HTTP endpoint.
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A data engineer is building a Cloud Data Fusion pipeline to clean a dataset with inconsistent date formats. Some dates are 'MM/DD/YYYY', others are 'YYYY-MM-DD'. The pipeline must convert all dates to a single format. Which plugin should be used?

   • AJoiner
   • BAggregator
   • CSplitter
   • DWrangler
   Reveal Solution Discussion Select an answer first
4. 8expert · hard

   A company uses Cloud Data Fusion to run a nightly batch pipeline that cleans and transforms data. Recently, the pipeline started failing because some input files have unexpected schemas. The team wants to handle these schema variations without stopping the pipeline. What should they do?

   • AUse a Wrangler transform to manually fix the schema for each file before loading.
   • BUse a Conditional plugin to check the schema and route files with unexpected schemas to a separate error path.
   • CUse a Deduplicate plugin to remove schema inconsistencies.
   • DUse a Joiner to merge all files regardless of schema.
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A retail company needs to migrate 500 TB of historical sales data from an on-premises Hadoop cluster to Cloud Storage. The office has a 1 Gbps internet connection, and the migration must complete within two weeks. What should the data engineer recommend?

   • AUse gsutil rsync to copy the data over the internet in parallel.
   • BUse Storage Transfer Service to schedule a one-time transfer from the on-premises cluster.
   • CUse Transfer Appliance to ship the data to Google, then load it into Cloud Storage.
   • DUse BigQuery Data Transfer Service to load the data directly into BigQuery.
   Reveal Solution Discussion Select an answer first
6. 10expert · hard

   A company is designing a data pipeline for a new analytics initiative. The data sources are diverse, including streaming IoT data, batch files, and database exports. The team wants to use a single pipeline that can handle both batch and streaming data, and they need to perform complex transformations that require custom code. Which approach is most appropriate?

   • AUse Cloud Data Fusion for batch and Dataflow for streaming, with separate pipelines.
   • BUse Dataflow with the Apache Beam SDK, which supports both batch and streaming in a unified model.
   • CUse Cloud Functions to process both batch and streaming data.
   • DUse Storage Transfer Service to ingest all data into Cloud Storage, then use BigQuery for transformations.
   Reveal Solution Discussion Select an answer first