Online Access Free 070-448 Exam Questions

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.Create a view, SalesProfit, as Select *, OrderTotal CostTotal as Profit from SalesOrder.
• 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 * from SalesOrder as the expression.
• D.Add a Named Query to the DSV, using Select *,OrderTotal CostTotal from SalesOrder as the expression.
• E.Add a Named Calculation to the SalesOrder table, using OrderTotal,CostTotal as the expression.
• F.Add a Named Query to the DSV and then ass a Named Calculation to that query, using OrderTotal -CostTotal 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 * from SalesOrder.

You are editing a SQL Server 2008 Integration Services (SSIS) package by using Business Intelligence
Development Studio. The package uses a custom data flow component. The package runs successfully.
You attempt to add another instance of the custom data flow component to the package. The data flow
component does not appear in the toolbox or in the Choose Toolbox Items dialog box.
You need to add the custom data flow component to the toolbox.
What should you do?

• A.Add the assembly to the Global Assembly Cache.
• B.Copy the assembly to the appropriate folder.
• C.Register the assembly by using the Assembly Registration utility (REGASM.EXE).
• D.Register the assembly by using the REGSVR32 utility.

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You create a SQL Server 2008 Reporting Services (SSRS) report. The report is hosted in a SharePoint environment. The UserID is passed into the report automatically when the user views the report. The UserID will be used to link to other pages on the SharePoint site via url.
You need to prevent the user from seeing their UserID.
What should you do?

• A.Create a dynamic data source from a dataset by using the IN operator.
• B.Create a dynamic data source from a dataset that includes a list of distinct servers.
• C.Create a dynamic dataset that utilizes the WHERE clause to filter by the parameter.
• D.Configure the Internal Visibility option for the parameter.
• E.Configure the Hidden Visibility property.
• F.Develop a report for each environment.
• G.Create a distinct dataset that includes all possible values and attach it to the parameter.
• H.Create a dynamic dataset that includes a list of the different users.

You administer an instance of a SQL Server 2008 server.
The server is used to execute SQL Server 2008 Integration Services (SSIS) packages.
You need to ensure that the server executes only correctly signed packages.
What should you do?

• A.Set the BlockedSignatureStates registry entry to NoAdministrativeRestriction.
• B.Set the package protection level on all packages to EncryptSensitiveWithPassword.
• C.Set the package protection level on all packages to DontSaveSensitive.
• D.Set the BlockedSignatureStates registry entry to Block invalid and untrusted signatures and unsigned
  packages.

You maintain an instance of SQL Server 2008 Reporting Services (SSRS). The instance contains
several reports.
You deploy a report project on the instance by using the Business Intelligence Development Studio (BIDS).
You discover that the production data sources on the instance are replaced by the test data sources of the
report project.
You need to ensure that when the report project is deployed in future, the existing reports are unaffected.
What should you do?

• A.Configure the TargetDataSourceFolder property.
• B.Configure the TargetReportFolder property.
• C.Configure the TargetServerURL property.
• D.Configure the OverwriteDataSources property.