๐ŸŽ„

CertoMetrics - 15% OFF Special Discount Offer - Ends In:

0d 00h 00m 00s
Coupon code: SALE2026

Google Cloud Certified - Associate Data Practitioner (PR000306)

Get full access to the updated question bank and confidently prepare for your exam.

Vendor

Google

Certification

Google Associate certification

Content

98 Qs

Status

Verified

Updated

1 day ago

Test the Practice Engine

Experience our interactive testing environment with free demo questions

Launch Free Demo
Best Value Bundle

Premium Bundle

Complete Success Suite

$83 $49

Save $34 Instantly

  • โœ“
    Full PDF + Interactive Engine Everything you need to pass
  • โœ“
    All Advanced Question Types Drag & Drop, Hotspots, Case Studies
  • โœ“
    Priority 24/7 Expert Support Direct line to certification leads
  • โœ“
    90 Days Free Priority Updates Stay current as exams change

Success Metric

98.4% Pass Rate

Verified by 15k+ Students
Secure Checkout
Popular

Standard Simulation

Practice Engine

$44

One-Time Payment

  • Web-Based (Zero Install)
  • Real Testing Environment Virtual & Practice Modes
  • Interactive Engine Drag & Drop, Hotspots
  • 60 Days Free Updates

Compatible with All Devices

Chrome
Verified Secure Checkout

Basic Tier

PDF Study Guide

$39

Digital Access

  • โœ“ Exam Questions (PDF)
  • โœ“ Mobile Friendly
  • โœ“ 60 Days Updates
Download Free Sample PDF

Verified 20-Question Preview (PR000306)

Secure Checkout

Verified Community

The CertoMetrics Standard.

Recommend the #1 platform for verified Google certification resources.

Success Network

Help a Colleague Succeed.

Invite a peer to get their own updated PR000306 prep kit.

Exam Overview

The Google Cloud Associate Data Practitioner certification stands as a pivotal credential for professionals aiming to demonstrate foundational proficiency in Google Cloud's robust data services. This certification validates your ability to ingest, store, process, and analyze data effectively within the Google Cloud ecosystem. Earning this badge signifies your readiness to contribute to data-driven initiatives, enabling organizations to extract valuable insights and make informed decisions. It enhances your professional credibility, opens doors to specialized data roles, and equips you with the practical skills demanded by today's data-intensive landscapes. This certification is a crucial step for anyone looking to build a career at the intersection of data and cloud technology.

Questions

50-60

Passing Score

700/1000

Duration

120 Minutes

Difficulty

Intermediate

Level

Associate

Skills Measured

Ingesting and Storing Data on Google Cloud
Processing and Transforming Data using Google Cloud Services
Analyzing and Visualizing Data for Insights
Building and Operating Data Pipelines
Ensuring Data Quality, Security, and Governance

Career Path

Target Roles

Data Analyst Junior Data Engineer Business Intelligence Developer

Common Questions

Is the material up to date?

Yes. We update our question bank weekly to match the latest Google standards. You get free updates for 90 days.

What format do I get?

You get instant access to both the **PDF** (for reading) and our **Premium Test Engine** (for exam simulation).

Is there a guarantee?

Absolutely. If you fail the PR000306 exam using our materials, we offer a full money-back guarantee.

When do I get the download?

Instantly. The download link is available in your dashboard immediately after payment is confirmed.

Free Study Guide Samples

Previewing updated PR000306 bank (20 Questions).

QUESTION 1

Your retail company wants to analyze customer reviews to understand sentiment and identify areas for improvement. Your company has a large dataset of customer feedback text stored in BigQuery that includes diverse language patterns, emojis, and slang. You want to build a solution to classify customer sentiment from the feedback text. What should you do?

A
Preprocess the text data in BigQuery using SQL functions. Export the processed data to AutoML Natural Language for model training and deployment.
B
Develop a custom sentiment analysis model using TensorFlow. Deploy it on a Compute Engine instance.
C
Use Dataproc to create a Spark cluster, perform text preprocessing using Spark NLP, and build a sentiment analysis model with Spark MLlib.
D
Export the raw data from BigQuery. Use AutoML Natural Language to train a custom sentiment analysis model.

Correct Option: D

