Instantly download 70-448 updated real questions

You administer a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to troubleshoot query performance by using a Dynamic Management View (DMV).
You need to identify query sessions that execute more than 10 commands prior to disconnecting.
Which DMV should you use?

• A. Discover_Traces
• B. Discover_Sessions
• C. Discover_Connections
• D. Discover_Commands

You create a SQL Server 2008 Analysis Services (SSAS) solution. The cube structure is as shown in the
following exhibit. (Click the Exhibit button.)
The Ownership column contains decimal values that represent percentage of ownership. The sum of all the
values in the Ownership column for a single DimAccount member is 100%.
You create the following measures:
Ownership
Amount
You need to ensure that when the Amount measure is calculated against the DimCustomer dimension, the
weighted value is calculated based on the Ownership measure.
What should you do?

• A. Set the FormatString property of the Amount measure to [DimCustomer].[Amount]*[Ownership].
• B. Set the FormatString property of the Amount measure to [Amount]*[Ownership].
• C. Set the MeasureExpression property of the Amount measure to [DimCustomer].[Amount]*[Ownership].
• D. Set the MeasureExpression property of the Amount measure to [Amount]*[Ownership].

You use SSIS to consolidate customer data from a relational database and several Microsoft Excel files into a single data warehouse.
The data warehouse is missing information that exists in the Excel files.
You need to discover why the data warehouse is missing data. What should you verify first to begin troubleshooting?

• A. That SSRS has been installed and configured.
• B. That MSDTC has been started on the system.
• C. That system event logs are not full.
• D. That SSAS has been installed and configured.

You develop a SQL Server 2008 Reporting Services (SSRS) report.
The report contains a parameter named @SalesTaxRateID.
You set the value of the @SalesTaxRateID parameter in the report by selecting a specific region.
You need to configure the report to prevent users from modifying the value of the @SalesTaxRateID
parameter. What should you do?

• A. Set the Internal property.
• B. Remove the default values.
• C. Set the Hidden property.
• D. Clear the Prompt value.

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?

• A. Add a Named Query to the DSV and then ass a Named Calculation to that query, using OrderTotal -CostTotal as the expression.
• B. Add a Named Calculation to the SalesOrder table, using OrderTotal,CostTotal as the expression.
• C. Add a Named Query to the DSV, using Select *,OrderTotal CostTotal from SalesOrder as the expression.
• D. Add a Named Calculation to the SalesOrder table, using OrderTotal CostTotal as the expression.
• E. Create a view, SalesProfit, as Select * from SalesOrder.
• F. Add a Named Query to the DSV, using Select * from SalesOrder as the expression.
• G. Add a Named Calculation to the SalesOrder table, using OrderTotal + CostTotal as the expression.
• H. Create a view, SalesProfit, as Select *, OrderTotal CostTotal as Profit from SalesOrder.