READ Free Dumps For Microsoft- 70-461
| Question ID 15082 | You need to create a table named OrderDetails on a new server. OrderDetails must meet
the following requirements:
✑ Contain a new column named LineltemTotal that stores the product of ListPrice
and Quantity for each row.
✑ The calculation for a line item total must not be run every time the table is queried.
✑ The code must NOT use any object delimiters.
The solution must ensure that LineItemTotal is stored as the last column in the table.
Part of the correct T-SQL statement has been provided in the answer area. Provide the
complete code.
|
| Option A | Answer : Please review the explanation part for this answer
|
Explanation Explanation: CREATE TABLE OrderDetails ( ListPrice money NOT NULL, Quantity int NOT NULL, LineItemTotal AS (ListPrice * Quantity) PERSISTED )
| Question ID 15083 | You develop a Microsoft SQL Server 2012 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?
|
| Option A | Create an INSTEAD OF trigger on the view.
|
| Option B | Create an AFTER trigger on the view.
|
| Option C | Modify the view to use the WITH VIEW_METADATA clause.
|
| Option D | Create a clustered index on the view.
|
| Correct Answer | D |
Explanation Reference: http://msdn.microsoft.com/en-us/library/ms188783.aspx