Timedora
Free Practice Quiz Question List

Data Quality, Grain, and Relational Joins Online Quiz Questions

Use this free practice quiz with 20 questions to review Data Quality, Grain, and Relational Joins, test your knowledge, and prepare for your next test or exam.

20 questions
01
Choose one
1 point

A transaction system reliably records completed purchases but does not include people who never bought. Which use best accounts for the source's scope?

  1. A

    Use transaction records to estimate how many people considered buying but did not purchase.

  2. B

    Use transaction records to summarize completed purchases, while noting that nonbuyers are not represented.

  3. C

    Use transaction records to describe opinions held by all customers, including those who never purchased.

02
Choose all
1 point

Select all statements that correctly describe relational keys or a risk to check before joining tables.

  1. A

    A primary key uniquely identifies a row.

  2. B

    A foreign key is a value that must be unique within its own table.

  3. C

    A foreign key can refer to a key in another table to connect related records.

  4. D

    A join can unintentionally duplicate or drop rows if the keys or relationship are not checked.

03
True or false
1 point

A product code such as 00127 should be treated as a quantity because it contains digits.

  1. A

    True

  2. B

    False

04
Written response
1 point

Which data-quality dimension asks whether the required records and fields are present?

05
Fill in the blank
1 point

A useful quality check reports an issue and its .

06
Open ended
1 point

A customer table is joined to an orders table in which each customer may have many orders. Explain how this join can affect the number of rows per customer and the resulting grain, and name one risk to check.

07
Choose one
1 point

A dataset has one row per order line, and an order may contain several lines. What does counting its rows measure?

  1. A

    The number of customers who made purchases.

  2. B

    The number of distinct orders, regardless of how many lines each contains.

  3. C

    The number of order lines, which may be greater than the number of orders.

08
Choose all
1 point

Select all statements that correctly connect data types or values to their analytical meaning.

  1. A

    A product code such as 00127 can be stored as text to preserve its leading zero and identifier meaning.

  2. B

    A missing value can be treated as zero whenever a field is numeric.

  3. C

    A date or timestamp type can support representing events and ordering them over time.

  4. D

    A missing value, zero, and an empty string can have different meanings.

09
True or false
1 point

Data-quality checks are only needed at the beginning of data handling because later processing cannot introduce new problems.

  1. A

    True

  2. B

    False

10
Written response
1 point

Which data-quality dimension concerns whether values conform to expected types, formats, and business rules?

11
Fill in the blank
1 point

When reporting a data-quality issue, state the issue and its analytical .

12
Choose one
1 point

A team checks whether its data is current enough for a decision and covers the correct reporting period. Which data-quality dimension is it assessing?

  1. A

    Accuracy

  2. B

    Timeliness

  3. C

    Consistency

  4. D

    Validity

13
True or false
1 point

Joining one customer record to that customer's many order records can produce multiple rows for the customer and change the resulting grain.

  1. A

    True

  2. B

    False

14
Written response
1 point

What term describes what one record in a dataset represents?

15
Choose one
1 point

A product code such as 00127 is an identifier, not a quantity. Which data type is most appropriate for storing it so its leading zero is preserved?

  1. A

    Integer

  2. B

    Decimal

  3. C

    Text

  4. D

    Boolean

16
True or false
1 point

A missing value should not automatically be treated as equivalent to zero, an empty string, or “not applicable.”

  1. A

    True

  2. B

    False

17
Written response
1 point

What is the concise term for the effect a data-quality issue could have on an analysis?

18
Choose one
1 point

A dataset contains every required field, but some values may not reflect the real events they describe. Which data-quality dimension still needs to be assessed?

  1. A

    Accuracy

  2. B

    Completeness

  3. C

    Uniqueness

  4. D

    Timeliness

19
Written response
1 point

What type of key uniquely identifies a row in a table?

20
Choose one
1 point

A transaction system reliably records completed purchases but omits people who never bought. What is the most relevant concern when deciding whether to use it to study all potential customers?

  1. A

    It is necessarily inaccurate because it records transactions.

  2. B

    It is necessarily incomplete because every data source must include every person.

  3. C

    Its scope may exclude people who never made a purchase.

  4. D

    Its grain must be one customer because it comes from a transaction system.