nerdexam
CompTIA

DA0-001 · Question #212

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

The correct answer is B. Text. 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.

Data Concepts and Environments

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

How the community answered

(24 responses)
  • A
    4% (1)
  • B
    92% (22)
  • C
    4% (1)

Why each option

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.

ANumeric

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.

BTextCorrect

Text data, also known as string data, is used for values that contain characters, numbers, and symbols and are not intended for mathematical calculations. Reference numbers often fit this description, as they might include prefixes, leading zeros, or hyphens (e.g., "INV-001", "REF12345"), making them unsuitable for numeric or currency data types and are best stored as text.

CCurrency

Currency data is a specific type of numeric data with associated currency symbols and formatting; RefNo values are identifiers, not monetary amounts.

DAlphanumeric

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

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

Topics

#Data Types#Database Concepts#Data Classification#Column Properties

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice