PrepAway - Latest Free Exam Questions & Answers

What should you do?

You are a database administrator for AIOTestKing.com. The company uses a SQL Server 2005 database that includes a table named Customers. The table includes a column named EmailAddress that contains string data. Company policy specifies a required format for data in the EmailAddress column. Changes to the EmailAddress column are made several ways, including by using ad hoc queries. You need to ensure that the data in the EmailAddress column is properly formatted. Your solution must provide the best possible performance when thousands of rows are added to the database. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
On the EmailAddress column, create a default constraint that specifies a string in the proper format.

B.
Write a stored procedure that disallows changes to the EmailAddress column that violate company policy.

C.
On the EmailAddress column, create a check constraint that uses a user-defined function to validate the format of the data.

D.
Write a trigger that rolls back changes to the EmailAddress column that violate company policy.


Leave a Reply