Question-21: You have been given below sample data

And your data model is as below. There are 1000’s of CourseGroup in data.

CREATE TABLE he_users (

    id uuid PRIMARY KEY,

    username text,

    email text,

    location text,

    first text,

    last text

)

CREATE TABLE he_groups (

    coursegroup text,

    user_id uuid,

    PRIMARY KEY coursegroup , user_id)

)

Which of the following statements are correct?

1. This modeling would have reduce the duplication of users across many groups.
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

Ans: A, B, D

Exp:  Given data model helps in reducing the data duplication for sure. But we have to make sure, does it satisfy our query requirement. As given in the question there 1000’s of groups and we need to extract all the user information then query will read all the 1000’s partition.

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