CertyIQ - Google - Prof Data Eng - pt 10

Which row keys are likely to cause a disproportionate number of reads and/or writes on a particular node in a Bigtable cluster (select 2 answers)?

• A sequential numeric ID

• A timestamp followed by a stock symbo

• A non-sequential numeric ID

• A stock symbol followed by a timestamp

When a Cloud Bigtable node fails, ____ is lost.

• all data

• no data

• the last transaction

• the time dimension

Which is not a valid reason for poor Cloud Bigtable performance?

• The workload isn't appropriate for Cloud Bigtable.

• The table's schema is not designed correctly

• The Cloud Bigtable cluster has too many nodes.

• There are issues with the network connection.

Which is the preferred method to use to avoid hotspotting in time series data in Bigtable?

• Field promotion

• Randomization

• Salting

• Hashing

When you design a Google Cloud Bigtable schema it is recommended that you _________.

• Avoid schema designs that are based on NoSQL concepts

• Create schema designs that are based on a relational database design

• Avoid schema designs that require atomicity across rows

• Create schema designs that require atomicity across rows

Which of the following is NOT a valid use case to select HDD (hard disk drives) as the storage for Google Cloud Bigtable?

• You expect to store at least 10 TB of data.

• You will mostly run batch workloads with scans and writes, rather than frequently executing random reads of a small number of rows.

• You need to integrate with Google BigQuery.

• You will not use the data to back a user-facing or latency-sensitive application.

Cloud Bigtable is Google's ______ Big Data database service.

• Relational

• mySQL

• NoSQL

• SQL Server

When you store data in Cloud Bigtable, what is the recommended minimum amount of stored data?

• 500 TB

• 1 GB

• 1 TB

• 500 GB

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?

• Do not use a production instance.

• Run your test for at least 10 minutes.

• Before you test, run a heavy pre-test for several minutes.

• Use at least 300 GB of data.

Cloud Bigtable is a recommended option for storing very large amounts of ____________________________?

• multi-keyed data with very high latency

• multi-keyed data with very low latency

• single-keyed data with very low latency

• single-keyed data with very high latency