Microsoft
70-451 · Question #99
You are designing a table that will contain the columns in the following table. You need to add a column that will display the sum of the Subtotal, TaxAmt, and FreightAmt columns. The solution must…
The correct answer is B. a computed column. See the full explanation below for the reasoning.
Question
You are designing a table that will contain the columns in the following table. You need to add a column that will display the sum of the Subtotal, TaxAmt, and FreightAmt columns. The solution must minimize the amount of storage space required to store the table. What should you create?
Options
- Aa column that uses the numeric data type
- Ba computed column
- Ca persisted computed column
- Da column that uses the money data type
How the community answered
(42 responses)- A2% (1)
- B76% (32)
- C5% (2)
- D17% (7)
Community Discussion
No community discussion yet for this question.