Online Access Free 070-448 Exam Questions

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 OverwriteDataSources property.
• B.Configure the TargetReportFolder property.
• C.Configure the TargetDataSourceFolder property.
• D.Configure the TargetServerURL property.

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 develop a SQL Server 2008 Reporting services (SSRS) instance of a report model.
The organization requires that users of a report be able to dynamically change the server environment.
You need to create a parameter that gives the user the option to choose the server before report execution.
What should you do?

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

You create a SQL Server 2008 Analysis Services (SSAS) solution.
You enable proactive caching for a partition.
You need to ensure that SSAS can query relational data when multidimensional storage is being updated.
What should you do?

• A.Set the OnlineMode property for the partition to Immediate.
• B.Set the ProcessingMode property for the partition to LazyAggregations.
• C.Set the OnlineMode property for the partition to OnCacheComplete.
• D.Set the ProcessingMode property for the partition to Regular.

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 False.
• 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 True.

You are managing the security in SQL Server 2008 Reporting Services (SSRS).
You assign a new user to a role.
You need to grant the permissions to the user to publish reports and manage content only in a private folder.
What should you do?

• A.Assign the user to the Content Manager and the Report Builder roles.
• B.Assign the user to the Publisher role.
• C.Assign the user to the My Reports role.
• D.Assign the user to the Content Manager and the Browser roles.