get the app get the app       get the app       get the app
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.

  • : 199
  • : 6
    Previous Next

    Add a Named Calculation to the SalesOrder table, using OrderTotal ­ CostTotal as the expression.

    Add a Named Query to the DSV, using Select *,OrderTotal ­ CostTotal from SalesOrder as the expression.

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

  • 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