Home » Microsoft » 70-461 » Which data type should you use?
You are developing a database that will contain price information.
You need to store the prices that include a fixed precision and a scale of six digits.
Which data type should you use?
A. Smallmoney
B. Numeric
C. Money
D. Varchar
Correct Answer: B
Explanation/Reference:
Numeric data types that have fixed precision and scale.
decimal[ (p[ , s] )] and numeric[ (p[ , s] )]
where
* p (precision)
The maximum total number of decimal digits that will be stored, both to the left and to the right of the decimal point. The precision must be a value from 1 through the maximum precision of 38. The default precision is 18.
* (scale)
The number of decimal digits that will be stored to the right of the decimal point. Incorrect answers:
Not A, not C: The money and smallmoney data types are accurate to a ten-thousandth of the monetary units that they represent.
Not C: The money and smallmoney data types are accurate to a ten-thousandth of the monetary units that they represent.
Reference: decimal and numeric (Transact-SQL)
https://msdn.microsoft.com/en-us/library/ms187746.aspx