DA0-001 Question #212: Real Exam Question with Answer & Explanation

Question

An analyst reviews the following table: Which of the following data types is represented in the values in the RefNo column?

Options

• ANumeric
• BText
• CCurrency
• DAlphanumeric

Explanation

The RefNo column contains values that are best classified as Text data, as they are likely identifiers that may include a combination of characters, numbers, or leading zeros, and are not typically used in mathematical operations.

Common mistakes.

• A. Numeric data is exclusively for values that represent quantities and are used in calculations; RefNo values might contain non-numeric characters or leading zeros, making them unsuitable for a pure numeric type.
• C. Currency data is a specific type of numeric data with associated currency symbols and formatting; RefNo values are identifiers, not monetary amounts.
• D. Alphanumeric data is a subset of text data that specifically refers to characters that are either letters or numbers. While RefNo might be alphanumeric, "Text" is a more general and encompassing data type that allows for other characters (like hyphens) often found in reference numbers, and is typically preferred when values are identifiers rather than quantities for calculation.

Concept tested. Data types - Text/String

Reference. https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-data-types

No community discussion yet for this question.