Free DataStax Apache-Cassandra-Developer-Associate Exam Questions

Consider the following keyspace definition:

1. CREATE KEYSPACE mykeyspace

2.   WITH replication = {'class': 'NetworkTopologyStrategy', 'DC1': 3, 'DC2': 3};

DC1 has 4 nodes active and 2 down, DC2 has 3 nodes active and one down.

Which of the next statements is true?

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?

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);

How to define the primary key of a Country table, if we want individual records by country and state, and filtered lists of cities by a population range?

You execute queries with CL THREE on a single datacenter cluster with RF 3.

Why all operations are strongly consistent?