- (Exam Topic 4)
You work for a large fast food restaurant chain with over 400,000 employees. You store employee information in Google BigQuery in a Users table consisting of a FirstName field and a LastName field. A member of IT is building an application and asks you to modify the schema and data in BigQuery so the application can query a FullName field consisting of the value of the FirstName field concatenated with a space, followed by the value of the LastName field for each employee. How can you make that data available while minimizing cost?

1. A. Create a view in BigQuery that concatenates the FirstName and LastName field values to produce the FullName.
2. B. Add a new column called FullName to the Users tabl
3. C. Run an UPDATE statement that updates the FullName column for each user with the concatenation of the FirstName and LastName values.
4. D. Create a Google Cloud Dataflow job that queries BigQuery for the entire Users table, concatenates the FirstName value and LastName value for each user, and loads the proper values for FirstName, LastName, and FullName into a new table in BigQuery.
5. E. Use BigQuery to export the data for the table to a CSV fil
6. F. Create a Google Cloud Dataproc job to process the CSV file and output a new CSV file containing the proper values for FirstName, LastName and FullNam
7. G. Run a BigQuery load job to load the new CSV file into BigQuery.

Correct Answer: C

- (Exam Topic 6)
You are a retailer that wants to integrate your online sales capabilities with different in-home assistants, such as Google Home. You need to interpret customer voice commands and issue an order to the backend systems. Which solutions should you choose?

1. A. Cloud Speech-to-Text API
2. B. Cloud Natural Language API
3. C. Dialogflow Enterprise Edition
4. D. Cloud AutoML Natural Language

Correct Answer: C

- (Exam Topic 3)
MJTelco is building a custom interface to share data. 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?

1. A. Cloud Datastore and Cloud Bigtable
2. B. Cloud Bigtable and Cloud SQL
3. C. BigQuery and Cloud Bigtable
4. D. BigQuery and Cloud Storage

Correct Answer: C

- (Exam Topic 6)
Your analytics team wants to build a simple statistical model to determine which customers are most likely to work with your company again, based on a few different metrics. They want to run the model on Apache Spark, using data housed in Google Cloud Storage, and you have recommended using Google Cloud Dataproc to execute this job. Testing has shown that this workload can run in approximately 30 minutes on a 15-node cluster, outputting the results into Google BigQuery. The plan is to run this workload weekly. How should you optimize the cluster for cost?

1. A. Migrate the workload to Google Cloud Dataflow
2. B. Use pre-emptible virtual machines (VMs) for the cluster
3. C. Use a higher-memory node so that the job runs faster
4. D. Use SSDs on the worker nodes so that the job can run faster

Correct Answer: A

- (Exam Topic 6)
You are integrating one of your internal IT applications and Google BigQuery, so users can query BigQuery from the application’s interface. You do not want individual users to authenticate to BigQuery and you do not want to give them access to the dataset. You need to securely access BigQuery from your IT application.
What should you do?

1. A. Create groups for your users and give those groups access to the dataset
2. B. Integrate with a single sign-on (SSO) platform, and pass each user’s credentials along with the query request
3. C. Create a service account and grant dataset access to that accoun
4. D. Use the service account’s private key to access the dataset
5. E. Create a dummy user and grant dataset access to that use
6. F. Store the username and password for that user in a file on the files system, and use those credentials to access the BigQuery dataset

Correct Answer: C