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