Microsoft
70-451 · Question #5
You are designing a maintenance strategy for a database that contains several views. The views will be assigned custom permissions. You need to recommend a solution that will allow developers to…
The correct answer is B. Alter the existing view. See the full explanation below for the reasoning.
Question
You are designing a maintenance strategy for a database that contains several views. The views will be assigned custom permissions. You need to recommend a solution that will allow developers to modify the views without affecting the views' existing permissions. What should you recommend?
Options
- ACreate a new view.
- BAlter the existing view.
- CRename the existing view.
- DDrop the existing view and then recreate the view.
How the community answered
(47 responses)- A13% (6)
- B77% (36)
- C4% (2)
- D6% (3)
Community Discussion
No community discussion yet for this question.