Home » Microsoft » 70-461 v.2 » 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