Microsoft
70-463 · Question #232
70-463 Question #232: Real Exam Question with Answer & Explanation
The correct answer is B: An SSIS project can contain one or more SSIS packages.. An SSIS project is a container that holds one or more packages, and each package contains the control flow and data flow logic for a specific ETL operation.
Question
Which of the following statements are true? (Choose all that apply.)
Options
- AAn SSIS package can contain one or more SSDT solutions, each performing a specific data
- BAn SSIS project can contain one or more SSIS packages.
- CAn SSIS project can contain exactly one SSIS package.
- DSSIS packages contain programmatic logic used in data movements and data transformation
Explanation
An SSIS project is a container that holds one or more packages, and each package contains the control flow and data flow logic for a specific ETL operation.
Common mistakes.
- A. An SSIS package contains tasks, transformations, and data flows - not SSDT solutions; SSDT is the development environment used to create packages, not something contained within them.
- C. An SSIS project can contain multiple packages, not exactly one; this is a core feature of the project deployment model which groups related packages together.
Concept tested. SSIS project and package hierarchy and structure
Community Discussion
No community discussion yet for this question.