GCP-ADP sample questions

Question 1

A retail company collects clickstream data from its e-commerce website. The data is currently stored in on-premises servers as JSON files. You need to migrate this historical data (approximately 50 TB) to Google Cloud for analysis in BigQuery. The company has a limited network bandwidth of 100 Mbps and requires the data to be available in Google Cloud within one week. Which approach should you take?

Accepted Answer

Order a Transfer Appliance to capture the data and ship it to Google.

Answer

Use `gsutil -m cp` to upload the files directly to Cloud Storage.

Answer

Configure Storage Transfer Service for on-premises data to upload the files over the internet.

Answer

Set up a dedicated Cloud Interconnect connection to facilitate the transfer.

Question 2

You are designing a data ingestion pipeline for a financial services application. The application generates high-throughput transactional data that must be stored with strong consistency and high availability across a global user base. You need to select a storage solution that supports SQL queries and horizontal scalability. Which service should you choose?

Accepted Answer

Cloud Spanner

Answer

Cloud SQL

Answer

BigQuery

Answer

Cloud Bigtable

Question 3

You are building a data warehouse in BigQuery. You have a requirement to load daily batch files from Cloud Storage into BigQuery. The source data is in CSV format, but the schema of the files might evolve over time (e.g., new columns added). You want to ensure that the loading process handles these schema changes automatically without manual intervention. What should you do?

Accepted Answer

Convert the CSV files to Avro format before loading and use the `schema_update_options` flag set to `ALLOW_FIELD_ADDITION`.

Answer

Use the `bq load` command with the `--autodetect` flag for every load job.

Answer

Load the data into a temporary table first, then use a `MERGE` statement to update the target table.

Answer

Use Dataflow to read the CSVs and write to BigQuery using the `BigQueryIO` sink with `CREATE_IF_NEEDED`.

Question 4

A marketing team needs to analyze customer sentiment from social media posts. The data is unstructured text stored in Cloud Storage. You need to process this data, extract sentiment scores, and store the structured results in BigQuery for analysis. Which tool provides a visual interface to build this pipeline without writing extensive code?

Accepted Answer

Cloud Data Fusion

Answer

Cloud Dataflow

Answer

Cloud Dataproc

Answer

Cloud Composer

Question 5

You are managing a data lake in Cloud Storage containing sensitive customer information. You need to ensure that the data is stored cost-effectively. The data is accessed frequently during the first 30 days, rarely for the next 60 days, and almost never after 90 days, but must be retained for 3 years for compliance. Which Object Lifecycle Management configuration should you apply?

Accepted Answer

Set the storage class to Standard initially. Add a rule to change to Nearline after 30 days, to Coldline after 90 days, and delete after 3 years.

Answer

Set the storage class to Standard initially. Add a rule to change to Nearline after 30 days, to Archive after 90 days, and delete after 3 years.

Answer

Set the storage class to Nearline initially. Add a rule to change to Archive after 90 days.

Answer

Use Autoclass to automatically manage all transitions.

Question 6

You are analyzing a large dataset in BigQuery to identify sales trends. You need to calculate the moving average of sales over the last 7 days for each product. Which SQL construct should you use?

Accepted Answer

Window function with AVG() OVER (PARTITION BY product_id ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW)

Answer

GROUP BY with AVG()

Answer

Common Table Expression (CTE) with a self-join

Answer

UNNEST() function

Top vendors

Top exams

Free GCP-ADP sample questions

You are analyzing a large dataset in BigQuery to identify sales trends. You need to calculate the moving average of sales over the last 7 days for each product. Which SQL construct should you use?

6 more free samples are waiting