Data Preparation And Ingestion

You need to store sensitive data in GCS. Which feature ensures data is encrypted at rest?

Which GCS storage class is most cost-effective for data accessed only once per year?

You are designing a streaming pipeline in Dataflow. You need to ensure that data is processed in the order it was generated, even if it arrives late. What do you use?

You need to load CSV files from GCS to BigQuery. The schema changes frequently. Which approach handles schema evolution automatically?

You need to perform data cleansing on a large dataset in Dataprep. Which execution engine should you choose for scalability?

You need to ingest data from an external API that requires an OAuth token. Which tool is best for executing this periodically?

You are processing streaming data in Dataflow and notice 'stuck' elements causing pipeline latency. Which feature helps debug this?

You want to run a Dataflow pipeline on a schedule. What should you use?

You need to set up an alert when a GCS bucket exceeds a certain size. Which tool do you use?

You need to transfer files from an Amazon S3 bucket to GCS. What is the most efficient method?

You are migrating a high-throughput on-premises database to BigQuery. You need to ensure zero downtime. What is your best strategy?

You need to provide temporary access to a GCS file for a third party. What should you use?

You need to ingest IoT data into BigQuery. You need to handle messages arriving in millions per second. Which service acts as the buffer?

You are running a Dataflow job and notice that it is consuming too much memory and crashing. How do you optimize this?

You need to track who accessed which GCS bucket. Which service provides this audit trail?

You are processing streaming data in Pub/Sub and need to archive every message into GCS without writing custom code. What should you use?

You need to ensure that deleted files in GCS can be restored for 30 days. What should you configure?

You are cleaning data using Dataprep. You want to save the final dataset in BigQuery. What do you do?

You are using Dataflow to read from Pub/Sub. The pipeline is failing due to malformed messages. How can you handle these without crashing?

What is the primary benefit of using partitioned tables in BigQuery?

You need to ingest log data into BigQuery from GCS files that arrive sporadically. Which service is best to trigger this?

You are running a Dataflow job that joins two large datasets. Which join strategy should you avoid to prevent OOM errors?

Which GCP tool provides a managed way to run Apache Airflow workflows?

You need to anonymize PII (Personally Identifiable Information) before loading data into BigQuery. Which tool is best?

You need to ingest data from a legacy database into Google Cloud. The database has strict network egress controls. How should you connect?

You need to delete all files in a GCS bucket older than 90 days. What is the most efficient approach?

You are using Dataflow with autoscaling. What metric determines whether the worker pool scales up or down?

You need to verify the integrity of a large file uploaded to GCS. What is the standard way to do this?

You need to perform a complex windowing operation on streaming data in Dataflow. Which windowing strategy is best for session-based activity?

You are using BigQuery and need to load data from an external file that is not in GCS. Which method is recommended?

Which service should you use to ingest streaming data from mobile devices?

You are using Dataflow with a custom container. Which command do you use to specify the container image?

You are using Dataprep to prepare data. How can you share your work with a team?

How do you restrict access to a specific GCS bucket to only members of a specific team?

Which tool is used to monitor the performance of your Dataflow pipelines?

You are using BigQuery and need to query a large dataset that is partitioned by day. Which clause should you always include for efficiency?

You need to ingest small files into Cloud Storage using a command-line tool. Which command is most appropriate?

In Dataflow, what is the impact of using a high number of workers for a small dataset?

You need to perform a rolling update on a Dataflow job without losing current state. How do you do this?

Which TWO of the following are valid ways to ingest data into BigQuery?

Which TWO factors should you consider when choosing a GCS storage class?

Which THREE of the following are Dataflow windowing types?

Which TWO of the following are benefits of using Cloud Storage?

Which THREE features does Dataprep provide?

Which TWO of the following are common Dataflow pipeline patterns?

Which TWO of the following are GCP ingestion tools?

Which THREE of the following are valid GCS storage classes?

Which THREE steps are involved in an effective Dataflow pipeline development?

Which TWO are common causes of Dataflow pipeline failures?

Which THREE are features of Pub/Sub?

Which TWO of the following are valid ways to monitor Dataflow performance?

Which TWO are methods to secure GCS data?

Which THREE of the following are valid BigQuery table types?

Which TWO of the following are key benefits of using Dataflow?

Which TWO are valid methods to trigger a Dataflow job?

Which THREE of the following are necessary for a production-ready Dataflow pipeline?

You need to ingest large amounts of unstructured data into Cloud Storage from an on-premises data center with limited bandwidth. Which service should you choose to ensure the most cost-effective and secure transfer?

Your team uses Dataprep by Trifacta to clean data before loading it into BigQuery. You notice that the column header names contain inconsistent casing and special characters. Which Dataprep transformation should you use to standardize these headers globally?

You are building a streaming pipeline using Dataflow to process sensor data arriving via Pub/Sub. You need to handle out-of-order data by allowing events to arrive late. Which Dataflow concept must you configure?

You are troubleshooting a Dataflow job that is running slower than expected when writing data to BigQuery. You suspect the issue is related to hot keys. What is the recommended strategy to mitigate this?

Your organization requires that all data ingested into Cloud Storage be encrypted at rest using keys managed by you, not Google. Which feature should you implement?

You have a large CSV file in Cloud Storage that needs to be loaded into BigQuery. The file contains a nested JSON structure in one column. How should you best prepare this data?

You are configuring a Cloud Data Fusion pipeline to ingest data from an external SQL database. You need to ensure that only rows modified within the last hour are ingested. Which feature should you use?

Which TWO of the following are recommended practices when designing a Dataflow pipeline for high-throughput streaming ingestion?

You are optimizing a Dataflow job. Which THREE of the following actions can help improve job performance and reduce costs?

You are planning to ingest log data into Google Cloud. Which THREE of the following services support streaming ingestion?