The Sales database includes a table named Products that contains 42 columns, and two
tables that record all product sales transactions. The database does not store aggregated
data. The database is continually maintained to provide optimal indexing. The database
server is sized appropriately.
The Marketing department requests a delimited text file that includes seven fields containing
product information from the Products table.
You have the following requirements:
Display the ProductID in the first column. Organize the remaining columns alphabetically by
column heading.
Sort rows in ProductID order.
Aggregate product units sold.
Minimize the time required to return the results.
You create a SQL Server Integration Services (SSIS) package and add the appropriate
connection managers and a Data Flow task.
You need to develop the Data Flow task.
What should you add to the Data Flow task? (More than one answer choice may achieve the
goal. Select the BEST answer.)
A.
A table-based OLE DB source; a Script component; and a Flat File destination.
B.
Only a SQL command-based OLE DB source and a Flat File destination.
C.
A table-based OLE DB source; Lookup, Aggregate, and Sort transformations; and a Flat
File destination.
D.
A SQL command-based OLE DB source; Aggregate and Sort transformations; and a Flat
File destination.
I think that is database is optimized, B solution should be faster.
You push aggregate and sort the data to DB.
Moreover after the data is aggregated there is less network
overload (less rows fetched from DB).
Dim, do you have any latest & valid dump??
If so, can you please send it to [email protected]
Will highly appreciate it.
Thank you, Andres
Agree
Agree with Dim. T-SQL group by clause is faster than SSIS aggregate transformation.
Nevertheless, there could be cases where D answer could be correct:
https://mitchellsql.wordpress.com/2014/06/22/use-the-aggregate-transform-in-ssis-to-improve-performance-of-t-sql/