GCP_PDE_BigTable

Building for Builders LLC manufactures equipment used in residential and commercial

building. Each of its 500,000 pieces of equipment in use around the globe has IoT devices

collecting data about the state of equipment. The IoT data is streamed from each device every 10 seconds. On average, 10 KB of data is sent in each message. The data will be used for predictive maintenance and product development. The company would like to use a managed service in Google Cloud. What would you recommend?

• Apache Cassandra

• Cloud SQL

• BigTable

• Spanner

Mountkirk Games wants to store player game data in a time- series database. Which Google Cloud managed database would you recommend?

• BigTable

• Redis Memorystore

• Cloud SQL

• BigQuery

Your Cloud SQL database is close to maximizing the number of read operations that it can perform. You could vertically scale the database to use a larger instance, but you do not need additional write capacity. What else could you try to reduce the number of reads performed by the database?

• Switch to Cloud Spanner.

• Use Cloud Memorystore to cache the query results.

• Switch to Cloud Storage

• Use Cloud Bigtable instead.

A team of developers is choosing between using NoSQL or a relational database. What is a feature of NoSQL databases that is not available in relational databases?

• Fixed Schema

• Indexes

• ACID Transactions

• Flexible Schema

A software-as-a-service (SaaS) company specializing in automobile IoT sensors collects streaming time-series data from tens of thousands of vehicles. The vehicles are owned and operated by 40 different companies, who are the primary customers of the SaaS company. The data will be stored in Bigtable using a multitenant database; that is, all customer data will be stored in the same database. The data sent from the IoT device includes a sensor ID, which is globally unique; a timestamp; and several metrics about engine efficiency. Each customer will query their own data only. Which of the following would you use as a row-key?

• Customer ID, timestamp, sensor ID

• Customer ID, sensor ID, timestamp

• Sensor ID, timestamp, customer ID

• Sensor ID, customer ID, timestamp