Smartly Prepare Exam with Free Online Apache-Cassandra-Developer-Associate Practice Test

We offer the latest Apache-Cassandra-Developer-Associate practice test designed for free and effective online Apache Cassandra Developer Associate Certification certification preparation. It's a simulation of the real Apache-Cassandra-Developer-Associate exam experience, built to help you understand the structure, complexity, and topics you'll face on exam day.

Question 1

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 2

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

Why all operations are strongly consistent?

Options :

A : Because this is equivalent to the ANY consistency level.

B : Because CL THREE guarantees strong consistency.

C : Because RF 3 guarantees strong consistency.

D : Because there are 3 replicas in total and they must all confirm any read or write operation.

Answer: D

Question 3

What is a NOT a valid limitation for Cassandra counters?

Options :

A : Counters cannot be used for columns part of the PRIMARY KEY of a table.

B : Counter values cannot go below zero.

C : The value of a counter cannot be set.

D : A table that contains a counter can only contain counters.

Answer: B

Question 4

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?

Options :

A : PRIMARY KEY (country, state, city, population)

B : PRIMARY KEY ((country, state), city, population)

C : PRIMARY KEY ((country, state), population, city)

D : PRIMARY KEY (country, state, population, city)

Answer: C

Question 5

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

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