Associate Data Practitioner Free Practice Questions — Page 3
Question 15
You manage a large amount of data in Cloud Storage, including raw data, processed data, and backups. Your organization is subject to strict compliance regulations that mandate data immutability for specific data types. You want to use an efficient process to reduce storage costs while ensuring that your storage strategy meets retention requirements. What should you do?
A. Configure lifecycle management rules to transition objects to appropriate storage classes based on access patterns. Set up Object Versioning for all objects to meet immutability requirements.
B. Move objects to different storage classes based on their age and access patterns. Use Cloud Key Management Service (Cloud KMS) to encrypt specific objects with customer-managed encryption keys (CMEK) to meet immutability requirements.
C. Create a Cloud Run function to periodically check object metadata, and move objects to the appropriate storage class based on age and access patterns. Use object holds to enforce immutability for specific objects.
D. Use object holds to enforce immutability for specific objects, and configure lifecycle management rules to transition objects to appropriate storage classes based on age and access patterns.
Show Answer
Correct Answer: D
Explanation: Use object holds to prevent deletion of the specific objects that must be retained, and lifecycle management rules to transition objects to lower-cost storage classes as they age or become less frequently accessed. Versioning supports recovery rather than immutability, and CMEK provides encryption rather than retention enforcement.
Question 16
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. Create a derived table that pre-calculates the profit margin for each product, and include it in the Looker model.
B. Define a new measure that calculates the profit margin by using the existing revenue and cost fields.
C. Create a new dimension that categorizes products based on their profit margin ranges (e.g., high, medium, low).
D. Apply a filter to only show products with a positive profit margin.
Show Answer
Correct Answer: B
Explanation: Define a LookML measure for profit margin using the existing revenue and cost fields. Measures let Looker calculate the metric in queries for each product, making this faster and more efficient than building a derived table. A category dimension or filter would not calculate the margin.
Question 17
Your company uses Looker to visualize and analyze sales data. You need to create a dashboard that displays sales metrics, such as sales by region, product category, and time period. Each metric relies on its own set of attributes distributed across several tables. You need to provide users the ability to filter the data by specific sales representatives and view individual transactions. You want to follow the Google-recommended approach. What should you do?
A. Create multiple Explores, each focusing on each sales metric. Link the Explores together in a dashboard using drill-down functionality.
B. Use BigQuery to create multiple materialized views, each focusing on a specific sales metric. Build the dashboard using these views.
C. Create a single Explore with all sales metrics. Build the dashboard using this Explore.
D. Use Looker's custom visualization capabilities to create a single visualization that displays all the sales metrics with filtering and drill-down functionality.
Show Answer
Correct Answer: C
Explanation: Create a single Explore that joins the relevant sales tables and includes the fields needed for each metric. Building the dashboard from that Explore lets users apply a shared sales-representative filter and drill into individual transactions.
Question 18
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 data. What should you do?
A. Grant the data analyst the BigQuery Job User IAM role in the Google Cloud project.
B. 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.
C. 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.
D. Grant the data analyst the BigQuery Data Viewer IAM role in the Google Cloud project.
Show Answer
Correct Answer: B
Explanation: Create a materialized view that exposes only the data the analyst is permitted to query, and place it in a separate dataset. Grant BigQuery Data Viewer on that dataset and BigQuery Job User on the project so the analyst can query the view without receiving access to the sensitive source datasets.
Question 19
You are a database administrator managing sales transaction data by region stored in a BigQuery table. You need to ensure that each sales representative can only see the transactions in their region. What should you do?
A. Add a policy tag in BigQuery.
B. Create a row-level access policy.
C. Create a data masking rule.
D. Grant the appropriate IAM permissions on the dataset.
Show Answer
Correct Answer: B
Explanation: Create a row-level access policy to filter the table so each sales representative can see only transactions for their region. Policy tags control access to columns, masking obscures values, and dataset IAM permissions do not filter individual rows.
Question 20
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.
Show Answer
Correct Answer: D
Explanation: Create an object table. BigQuery object tables represent unstructured files stored in Cloud Storage and expose their metadata and object references for querying and use in BigQuery ML.
Question 21
You created a customer support application that sends several forms of data to Google Cloud. Your application is sending:
1. Audio files from phone interactions with support agents that will be accessed during trainings.
2. CSV files of users’ personally identifiable information (Pll) that will be analyzed with SQL.
3. A large volume of small document files that will power other applications.
You need to select the appropriate tool for each data type given the required use case, while following Google-recommended practices. Which should you choose?
A. 1. Cloud Storage 2. CloudSQL for PostgreSQL 3. Bigtable
B. 1. Filestore 2. Cloud SQL for PostgreSQL 3. Datastore
C. 1. Cloud Storage 2. BigQuery 3. Firestore
D. 1. Filestore 2. Bigtable 3. BigQuery
Show Answer
Correct Answer: C
Explanation: Cloud Storage is suited to storing audio files. BigQuery supports SQL analysis of CSV data, and Firestore is a document database suited to application data stored as many small documents.
Question 22
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 data. 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.
Show Answer
Correct Answer: C
Explanation: Database Migration Service supports migrating MySQL databases to Cloud SQL for MySQL and can continuously replicate changes after the initial load. This helps preserve data integrity and reduce downtime during cutover, while avoiding the custom pipeline or file-based export steps in the other options.
Question 23
You work for a global financial services company that trades stocks 24/7. You have a Cloud SGL for PostgreSQL user database. You need to identify a solution that ensures that the database is continuously operational, minimizes downtime, and will not lose any data in the event of a zonal outage. What should you do?
A. Continuously back up the Cloud SGL instance to Cloud Storage. Create a Compute Engine instance with PostgreSCL in a different region. Restore the backup in the Compute Engine instance if a failure occurs.
B. Create a read replica in another region. Promote the replica to primary if a failure occurs.
C. Configure and create a high-availability Cloud SQL instance with the primary instance in zone A and a secondary instance in any zone other than zone A.
D. Create a read replica in the same region but in a different zone.
Show Answer
Correct Answer: C
Explanation: Configure a high-availability Cloud SQL instance with its primary and standby in different zones. Cloud SQL can automatically fail over to the standby during a zonal outage, minimizing downtime while synchronous replication helps prevent data loss. Backups and read replicas require restore or promotion and do not provide the same automatic HA failover.
Question 24
Your team uses the Google Ads platform to visualize metrics. You want to export the data to BigQuery to get more granular insights. You need to execute a one-time transfer of historical data and automatically update data daily. You want a solution that is low-code, serverless, and requires minimal maintenance. What should you do?
A. Export the historical data to BigQuery by using BigQuery Data Transfer Service. Use Cloud Composer for daily automation.
B. Export the historical data to Cloud Storage by using Storage Transfer Service. Use Pub/Sub to trigger a Dataflow template that loads data for daily automation.
C. Export the historical data as a CSV file. Import the file into BigQuery for analysis. Use Cloud Composer for daily automation.
D. Export the historical data to BigQuery by using BigQuery Data Transfer Service. Use BigQuery Data Transfer Service for daily automation.
Show Answer
Correct Answer: D
Explanation: BigQuery Data Transfer Service supports Google Ads transfers directly to BigQuery and can run on a recurring daily schedule. It provides a managed, serverless way to load historical data and keep it updated without adding orchestration services.
$19
Get all 90 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.