Question

In Cloud Spanner, how do you determine which child tables are stored with which parent tables?

a) By using a random allocation method
b) By specifying the allocation in the database settings
c) By letting the system automatically decide
d) By manually copying data between tables

Answer 1

In Cloud Spanner, the allocation of child tables with parent tables is determined by specifying the allocation in the database settings.

Step-by-step explanation:

In Cloud Spanner, the allocation of child tables with parent tables is determined by specifying the allocation in the database settings.

This means that you can define the relationship between parent and child tables at the time of creating the database, and Cloud Spanner will store them together accordingly.

For example, you can specify that a child table is interleaved with a parent table, which means that the child table's data will be physically stored in the same location as the parent table's data.