1.3 Storing and Accessing Data PROFESSIONAL-CLOUD-DEVELOPER Practice Questions (Page 2)

Questions 6–10

1. 6expert · hard

   A team is using Cloud Bigtable for a time-series application. They have a row key of sensorID#timestamp. They notice that writes are slow during peak hours. They suspect hot-spotting. What is the most likely cause and the best solution?

   • AThe sensorID is not random enough. Solution: add a random prefix to the sensorID.
   • BThe row key is too long. Solution: shorten the sensorID.
   • CThe timestamp is monotonically increasing, causing all writes to go to the same tablet. Solution: reverse the timestamp.
   • DThe table has too many column families. Solution: reduce the number of column families.
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A team is designing a schema for a multi-tenant SaaS application on Cloud Spanner. Each tenant has a tenant_id. The most common query is to fetch all records for a specific tenant. What is the best practice for designing the primary key?

   • AUse a composite primary key of (tenant_id, record_id) where record_id is a unique identifier.
   • BUse a primary key of record_id and store tenant_id as a non-key column.
   • CUse a single primary key of record_id and add a secondary index on tenant_id.
   • DUse a primary key of tenant_id only, since each tenant has only one record.
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   Which Google Cloud database service provides strong consistency by default across all replicas?

   • ACloud Spanner
   • BBigtable
   • CFirestore
   • DCloud Storage
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   A developer needs to store a large amount of unstructured data, such as images and videos, that will be accessed via HTTPS URLs. Which Google Cloud storage system is most appropriate for this use case?

   • ACloud Spanner
   • BFirestore
   • CBigtable
   • DCloud Storage
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   When designing a schema for a relational database like AlloyDB, which practice is essential to maintain data integrity and avoid redundancy?

   • AAvoiding primary keys
   • BUsing denormalization for all tables
   • CNormalizing tables to reduce data duplication
   • DStoring all data in a single table for simplicity
   Reveal Solution Discussion Select an answer first