Google Associate Data Practitioner Sample Questions:

1. Following a recent company acquisition, you inherited an on- premises data infrastructure that needs to move to Google Cloud. The acquired system has 250 Apache Airflow directed acyclic graphs (DAGs) orchestrating data pipelines. You need to migrate the pipelines to a Google Cloud managed service with minimal effort. What should you do?

A) Create a new Cloud Composer environment and copy DAGS to the Cloud Composer dags/folder.
B) Create a Google Kubernetes Engine (GKE) standard cluster and deploy Airflow as a workload. Migrate all DAGs to the new Airflow environment.
C) Create a Cloud Data Fusion instance. For each DAG, create a Cloud Data Fusion pipeline.
D) Convert each DAG to a Cloud Workflow and automate the execution with Cloud Scheduler.

2. You work for a home insurance company. You are frequently asked to create and save risk reports with charts for specific areas using a publicly available storm event dataset. You want to be able to quickly create and re- run risk reports when new data becomes available. What should you do?

A) Reference and query the storm event dataset using SQL in BigQuery Studio. Export the results to Google Sheets, and use cell data in the worksheets to create charts.
B) Reference and query the storm event dataset using SQL in a Colab Enterprise notebook. Display the table results and document with Markdown, and use Matplotlib to create charts.
C) Export the storm event dataset as a CSV file. Import the file to Google Sheets, and use cell data in the worksheets to create charts.
D) Copy the storm event dataset into your BigQuery project. Use BigQuery Studio to query and visualize the data in Looker Studio.

3. Your company's customer support audio files are stored in a Cloud Storage bucket. You plan to analyze the audio files' metadata and file content within BigQuery to create inference by using BigQuery ML. You need to create a corresponding table in BigQuery that represents the bucket containing the audio files. What should you do?

A) Create an external table.
B) Create a temporary table.
C) Create a native table.
D) Create an object table.

4. Your team wants to create a monthly report to analyze inventory data that is updated daily. You need to aggregate the inventory counts by using only the most recent month of data, and save the results to be used in a Looker Studio dashboard. What should you do?

A) Create a saved query in the BigQuery console that uses the SUM() function and the DATE_SUB() function. Re-run the saved query every month, and save the results to a BigQuery table.
B) Create a BigQuery table that uses the SUM() function and the DATE_DIFF() function.
C) Create a BigQuery table that uses the SUM() function and the _PARTITIONDATE filter.
D) Create a materialized view in BigQuery that uses the SUM() function and the DATE_SUB() function.

5. You need to transfer approximately 300 TB of data from your company's on-premises data center to Cloud Storage. You have 100 Mbps internet bandwidth, and the transfer needs to be completed as quickly as possible. What should you do?

A) Use the gcloud storage command to transfer the data over the internet.
B) Use Cloud Client Libraries to transfer the data over the internet.
C) Compress the data, upload it to multiple cloud storage providers, and then transfer the data to CloudStorage.
D) Request a Transfer Appliance, copy the data to the appliance, and ship it back to Google.

Solutions: