ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-464 All Questions

View all questions & answers for the 70-464 exam
Go to Exam

Exam 70-464 topic 1 question 9 discussion

Actual exam question from Microsoft's 70-464
Question #: 9
Topic #: 1
[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?

  • A. WITH CHECK OPTION
  • B. WITH VIEW_METADATA
  • C. WITH ENCRYPTION
  • D. WITH SCHEMABINDING
Show Suggested Answer Hide 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 Luzix at Nov. 2, 2020, 5:55 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
d_m
4 years, 4 months ago
Let's rewrite the question again like this! /*You need to ensure that the view can [not] update the data in the table, except for the data in Column1. Which code segment should you add at line 06? */
upvoted 1 times
...
Kepty
4 years, 5 months ago
The question is not defined properly, but what I know from similar questions, the answer is correct (the question will be different on the real exam).
upvoted 1 times
...
Luzix
4 years, 6 months ago
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
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago