Tired of trying again and again to pass Microsoft 70-463 exam? Lead2pass provides you the latest Microsoft exam 70-463 preparation material to make you pass in the first attempt. Those who are going to take Microsoft 70-463 exam shortly must use our excellent exam preparation products to increase the probability of getting amazing results.
QUESTION 131
You are designing a SQL Server Integration Services (SSIS) solution that will load multiple Online Transactional Processing (OLTP) data sources into a SQL Server data mart.
You have the following requirements:
– Ensure that the process supports the creation of an exception report that details possible duplicate key values, null ratios within columns, and column-length distributions of values. – Ensure that users can generate the exception report in an XML format.
– Use the minimum development effort.
You need to design the SSIS solution to meet the requirements.
What should you do?
(More than one answer choice may achieve the goal. Select the BEST answer.)
(more…)