Certified Data Engineer Associate Exam

Exam Certified Data Engineer Associate All QuestionsBrowse all questions from this exam

Go to Exam

Question 61

Which of the following commands will return the number of null values in the member_id column?

SELECT count(member_id) FROM my_table;

SELECT count(member_id) - count_null(member_id) FROM my_table;

SELECT count_if(member_id IS NULL) FROM my_table;

SELECT null(member_id) FROM my_table;

SELECT count_null(member_id) FROM my_table;

Correct Answer: C

To get the number of null values in the member_id column, use the command 'SELECT count_if(member_id IS NULL) FROM my_table;'. The function count_if checks for rows that meet a specific condition, in this case, whether member_id is NULL.

Discussion

55f31c8Option: C

https://docs.databricks.com/en/sql/language-manual/functions/count_if.html

meow_akkOption: C

Ans C : https://docs.databricks.com/en/sql/language-manual/functions/count.html Returns A BIGINT. If * is specified also counts row containing NULL values. If expr are specified counts only rows for which all expr are not NULL. If DISTINCT duplicate rows are not counted.

kishanuOption: C

count_if() can be used in this scenario

benni_aleOption: C

C is correct

bartftoOption: C

C: There are no 'null' and 'count_null' functions in SparkSQL