โœ… Option D (Correct) Reasoning:Exporting raw data from BigQuery and using AutoML Natural Language allows it to directly learn from diverse text, including emojis and slang. AutoML NL is a managed service specifically designed for custom text classification, such as sentiment analysis, requiring minimal machine learning expertise and handling complex text patterns effectively.โŒ Why the other choices are incorrect:

Option A is incorrect: Preprocessing complex text with diverse language, emojis, and slang using only SQL functions in BigQuery is often insufficient for robust sentiment analysis. AutoML Natural Language is designed to learn from raw or minimally processed text to extract relevant features.

Option B is incorrect: Developing a custom TensorFlow model and deploying it on Compute Engine requires significant ML expertise, time, and infrastructure management, which is more complex than necessary when a managed service like AutoML Natural Language can achieve the goal more efficiently.

Option C is incorrect: Using Dataproc with Spark NLP and Spark MLlib introduces considerable operational overhead for cluster management and custom code development. While powerful, it's a more complex and resource-intensive solution compared to the managed and simplified approach offered by AutoML Natural Language for this use case.



Reference: https://cloud.google.com/natural-language/automl/docs
QUESTION 2

Your organization's website uses an on-premises MySQL as a backend database. You need to migrate the on-premises MySQL database to Google Cloud while maintaining MySQL features. You want to minimize administrative overhead and downtime. What should you do?

A
Use a Google-provided Dataflow template to replicate the MySQL database in BigOuery.
B
Install MySQL on a Compute Engine virtual machine. Export the database files using the mysqldump command. Upload the files to Cloud Storage, and import them into the MySQL instance on Compute Engine.
C
Use Database Migration Service to transfer the data to Cloud SQL for MySQL, and configure the on-premises MySQL database as the source.
D
Export the database tables to CSV files, and upload the files to Cloud Storage. Convert the MySQL schema to a Spanner schema, create a JSON manifest file, and run a Google-provided Dataflow template to load the data into Spanner.

Correct Option: C

โœ… Option C (Correct) Reasoning: Database Migration Service (DMS) facilitates migrating on-premises MySQL databases to Cloud SQL for MySQL with minimal downtime. It supports continuous replication, ensuring data consistency during the migration while maintaining native MySQL features on a fully managed service, which reduces administrative overhead.โŒ Why the other choices are incorrect:

Option A is incorrect: BigQuery is an analytical data warehouse, not a transactional relational database. Replicating to BigQuery would not maintain MySQL features for a website's backend and is unsuitable for operational data.

Option B is incorrect: Installing MySQL on Compute Engine and performing a manual mysqldump/import is a valid approach but incurs significant administrative overhead and potential downtime compared to using a managed migration service.

Option D is incorrect: Migrating to Spanner requires converting the MySQL schema and likely refactoring the application, as Spanner has distinct features and a different SQL dialect. This does not maintain native MySQL features and involves high administrative effort.



Reference: https://cloud.google.com/database-migration/docs/mysql
QUESTION 3

Your company wants to implement a data transformation (ETL) pipeline for their BigQuery data warehouse. You need to identify a managed transformation solution that allows users to develop with SQL and JavaScript, has version control, allows for modular code, and has data quality checks. What should you do?

A
Use Dataform to define the transformations in SQLX.
B
Use Dataproc to create an Apache Spark cluster and implement the transformations by using PySpark SQL.
C
Create a Cloud Composer environment, and orchestrate the transformations by using the BigQueryInsertJob operator.
D
Create BigQuery scheduled queries to define the transformations in SQL.

Correct Option: A

โœ… Option A (Correct) Reasoning: Dataform is a managed service purpose-built for data transformation in BigQuery. It enables development using SQLX (SQL with JavaScript for templating), offers native Git-based version control, promotes modular code through views and tables, and includes assertions for data quality checks.โŒ Why the other choices are incorrect:

Option B is incorrect: Dataproc uses Apache Spark, primarily with PySpark (Python), Scala, or Java, not direct SQL and JavaScript for transformation definitions, and requires cluster management.

Option C is incorrect: Cloud Composer is an orchestration service; it triggers jobs but does not provide a transformation development environment with SQL/JavaScript, modularity, or built-in data quality features.

Option D is incorrect: BigQuery scheduled queries support SQL but lack integrated version control, modularity features, dedicated data quality checks, and JavaScript support for transformation logic.



Reference: https://cloud.google.com/dataform/docs/overview
QUESTION 4

