Question 1

Which is NOT true for a read repair?

Options :

A : Read repair is a process of repairing data replicas during a read request.

B : Read repair runs in the foreground as a blocking operation.

C : Read repair ensures that data in your cluster stays in sync.

D : Read repair always occurs when consistency level is ANY.

Answer: D

Question 2

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

Question 3

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 4

What values are stored in the pop column after the following sequence?

1. CREATE TABLE countries (

2. country text,

3. state text,

4. pop int STATIC,

5. PRIMARY KEY (country, state)

6. );

7.

8. INSERT INTO countries (country, state, pop) VALUES ('USA', 'Oregon', 4200000);

9. INSERT INTO countries (country, state, pop) VALUES ('USA', 'Idaho', -1);

10. INSERT INTO countries (country, state, pop) VALUES ('USA', 'Idaho', 1700000);

Options :

A : 4200000, -1, 1700000

B : 4200000, 1700000

C : 4200000, -1

D : 1700000, 1700000

Answer: D

Question 5

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

Free Apache-Cassandra-Developer-Associate Mock Exam – Practice Online Confidently

Buying Options: