DatabricksDatabricks
DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE · Question #34
DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE Question #34: Real Exam Question with Answer & Explanation
Sign in or unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE to reveal the answer and full explanation for question #34. The question stem and answer options stay visible for context.
Submitted by yuriko_h· Apr 18, 2026ELT with Spark SQL and Python
Question
Which of the following commands will return the number of null values in the member_id column?
Options
- ASELECT count(member_id) FROM my_table;
- BSELECT count(member_id) - count_null(member_id) FROM my_table;
- CSELECT count_if(member_id IS NULL) FROM my_table;
- DSELECT null(member_id) FROM my_table;
- ESELECT count_null(member_id) FROM my_table;
Unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE to see the answer
You've previewed enough free DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE questions. Unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Spark SQL#NULL values#Aggregate Functions#Data Querying