You created a curated dataset of market trends in BigQuery that you want to share with multiple external partners. You want to control the rows and columns that each partner has access to. You want to follow Google-recommended practices. What should you do?

A
Publish the dataset in Analytics Hub. Grant dataset-level access to each partner by using subscriptions.
B
Grant each partner read access to the BigQuery dataset by using IAM roles.
C
Create a separate Cloud Storage bucket for each partner. Export the dataset to each bucket and assign each partner to their respective bucket. Grant bucketlevel access by using IAM roles.
D
Create a separate project for each partner and copy the dataset into each project. Publish each dataset in Analytics Hub. Grant dataset-level access to each partner by using subscriptions.

Correct Option: A

โœ… Option A (Correct) Reasoning: Analytics Hub is designed for secure and managed data exchange with external partners. By publishing the BigQuery dataset (or an authorized view of it) in Analytics Hub, you can use subscriptions to grant access. BigQuery supports row-level and column-level security or authorized views to precisely control the data (rows and columns) each partner can access, adhering to Google-recommended practices for fine-grained data sharing.โŒ Why the other choices are incorrect:

Option B is incorrect: Granting read access via IAM roles to the entire BigQuery dataset does not inherently provide row-level or column-level access control. This approach would expose the entire dataset to each partner.

Option C is incorrect: Exporting data to separate Cloud Storage buckets creates data duplication, increases management overhead, and loses BigQuery's native querying capabilities. It's not a dynamic solution for granular access control.

Option D is incorrect: Creating separate projects and copying datasets for each partner is inefficient, leads to significant data redundancy, and complicates data governance. Analytics Hub aims to avoid such duplication.



Reference: https://cloud.google.com/analytics-hub/docs/exchange-data
QUESTION 5

You want to build a model to predict the likelihood of a customer clicking on an online advertisement. You have historical data in BigQuery that includes features such as user demographic, ad placement, and previous click behavior. After training the model, you want to generate predictions on new data. Which model type should you use in BigQuery ML?

A
Linear regression
B
Matrix factorization
C
Logistic regression
D
K-means clustering

Correct Option: C

โœ… Option C (Correct) Reasoning: Logistic regression is the appropriate model for binary classification tasks, such as predicting the likelihood or probability of a customer clicking an online advertisement (a binary outcome of click or no click). BigQuery ML provides the LOGISTIC_REG model type for this purpose.โŒ Why the other choices are incorrect:

Option A is incorrect: Linear regression is used for predicting continuous numerical values, not for binary outcomes or probabilities of a specific event.

Option B is incorrect: Matrix factorization is typically used for recommendation systems to predict user preferences or ratings, not for direct binary classification of ad clicks.

Option D is incorrect: K-means clustering is an unsupervised learning algorithm used for grouping similar data points into clusters. It is not used for predictive modeling or classification.



Reference: https://cloud.google.com/bigquery-ml/docs/reference/standard-sql/bigqueryml-syntax-create#model_type
QUESTION 6

You work for a gaming company that collects real-time player activity data. This data is streamed into Pub/Sub and needs to be processed and loaded into BigQuery for analysis. The processing involves filtering, enriching, and aggregating the data before loading it into partitioned BigQuery tables. You need to design a pipeline that ensures low latency and high throughput while following a Google-recommended approach. What should you do?

A
Use Cloud Composer to orchestrate a workflow that reads the data from Pub/Sub, processes the data using a Python script, and writes it to BigQuery.
B
Use Dataflow to create a streaming pipeline that reads the data from Pub/Sub, processes the data, and writes it to BigQuery using the streaming API.
C
Use Dataproc to create an Apache Spark streaming job that reads the data from Pub/Sub, processes the data, and writes it to BigQuery.
D
Use Cloud Run functions to subscribe to the Pub/Sub topic, process the data, and write it to BigQuery using the streaming API.

Correct Option: B

โœ… Option B (Correct) Reasoning: Dataflow is a fully managed, serverless service ideal for streaming data processing with low latency and high throughput. It integrates seamlessly with Pub/Sub for input and BigQuery for output, making it the Google-recommended approach for real-time ETL operations involving filtering, enriching, and aggregating data.โŒ Why the other choices are incorrect:

