Free Google ADP Exam Dumps Questions & Answers

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

Your company uses Looker to generate and share reports with various stakeholders. You have a complex dashboard with several visualizations that needs to be delivered to specific stakeholders on a recurring basis, with customized filters applied for each recipient. You need an efficient and scalable solution to automate the delivery of this customized dashboard. You want to follow the Google- recommended approach. What should you do?

• A.  Embed the Looker dashboard in a custom web application, and use the application's scheduling features to send the report with personalized filters.
• B.  Use the Looker Scheduler with a user attribute filter on the dashboard, and send the dashboard with personalized filters to each stakeholder based on their attributes.
• C.  Create a separate LookML model for each stakeholder with predefined filters, and schedule the dashboards using the Looker Scheduler.
• D.  Create a script using the Looker Python SDK, and configure user attribute filter values. Generate a new scheduled plan for each stakeholder.

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

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.  Create a Cloud Data Fusion instance and visually design an ETL pipeline that reads data from Cloud Storage, transforms it using built-in transformations, and loads the results into BigQuery.
• B.  Use Dataproc to create an Apache Hadoop cluster, perform the ETL process using Apache Spark, and load the results into BigQuery.
• C.  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.
• D.  Use BigQuery's SQL capabilities to load the data from Cloud Storage, transform it, and store the results in a new BigQuery table.

You recently inherited a task for managing Dataflow streaming pipelines in your organization and noticed that proper access had not been provisioned to you. You need to request a Google-provided IAM role so you can restart the pipelines. You need to follow the principle of least privilege. What should you do?

• A.  Request the Dataflow Admin role.
• B.  Request the Dataflow Viewer role.
• C.  Request the Dataflow Worker role.
• D.  Request the Dataflow Developer role.