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

Question : You have been given below conceptual data model for HadoopExam Inc online training institute.

Please find the correct query for given access pattern

where user_name = ? (All the comments by a user_name)



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

Correct Answer : Get Lastest Questions and Answer :
Explanation:
It’s many to many relationship, also we have equality access pattern so user_name will be partition key. To uniquely identify
many to many relationship, we have to use both entity key as well as relationship key.





Question : You have been given below conceptual data model for HadoopExam Inc online training institute.

Please find the correct query for given access pattern

where user_name = ? and comment_daye>?(All the comments by a user_name)


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

Correct Answer : Get Lastest Questions and Answer :
Explanation: It’s many to many relationship, also we have equality access pattern so user_name will be partition
key. To uniquely identify many to many relationship, we have to use both entity key as well as relationship key.

However, here we have inequality operator for the comment_date column, hence it should be first clustering column.





Question : You have been given below relationship for the HadoopExam Inc employee


Now find the correct table design for given query access pattern?

Where employee_id=?



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

Correct Answer : Get Lastest Questions and Answer :
Explanation: Here this is a disjoint relationship, contract employee and permanent employee are mutually exclusive
and can not be both. Employee_id uniquely identify
each employee. We have added one extra column which represent type if employee.

Related Questions

---

Question : You have been given below conceptual data model

And you have below Access pattern, which of the following is valid table design

where course_name=? and publish_date>?


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


Question : You have data size is TB and your schema design will duplicate this data times, having replication factor=.
How much data are you going to duplicate?

1. 500TB

2. 50TB
3. Access Mostly Uused Products by 50000+ Subscribers

4. 5000TB



Question : You have following table designed

Comment_By_course
comment_id K
course_id C
Title
description

For each comment_id, you will be copying entire course detail again. Is this an issue ?


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


Question : You have been given below conceptual data model

And you have below Access pattern, which of the following is valid table design

where rating=? and publish_date>?


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


Question : You have been given below conceptual datamodel for HadoopExam Inc online training institute.

Please find the correct query for given access pattern

where author_id = ? (All the courses created by an author)


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


Question :

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