MV and SI Quiz 3

For minimal storage overhead, the best way to select rows not based on the primary key in ScyllaDB is:

For the lowest latency, the best way to select rows not based on the primary key in ScyllaDB is:

Assume the following table, with 100M pets in it:

CREATE TABLE pets (

   pet_chip_id  uuid,

   gender Boolean,

   PRIMARY KEY (pet_chip_id  ));

  Examine the following four CQL commands :

A) CREATE INDEX pets_by_gender ON pets (gender);

SELECT * from pets WHERE gender = true;

B) CREATE MATERIALIZED VIEW pets_by_gender AS SELECT * FROM pets WHERE pet_chip_id IS NOT NULL AND gender IS NOT NULL PRIMARY KEY(gender, pet_chip_id);

SELECT * from pets_by_gender WHERE gender = true;

C) SELECT * from pets WHERE gender = true;

D) SELECT * from pets WHERE gender = true ALLOW FILTERING;

When using Local Secondary Indexes: