Online Access Free 070-448 Exam Questions

You are designing a SQL Server 2008 Integration Services (SSIS) packagE.The package includes a Data
Flow task that copies several million rows. The data flow requires a match against a reference table that
contains 10,000 rows. Each row in the reference table will be used during the data flow.
You need to ensure that the data flow executes in the minimum amount of time.
Which data flow component should you select?

• A.a Fuzzy Lookup transformation
• B.a Lookup transformation along with the No cache option
• C.a Lookup transformation along with the Full cache option
• D.a Lookup transformation along with the Partial cache option

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 False.
• B.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.
• C.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.
• 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 manage the security in SQL Server 2008 Reporting Services (SSRS). The report server contains a
folder named Management Reports.
All groups can view and modify reports in any folder.
You need to ensure that only the Managers group can view and modify reports in the Management Reports
folder.
What should you do?

• A.Create a Managers rolE. Assign the Managers role to the root folder. Remove all groups from the Management Reports folder.
• B.Create a Managers role. Assign the Managers role to the Management Reports folder. Remove all other groups from the Management Reports folder.
• C.Add the Managers group to the root folder and assign the Content Manager rolE. Remove all groups from the Management Reports folder.
• D.Remove all groups from the Management Reports folder. Add the Managers group to the folder and assign the Content Manager role.

You maintain a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to run the Usage-Based Optimization Wizard.
You need to enable query logging.
What should you do?

• A.Set the AllowedBrowsingFolders server property to include the folder from the LogDir setting.
• B.Set the QueryLogSampling server property to 10.
• C.Set the QueryLogConnectionString server property to a valid connection string.
• D.Set the LogDir server property to a valid path.

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.Create a distinct dataset that includes all possible values and attach it to the parameter.
• E.Create a dynamic dataset that utilizes the WHERE clause to filter by the parameter.
• F.Configure the Hidden Visibility property.
• G.Create a dynamic dataset that includes a list of the different users.
• H.Configure the Internal Visibility option for the parameter.