Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan : 70-448

You develop a SQL Server 2008 Integration Services (SSIS) package. The package downloads several
files from a remote FTP server by using multiple FTP tasks, and then processes data by using multiple
Execute SQL tasks.
You need to configure the package to restart at the point of failure after the package downloads the files.
What should you do?

• A. Configure the Execute SQL tasks to support transactions.
• B. Configure the package to use a checkpoint.
• C. Configure the FTP tasks to support transactions.
• D. Move all the FTP tasks to a sequence container.

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

You create a SQL Server 2008 Analysis Services (SSAS) solution. You have a dimension named Account and a time dimension named Time. You have a fact table that contains a column named CurrentBalance. CurrentBalance contains the current account balance. You need to create a measure named AccountBalance from the CurrentBalance column to display the closing account balance for a time period. What should you do?

• A. Set the AggregationFunction property of AccountBalance to Sum.
• B. Set the AggregationFunction property of AccountBalance to ByAccount.
• C. Set the AggregationFunction property of AccountBalance to LastNonEmpty.
• D. Set the AggregationFunction property of AccountBalance to FirstNonEmpty.

You create a SQL Server 2008 R2 Analysis Services (SSAS) solution.
You are configuring security settings for a new database role with the following requirements:
Only the West member can be viewed by the database role. All other existing members and any newly
added members of the Region attribute will not be visible. Members in attribute hierarchies that include a
member of the Region attribute remain visible. The members in other attribute hierarchies remain visible.
The state of Washington is visible.
The aggregated totals for the ALL Level and Region attributes include only the values for members that are
visible.
You need to ensure that the database role has these security settings.
What should you do? (Each correct answer presents part of the solution. Choose two.)

• A. Set the State attribute's IsAllowed = True, AllowedSet = "Except(Region..Members,{West})", ApplyDenied = True, and VisualTools = False.
• B. Set the State attribute's IsAllowed = True, AllowedSet = "Except(Region..Members,{West} + {Washington})", ApplyDenied = False, and VisualTools = False.
• C. Set the Region attribute's IsAllowed = False, DeniedSet = "Except(Region..Members,{West})", ApplyDenied = False, and VisualTools = False.
• D. Set the Region attribute's IsAllowed = True, DeniedSet = "Except(Region..Members,{West})", ApplyDenied = False, and VisualTools = True.

You design a SQL Server 2008 Integration Services (SSIS) package that contains several data flows.
You need to monitor the data that passes through each path in the data flow by using the Business
Intelligence Development Studio. You also need to ensure that data flow logic is retained.
What should you do?

• A. Use the Data Profiling task.
• B. Use the Data Viewer tool.
• C. Use the Audit transformation.
• D. Use breakpoints in the Script component.