070-448 무료 덤프문제 온라인 액세스

You design a package by using SQL Server 2008 Integration Services (SSIS). The package is designed by
using your local development environment.
The package extracts data from a remote server and inserts it in the PROD database on the local SQL
Server 2008 instance. You deploy the package to the MSDB database on the production server.
You need to ensure that users can view, execute, and delete their own packages. What should you do?

• A.Assign the users to the db_ssisadmin role.
• B.Assign the users to a custom database role in the PROD database.
• C.Assign the users to the db_ssisltduser role.
• D.Assign the users to the db_ssisoperator role.

You maintain a SQL Server 2008 Reporting Services (SSRS) instance.
Your instance supports several different rendering extensions.
You need to configure the server so that all reports render only to Microsoft Excel.
What should you do?

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

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

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.
Same row are not matching due to a mismatched case type
You need to ensure that the data flow executes to match all rows correctly.
Which data flow component should you select?

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

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 Viewer tool.
• B.Use the Data Profiling task.
• C.Use the Audit transformation.
• D.Use breakpoints in the Script component.