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

In Impala, which behavior do aggregate functions such as AVG() and SUM() exhibit when a column contains NULL values?

They return NULL for the entire result if any row is NULL They ignore NULL values and aggregate only the non-NULL rows They treat NULL as zero before aggregating They raise a runtime error unless a WHERE clause filters NULLs

Correct Answer:

They ignore NULL values and aggregate only the non-NULL rows

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