DataStax Cassandra Developer Certification Certification Questions and Answer (Dumps and Practice 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))) ?

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


Correct Answer : Get Lastest Questions and Answer :
Explanation:




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?

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


Correct Answer : Get Lastest Questions and Answer :
Explanation:




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?

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


Correct Answer : Get Lastest Questions and Answer :
Explanation: Cassandra stores table column in following order

- Primary Column
- Cluster Column
- Other columns in alphabetical order

Related Questions

---

Question : Which of the following aggregation functions are supported by Cassandra as of now ?


1. SUM

2. MAX

3. Access Mostly Uused Products by 50000+ Subscribers

4. COUNT

5. AVG



Question : Which of the following statement is correct for Counter data type

1. They are always 100% accurate

2. You can do add, subtract, increment and decrement current value

3. Access Mostly Uused Products by 50000+ Subscribers

4. 1 and 3

5. 2 and 3



Question : You have been given a Cassandra cluster (Ring) with nodes, spread across two availability zones (AWS : amazon
webservice) and new KeySpace created
by Admin named AcmeKeySpace with Replication factor 3. Select correct statement.
A. Whatever data updates are done can not be replicated to another availability zone.
B. Whatever data inserts are done can not be replicated to another availability zone.
C. Whatever data updates are done , automatically replicated to another availability zone.
D. Whatever data inserts are done , automatically replicated to another availability zone.


1. A,B
2. B,C
3. Access Mostly Uused Products by 50000+ Subscribers
4. A,D
5. B,D


Question : cassandra database is not good for, which of the following datatypes?


1. large amounts of structured

2. large amounts of semi-structured

3. Access Mostly Uused Products by 50000+ Subscribers

4. large amounts of XML data

5. None of the above



Question : Select correct statement, which applies for Cassandra NoSQL database.
A. Cassandra delivers continuous availability
B. Cassandra delivers linear scalability
C. Cassandra has operational simplicity across many commodity servers
D. Cassandra can have single point of failure.


1. A,B,C
2. B,C,D
3. Access Mostly Uused Products by 50000+ Subscribers
4. A,B,C,D


Question : You have been given a Cassandra cluster (Ring) with nodes, and you want to create new KeySpace and insert data
for your mobile application named AcmeApp.

1. You have to connect primary node in Ring and needs to create Database connection with it.

2. You can connect any two nodes (Defined by Admin) in Ring and needs to create Database connection any of
these two nodes.

3. Access Mostly Uused Products by 50000+ Subscribers

4. You can connect any nodes in Ring but at a time you can use only one node from ring for your database
operations.