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?
A. Create an e-mail profile for the Database Mail SQL Server component.
B. Use a non-persisted computed column.
C. Add a custom schema to the database.
D. Use a CHECK constraint that uses a CLR function
