70-463 試験問題を無料オンラインアクセス

You are developing a SQL Server Integration Services (SSIS) package.
OnError and OnWarning events must be logged for viewing in the built-in SSIS reports by using SQL Server Management Studio.
You need to execute the package and minimize the number of event types that are logged.
Which setting should you use? (To answer, change the appropriate setting in the answer area.)

正解：

Explanation

Ref: http://msdn.microsoft.com/en-gb/library/hh231191.aspx

You are developing a project that contains multiple SQL Server Integration Services (SSIS) packages. The packages will be deployed to the SSIS catalog. One of the steps in each package accesses an FTP site to download sales transaction data.
You create project parameters to store the username and password that are used to access the FTP site.
You need to ensure that the username and password values are encrypted when they are deployed.
What should you do?

• A.Change the parameters to package parameters.
• B.Set the Sensitive property of the parameters to True.
• C.Change the project to the Legacy Deployment model.
• D.Set the ProtectionLevel property of the package to EncryptSensitiveWithUserKey.

You are designing a SQL Server Integration Services (SSIS) package that will load data from a source system to a data mart.
You need to combine conditionally the value of two project parameters to a package variable.
What should you do?

• A.Set the Expression property of the variable.
• B.Set the data type property of the variable.
• C.Configure an event handler.
• D.Modify the namespace of the variable.

You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a source system into a data warehouse hosted on SQL Azure. One of the columns in the data source is named ProductCode.
Some of the data to be loaded will reference products that need special processing logic in the data flow.
You need to enable separate processing streams for a subset of rows based on the source product code.
Which data flow transformation should you use?

• A.Script Task
• B.Audit
• C.Source Assistant
• D.Conditional Split

You are preparing to install SQL Server 2012 Master Data Services (MDS).
You need to ensure that the database requirements are met.
What should you install?

• A.SQL Server 2008 Enterprise (64-bit) x64 on the database server
• B.Microsoft SharePoint Foundation 2010 SP1
• C.SQL Server 2012 Enterprise (64-bit) x64 on the database server
• D.SQL Server 2012 Data Center (64-bit) x64 on the database server