ACE Practice Test #2

You are creating an environment for researchers to run ad hoc SQL queries. The researchers work with large quantities of data. Although they will use the environment for an hour a day on average, the researchers need access to the functional environment at any time during the day. You need to deliver a cost-effective solution. What should you do?

• Store the data in Cloud Bigtable, and run SQL queries provided by Bigtable schema.

• Store the data in BigQuery, and run SQL queries in BigQuery.

• Create a Dataproc cluster, store the data in HDFS storage, and run SQL queries in Spark.

• Create a Dataproc cluster, store the data in Cloud Storage, and run SQL queries in Spark.

You are migrating your workload from on-premises deployment to Google Kubernetes Engine (GKE). You want to minimize costs and stay within budget. What should you do?

• Configure Autopilot in GKE to monitor node utilization and eliminate idle nodes.

• Configure the needed capacity; the sustained use discount will make you stay within budget.

• Scale individual nodes up and down with the Horizontal Pod Autoscaler.

• Create several nodes using Compute Engine, add them to a managed instance group, and set the group to scale up and down depending on load.

Your application allows users to upload pictures. You need to convert each picture to your internal optimized binary format and store it. You want to use the most efficient, cost-effective solution. What should you do?

• Store uploaded files in Cloud Bigtable, monitor Bigtable entries, and then run a Cloud Function to convert the files and store them in Bigtable.

• Store uploaded files in Firestore, monitor Firestore entries, and then run a Cloud Function to convert the files and store them in Firestore.

• Store uploaded files in Filestore, monitor Filestore entries, and then run a Cloud Function to convert the files and store them in Filestore.

• Save uploaded files in a Cloud Storage bucket, and monitor the bucket for uploads. Run a Cloud Function to convert the files and to store them in a Cloud Storage bucket.

You are migrating your on-premises solution to Google Cloud. As a first step, the new cloud solution will need to ingest 100 TB of data. Your daily uploads will be within your current bandwidth limit of 100 Mbps. You want to follow Google-recommended practices for the most cost-effective way to implement the migration. What should you do?

• Set up Partner Interconnect for the duration of the first upload.

• Obtain a Transfer Appliance, copy the data to it, and ship it to Google.

• Set up Dedicated Interconnect for the duration of your first upload, and then drop back to regular bandwidth.

• Divide your data between 100 computers, and upload each data portion to a bucket. Then run a script to merge the uploads together.

You are setting up billing for your project. You want to prevent excessive consumption of resources due to an error or malicious attack and prevent billing spikes or surprises. What should you do?

• Set up budgets and alerts in your project.

• Set up quotas for the resources that your project will be using.

• Set up a spending limit on the credit card used in your billing account.

• Label all resources according to best practices, regularly export the billing reports, and analyze them with BigQuery.

Your project team needs to estimate the spending for your Google Cloud project for the next quarter. You know the project requirements. You want to produce your estimate as quickly as possible. What should you do?

• Build a simple machine learning model that will predict your next month’s spend.

• Estimate the number of hours of compute time required, and then multiply by the VM per-hour pricing.

• Use the Google Cloud Pricing Calculator to enter your predicted consumption for all groups of resources.

• Use the Google Cloud Pricing Calculator to enter your consumption for all groups of resources, and then adjust for volume discounts.