This medium round puts you in a service review. You need to match indexes to a workload, publish reports, query documents and preserve atomic changes. Some plausible alternatives return a familiar-looking answer while breaking the required contract on a boundary row.
Read each output contract before writing SQL or choosing a response. Use the supplied evidence and keep missing values distinct from zeros, blanks and absent keys. For an operational scenario, select the option that satisfies every stated requirement rather than the one that sounds fastest.
The SQL tasks run on fresh fictional records and are checked again after those records change. You may use any equivalent query that produces the required result and preserves the stated database contract. The concurrency tasks use a clearly labeled session model. No question claims access to a live backup, a standby or a production connection pool.
Put the tenant equality key before the timestamp range key.