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

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 joint relationship, executive employee and contract employee are not mutually
exclusive and can be both. Employee_id uniquely identify each employee. We have added one extra column which represent type if
employee and now it will be collection set , because an employee can be both executive as well as on contract.




Question : You have been given below conceptual data model for HadoopExam on-demand training access.


Please design logical table, which represent below query?

Query : Find the course_list for a given owner and will be ranged based on update_time (sort course_list by recently updated
first)




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

Correct Answer : Get Lastest Questions and Answer :
Explanation: As we need detail about course_list for an owner of course_list. Hence, required attributes only from
course_list. Now, we need to identify the owner of playlist, which is user_id and that will be partition key. Now, update time
is clustering column and order by descending to get most recent updated first. To make primary key column unique we will add
list_name in primary key.





Question : You have been given below conceptual data model for HadoopExam on-demand training access.



Please design logical table, which represent below query?

Query : Find all course_channels subscribed by a subscriber (sort course_channel by ascending order)



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

Correct Answer : Get Lastest Questions and Answer :
Explanation:We are going to find all the channels subscribed by an user, hence, user_id will be a partition key.
Its many to many relationship hence, we need to consider from both the side of relation, as course_channel being a weak entity
we need to have get key from its relation, which again goes to user_subscriber entity, we will get it user_id as
channel_owner_id. Ordering is required on channel name, hence add as a clustering column, before any other clustering column.
Name and Email will be unique for each user_id (partition key). Hence, make this as a static column.

Related 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 author_name = ? (All the courses created by an author)


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


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_id = ? and video_id=? (All the comments by a user)


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


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_id = ? and comment_date>? (All the comments by a user)


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


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


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


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