Option A is incorrect: Cloud Composer is an orchestration service for workflows, primarily batch processing, not designed for real-time streaming data processing directly from Pub/Sub with low latency and high throughput.

Option C is incorrect: While Dataproc can run Spark streaming, Dataflow provides a more fully managed, serverless experience for streaming ETL, which is generally preferred and Google-recommended for these requirements.

Option D is incorrect: Cloud Run functions are suitable for event-driven, stateless processing. For continuous, high-throughput, and potentially stateful aggregations, a dedicated streaming service like Dataflow is more robust and efficient.



Reference: https://cloud.google.com/dataflow/docs/guides/streaming-pipeline
QUESTION 7

Your organization consists of two hundred employees on five different teams. The leadership team is concerned that any employee can move or delete all Looker dashboards saved in the Shared folder. You need to create an easy-to-manage solution that allows the five different teams in your organization to view content in the Shared folder, but only be able to move or delete their team-specific dashboard. What should you do?

A
1. Create Looker groups representing each of the five different teams, and add users to their corresponding group.2. Create five subfolders inside the Shared folder. Grant each group the View access level to their corresponding subfolder.
B
1. Change the access level of the Shared folder to View for the All Users group.2. Create five subfolders inside the Shared folder. Grant each team member the Manage Access, Edit access level to their corresponding subfolder.
C
1. Change the access level of the Shared folder to View for the All Users group.2. Create Looker groups representing each of the five different teams, and add users to their corresponding group.3. Create five subfolders inside the Shared folder. Grant each group the Manage Access, Edit access level to their corresponding subfolder.
D
1. Move all team-specific content into the dashboard owner's personal folder.2. Change the access level of the Shared folder to View for the All Users group.3. Instruct each user to create content for their team in the user's personal folder.

Correct Option: C

โœ… Option C (Correct) Reasoning: Changing the Shared folder's access to View for All Users allows everyone to see all content. Creating Looker groups for each team and assigning them 'Manage Access, Edit' permission to their specific subfolders within the Shared folder allows teams to manage (move/delete) only their dashboards, ensuring an easy-to-manage solution. โŒ Why the other choices are incorrect:

Option A is incorrect: Granting only 'View' access to subfolders prevents teams from moving or deleting their team-specific dashboards, failing a key requirement.

Option B is incorrect: Granting 'Manage Access, Edit' to 'each team member' individually is not an 'easy-to-manage solution' for a large organization, contradicting the prompt.

Option D is incorrect: Moving team-specific content to individual personal folders defeats the purpose of collaborative management within a shared folder structure and makes team content harder to find and manage centrally.



Reference: https://cloud.google.com/looker/docs/access-control#folder_access_levels
QUESTION 8

You are working with a small dataset in Cloud Storage that needs to be transformed and loaded into BigQuery for analysis. The transformation involves simple filtering and aggregation operations. You want to use the most efficient and cost-effective data manipulation approach. What should you do?

A
Use Dataproc to create an Apache Hadoop cluster, perform the ETL process using Apache Spark, and load the results into BigQuery.
B
Use BigQuery's SQL capabilities to load the data from Cloud Storage, transform if, and store the results in a new BigQuery table.
C
Create a Cloud Data Fusion instance and visually design an ETL pipeline that reads data from Cloud Storage, transforms it using built-transformations, and load the result into BigQuery.
D
Use Dataflow to perform the ETL process that reads the data from Cloud Storage, transforms it using Apache Beam, and writes the results to BigQuery.

Correct Option: B

โœ… Option B (Correct) Reasoning: BigQuery can directly query or load data from Cloud Storage. Its powerful SQL engine efficiently performs simple filtering and aggregation. This serverless approach is highly cost-effective and efficient for small datasets and straightforward transformations, avoiding additional service overhead.

โŒ Why the other choices are incorrect:


Option A is incorrect: Dataproc with Spark is for large-scale, complex data processing. For a small dataset and simple transformations, it introduces unnecessary cluster management, operational overhead, and higher costs.

Option C is incorrect: Cloud Data Fusion is a visual ETL tool for complex, enterprise-grade pipelines. For simple filtering and aggregation on a small dataset, setting up and running a Data Fusion instance is overkill, adding disproportionate complexity and cost.

Option D is incorrect: Dataflow is excellent for scalable batch/stream processing with Apache Beam. For simple transformations on a small dataset, it involves more configuration and potentially higher costs than directly using BigQuery SQL, which is optimized for in-database transformations.



