Microsoft
MB6-890 · Question #43
You want to store the Shipment Type of all orders in a table named ShipmentDetails. The Shipment Type needs to be a field that stores values for "Freight", "Ground", or "Air". You also need to…
The correct answer is A. Create an integer field for Shipment Type on the ShipmentDetail table. Write business logic to. See the full explanation below for the reasoning.
Question
You want to store the Shipment Type of all orders in a table named ShipmentDetails. The Shipment Type needs to be a field that stores values for "Freight", "Ground", or "Air". You also need to ensure that the text that is displayed to users on forms is localized for the shipment types and that the values in the database are independent of the language the user is utilizing. What should you do?
Options
- ACreate an integer field for Shipment Type on the ShipmentDetail table. Write business logic to
- BCreate a base enum for Shipment Type with the different shipment types as choices. Use this
- CCreate a string field for Shipment Type on the ShipmentDetails table.
- Dcreate an Extended Data Type (EDT) for Shipment Type that extends from string. Use this EDT
How the community answered
(29 responses)- A76% (22)
- B14% (4)
- C7% (2)
- D3% (1)
Community Discussion
No community discussion yet for this question.