Google : GCP-DE Questions & Answers

You have developed three data processing jobs. One executes a Cloud Dataflow pipeline that transforms data uploaded to Cloud Storage and writes results to BigQuery. The second ingests data from on-premises servers and uploads it to Cloud Storage. The third is a Cloud Dataflow pipeline that gets information from third-party data providers and uploads the information to Cloud Storage. You need to be able to schedule and monitor the execution of these three workflows and manually execute them when needed. What should you do?

• A. Develop an App Engine application to schedule and request the status of the jobs using GCP API calls.
• B. Create a Direct Acyclic Graph in Cloud Composer to schedule and monitor the jobs.
• C. Use Stackdriver Monitoring and set up an alert with a Webhook notification to trigger the jobs.
• D. Set up cron jobs in a Compute Engine instance to schedule and monitor the pipelines using GCP API calls.

As your organization expands its usage of GCP, many teams have started to create their own projects. Projects are further multiplied to accommodate different stages of deployments and target audiences. Each project requires unique access control configurations. The central IT team needs to have access to all projects. Furthermore, data from Cloud Storage buckets and BigQuery datasets must be shared for use in other projects in an ad hoc way. You want to simplify access control management by minimizing the number of policies. Which two steps should you take? Choose 2 answers.

• A. Introduce resource hierarchy to leverage access control policy inheritance.
• B. Create distinct groups for various teams, and specify groups in Cloud IAM policies.
• C. Only use service accounts when sharing data for Cloud Storage buckets and BigQuery datasets.
• D. For each Cloud Storage bucket or BigQuery dataset, decide which projects need acces
• E. Use Cloud Deployment Manager to automate access provision.
• F. Find all the active members who have access to these projects, and create a Cloud IAM policy to grant access to all these users.

What are two methods that can be used to denormalize tables in BigQuery?

• A. 1) Use a partitioned table; 2) Join tables into one table
• B. 1) Split table into multiple tables; 2) Use a partitioned table
• C. 1) Use nested repeated fields; 2) Use a partitioned table
• D. 1) Join tables into one table; 2) Use nested repeated fields

You are selecting services to write and transform JSON messages from Cloud Pub/Sub to BigQuery for a data pipeline on Google Cloud. You want to minimize service costs. You also want to monitor and accommodate input data volume that will vary in size with minimal manual intervention. What should you do?

• A. Configure the job to use non-default Compute Engine machine types when needed.
• B. Use the default autoscaling setting for worker instances.
• C. Monitor the total execution time for a sampling of job
• D. Use Cloud Dataproc to run your transformation
• E. Use Cloud Dataproc to run your transformation
• F. Use Cloud Dataflow to run your transformation
• G. Locate the bottleneck and adjust cluster resources.
• H. Use the diagnose command to generate an operational output archiv
• I. Monitor the job system lag with Stackdrive
• J. Use Cloud Dataflow to run your transformation
• K. Resize the number of worker nodes in your cluster via the command line.
• L. Monitor CPU utilization for the cluste

MJTelco is building a custom interface to share dat
a. They have these requirements:
They need to do aggregations over their petabyte-scale datasets.
They need to scan specific time range rows with a very fast response time (milliseconds). Which combination of Google Cloud Platform products should you recommend?

• A. BigQuery and Cloud Bigtable
• B. Cloud Datastore and Cloud Bigtable
• C. Cloud Bigtable and Cloud SQL
• D. BigQuery and Cloud Storage