Ensurepass.com : Ensure you pass the IT Exams
2018 May Microsoft Official New Released 70-463
100% Free Download! 100% Pass Guaranteed!

Implementing a Data Warehouse with Microsoft SQL Server 2012

Question No: 51 – (Topic 1)

You are writing a SQL Server Integration Services (SSIS) package that transfers data from a legacy system.

Data integrity in the legacy system is very poor. Invalid rows are discarded by the package but must be logged to a CSV file for auditing purposes.

You need to establish the best technique to log these invalid rows while minimizing the amount of development effort.

What should you do?

  1. Add a data tap on the output of a component in the package data flow.

  2. Deploy the package by using an msi file.

  3. Run the package by using the dtexecui.exe utility and the SQL Log provider.

  4. uses the dtutil /copy command.

  5. Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.

  6. Create an OnError event handler.

  7. uses the Project Deployment Wizard.

  8. Use the gacutil command.

  9. Create a reusable custom logging component.

  10. Run the package by using the dtexec /rep /conn command.

  11. Run the package by using the dtexec /dumperror /conn command.

Answer: A

Reference:

http://www.rafael-salas.com/2012/01/ssis-2012-quick-peek-to-data-taps.html http://msdn.microsoft.com/en-us/library/hh230989.aspx http://msdn.microsoft.com/en-us/library/jj655339.aspx

Question No: 52 DRAG DROP – (Topic 1)

You use SQL Server Integration Services (SSIS) for extract, transformation, load (ETL) processing.

Issues concerning addresses are discovered in the data warehouse that you manage. Validation must separate the addresses into three categories:

->Valid addresses

->Autocorrected addresses

->Invalid addresses

You need to enhance the SSIS packages to perform address validation by using an external service.

Which transformation should you use? (To answer, drag the appropriate transformation from the list of options to the correct location or locations in the answer area.)

Answer:

Ensurepass 2018 PDF and VCE

Question No: 53 – (Topic 1)

To ease the debugging of packages, you standardize the SQL Server Integration Services (SSIS) package logging methodology.

The methodology has the following requirements:

鈥entralized logging in SQL Server

鈥imple deployment

鈥vailability of log information through reports or T-SQL

鈥utomatic purge of older log entries

鈥onfigurable log details

You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort.

What should you do?

  1. Deploy the package by using an msi file.

  2. Use the gacutil command.

  3. Create an OnError event handler.

  4. Create a reusable custom logging component.

  5. Use the dtutil /copy command.

  6. Use the Project Deployment Wizard.

  7. Run the package by using the dtexec /rep /conn command.

  8. Add a data tap on the output of a component in the package data flow.

  9. Run the package by using the dtexec /dumperror /conn command.

  10. Run the package by using the dtexecui.exe utility and the SQL Log provider.

  11. Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.

Answer: J Explanation: References:

http://msdn.microsoft.com/en-us/library/ms140246.aspx http://msdn.microsoft.com/en-us/library/ms180378(v=sql.110).aspx

Question No: 54 – (Topic 1)

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?

  1. Add an OnError event handler to the SSIS project.

  2. Open a command prompt and run the gacutil command.

  3. Configure the SSIS solution to use the Project Deployment Model.

  4. Open a command prompt and run the dtexec /dumperror /conn command.

  5. Configure the output of a component in the package data flow to use a data tap.

  6. Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.

  7. Open a command prompt and run the dtexec /rep /conn command.

  8. Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.

  9. Use an msi file to deploy the package on the server.

  10. Open a command prompt and run the dtutil /copy command.

  11. Create a reusable custom logging component and use it in the SSIS project.

Answer: B

Reference:

http://msdn.microsoft.com/en-us/library/ms403356.aspx

Question No: 55 – (Topic 1)

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?

  1. Set the Sensitive property of the parameters to True.

  2. Set the ProtectionLevel property of the package to EncryptSensitiveWithUserKey.

  3. Change the parameters to package parameters.

  4. Change the project to the Legacy Deployment model.

Answer: A

Question No: 56 – (Topic 1)

You manage a SQL Server Master Data Services (MDS) environment.

A new application requires access to the product data that is available in the MDS repository.

You need to design a solution that gives the application access to the product data with the least amount of development effort.

What should you do?

  1. Use sp_addlinkedserver to add a linked server to access the MDS database tables directly.

  2. Create an OLE DB connection string that sets the Provider property to MDS.

  3. Use transactional replication for data synchronization.

  4. Create a Subscription View in MDS.

Answer: D

Question No: 57 – (Topic 1)

You are creating a SQL Server Master Data Services (MDS) model. This model is used to store a master list of products.

An attribute must be added to the Product entity to define the sales manager responsible for each product.

You need to create an attribute in the Product entity that prevents users from entering invalid sales manager values.

Which type of attribute should you create?

  1. Recursive

  2. Explicit

  3. Domain-based

  4. User-defined

  5. Derived

  6. Parent

Answer: C

Explanation: References: http://msdn.microsoft.com/en-us/library/bb190163.aspx http://msdn.microsoft.com/en-us/library/ee633737.aspx http://msdn.microsoft.com/en-us/library/ee633759.aspx http://msdn.microsoft.com/en-us/library/ee633745.aspx http://msdn.microsoft.com/en-us/library/ee633724.aspx http://msdn.microsoft.com/en-us/library/ee633733.aspx http://msdn.microsoft.com/en-us/library/ff487058.aspx

Question No: 58 DRAG DROP – (Topic 1)

You are editing a SQL Server Integration Services (SSIS) package that contains a task with a sensitive property.

You need to create a project parameter and configure it so that its value is encrypted when

it is deployed to the SSIS catalog.

Which three steps should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Answer:

Ensurepass 2018 PDF and VCE

Question No: 59 – (Topic 1)

You are using a SQL Server Integration Services (SSIS) project that is stored in the SSIS catalog. An Environment has been defined in the SSIS catalog.

You need to add the Environment to the project. Which stored procedure should you use?

  1. catalog.set_environment_reference_type

  2. catalog.set_environment_property

  3. catalog.create_environment_reference

  4. catalog.create_environment

Answer: C

Question No: 60 DRAG DROP – (Topic 1)

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:

鈥xpectedStartDate – New values should be tracked over time.

鈥ctualStartDate – New values should not be accepted.

鈥xpectedEndDate – New values should replace existing values.

鈥ctualEndDate – 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 settings should you select? (To answer, select the appropriate setting or settings in the answer area. Each Change Type may be used once, more than once, or not at all.)

Ensurepass 2018 PDF and VCE

Answer: Explanation:

References:

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

100% Ensurepass Free Download!
Download Free Demo:70-463 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2018 EnsurePass 70-463 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Comments are closed.