Microsoft
70-451 · Question #21
You are designing a database that will store telephone numbers. You need to ensure that only phone numbers that use a specific format are written to the database. What should you create?
The correct answer is A. a CHECK constraint. See the full explanation below for the reasoning.
Question
You are designing a database that will store telephone numbers. You need to ensure that only phone numbers that use a specific format are written to the database. What should you create?
Options
- Aa CHECK constraint
- Ba computed column
- Ca DEFAULT constraint
- Da persisted computed column
How the community answered
(54 responses)- A76% (41)
- B6% (3)
- C15% (8)
- D4% (2)
Community Discussion
No community discussion yet for this question.