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

You are developing a SQL Server Integration Services (SSIS) package that imports unsorted data into a data warehouse hosted on Microsoft Azure SQL Database.
You have the following requirements:
*A destination table must contain all of the data in two source tables.
*Duplicate records must be inserted into the destination table.
You need to develop a data flow that imports the data while meeting the requirements.
How should you develop the data flow? (To answer, drag the appropriate transformation from the list of transformations to the correct location in the answer area.)

정답:

Explanation

References:
http://msdn.microsoft.com/en-us/library/ms141703.aspx
http://msdn.microsoft.com/en-us/library/ms141775.aspx
http://msdn.microsoft.com/en-us/library/ms1410
http://msdn.microsoft.com/en-us/library/ms140182

You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse.
You are developing the part of the SSIS package that populates the ProjectDates dimension table. The business key of the ProjectDates table is the ProjectName column.
The business user has given you the dimensional attribute behavior for each of the four columns in the ProjectDates table:
*ExpectedStartDate - New values should be tracked over time.
*ActualStartDate - New values should not be accepted.
*ExpectedEndDate - New values should replace existing values.
*ActualEndDate - New values should be tracked over time.
You use the SSIS Slowly Changing Dimension Transformation.
You must configure the Change Type value for each source column.
Which Change Type values should you select? (To answer, drag the appropriate value from the list of values to the correct location or locations in the answer area.)

정답:

Explanation

References:
http://msdn.microsoft.com/en-us/library/ms141715.aspx
http://msdn.microsoft.com/en-us/library/ms141662.aspx

You are using SQL Server Data Tools to develop a SQL Server Integration Services (SSIS) project.
The first package that you create in this project contains a package connection that accesses a flat file.
Additional packages in the project must also access this file.
You need to define and reuse the flat file connection in all project packages.
What should you do?

• A.Set the ProtectionLevel property of the package Connection Manager to DontSaveSensitive to reuse the flat file connection.
• B.move a table named OLDCUSTOMERS
  a project Connection Manager.
• C.Convert the project to the Package Deployment model.
• D.Copy the package Connection Manager and paste it into the second package.

You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model.
The project will be deployed to an SSIS catalog folder where Environments have already been created. You need to deploy the project. What should you do?

• A.Use an event handler for OnTaskFailed for the package.
• B.Deploy the project by using dtutil.exe with the /COPY DTS option.
• C.Create a SQL Server Agent job to execute the SSISDB.catalog.validate_project stored procedure.
• D.View the All Messages subsection of the All Executions report for the package.
• E.Create a SQL Server Agent job to execute the SSISDB.catalog.validate_package stored procedure.
• F.Use an event handler for OnError for the package.
• G.Use an event handler for OnError for each data flow task.
• H.Deploy the .ispac file by using the Integration Services Deployment Wizard.
• I.Enable the SSIS log provider for SQL Server for OnTaskFailed in the package control flow,
• J.Store the System::SourceID variable in the custom log table.
• K.Create a table to store error information. Create an error output on each data flow destination that writes OnError event text to the table.
• L.Create a table to store error information. Create an error output on each data flow destination that writes OnTaskFailed event text to the table.
• M.View the job history for the SQL Server Agent job.
• N.Store the System::ExecutionInstanceGUID variable in the custom log table.
• O.Enable the SSIS log provider for SQL Server for OnError in the package control flow.
• P.Deploy the project by using dtutil.exe with the /COPY SQL option.
• Q.Store the System::ServerExecutionID variable in the custom log table.
• R.Create a SQL Server Agent job to execute the
  SSISDB.catalog.create_execution and SSISDB.catalog.start_execution stored procedures.

NO: 206
Some of the data your company processes is sent in from partners via email.
How would you configure an SMTP connection manager to extract files from email messages?

• A.In the SMTP connection manager, configure the OperationMode setting to Send And Receive.
• B.It is not possible to use the SMTP connection manager for this; use the IMAP (Internet Message Access Protocol) connection manager instead.
• C.The SMTP connection manager supports sending and receiving email messages by default, so no additional configuration is necessary.
• D.It is not possible to use the SMTP connection manager in this way, because it can only be used by SSIS to send email messages.