Transactions and Partition Keys Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Data Partitioning Strategy

What you'll be asked

  1. What is the primary purpose of a partition key in a distributed database system?
  2. Why is it generally recommended to keep transactions within the scope of a single partition key?
  3. You are designing a schema for an e-commerce platform. Which partition key strategy would best support high-throughput 'Order History' lookups for individual customers?
  4. What is the primary risk of choosing a partition key with low cardinality (e.g., 'Status' field with values 'Active' and 'Inactive')?
  5. In a system using a composite partition key (e.g., PartitionKey: 'TenantID', SortKey: 'Timestamp'), why might a query that only filters by 'Timestamp' be inefficient?

Answers and explanations come after you submit.