Free Google ADP Exam Dumps Questions & Answers

You are developing a data ingestion pipeline to load small CSV files into BigQuery from Cloud Storage. You want to load these files upon arrival to minimize data latency. You want to accomplish this with minimal cost and maintenance. What should you do?

• A.  Create a Cloud Composer pipeline to load new files from Cloud Storage to BigQuery and schedule it to run every 10 minutes.
• B.  Use the bq command-line tool within a Cloud Shell instance to load the data into BigQuery.
• C.  Create a Cloud Run function to load the data into BigQuery that is triggered when data arrives in Cloud Storage.
• D.  Create a Dataproc cluster to pull CSV files from Cloud Storage, process them using Spark, and write the results to BigQuery.

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.  Compress the data, upload it to multiple cloud storage providers, and then transfer the data to CloudStorage.
• B.  Use the gcloud storage command to transfer the data over the internet.
• C.  Request a Transfer Appliance, copy the data to the appliance, and ship it back to Google.
• D.  Use Cloud Client Libraries to transfer the data over the internet.

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?

• A.  Create five different Explores with thesql_always_filterExplore filter applied on theregion_namedimension. Set eachregion_namevalue to the corresponding region for each manager.
• B.  Add anaccess_filterExplore filter on theregion_namedimension by using thesales_regionuser attribute.
• C.  Create separate Looker dashboards for each regional manager. Set the default dashboard filter to the corresponding region for each manager.
• D.  Create asales_regionuser attribute, and assign each manager's region as the value of their user attribute.

Your organization has decided to move their on-premises Apache Spark-based workload to Google Cloud.
You want to be able to manage the code without needing to provision and manage your own cluster. What should you do?

• A.  Configure a Google Kubernetes Engine cluster with Spark operators, and deploy the Spark jobs.
• B.  Migrate the Spark jobs to Dataproc Serverless.
• C.  Migrate the Spark jobs to Dataproc on Compute Engine.
• D.  Migrate the Spark jobs to Dataproc on Google Kubernetes Engine.

Your organization uses a BigQuery table that is partitioned by ingestion time. You need to remove data that is older than one year to reduce your organization's storage costs. You want to use the most efficient approach while minimizing cost. What should you do?

• A.  Create a scheduled query that periodically runs an update statement in SQL that sets the "deleted" column to "yes" for data that is more than one year old. Create a view that filters out rows that have been marked deleted.
• B.  Require users to specify a partition filter using the alter table statement in SQL.
• C.  Set the table partition expiration period to one year using the ALTER TABLE statement in SQL.
• D.  Create a view that filters out rows that are older than one year.