Cloudera CDP Data Analyst Practice Questions - Cloudera CDP Data Analyst (Exam CDP-4001) Exam

When you write SELECT region, SUM(amount) FROM sales GROUP BY region in Hive, what does the GROUP BY clause accomplish?

It collapses rows into one row per distinct region so SUM is computed per group It sorts the output rows by region in ascending order It removes duplicate region values from the result without aggregating It filters out regions whose total amount is below a threshold

Correct Answer:

It collapses rows into one row per distinct region so SUM is computed per group

Access more questions from this quiz

Continue to Cloudera CDP Data Analyst Practice Questions - Cloudera CDP Data Analyst (Exam CDP-4001) Exam for more practice questions and the full quiz experience.

Access More Questions