Logo ExamsQA
Exit
Official Bank 0/106

Google Associate Data Practitioner (Associate Data Practitioner) - Google Cloud Exam Questions

Last updated on June 20, 2026

97% Exam Compliance
106 Total Questions
1
Question
You work for a retail company that collects customer data from various sources: Online transactions: Stored in a MySQL database Customer feedback: Stored as text files on a company server Social media activity: Streamed in real-time from social media platforms You need to design a data pipeline to extract and load the data into the appropriate Google Cloud storage system(s) for further analysis and ML model training. What should you do?
Options
A Extract and load the online transactions data, customer feedback data, and social media activity into Cloud Storage.
B Copy the online transactions data into Cloud SQL for MySQL. Import the customer feedback into BigQuery. Stream the social media activity into Cloud Storage.
C Extract and load the online transactions data into BigQuery. Load the customer feedback data into Cloud Storage. Stream the social media activity by using Pub/Sub and Dataflow, and store the data in BigQuery.
D Extract and load the online transactions data into Bigtable. Import the customer feedback data into Cloud Storage. Store the social media activity in Cloud SQL for MySQL.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
You are working on a project that requires analyzing daily social media dat
Options
A Use Cloud Data Fusion to transfer the data into BigQuery raw tables, and use SQL to transform it.
B Manually download the data from Cloud Storage. Use a Python script to transform and upload the data into BigQuery.
C Use Dataflow to transform the data and write the transformed data to BigQuery.
D Use Cloud Run functions to transform and load the data into BigQuery.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
You need to design a data pipeline to process large volumes of raw server log data stored in Cloud Storage. The data needs to be cleaned, transformed, and aggregated before being loaded into BigQuery for analysis. The transformation involves complex data manipulation using Spark scripts that your team developed. You need to implement a solution that leverages your team’s existing skillset, processes data at scale, and minimizes cost. What should you do?
Options
A Use Dataflow with a custom template for the transformation logic.
B Use Dataproc to run the transformations on a cluster.
C Use Dataform to define the transformations in SQLX.
D Use Cloud Data Fusion to visually design and manage the pipeline.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
You work for a financial services company that handles highly sensitive dat
Options
A Use customer-supplied encryption keys (CSEK).
B Use Google-managed encryption keys (GMEK).
C Use a dedicated third-party key management system (KMS) chosen by the company.
D Use customer-managed encryption keys (CMEK).
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
Your organization has a BigQuery dataset that contains sensitive employee information such as salaries and performance reviews. The payroll specialist in the HR department needs to have continuous access to aggregated performance data, but they do not need continuous access to other sensitive dat
Options
A Create a table with the aggregated performance data. Use table-level permissions to grant access to the payroll specialist.
B Use authorized views to share query results with the payroll specialist.
C Create row-level and column-level permissions and policies on the table that contains performance data in the dataset. Provide the payroll specialist with the appropriate permission set.
D Create a SQL query with the aggregated performance data. Export the results to an Avro file in a Cloud Storage bucket. Share the bucket with the payroll specialist.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.