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

Exam 70-461 All Questions

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

Exam 70-461 topic 1 question 2 discussion

Actual exam question from Microsoft's 70-461
Question #: 2
Topic #: 1
[All 70-461 Questions]

You develop a Microsoft SQL Server database. You create a view from the Orders and OrderDetails tables by using the following definition.

You need to improve the performance of the view by persisting data to disk. What should you do?

  • A. Create anINSTEAD OFtrigger on the view.
  • B. Create anAFTERtrigger on the view.
  • C. Modify the view to use theWITH VIEW_METADATAclause.
  • D. Create a clustered index on the view.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
Reference:
http://msdn.microsoft.com/en-us/library/ms188783.aspx
by ayn1 at Aug. 31, 2023, 5:13 a.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
ayn1
1 year, 8 months ago
Agree.
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