Associate Data Practitioner Practice Test

Associate Data Practitioner Practice Test practice questions, page 4 of 4, with answer review and explanations.

Question 16

You have created a LookML model and dashboard that shows daily sales metrics for five regional managers to use. You want to ensure that the regional managers can only see sales metrics specific to their region. You need an easy-to-implement solution. What should you do?

  1. Create a sales_region user attribute, and assign each manager’s region as the value of their user attribute. Add an access_filter Explore filter on the region_name dimension by using the sales_region user attribute.
  2. Create five different Explores with the sql_always_filter Explore filter applied on the region_name dimension. Set each region_name value to the corresponding region for each manager.
  3. Create separate Looker dashboards for each regional manager. Set the default dashboard filter to the corresponding region for each manager.
  4. Create separate Looker instances for each regional manager. Copy the LookML model and dashboard to each instance. Provision viewer access to the corresponding manager.

Question 17

You need to design a data pipeline that ingests data from CSV, Avro, and Parquet files into Cloud Storage. The data includes raw user input. You need to remove all malicious SQL injections before storing the data in BigQuery. Which data manipulation methodology should you choose?

  1. EL
  2. ELT
  3. ETL
  4. ETLT

Question 18

You are working with a large dataset of customer reviews stored in Cloud Storage. The dataset contains several inconsistencies, such as missing values, incorrect data types, and duplicate entries. You need to clean the data to ensure that it is accurate and consistent before using it for analysis. What should you do?

  1. Use the PythonOperator in Cloud Composer to clean the data and load it into BigQuery. Use SQL for analysis.
  2. Use BigQuery to batch load the data into BigQuery. Use SQL for cleaning and analysis.
  3. Use Storage Transfer Service to move the data to a different Cloud Storage bucket. Use event triggers to invoke Cloud Run functions to load the data into BigQuery. Use SQL for analysis.
  4. Use Cloud Run functions to clean the data and load it into BigQuery. Use SQL for analysis.

Question 19

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?

  1. Use Google-managed encryption keys (GMEK).
  2. Use customer-managed encryption keys (CMEK).
  3. Use customer-supplied encryption keys (CSEK).
  4. Use customer-supplied encryption keys (CSEK) for the sensitive data and customer-managed encryption keys (CMEK) for the less sensitive data.

Question 20

You work for a financial organization that stores transaction data in BigQuery. Your organization has a regulatory requirement to retain data for a minimum of seven years for auditing purposes. You need to ensure that the data is retained for seven years using an efficient and cost-optimized approach. What should you do?

  1. Create a partition by transaction date, and set the partition expiration policy to seven years.
  2. Set the table-level retention policy in BigQuery to seven years.
  3. Set the dataset-level retention policy in BigQuery to seven years.
  4. Export the BigQuery tables to Cloud Storage daily, and enforce a lifecycle management policy that has a seven-year retention rule.