Microsoft 070-448 Value Pack (Frequently Bought Together)

You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution contains a time
dimension named DimTime that contains a hierarchy named Yr-Qtr-Mth.
You have a measure named Amount from a measure group named Measures.
You need to create a calculated member to display the Amount measure in the previous time period for the
current level of the Yr-Qtr-Mth hierarchy.
Which expression should you use?

• A. ([Measures].[Amount],OPENINGPERIOD( [DimTime].[Yr-Qtr-Mth].FirstSibling.Level))
• B. ([Measures].[Amount],LASTPERIODS( 0,[DimTime].[Yr-Qtr-Mth].PrevMember))
• C. ([Measures].[Amount],[DimTime].[Yr-Qtr-Mth].FirstSibling)
• D. ([Measures].[Amount],[DimTime].[Yr-Qtr-Mth].PrevMember)

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 are SQL Server 2008 Reporting Services (SSRS) developer. You develop a report with two parameters
names State and City in that order.
When the State parameter is selected, the City parameter should be filtered by the State selected.
You need to enable this functionality.
What should you do?

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

You install and configure SQL Server 2008 Reporting Services (SSRS) instance.
The users of the report server plan to deliver reports through e-mail messages.
You need to configure the report server for e-mail message delivery by using a remote SMTP server.
What should you do?

• A. Modify the Global.asax file.
• B. Modify the rssrvpolicy.config file.
• C. Modify the Web.config file.
• D. Modify the RSReportServer.config file.

You create a SQL Server 2008 Analysis Services (SSAS) solution.
You create a dimension named DimProduct that contains an attribute named Price. You use the
DimProduct dimension in a cube.
You need to ensure that aggregations are not associated with the Price attribute.
What should you do?

• A. Set the AttributeHierarchyEnabled property of the Price attribute to False.
• B. Set the IsAggregatable property of the Price attribute to False.
• C. Set the GroupingBehavior property of the Price attribute to DiscourageGrouping.
• D. Set the MembersWithData property of the Price attribute to NonLeafDataHidden.

You design a report by using SQL Server 2008 Reporting Services (SSRS).
The report will be included in a Windows Forms application that is distributed to remote users. These users
have no access to the report server.
You need to ensure that the application renders the report correctly.
What should you do?

• A. Use the RenderStream method of the Reporting Services Simple Object Access Protocol (SOAP) API.
• B. Use the ReportViewer control along with the LocalReport property.
• C. Use the Render method of the Reporting Services Simple Object Access Protocol (SOAP) API.
• D. Use the ReportViewer control along with the RemoteReport property.