nerdexam
Microsoft

70-448 · Question #48

You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL…

The correct answer is B. You should build the Integration Services project. See the full explanation below for the reasoning.

Question

You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL Server 2008. You work as the technical support. Now in Business Intelligence Development Studio, you are developing a SQL Server 2008 Integration Services (SSIS) project. You configure the project properties as shown in the following image. You need to create a deployment manifest for all packages in the project. What should you do?

Exhibit

70-448 question #48 exhibit

Options

  • AYou should view the code of each Data Transformation Services (DTS) package.
  • BYou should build the Integration Services project
  • CYou should modify the AllowConfigurationChanges property of the project
  • DYou should copy each package.

How the community answered

(37 responses)
  • A
    14% (5)
  • B
    78% (29)
  • C
    5% (2)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice