You want to process payment transactions in a point-of-sale application that will run on Google Cloud Platform. Your user base could grow exponentially, but you do not want to manage infrastructure scaling.
Which Google database service should you use?

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

You launched a new gaming app almost three years ago. You have been uploading log files from the previous day to a separate Google BigQuery table with the table name format LOGS_yyyymmdd. You have been using table wildcard functions to generate daily and monthly reports for all time ranges. Recently, you discovered that some queries that cover long date ranges are exceeding the limit of 1,000 tables and failing. How can you resolve this issue?

• A. Enable query caching so you can cache data from previous months
• B. Convert the sharded tables into a single partitioned table
• C. Create separate views to cover each month, and query from these views
• D. Convert all daily log tables into date-partitioned tables

Suppose you have a table that includes a nested column called "city" inside a column called "person", but when you try to submit the following query in BigQuery, it gives you an error.
SELECT person FROM `project1.example.table1` WHERE city = "London"
How would you correct the error?

• A. Change "person" to "city.person".
• B. Change "person" to "person.city".
• C. Add ", UNNEST(person)" before the WHERE clause.
• D. Add ", UNNEST(city)" before the WHERE clause.

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. Only use service accounts when sharing data for Cloud Storage buckets and BigQuery datasets.
• B. Use Cloud Deployment Manager to automate access provision.
• C. Introduce resource hierarchy to leverage access control policy inheritance.
• D. For each Cloud Storage bucket or BigQuery dataset, decide which projects need acces
• E. Create distinct groups for various teams, and specify groups in Cloud IAM policies.
• 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.

If you're running a performance test that depends upon Cloud Bigtable, all the choices except one below are recommended steps. Which is NOT a recommended step to follow?

• A. Before you test, run a heavy pre-test for several minutes.
• B. Run your test for at least 10 minutes.
• C. Use at least 300 GB of data.
• D. Do not use a production instance.