Microsoft
70-451 · Question #68
70-451 Question #68: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #68. The question stem and answer options stay visible for context.
Question
You are designing a table to store customer data. The table will contain a column to store the e-mail addresses of the customers. You need to recommend a solution to store the e-mail addresses. The solution must meet the following requirements: - E-mail addresses must contain the @ symbol - E-mail addresses must be validated by using a regular expression - E-mail addresses must contain a top-level domain of .com, .org, or .edu What should you recommend?
Options
- ACreate an e-mail profile for the Database Mail SQL Server component.
- BUse a CHECK constraint that uses a CLR function.
- CAdd a custom schema to the database.
- DUse a non-persisted computed column.
Unlock 70-451 to see the answer
You've previewed enough free 70-451 questions. Unlock 70-451 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.