GCP ace

Your company implemented BigQuery as an enterprise data warehouse. Users from multiple business units run queries on this data warehouse. However, you notice that query costs for BigQuery are very high, and you need to control costs. Which two methods should you use? (Choose two.)

• Split the users from business units to multiple projects.

• Apply a user- or project-level custom query quota for BigQuery data warehouse

• Create separate copies of your BigQuery data warehouse for each business unit.

• Split your BigQuery data warehouse into multiple data warehouses for each business unit.

• Change your BigQuery query model from on-demand to flat rate. Apply the appropriate number of slots to each Project.

You want to find out when users were added to Cloud Spanner Identity Access Management (IAM) roles on your Google Cloud Platform (GCP) project. What should you do in the GCP Console?

• Open the Cloud Spanner console to review configurations.

• Open the IAM & admin console to review IAM policies for Cloud Spanner roles.

• Go to the Stackdriver Monitoring console and review information for Cloud Spanner.

• Go to the Stackdriver Logging console, review admin activity logs, and filter them for Cloud Spanner IAM roles.

You create a Deployment with 2 replicas in a Google Kubernetes Engine cluster that has a single preemptible node pool. After a few minutes, you use kubectl to examine the status of your Pod and observe that one of them is still in Pending status:

What is the most likely cause?

• The pending Pod's resource requests are too large to fit on a single node of the cluster.

• Too many Pods are already running in the cluster, and there are not enough resources left to schedule the pending Pod.

• The node pool is configured with a service account that does not have permission to pull the container image used by the pending Pod.

• The pending Pod was originally scheduled on a node that has been preempted between the creation of the Deployment and your verification of the Pods' status. It is currently being rescheduled on a new node.

Your company uses BigQuery for data warehousing. Over time, many different business units in your company have created 1000+ datasets across hundreds of projects. Your CIO wants you to examine all datasets to find tables that contain an employee_ssn column. You want to minimize effort in performing this task.What should you do?

• Go to Data Catalog and search for employee_ssn in the search box.

• Write a shell script that uses the bq command line tool to loop through all the projects in your organization.

• Write a script that loops through all the projects in your organization and runs a query on INFORMATION_SCHEMA.COLUMNS view to find the employee_ssn column.

• Write a Cloud Dataflow job that loops through all the projects in your organization and runs a query on INFORMATION_SCHEMA.COLUMNS view to find employee_ssn column.

You want to select and configure a solution for storing and archiving data on Google Cloud Platform. You need to support compliance objectives for data from one geographic location. This data is archived after 30 days and needs to be accessed annually. What should you do?

• Select Multi-Regional Storage. Add a bucket lifecycle rule that archives data after 30 days to Coldline Storage.

• Select Multi-Regional Storage. Add a bucket lifecycle rule that archives data after 30 days to Nearline Storage.

• Select Regional Storage. Add a bucket lifecycle rule that archives data after 30 days to Nearline Storage.

• Select Regional Storage. Add a bucket lifecycle rule that archives data after 30 days to Coldline Storage.

Your company's infrastructure is on-premises, but all machines are running at maximum capacity. You want to burst to Google Cloud. The workloads on GoogleCloud must be able to directly communicate to the workloads on-premises using a private IP range. What should you do?

• In Google Cloud, configure the VPC as a host for Shared VPC.

• In Google Cloud, configure the VPC for VPC Network Peering.

• Create bastion hosts both in your on-premises environment and on Google Cloud. Configure both as proxy servers using their public IP addresses.

• Set up Cloud VPN between the infrastructure on-premises and Google Cloud.

You want to configure a solution for archiving data in a Cloud Storage bucket. The solution must be cost-effective. Data with multiple versions should be archived after 30 days. Previous versions are accessed once a month for reporting. This archive data is also occasionally updated at month-end. What should you do?

• Add a bucket lifecycle rule that archives data with newer versions after 30 days to Coldline Storage.

• Add a bucket lifecycle rule that archives data with newer versions after 30 days to Nearline Storage.

• Add a bucket lifecycle rule that archives data from regional storage after 30 days to Coldline Storage

• Add a bucket lifecycle rule that archives data from regional storage after 30 days to Nearline Storage.

You are migrating a production-critical on-premises application that requires 96 vCPUs to perform its task. You want to make sure the application runs in a similar environment on GCP. What should you do?

• When creating the VM, use machine type n1-standard-96

• When creating the VM, use Intel Skylake as the CPU platform.

• Create the VM using Compute Engine default settings. Use gcloud to modify the running instance to have 96 vCPUs.

• Start the VM using Compute Engine default settings, and adjust as you go based on Rightsizing Recommendations.

You need to set a budget alert for use of Compute Engineer services on one of the three Google Cloud Platform projects that you manage. All three projects are linked to a single billing account. What should you do?

• Verify that you are the project billing administrator. Select the associated billing account and create a budget and alert for the appropriate project.

• Verify that you are the project billing administrator. Select the associated billing account and create a budget and a custom alert.

• Verify that you are the project administrator. Select the associated billing account and create a budget for the appropriate project.

• Verify that you are project administrator. Select the associated billing account and create a budget and a custom alert.

  Reveal Solution   Discussion   52

  Previous QuestionsNext Questions

You deployed an LDAP server on Compute Engine that is reachable via TLS through port 636 using UDP. You want to make sure it is reachable by clients over that port. What should you do?

• Add the network tag allow-udp-636 to the VM instance running the LDAP server.

• Create a route called allow-udp-636 and set the next hop to be the VM instance running the LDAP server.

• Add a network tag of your choice to the instance. Create a firewall rule to allow ingress on UDP port 636 for that network tag.

• Add a network tag of your choice to the instance running the LDAP server. Create a firewall rule to allow egress on UDP port 636 for that network tag.