Google : ADP Questions & Answers

Your organization has several datasets in BigQuery. The datasets need to be shared with your external partners so that they can run SQL queries without needing to copy the data to their own projects. You have organized each partner's data in its own BigQuery dataset. Each partner should be able to access only their dat a. You want to share the data while following Google-recommended practices. What should you do?

• A. Export the BigQuery data to a Cloud Storage bucket. Grant the partners the storage.objectUser IAM role on the bucket.
• B. Use Analytics Hub to create a listing on a private data exchange for each partner dataset. Allow each partner to subscribe to their respective listings.
• C. Create a Dataflow job that reads from each BigQuery dataset and pushes the data into a dedicated Pub /Sub topic for each partner. Grant each partner the pubsub. subscriber IAM role.
• D. Grant the partners the bigquery.user IAM role on the BigQuery project.

You need to design a data pipeline to process large volumes of raw server log data stored in Cloud Storage.
The data needs to be cleaned, transformed, and aggregated before being loaded into BigQuery for analysis.
The transformation involves complex data manipulation using Spark scripts that your team developed. You need to implement a solution that leverages your team's existing skillset, processes data at scale, and minimizes cost. What should you do?

• A. Use Dataflow with a custom template for the transformation logic.
• B. Use Cloud Data Fusion to visually design and manage the pipeline.
• C. Use Dataform to define the transformations in SQLX.
• D. Use Dataproc to run the transformations on a cluster.

Your organization has a BigQuery dataset that contains sensitive employee information such as salaries and performance reviews. The payroll specialist in the HR department needs to have continuous access to aggregated performance data, but they do not need continuous access to other sensitive dat a. You need to grant the payroll specialist access to the performance data without granting them access to the entire dataset using the simplest and most secure approach. What should you do?

• A. Create a SQL query with the aggregated performance data. Export the results to an Avro file in a Cloud Storage bucket. Share the bucket with the payroll specialist.
• B. Create row-level and column-level permissions and policies on the table that contains performance data in the dataset. Provide the payroll specialist with the appropriate permission set.
• C. Use authorized views to share query results with the payroll specialist.
• D. Create a table with the aggregated performance data. Use table-level permissions to grant access to the payroll specialist.

Your organization is building a new application on Google Cloud. Several data files will need to be stored in Cloud Storage. Your organization has approved only two specific cloud regions where these data files can reside. You need to determine a Cloud Storage bucket strategy that includes automated high availability.
What should you do?

• A. Create a dual-region bucket, and upload the files to this bucket.
• B. Create a multi-region bucket, and upload the files to this bucket.
• C. Create a single-region bucket in each of the two regions, and use Storage Transfer Service to replicate the data across the buckets in both regions.
• D. Create a single-region bucket in each of the two regions, and use the gcloud storage command to replicate the data across the buckets in both regions.

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 Storage Transfer Service.
• B. Use Cloud Storage FUSE.
• C. Use gcloud storage commands.
• D. Use a Transfer Appliance.