Register
Question 1
In Impala, which behavior do aggregate functions such as AVG() and SUM() exhibit when a column contains NULL values?
Correct Answer:
They ignore NULL values and aggregate only the non-NULL rows
Question 2
A data analyst needs the number of distinct customer IDs in an orders table using Impala. Which expression returns that value?
Correct Answer:
COUNT(DISTINCT customer_id)
Question 3
When you write SELECT region, SUM(amount) FROM sales GROUP BY region in Hive, what does the GROUP BY clause accomplish?
Correct Answer:
It collapses rows into one row per distinct region so SUM is computed per group
Question 4
Which clause must you use to filter the results of a GROUP BY query based on the value of an aggregate function such as SUM(amount) > 1000?
Correct Answer:
HAVING
Question 5
A report needs the highest and lowest transaction values per store. Which pair of Impala aggregate functions provides these directly?
Correct Answer:
MAX() and MIN()
Question 1
Exam overview

About this Exam

Prepare with the Cloudera CDP Data Analyst Practice Questions - Cloudera CDP Data Analyst (Exam CDP-4001) Exam practice quiz. This question bank includes 100 questions covering impala, table, analyst, hive, and query. Use it to review important concepts, identify knowledge gaps, and build confidence for the related exam, course, or assessment.

More details

Additional Information

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

This practice set contains 100 questions from the matching question bank and focuses on impala, table, analyst, hive, and query. Work through each question carefully, review the provided solutions, and revisit topics that need more study before your next attempt.

This is an independent study resource intended for practice and review; it is not an official examination or an endorsement by any organization named in the title.

Quiz information

Frequently Asked Questions

The complete question count is available after full access is unlocked.
No fixed duration is currently configured for this quiz.
Question explanations are included where they are available in the quiz content, helping you review the reasoning after answering.
Yes. You can retake the practice test again as you continue studying during your available access period.
After your access is confirmed, you can continue into the complete practice exam from this quiz flow.
Unless explicitly stated otherwise, this page provides independent practice material for study and exam preparation and is not the official examination itself.
Keep studying

Related Questions

Certified Valuation Analyst (CVA) Practice Exam

0 min

Certified Quality Process Analyst (CQPA) 1 Practice Exam

0 min

ABFT Analyst Certification Practice Exam

0 min

Chartered Alternative Investment Analyst (CAIA) Level I Practice Test

0 min

Chartered Alternative Investment Analyst (CAIA) Level II Practice Test

0 min

Chartered Alternative Investment Analyst Association (CAIA) Practice Exam

0 min