Free DataStax Apache-Cassandra-Developer-Associate Exam Questions

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?

Which is NOT true for a read repair?

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?

Primary keys:

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