Home » Microsoft » 70-457 » 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. Float
B. Money
C. Smallmoney
D. Numeric
Correct Answer: D
Explanation/Reference:
--Burgos - YES
In my test on Dec 20 in MN, USA, D option goes with "decimal", which is the same as "Numeric".
Numeric is the only one in the list that can give a fixed precision and scale.
Reference: http://msdn.microsoft.com/en-us/library/ms179882.aspx