Reference: https://cloud.google.com/bigquery/docs/loading-data-cloud-storage
QUESTION 9

You have a Cloud SQL for PostgreSQL database that stores sensitive historical financial data. You need to ensure that the data is uncorrupted and recoverable in the event that the primary region is destroyed. The data is valuable, so you need to prioritize recovery point objective (RPO) over recovery time objective (RTO). You want to recommend a solution that minimizes latency for primary read and write operations. What should you do?

A
Configure the Cloud SQL for PostgreSQL instance for multi-region backup locations.
B
Configure the Cloud SQL for PostgreSQL instance for regional availability (HA) with synchronous replication to a secondary instance in a different zone.
C
Configure the Cloud SQL for PostgreSQL instance for regional availability (HA) with asynchronous replication to a secondary instance in a different region.
D
Configure the Cloud SQL for PostgreSQL instance for regional availability (HA). Back up the Cloud SQL for PostgreSQL database hourly to a Cloud Storage bucket in a different region.

Correct Option: C

โœ… Option C (Correct) Reasoning: Configuring Cloud SQL with asynchronous replication to a secondary instance (read replica) in a different region effectively protects against a primary region's destruction. Asynchronous replication ensures primary write operations are not delayed by cross-region latency, thus minimizing latency. It also provides a significantly lower Recovery Point Objective (RPO) than hourly backups, aligning with the prioritization of RPO over RTO.โŒ Why the other choices are incorrect:

Option A is incorrect: Multi-region backups offer disaster recovery but typically have a higher RPO (data loss) than replication, as they are point-in-time snapshots, not continuous.

Option B is incorrect: Synchronous replication to a different the same region provides High Availability (HA) against but does not protect against the destruction of the entire primary region.

Option D is incorrect: While regional availability (HA) protects against , hourly backups to a different region result in an RPO of up to one hour, which does not strongly prioritize RPO over RTO for sensitive data compared to asynchronous replication.



Reference: https://cloud.google.com/sql/docs/postgres/replication/configure-read-replicas#cross-region-replication
QUESTION 10

You are working on a project that requires analyzing dally social media data. You have 100 GB of JSON formatted data stored in Cloud Storage that keeps growing. You need to transform and load this data into BigQuery for analysis. You want to follow the Google-recommended approach. What should you do?

A
Use Cloud Data Fusion to transfer the data into BigOuery raw tables, and use SQL to transform it.
B
Use Dataflow to transform the data and write the transformed data to BigQuery.
C
Manually download the data from Cloud Storage. Use a Python script to transform and upload the data into BigQuery.
D
Use Cloud Run functions to transform and load the data into BigOuery.

Correct Option: B

โœ… Option B (Correct) Reasoning: Dataflow is a fully managed service for executing Apache Beam pipelines, ideal for large-scale batch and stream data processing, including ETL. It efficiently transforms growing daily JSON data from Cloud Storage and loads it into BigQuery, following a Google-recommended scalable approach.โŒ Why the other choices are incorrect:

Option A is incorrect: While Cloud Data Fusion can orchestrate ELT pipelines, Dataflow is generally the more direct and robust choice for custom, scalable data transformations for large, growing datasets before loading into BigQuery.

Option C is incorrect: Manually downloading and using a local Python script is not scalable, automated, or resilient for 100 GB of daily, growing data. This approach is not Google-recommended for production workloads.

Option D is incorrect: Cloud Run is better suited for event-driven microservices or web applications. Transforming 100 GB of daily data in a single Cloud Run function would likely exceed execution limits or require complex, non-standard orchestration, making it less suitable than Dataflow for this scale of batch processing.



Reference: https://cloud.google.com/dataflow/docs
QUESTION 11

You manage an ecommerce website that has a diverse range of product. You need to forecast future product demand accurately to ensure that your company has sufficient inventory to meet customer needs and avoid stockouts. Your company's historical sales data is stored in BigQuery table. You need to create a scalable solution that takes into account the seasonality and historical data to predict product demand. What should you do?

