get the app get the app       get the app       get the app


Question: You have a SQL Server 2008 R2 Analysis Services (SSAS) solution.

You add a new Data Source View (DSV) to the solution. The DSV includes a SalesOrder table with columns for OrderTotal and CostTotal.

You need to derive the profit for each order without modifying the underlying data.

What should you do?

1)Add a Named Calculation to the SalesOrder table, using OrderTotal ­ CostTotal as the expression.
2)Add a Named Query to the DSV, using Select *,OrderTotal ­ CostTotal from SalesOrder as the expression.
3)Create a view, SalesProfit, as Select *, OrderTotal ­ CostTotal as Profit from SalesOrder.
4)Add a Named Query to the DSV and then ass a Named Calculation to that query, using OrderTotal ­ CostTotal as the expression.
5)Create a view, SalesProfit, as Select * from SalesOrder.
6)Add a Named Query to the DSV, using Select * from SalesOrder as the expression.
7)Add a Named Calculation to the SalesOrder table, using OrderTotal,CostTotal as the expression.
8)Add a Named Calculation to the SalesOrder table, using OrderTotal + CostTotal as the expression.


Previous Next
Exam



Suggest other answer
Login to Discuss/suggest the answer...

Exam Exam: 70-448 MS SQL Server 2008, Business Intelligence





Recommended Learning for you

Close(X)
Subscribe here for free mock test on IAS PCS SSC and other competitive exam. Signup here to get SSC CGL Solution and main exam study material