Free Microsoft 70-448 Exam Dumps Questions & Answers

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 maintain a SQL Server 2008 Reporting Services (SSRS) instance for a shoe company.
An existing report on shoe sales allows the user to see the company's revenue across many different
attributes.
You need to create a drop down list that filters the report by one or more shoe colors.
You alter the main dataset and configure the report parameter to accept multiple values.
What should you do next?

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

You create a SQL Server 2008 Reporting Services (SSRS) report. This report includes a matrix containing three groups. The last group is Customer Name.
When a user clicks on a customer name, a new report should open with detailed customer information.
You need to enable this functionality. What option should you use?

• A.  Go to Bookmark
• B.  Go to URL
• C.  Go to Report
• D.  Enable Interactive Sorting

You maintain a SQL Server 2008 Analysis Services (SSAS) instance. The instance contains a database
that is used by the members of the Engineering group.
You configure a new role named Engineering and Design by using the following allowed permission set:
{[Employees].[Department].[Engineering and Design]}
You assign the Engineering group to the Engineering and Design role.
You need to ensure that users in the Engineering and Design role can view data only for their department.
What should you do?

• A.  Select the Enable Visual Totals check box for the Engineering and Design role.
• B.  Add the Roles = [Engineering and Design]; parameter to the connection string.
• C.  Add the User ID = [Engineering and Design]; parameter to the connection string.
• D.  Add your account temporarily to the Engineering and Design role.

You maintain a SQL Server 2008 Integration Services (SSIS) instancE.The instance stores packages in
a SQL Server 2008 instance.
You need to deploy the package of an instance of SSIS to another SSIS instance that stores its packages in
a shared directory.
What should you do?

• A.  Execute the dtexecui command.
• B.  Execute the dtutil command.
• C.  Execute the dtswizard command.
• D.  Execute the dtexec command.

You create a SQL Server 2008 Analysis Services (SSAS) solution.
The cube structure is as shown in the following exhibit. (Click the Exhibit button.)
You need to ensure that the Amount measure can be aggregated for the DimCustomer dimension.
What should you do?

• A.  Create a referenced relationship between DimCustomer and FactCustomerAccount. Set DimAccount as an intermediate dimension.
• B.  Create a many-to-many relationship between DimCustomer and FactTransaction. Set FactCustomerAccount as an intermediate measure group.
• C.  Create a regular relationship between DimCustomer and FactTransaction.
• D.  Create a many-to-many relationship between DimCustomer and FactCustomerAccount. Set FactTransaction as an intermediate measure group.