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

Question : You have below sample data from a csv file.

1be43390-9fe4-41e3-8d05-425861b86ab6, 1be43390-9fe4-11e3-8d05-425861b86ab6, Amit Jain, I am learning Cassandra from
HadoopExam, 111

Which of the following is correct definition of Cassandra table for this data.

1.
2.
3. Access Mostly Uused Products by 50000+ Subscribers


4.


Correct Answer : Get Lastest Questions and Answer :
Explanation: 1st value is : UUID
2nd Value is : time UUID
3rd Value is : text type
4th Value is : text type
5th value is : int type

Hence, based on this option 2 is correct.





Question : You have been given below table definitions
CREATE TABLE HADOOPEXAM (

id uuid,
t_id timeuuid,
name text,
description text,
price int
primary key (t_id));

Now you run the below query

Select * from HADOOPEXAM where name='Amit Jain'

What is the expected result?

1. It will successfully return all the rows, where name matches.

2. It will run successfully, but result set would be empty, saying this is not supported.

3. Access Mostly Uused Products by 50000+ Subscribers

4. It will return first 5 matching rows only.


Correct Answer : Get Lastest Questions and Answer :
Explanation: There is one constraint in Cassandra: any field you want to use in the where clause has to be the
primary key of the table or there must be a secondary index on it. So you have to create an index to name and only after that
you can use name in the where condition and you will get the result you were expecting.




Question : You have been given below table definition, which of the following is a partition key?

CREATE TABLE HADOOPEXAM (

id uuid,
t_id timeuuid,
name text,
description text,
price int
primary key (t_id));

1. ID

2. NAME

3. Access Mostly Uused Products by 50000+ Subscribers

4. cannot be determined and will decided by Cassandra


Correct Answer : Get Lastest Questions and Answer :
Explanation:

Related Questions

---

Question : What is true about Chebotko Diagram ?


1. These diagrams are graphical representation of Cassandra database schema design

2. They Helps, on Documenting Logical Data Model

3. Access Mostly Uused Products by 50000+ Subscribers

4. 1 and 2

5. 1,2 and 3



Question : Which is true about logical and physical data model ?

A. Logical level shows column name and its properties
B. Physical level shows column name and its properties
C. Logical level shows column name , its properties and column data type
D. Physical level shows column name , its properties and column data type


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


Question : Which is true about Chebotko Diagram notation ?



1. Counter is represented as ++

2. Secondary index represented as IDX

3. Access Mostly Uused Products by 50000+ Subscribers

4. 1 and 3

5. 1 and 2


Question : Which all are true for Cassandra data modeling principal?

A. You must know your data
B. You know all your queries in advance
C. Wherever required de-normalize your data
D. You can store duplicate data


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


Question : In Cassandra, following scenarios can be considered as an ideal.

To fetch the data, Query needs to access all the partitions in a table, to retrieve results.


1. True
2. False


Question : Cassandra prefer space compare to time , while designing data modeling?

1. True
2. False