Courseiva
Data Acquisition and PreparationmediumMultiple SelectObjective-mapped

DA0-002 Data Acquisition and Preparation Practice Question

A data analyst is performing data profiling on a customer table. Which TWO metrics are commonly used to assess the completeness of a column? (Select TWO.)

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

Row count

Completeness is measured by null count and row count; null count shows missing values, row count gives total rows.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • Row count

    Why this is correct

    Total rows; used to compute percentage complete.

  • Null count

    Why this is correct

    Number of missing values.

  • Cardinality

    Why it's wrong here

    Number of distinct values, not completeness.

  • Mean

    Why it's wrong here

    Average value, not completeness.

  • Standard deviation

    Why it's wrong here

    Measure of spread, not completeness.

About these practice questions

One of 986 original DA0-002 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This DA0-002 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DA0-002 exam.