Question 1

When to use a secondary index?

Options :

A : When querying a table using a column that cannot normally be queried.

B : On tables with a counter column.

C : On a frequently updated or deleted column.

D : On high-cardinality columns.

Answer: A

Question 2

What is wrong with this user-defined type (UDT) definition?

1. CREATE TYPE States (

2. id uuid PRIMARY KEY,

3. name text

4. );

Options :

A : UDTs cannot declare primary keys.

B : UUID is not a valid CQL data type.

C : Must start by CREATE TYPE IF NOT EXISTS.

D : The name should be all lower cases.

Answer: A

Question 3

What is an example of hybrid-cloud deployment?

Options :

A : Cassandra in on-premise data center accessed from AWS virtual machines.

B : Cassandra deployed on both on-premise and on Azure virtual machines.

C : Cassandra in two inter-connected on-premise data centers.

D : Cassandra in two separate on-premise data centers.

Answer: B

Question 4

You have a single datacenter 10-node cluster with a replication factor of 3.

What can NOT happen on an UPDATE query for one single row, when the consistency level is set to ONE?

Options :

A : An incoming write will go only to the first node that owns the requested row.

B : Only one node can properly complete the write

C : The other two replicas can miss the write.

D : Coordinator returns control back to the client after one single write is confirmed.

Answer: A

Question 5

Primary keys:

Options :

A : identify the nodes in the cluster that store the row(s).

B : uniquely identify rows in a table and determine their sort order.

C : uniquely identify rows in a partition and determine their sort order.

D : are alternative surrogate keys for row numbers.

Answer: B