Prepare with Microsoft 70-448 exam practice material, pass for sure

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

You create a SQL Server 2008 Analysis Services (SSAS) solution.
You add a data source view (DSV) to the solution. The DSV has a table named Employee that includes the
following columns:
EmployeeKey
ManagerKey
The ManagerKey column references the manager of the employees.
You need to define the relationship between the employees and their manager in the DSV.
What should you do?

• A. Create a relationship by using ManagerKey as the source column and EmployeeKey as the destination column.
• B. Create a Named Calculation that uses EmployeeKey and ManagerKey
• C. Create a Named Query that uses a relationship with EmployeeKey as the source column and ManagerKey as the destination column.
• D. Create a relationship by using EmployeeKey as the source column and ManagerKey as the destination column.

You are developing a SQL Server 2008 Integration Services (SSIS) package.
The package performs the following tasks:
Processes multiple files by using a ForEach Loop container.
Imports the contents of the files to a table by using a Data Flow task.
Logs the results of the status into a table by using an Execute SQL task.
You need to ensure that all the tasks of the package except the Execute SQL task execute within a single
transaction.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. In the Execute SQL task, configure the TransactionOption property to NotSupported.
• B. In the Foreach Loop container, configure the TransactionOption property to NotSupported.
• C. In the package, configure the TransactionOption property to Required.
• D. In the Data Flow task, configure the TransactionOption property to Required.
• E. In the package, configure the TransactionOption property to NotSupported.
• F. In the Execute SQL task, configure the TransactionOption property to Supported.

You design a report by using SQL Server 2008 Reporting Services (SSRS).
Detail information is displayed each time the users render the report.
You need to ensure that the following requirements are met:
Summary information is displayed when the report is initially rendered.
Detail information is displayed only when the users click a column header.
What should you do?

• A. On the column that contains detail information, set the hidden property to TruE. Set the Visibility can be toggled by another report item property to True.
• B. On the column that contains detail information, set the hidden property to TruE. Set the Visibility can be toggled by another report item property to False.
• C. On the column that contains detail information, set the hidden property to FalsE. Set the Visibility can be toggled by another report item property to True.
• D. On the column that contains detail information, set the hidden property to FalsE. Set the Visibility can be toggled by another report item property to False.

You create a SQL Server 2008 R2 Reporting Services (SSRS) solution.
The school district needs to be able to retrieve the median value of all tests scores.
You build a custom function named Median that accepts the test scores and returns the median test score.
You need to run this custom function.
Which expression should you use?

• A. =Code.Function.Median()
• B. =Execute.Median(Fields!TestScores)
• C. =Code.Median(Fields!TestScores)
• D. =Execute Function Median(Fields!TestScores)