CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Google
  5. Google Associate Cloud Engineer

Free Google Associate Cloud Engineer Exam Braindumps (page: 25)

Page 24 of 74
PDF with 290 Questions

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?

  1. Go to Data Catalog and search for employee_ssn in the search box.
  2. Write a shell script that uses the bq command line tool to loop through all the projects in your organization.
  3. 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.
  4. 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.

Answer(s): A

Explanation:

https://cloud.google.com/bigquery/docs/quickstarts/quickstart-web-ui?authuser=4



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?

  1. The pending Pod's resource requests are too large to fit on a single node of the cluster.
  2. Too many Pods are already running in the cluster, and there are not enough resources left to schedule the pending Pod.
  3. The node pool is configured with a service account that does not have permission to pull the container image used by the pending Pod.
  4. 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.

Answer(s): B

Explanation:

The pending Pods 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. is the right answer.
When you have a deployment with some pods in running and other pods in the pending state, more often than not it is a problem with resources on the nodes. Heres a sample output of this use case. We see that the problem is with insufficient CPU on the Kubernetes nodes so we have to either enable auto-scaling or manually scale up the nodes.



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?

  1. Open the Cloud Spanner console to review configurations.
  2. Open the IAM & admin console to review IAM policies for Cloud Spanner roles.
  3. Go to the Stackdriver Monitoring console and review information for Cloud Spanner.
  4. Go to the Stackdriver Logging console, review admin activity logs, and filter them for Cloud Spanner IAM roles.

Answer(s): D

Explanation:

https://cloud.google.com/monitoring/audit-logging



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.)

  1. Split the users from business units to multiple projects.
  2. Apply a user- or project-level custom query quota for BigQuery data warehouse.
  3. Create separate copies of your BigQuery data warehouse for each business unit.
  4. Split your BigQuery data warehouse into multiple data warehouses for each business unit.
  5. Change your BigQuery query model from on-demand to flat rate. Apply the appropriate number of slots to each Project.

Answer(s): B,E

Explanation:

https://cloud.google.com/bigquery/docs/custom-quotas https://cloud.google.com/bigquery/pricing#flat_rate_pricing






Post your Comments and Discuss Google Google Associate Cloud Engineer exam with other Community members:

Google Associate Cloud Engineer Discussions & Posts