Tag: architecture

Quizzes (70) Questions (1408)

Questions Related to architecture

Multiple choice technology architecture

You are developing a SQL Server 2008 Integration Services package. The package consists of a Sequence container holding a For Loop and Foreach Loop. There are two Execute SQL tasks in the Foreach Loop, and one Script Task in the For Loop. You have created a variable for the Foreach Loop. What will be the scope of the variable?

  1. The variable is only accessible to the first Execute SQL Task

  2. The variable is accessible to both Execute SQL Task, but not the Script Task

  3. The variable is accessible to both Execute SQL Task and the Script Task

  4. The variable is not accessible to any Task
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation
Multiple choice technology architecture

You are developing a SQL Server 2008 Integration Services data flow that loads data to a SQL Server 2008 database. You need to ensure that the data flow updates the existing records in the SQL Server database by using data from the rows in your data flow. Which data flow component should you use?

  1. SQL Server Destination

  2. OLE DB Destination

  3. OLE DB Command Transformation

  4. Data Conversion Transformation
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology architecture

You want to deploy a custom assembly in SQL Server 2008 Report Services for use in the reports you are generating for your organization. What must you do to deploy a custom assembly?

  1. Grant Execution permissions to custom assemblies

  2. Copy the custom assembly from the build location to the report server bin folder

  3. Copy the custom assembly from the build location to the report manager bin folder

  4. Copy the custom assembly from the build location to the report server temp file folder
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation