A data engineer is creating a database field to capture whether a customer likes vanilla ice cream. Which of the following data types is the best to capture this information?

The correct answer is B. Boolean. A Boolean data type stores only two possible values: TRUE or FALSE (yes or no). Since the question asks whether a customer 'likes' vanilla ice cream, the answer is inherently binary - they either do or they don't. Integer and Numeric types store numbers and are unnecessarily…

Data Concepts and Environments

Question

Options

AInteger
BBoolean
CCategorical
DNumeric

How the community answered

(35 responses)

A
3% (1)
B
86% (30)
C
9% (3)
D
3% (1)

Explanation

A Boolean data type stores only two possible values: TRUE or FALSE (yes or no). Since the question asks whether a customer 'likes' vanilla ice cream, the answer is inherently binary - they either do or they don't. Integer and Numeric types store numbers and are unnecessarily broad for a yes/no answer. Categorical could technically work but is less precise and efficient than Boolean for a strictly binary outcome.

Topics

#Data types#Boolean#Database design#Data modeling

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice