Microsoft
70-463 · Question #183
70-463 Question #183: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #183. The question stem and answer options stay visible for context.
Extract and transform data
Question
To support the implementation of new reports, Active Directory data will be downloaded to a SQL Server database by using a SQL Server Integration Services (SSIS) 2012 package. The following requirements must be met: - All the user information for a given Active Directory group must be downloaded to a SQL Server table. - The download process must traverse the Active Directory hierarchy recursively. You need to configure the package to meet the requirements by using the least development effort. Which item should you use?
Options
- AScript task
- BScript component configured as a transformation
- CScript component configured as a source
- DScript component configured as a destination
Unlock 70-463 to see the answer
You've previewed enough free 70-463 questions. Unlock 70-463 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.
Topics
#Script component#Active Directory#data source#recursive traversal