100% Free Google Associate-Data-Practitioner Practice Test Questions

Question 1

You are migrating data from a legacy on-premises MySQL database to Google Cloud. The database contains various tables with different data types and sizes, including large tables with millions of rows and transactional dat a. You need to migrate this data while maintaining data integrity, and minimizing downtime and cost. What should you do?

A : Set up a Cloud Composer environment to orchestrate a custom data pipeline. Use a Python script to extract data from the MySQL database and load it to MySQL on Compute Engine.

B : Export the MySQL database to CSV files, transfer the files to Cloud Storage by using Storage Transfer Service, and load the files into a Cloud SQL for MySQL instance.

C : Use Database Migration Service to replicate the MySQL database to a Cloud SQL for MySQL instance.

D : Use Cloud Data Fusion to migrate the MySQL database to MySQL on Compute Engine.

Answer: C

Question 2

You are migrating data from a legacy on-premises MySQL database to Google Cloud. The database contains various tables with different data types and sizes, including large tables with millions of rows and transactional dat a. You need to migrate this data while maintaining data integrity, and minimizing downtime and cost. What should you do?

A : Set up a Cloud Composer environment to orchestrate a custom data pipeline. Use a Python script to extract data from the MySQL database and load it to MySQL on Compute Engine.

B : Export the MySQL database to CSV files, transfer the files to Cloud Storage by using Storage Transfer Service, and load the files into a Cloud SQL for MySQL instance.

C : Use Database Migration Service to replicate the MySQL database to a Cloud SQL for MySQL instance.

D : Use Cloud Data Fusion to migrate the MySQL database to MySQL on Compute Engine.

Answer: C

Question 3

You work for an ecommerce company that has a BigQuery dataset that contains customer purchase history, demographics, and website interactions. You need to build a machine learning (ML) model to predict which customers are most likely to make a purchase in the next month. You have limited engineering resources and need to minimize the ML expertise required for the solution. What should you do?

A : Use BigQuery ML to create a logistic regression model for purchase prediction.

B : Use Vertex AI Workbench to develop a custom model for purchase prediction.

C : Use Colab Enterprise to develop a custom model for purchase prediction.

D : Export the data to Cloud Storage, and use AutoML Tables to build a classification model for purchase prediction.

Answer: A

Question 4

You are migrating data from a legacy on-premises MySQL database to Google Cloud. The database contains various tables with different data types and sizes, including large tables with millions of rows and transactional dat a. You need to migrate this data while maintaining data integrity, and minimizing downtime and cost. What should you do?

A : Set up a Cloud Composer environment to orchestrate a custom data pipeline. Use a Python script to extract data from the MySQL database and load it to MySQL on Compute Engine.

B : Export the MySQL database to CSV files, transfer the files to Cloud Storage by using Storage Transfer Service, and load the files into a Cloud SQL for MySQL instance.

C : Use Database Migration Service to replicate the MySQL database to a Cloud SQL for MySQL instance.

D : Use Cloud Data Fusion to migrate the MySQL database to MySQL on Compute Engine.

Answer: C

Question 5

Your retail organization stores sensitive application usage data in Cloud Storage. You need to encrypt the data without the operational overhead of managing encryption keys. What should you do?

A : Use Google-managed encryption keys (GMEK).

B : Use customer-managed encryption keys (CMEK).

C : Use customer-supplied encryption keys (CSEK).

D : Use customer-supplied encryption keys (CSEK) for the sensitive data and customer-managed encryption keys (CMEK) for the less sensitive data.

Answer: A

Free Practice Google Associate-Data-Practitioner Exam Questions 2025