CCNA Data Preparation And Ingestion Questions

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

Which TWO of the following are common Dataflow pipeline patterns?

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?

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

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

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

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

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

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

Which THREE features does Dataprep provide?

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

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

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

Which THREE are features of Pub/Sub?

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

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

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

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

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?

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

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 are running a Dataflow job that joins two large datasets. Which join strategy should you avoid to prevent OOM errors?

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

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

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

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

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

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

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

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

Which TWO are common causes of Dataflow pipeline failures?

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

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

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

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 are valid methods to trigger a Dataflow job?

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 cleaning data using Dataprep. You want to save the final dataset in BigQuery. What do you do?

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

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?

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

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

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

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?

Which THREE of the following are valid GCS storage classes?

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?

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

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

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?

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

Which TWO of the following are GCP ingestion tools?

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

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

Which TWO are methods to secure GCS data?

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

Which THREE of the following are valid BigQuery table types?

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

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 ingest log data into BigQuery from GCS files that arrive sporadically. Which service is best to trigger 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 Dataflow with autoscaling. What metric determines whether the worker pool scales up or down?

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

Which THREE of the following are Dataflow windowing types?

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

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

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