What should you recommend?

Correct Answer for the following Question is given below

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 .eduWhat should you recommend?Although T-SQL is extremely powerful for most data processing, it provides little support for text analysis or manipulation. Attempting to perform any sophisticated text analysis using the built-in string functions results in massively large functions and stored procedures that are difficult to debug and maintain. In such situations regular expressions provide a much more efficient and elegant solution.In the current scenario, we should use System.Text.RegularExpressions to create a CLR function and use this function in a CHECK constraint.

Question:

What should you recommend?

Options:

Create an e-mail profile for the Database Mail SQL Server component.

Use a non-persisted computed column.

Add a custom schema to the database.

Use a CHECK constraint that uses a CLR function

Correct Answer

The Correct Answer for this Question is

Use a CHECK constraint that uses a CLR function

Explanation

The Question – What should you recommend? has been answered correctly and answers for the question is Use a CHECK constraint that uses a CLR function

More about these Exams

These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.

We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.

you can find more here at mnccertified

Feel free to contact via comment or email.

Happy Learning

Cheers, Team MNCcertified

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *