Microsoft Exam 70-464 Topic 5 Question 4 Discussion

Actual exam question for Microsoft's 70-464 exam

Question #: 4
Topic #: 5

[All 70-464 Questions]

You have a database hosted on SQL Azure.

You are developing a script to create a view that will be used to update the data in a table.

The following is the relevant portion of the script. (Line numbers are included for reference only.)

You need to ensure that the view can update the data in the table, except for the data in Column1.

Which code segment should you add at line 06?

AWITH CHECK OPTION

BWITH VIEW_METADATA

CWITH ENCRYPTION

DWITH SCHEMABINDING

Show Suggested Answer

Suggested Answer: A

The question concerning the view that has a clause "WHERE Column1 = 'City1' is wrong. That's not what the CHECK option is made for. Actually you will be able to update ONLY the rows satisfied by that WHERE clause, that is, only the rows with the Column1 being 'City1'.

None of the answers are valid from that question. You need a trigger to achieve that.

http://msdn.microsoft.com/en-us/library/ms187956.aspx

by Rolland at May 05, 2022, 01:50 AM

Limited Time Offer

25%

Off

Get Premium 70-464 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!