Premium

DataStax Cassandra Developer Certification Certification Questions and Answer (Dumps and Practice Questions)



Question : You can use network attached storage and needs to be avoided for Cassandra node ?
: You can use network attached storage and needs to be avoided for Cassandra node ?
1. True
2. False

Correct Answer : 1
Explanation: It is not a good idea to use network attached storage for Cassandra.




Question : Which of the following statements are correct?

A. You can write data on any node in Cassandra cluster
B. Any node in the cluster can work as Coordinator
C. You have to define 1/4 th of total node as Cassandra Cluster
D. Coordinator is optional in Cassandra

: Which of the following statements are correct?
1. A,B
2. B,C
3. C,D
4. A,D
5. B,D

Correct Answer : 1
Explanation: you can write data to any node in the cluster. Because every node can act as a coordinator. And a
coordinator's a very important role for each node and its not optional.




Question : Using driver you can connect to specific node, for which your data belongs to and you can do read and write only
on that node in Cassandra ring
: Using driver you can connect to specific node, for which your data belongs to and you can do read and write only
1. True
2. False

Correct Answer : 2
Explanation: Each node is going to be assigned a different range of data which are called token ranges. And that
range of data says, this data belongs to particular node. Now that coordinator can then take that data and hold that, and send
this to the proper node. Now that node gets the data, the acknowledgement gets sent back to the client.


Related Questions

Question : You have been given below table definition

CREATE TABLE HADOOEXAM(

COURSE_TITLE text,
COURSE_ADDED_YEAR int,
COURSE_ADDED_DATE timestamp,
COURSE_DETAIL text,
USER_ID UUID,
COURSE_ID TIMEUUID,
PRIMARY KEY ((COURSE_TITLE), COURSE_ADDED_YEAR)));

What is the advantage of having PRIMARY KEY defined with this syntax ((COURSE_TITLE), COURSE_ADDED_YEAR))) ?
 : You have been given below table definition
1. COURSE_ADDED_YEAR column Provide uniqueness within the partition as well as ordering criteria

2. COURSE_ADDED_YEAR column Groups related data on a single node

3. Access Mostly Uused Products by 50000+ Subscribers

4. COURSE_ADDED_YEAR column Creates clusters within the rack



Question : . You have been given below table definition

CREATE TABLE HADOOEXAM (

COURSE_TITLE text,
COURSE_ADDED_YEAR int,
COURSE_ADDED_DATE timestamp,
COURSE_DETAIL text,
USER_ID UUID,
COURSE_ID TIMEUUID,
PRIMARY KEY ((COURSE_TITLE), COURSE_ADDED_YEAR)));

What is the relation between COURSE_TITLE and COURSE_ADDED_YEAR in this definition?
 : . You have been given below table definition
1. Behavior for COURSE_TITLE and COURSE_ADDED_YEAR are the same.

2. COURSE_ADDED_YEAR column hash to a partition key

 3. Access Mostly Uused Products by 50000+ Subscribers
criteria

4. COURSE_ADDED_YEAR column determine grouping criteria whereas COURSE_TITLE key determine ordering criteria



Question : You have been given below table definition

CREATE TABLE HADOOEXAM(

COURSE_TITLE text,
COURSE_ADDED_YEAR int,
COURSE_ADDED_DATE timestamp,
COURSE_DETAIL text,
USER_ID UUID,
COURSE_ID TIMEUUID,
PRIMARY KEY ((COURSE_TITLE), COURSE_ADDED_YEAR)));

How does Cassandra will order this table columns?
 : You have been given below table definition
1. COURSE_TITLE, COURSE_ADDED_YEAR, COURSE_ADDED_DATE , COURSE_DETAIL , COURSE_ID , USER_ID

2. COURSE_ADDED_YEAR, COURSE_TITLE, COURSE_ADDED_DATE , COURSE_DETAIL , COURSE_ID , USER_ID

 3. Access Mostly Uused Products by 50000+ Subscribers

4. COURSE_TITLE, COURSE_ADDED_YEAR, COURSE_ADDED_DATE , COURSE_DETAIL , USER_ID, COURSE_ID



Question : You have been given metadata for creating Cassandra table.

Category text
Created_year int
course_id uuid
published_date timestamp
course_detail text
course_title text
user_id uuid

And you have created table as below

CREATE TABLE HADOOPEXAM (
Category text,
Created_year int,
published_date timestamp,
course_title text,
course_detail text,
user_id uuid,
course_id uuid,
PRIMARY KEY ((course_id))
);

What do you see in above table creation definition assuming combination of these three columns course_id,Category,Created_year
to be unique across all data.

 : You have been given metadata for creating Cassandra table.
1. It is a good design of table, it can avoid the upserts.

2. It is a good design of table, and you can easily do the range query on Created_year column.

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Its not a good or bad design. Itas based on requirement.



Question : You have been given below metadata for creating Cassandra table.

Category text
Created_year int
course_id uuid
published_date timestamp
course_detail text
user_id uuid

In this assuming combination of these three columns course_id,Category,Created_year to be unique across all data.
Now you need to design a table where allow users to query on Category and possible created_year ranges while avoiding upserts
on import. You must also return your results in descending order of created_year.
 : You have been given below metadata for creating Cassandra table.
1.



2.


3. Access Mostly Uused Products by 50000+ Subscribers


4.




Question : You have wrongly loaded all the data in Cassandra table and want to delete all the rows from that table. Which of
the following will help you to do this?
 : You have wrongly loaded all the data in Cassandra table and want to delete all the rows from that table. Which of
1. DROP

2. TRUNCATE

 3. Access Mostly Uused Products by 50000+ Subscribers

4. ERASE