Which two of the following options describe the solution that would require the minimum development effort?

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
The company has a SQL Server data mart named DMMarketing which contains historical
data for use by the Marketing department.
You need to create a package in SQL Server Integration Services (SSIS) to load data into
DMMarketing. The data will come from multiple Online Transactional Processing (OLTP)
data sources.
Your solution must be able to analyze the data for problems by reporting on column-length
value distribution, null values in selected columns and duplicate values in potential key
columns. Users must be able to generate an XML report that lists any exceptions.
Which two of the following options describe the solution that would require the minimum
development effort? (Choose two).

A.
Configure a Data Profiling task to analyze the data.

B.
Configure a Data Flow task to analyze the data and load the exceptions into a SQL Server
table.

C.
Create a stored procedure to analyze the data and load the exceptions into a SQL Server table.

D.
Query the table to view the exceptions.

E.
Use Data Profile Viewer to view the exceptions.

Explanation: