CompTIA Data+ DA0-002 (V2) Practice Question

The correct answer is Decimal. The Decimal data type is a fixed-precision numeric type designed to store exact numeric values, which is essential for financial data to prevent rounding errors. The Float data type is an approximate-value numeric type and can introduce small rounding errors, making it unsuitable for financial calculations where precision is critical. The Integer data type can only store whole numbers and cannot hold the fractional part of a price (the cents). The Varchar data type stores character strings, not numeric values, which prevents the database from performing mathematical calculations on the data directly.