Microsoft
70-459 · Question #21
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 number
The correct answer is C. WITH CHECK OPTION. See the full explanation below for the reasoning.
Question
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 Columnl. Which code segment should you add at line 06?
Options
- AWITH VIEW_METADATA
- BWITH ENCRYPTION
- CWITH CHECK OPTION
- DWITH SCHEMABINDING
How the community answered
(41 responses)- A5% (2)
- B5% (2)
- C78% (32)
- D12% (5)
Community Discussion
No community discussion yet for this question.