Confidently Practice Online with Free Apache-Cassandra-Developer-Associate Exam Cram

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?

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?

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?

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

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

1. CREATE TYPE States (

2.   id uuid PRIMARY KEY,

3.   name text

4. );