List common data types used for numeric, text, and date fields in Clarity and give examples.

List common data types used for numeric, text, and date fields in Clarity and give examples.

• A. Numeric: integer, bigint, decimal; Text: varchar, nvarchar; Date/time: date, timestamp; Boolean: boolean; GUID: uniqueidentifier.
• B. Numeric: float only; Text: text; Date: only date.
• C. Numeric: decimal only; Text: char; Date: datetime.
• D. Numeric: bigint; Text: nvarchar; Date: time.

Answer: (A)

In Clarity data modeling, numeric, text, and date fields are typically defined using common SQL-like data types that cover the main ways we store each kind of data. For numeric values, using integer, bigint, and decimal gives you a spectrum from standard whole numbers to larger ranges and precise fractional values. For text, varchar and nvarchar handle variable-length strings, with nvarchar offering Unicode support for international characters. For dates and times, date and timestamp (often used interchangeably with datetime in many schemas) let you store calendar dates and exact instants. It’s also common to see boolean for true/false flags and GUID (uniqueidentifier) for globally unique identifiers, which are frequently used as identifiers or keys in Clarity schemas. This set represents the main categories with practical, widely-supported examples, while also acknowledging additional types that appear in practice. The other options tend to be too narrow—they restrict to a single type per category or omit commonly used types like varchar/nvarchar or date/timestamp, making them less representative for real Clarity data models.

In Clarity data modeling, numeric, text, and date fields are typically defined using common SQL-like data types that cover the main ways we store each kind of data. For numeric values, using integer, bigint, and decimal gives you a spectrum from standard whole numbers to larger ranges and precise fractional values. For text, varchar and nvarchar handle variable-length strings, with nvarchar offering Unicode support for international characters. For dates and times, date and timestamp (often used interchangeably with datetime in many schemas) let you store calendar dates and exact instants. It’s also common to see boolean for true/false flags and GUID (uniqueidentifier) for globally unique identifiers, which are frequently used as identifiers or keys in Clarity schemas. This set represents the main categories with practical, widely-supported examples, while also acknowledging additional types that appear in practice. The other options tend to be too narrow—they restrict to a single type per category or omit commonly used types like varchar/nvarchar or date/timestamp, making them less representative for real Clarity data models.