A
Use the historical sales data to train and create a BigQueryML time series model. Use the ML.FORECAST function call to output the predictions into a new BigQuery table.
B
Use Colab Enterprise to create a Jupyter notebook. Use the historical sales data to train a custom prediction model in Python.
C
Use the historical sales data to train and create a BigQueryML linear regression model. Use the ML.PREDICT function call to output the predictions into a new BigQuery table.
D
Use the historical sales data to train and create a BigQueryML logistic regression model. Use the ML.PREDICT function call to output the predictions into a new BigQuery table.

Premium Solution Locked

Unlock all 98 answers & explanations

QUESTION 12

Your company stores historical data in Cloud Storage. You need to ensure that all data is saved in a bucket for at least three years. What should you do?

A
Set temporary object holds.
B
Set a bucket retention policy.
C
Change the bucket storage class to Archive.
D
Enable Object Versioning.

Premium Solution Locked

Unlock all 98 answers & explanations

QUESTION 13

You need to transfer approximately 300 TB of data from your company's on-premises data center to Cloud Storage. You have 100 Mbps internet bandwidth, and the transfer needs to be completed as quickly as possible. What should you do?

A
Use Cloud Client Libraries to transfer the data over the internet.
B
Compress the data, upload it to multiple cloud storage providers, and then transfer the data to Cloud Storage.
C
Request a Transfer Appliance, copy the data to the appliance, and ship it back to Google.
D
Use the gcloud storage command to transfer the data over the internet.

Premium Solution Locked

Unlock all 98 answers & explanations

QUESTION 14

Your team uses Google Sheets to track budget data that is updated daily. The team wants to compare budget data against actual cost data, which is stored in a BigQuery table. You need to create a solution that calculates the difference between each day's budget and actual costs. You want to ensure that your team has access to daily-updated results in Google Sheets. What should you do?

A
Download the budget data as a CSV file and upload the CSV file to a Cloud Storage bucket. Create a new BigQuery table from Cloud Storage, and join the actual cost table with it. Open the joined BigOuery table by using Connected Sheets.
B
Create a BigQuery external table by using the Drive URI of the Google sheet, and join the actual cost table with it. Save the joined table, and open it by using Connected Sheets.
C
Download the budget data as a CSV file, and upload the CSV file to create a new BigQuery table. Join the actual cost table with the new BigQuery table, and save the results as a CSV file. Open the CSV file in Google Sheets.
D
Create a BigQuery external table by using the Drive URI of the Google sheet, and join the actual cost table with it. Save the joined table as a CSV file and open the file in Google Sheets.

Premium Solution Locked

Unlock all 98 answers & explanations

QUESTION 15

Your organization is conducting analysis on regional sales metrics. Data from each regional sales team is stored as separate tables in BigQuery and updated monthly. You need to create a solution that identifies the top three regions with the highest monthly sales for the next three months. You want the solution to automatically provide up-to-date results. What should you do?

A
Create a BigQuery table that performs a UNION across all of the regional sales tables. Use the ROW_NUMBER() window function to query the new table.
B
Create a BigQuery table that performs a CROSS JOIN across all of the regional sales tables. Use the RANK( ) window function to query the new table.
C
Create a BigQuery materialized view that performs a UNION across all of the regional sales tables. Use the RANK() window function to query the new materialized view.
D
Create a BigQuery materialized view that performs a CROSS JOIN across all of the regional sales tables. Use the ROW_NUMBER() window function to query the new materialized view.

Premium Solution Locked

Unlock all 98 answers & explanations

QUESTION 16

You work for a healthcare company. You have a daily ETL pipeline that extracts patient data from a legacy system, transforms it, and loads it into BigQuery for analysis. The pipeline currently runs manually using a shell script. You want to automate this process and add monitoring to ensure pipeline observability and troubleshooting insights. You want one centralized solution, using open-source tooling, without rewriting the ETL code. What should you do?

A
Create a Cloud Run function that runs the pipeline daily. Monitor the function's execution using Cloud Monitoring.
B
Configure Cloud Dataflow to implement the ETL pipeline, and use Cloud Scheduler to trigger the Dataflow pipeline daily. Monitor the pipeline's execution using the Dataflow job monitoring interface and Cloud Monitoring.
C
Use Cloud Scheduler to trigger a Dataproc job to execute the pipeline daily. Monitor the job's progress using the Dataproc job web interface and CloudMonitoring.
D
Create a direct acyclic graph (DAG) in Cloud Composer to orchestrate a pipeline trigger daily. Monitor the pipeline's execution using the Apache Airflow web interface and Cloud Monitoring.

Premium Solution Locked

Unlock all 98 answers & explanations

QUESTION 17

You have an existing weekly Storage Transfer Service transfer job from Amazon S3 to a Nearline Cloud Storage bucket in Google Cloud. Each week, the job moves a large number of relatively small files. As the number of files to be transferred each week has grown over time, you are at risk of no longer completing the transfer in the allocated time frame. You need to decrease the total transfer time by replacing the process. Your solution should minimize costs where possible. What should you do?

A
Create parallel transfer jobs using include and exclude prefixes.
B
Create a transfer job using the Google Cloud CLI, and specify the Standard storage class with the --custom-storage-class flag.
C
Create a batch Dataflow job that is scheduled weekly to migrate the data from Amazon S3 to Cloud Storage.
D
Create an agent-based transfer job that utilizes multiple transfer agents on Compute Engine instances.

Premium Solution Locked

Unlock all 98 answers & explanations

QUESTION 18

Your company has an on-premises file server with 5 TB of data that needs to be migrated to Google Cloud. The network operations team has mandated that you can only use up to 250 Mbps of the total available bandwidth for the migration. You need to perform an online migration to Cloud Storage. What should you do?

A
Use the gcloud storage cp command to copy all files from on-premises to Cloud Storage using the --daisy-chain option.
B
Use Storage Transfer Service to configure an agent-based transfer. Set the appropriate bandwidth limit for the agent pool.
C
Request a Transfer Appliance, copy the data to the appliance, and ship it back to Google Cloud.
D
Use the gcloud storage cp command to copy all files from on-premises to Cloud Storage using the --no-clobber option.

Premium Solution Locked

Unlock all 98 answers & explanations

QUESTION 19

You manage data at an ecommerce company. You have a Dataflow pipeline that processes order data from Pub/Sub, enriches the data with product information from Bigtable, and writes the processed data to BigQuery for analysis. The pipeline runs continuously and processes thousands of orders every minute. You need to monitor the pipeline's performance and be alerted if errors occur. What should you do?

A
Use Cloud Logging to view the pipeline logs and check for errors. Set up alerts based on specific keywords in the logs.
B
Use the Dataflow job monitoring interface to visually inspect the pipeline graph, check for errors, and configure notifications when critical errors occur.
C
Use Cloud Monitoring to track key metrics. Create alerting policies in Cloud Monitoring to trigger notifications when metrics exceed thresholds or when errors occur.
D
Use BigQuery to analyze the processed data in Cloud Storage and identify anomalies or inconsistencies. Set up scheduled alerts based when anomalies or inconsistencies occur.

Premium Solution Locked

Unlock all 98 answers & explanations

QUESTION 20

Your company is setting up an enterprise business intelligence platform. You need to limit data access between many different teams while following the Google-recommended approach. What should you do first?

A
Create a separate Looker Studio report for each team, and share each report with the individual within each team.
B
Create one Looker Studio report with multiple pages, and add each team's data as a separate data source to the report.
C
Create a Looker (Google Cloud core) instance, and create a separate dashboard for each team.
D
Create a Looker (Google Cloud core) instance, and configure different Looker groups for each team.

Premium Solution Locked

Unlock all 98 answers & explanations

Full Question Bank Locked

You have reached the end of the free study guide preview. Upgrade now to unlock all 98 questions and the full simulation engine.

Customer Reviews

5 / 5
(15,000+ verified)
5
100%
4
0%
3
0%
2
0%
1
0%

Global Community Feedback

DM

David M.

Verified Student

"The practice engine is incredible. It feels exactly like the real testing environment and helped me build so much confidence."

SJ

Sarah J.

Premium Member

"The PDF is very well organized and the explanations for the answers are actually helpful, not just random text."

MC

Michael C.

Verified Buyer

"I was skeptical, but the content is high quality and definitely worth the price. I passed on my first try!"

Need Assistance?

> Our expert support team is available to assist you with any inquiries about our exam materials.

Contact Support
Average response: < 24 Hours

Get Exam Updates

> Subscribe to receive instant notifications on new questions and exclusive flash sales.

* Join 5,000+ students getting weekly updates

Support Chat โ— Active Now

๐Ÿ‘‹ Hi! How can we help you pass your exam?

Enter email to start chatting