Google Associate Data Practitioner Sample Questions:

1. 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 a. You need to grant the payroll specialist access to the performance data without granting them access to the entire dataset using the simplest and most secure approach. What should you do?

A) 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.
B) Use authorized views to share query results with the payroll specialist.
C) Create a table with the aggregated performance data. Use table-level permissions to grant access to the payroll specialist.
D) 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.

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) Use Database Migration Service to replicate the MySQL database to a Cloud SQL for MySQL instance.
B) 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.
C) Use Cloud Data Fusion to migrate the MySQL database to MySQL on Compute Engine.
D) 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.

3. Your company uses Looker as its primary business intelligence platform. You want to use LookML to visualize the profit margin for each of your company's products in your Looker Explores and dashboards.
You need to implement a solution quickly and efficiently. What should you do?

A) Apply a filter to only show products with a positive profit margin.
B) Define a new measure that calculates the profit margin by using the existing revenue and cost fields.
C) Create a derived table that pre-calculates the profit margin for each product, and include it in the Looker model.
D) Create a new dimension that categorizes products based on their profit margin ranges (e.g., high, medium, low).

4. Your organization has highly sensitive data that gets updated once a day and is stored across multiple datasets in BigQuery. You need to provide a new data analyst access to query specific data in BigQuery while preventing access to sensitive dat a. What should you do?

A) Grant the data analyst the BigQuery Data Viewer IAM role in the Google Cloud project.
B) Create a new Google Cloud project, and copy the limited data into a BigQuery table. Grant the data analyst the BigQuery Data Owner IAM role in the new Google Cloud project.
C) Grant the data analyst the BigQuery Job User IAM role in the Google Cloud project.
D) Create a materialized view with the limited data in a new dataset. Grant the data analyst BigQuery Data Viewer IAM role in the dataset and the BigQuery Job User IAM role in the Google Cloud project.

5. You are designing a BigQuery data warehouse with a team of experienced SQL developers. You need to recommend a cost- effective, fully-managed, serverless solution to build ELT processes with SQL pipelines.
Your solution must include source code control, environment parameterization, and data quality checks. What should you do?

A) Use Cloud Composer to orchestrate and run data workflows.
B) Use Dataproc to run MapReduce jobs for distributed data processing.
C) Use Dataform to build, orchestrate, and monitor the pipelines.
D) Use Cloud Data Fusion to visually design and manage the pipelines.

Solutions: