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

You are developing a SQL Server Integration Services (SSIS) package.
To process complex scientific data originating from a SQL Azure database, a custom task component is added to the project.
You need to ensure that the custom component is deployed on a test environment correctly.
What should you do?

• A.Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.
• B.Configure the SSIS solution to use the Project Deployment Model.
• C.Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.
• D.Use an msi file to deploy the package on the server.
• E.Open a command prompt and run the gacutil command.
• F.Open a command prompt and run the dtutil /copy command.
• G.Add an OnError event handler to the SSIS project.
• H.Create a reusable custom logging component and use it in the SSIS project.
• I.Configure the output of a component in the package data flow to use a data tap.
• J.Open a command prompt and run the dtexec /rep /conn command.
• K.Open a command prompt and run the dtexec /dumperror /conn command.

You are the administrator for a Master Data Services (MDS) environment.
A user who is not an administrator must be able to access Master Data Manager.
You need to assign permissions to the user.
Which function should you use?

• A.Version Management
• B.Integration Management
• C.System Administration
• D.Explorer
• E.User and Group Permissions

You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection managers and variables.
You have the following requirements:
*Ensure that the deployment model supports changing the content of connection strings by using parameters at execution time.
*Ensure that the deployment model automatically starts from calls to the catalog.start_execution stored procedure in the SSISDB database.
*Maximize performance at execution time.
*Minimize development effort.
You need to design a solution that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Use a project deployment model. Configure connections in an XML configuration file referenced by an environment variable that corresponds to the SQL Server environment of each SSIS package.
• B.Use a package deployment model. Save each SSIS package to a file share that can be accessed from all environments.
• C.Use a project deployment model. Modify connection manager properties to use project parameters.
  Ensure that the SSISDB database is created.
• D.Use a package deployment model. Use a SQL Server package configuration with a common filter.
  Change the contents of the SSIS Configurations table at runtime.

You are installing the Data Quality Client on user desktops.
You need to ensure that the prerequisite software components are installed.
Which components must be present to meet this goal? (Each correct answer presents part of the solution.
Choose all that apply.)

• A.Microsoft Silverlight 5
• B.Microsoft Silverlight 4
• C..NET Framework 4.0
• D.SQL Server Data Tools
• E..NET Framework 3.5 SP1
• F.SQL Server Management Studio
• G.Internet Explorer 6.0 SP1 or later

You are the data steward for a Business Intelligence project.
You must identify duplicate rows stored in a SQL Server table and output discoveries to a CSV file. A Data Quality Services (DQS) knowledge base has been created to support this project.
You need to produce the CSV file with the least amount of development effort.
What should you do?

• A.Create an Integration Services package and use a Fuzzy Lookup transform.
• B.Create a Data Quality Project.
• C.Create an Integration Services package and use a DQS Cleansing transform.
• D.Create an Integration Services package and use a Fuzzy Grouping transform.
• E.Create a Master Data Services (MDS) model.