Microsoft
70-467 · Question #166
70-467 Question #166: Real Exam Question with Answer & Explanation
Sign in or unlock 70-467 to reveal the answer and full explanation for question #166. The question stem and answer options stay visible for context.
Question
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.)
Options
- AA table-based OLE DB source; a Script component; and a Flat File destination.
- BOnly a SQL command-based OLE DB source and a Flat File destination.
- CA table-based OLE DB source; Lookup, Aggregate, and Sort transformations;
- DA SQL command-based OLE DB source; Aggregate and Sort transformations;
Unlock 70-467 to see the answer
You've previewed enough free 70-467 questions. Unlock 70-467 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.