Question 51: You have defined following table

CREATE TABLE TRINING_COURSE (

  id uuid,

  course_sequence int,

  course_id uuid,

  title text,

  category text,

  trainer text,

  PRIMARY KEY  (id, course_sequence ) );

Which of the following is a valid Query on this table ?

1. SELECT * FROM playlists;
2. Get all Questions and Answer from here
3. You need to have paid subscription to access all questions
4. Thanks for considering Python Certification Material

Correct Answer: 4

Exp : Cassandra will reject query in option 2 because the query requires a sequential scan across the entire  dataset, because trainer is not a partition key or clustering column.

You can access to full explanation to question and answer from this page.