Online Access Free ADP Exam Questions

Following a recent company acquisition, you inherited an on- premises data infrastructure that needs to move to Google Cloud. The acquired system has 250 Apache Airflow directed acyclic graphs (DAGs) orchestrating data pipelines. You need to migrate the pipelines to a Google Cloud managed service with minimal effort. What should you do?

• A.Convert each DAG to a Cloud Workflow and automate the execution with Cloud Scheduler.
• B.Create a Cloud Data Fusion instance. For each DAG, create a Cloud Data Fusion pipeline.
• C.Create a Google Kubernetes Engine (GKE) standard cluster and deploy Airflow as a workload. Migrate all DAGs to the new Airflow environment.
• D.Create a new Cloud Composer environment and copy DAGS to the Cloud Composer dags/folder.

Your organization needs to store historical customer order dat
a. The data will only be accessed once a month for analysis and must be readily available within a few seconds when it is accessed. You need to choose a storage class that minimizes storage costs while ensuring that the data can be retrieved quickly. What should you do?

• A.Store the data in Cloud Storage using Nearline storage.
• B.Store the data in Cloud Storage using Archive storage.
• C.Store the data in Cloud Storage using Standard storage.
• D.Store the data in Cloud Storage using Coldline storage.

Your company currently uses an on-premises network file system (NFS) and is migrating data to Google Cloud. You want to be able to control how much bandwidth is used by the data migration while capturing detailed reporting on the migration status. What should you do?

• A.Use a Transfer Appliance.
• B.Use gcloud storage commands.
• C.Use Cloud Storage FUSE.
• D.Use Storage Transfer Service.

Your company is building a near real-time streaming pipeline to process JSON telemetry data from small appliances. You need to process messages arriving at a Pub/Sub topic, capitalize letters in the serial number field, and write results to BigQuery. You want to use a managed service and write a minimal amount of code for underlying transformations. What should you do?

• A.Use a Pub/Sub to BigQuery subscription, write results directly to BigQuery, and schedule a transformation query to run every five minutes.
• B.Use the "Pub/Sub to BigQuery" Dataflow template with a UDF, and write the results to BigQuery.
• C.Use a Pub/Sub push subscription, write a Cloud Run service that accepts the messages, performs the transformations, and writes the results to BigQuery.
• D.Use a Pub/Sub to Cloud Storage subscription, write a Cloud Run service that is triggered when objects arrive in the bucket, performs the transformations, and writes the results to BigQuery.

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.Require users to specify a partition filter using the alter table statement in SQL.
• B.Set the table partition expiration period to one year using the ALTER TABLE statement in SQL.
• C.Create a view that filters out rows that are older than one year.
• D.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.