Tag: architecture

Questions Related to architecture

___ is a business unit of work.
technology architecture

  1. BTM tasks

  2. Business task

  3. Business Process

  4. All the above

Show answer
Correct Option: A

____ is a valid BTM Return code.
technology architecture

  1. TASK_EXECUTING

  2. TASK_COMPLETE

  3. TASK_FAILED

  4. TASK_EXIT

Show answer
Correct Option: B

Task behaviours are , __,.
technology architecture

  1. STATIC,EXIT,GLOBAL

  2. GLOBAL,STATIC,DYNAMIC

  3. EXIT,POSTSTORE,COMPLETE

  4. STATIC, TEMPORARY,DYNAMIC

Show answer
Correct Option: D

____ is not a point for rule execution.
technology architecture

  1. PreLoad

  2. PostLoad

  3. Exit

  4. AfterLoad

Show answer
Correct Option: C

If a task needs to temporarily save information while a UI is presented, it can be saved in ___.
technology architecture

  1. Content Data Manager

  2. Uniform Rule Table

  3. Uniform Data Table

  4. Content DB

Show answer
Correct Option: D

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?
technology architecture

  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

Show answer
Correct Option: B

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?
technology architecture

  1. SQL Server Destination

  2. OLE DB Destination

  3. OLE DB Command Transformation

  4. Data Conversion Transformation

Show answer
Correct Option: C

Your client has requested for interactive reports. You have used SSRS to design the layout. What options of SSRS can you use to provide interactivity? (Choose all that apply)
technology architecture

  1. Define Actions

  2. Use Visibility properties

  3. Include Sub Report

  4. Use Matrix

Show answer
Correct Option: A,B

To provide for settings of connection strings in a SSIS package, which of the following is true? (Choose one ONLY)
technology architecture

  1. Use Log Configurations

  2. Use Package Configurations

  3. Use Variables

  4. Edit Package before execution

Show answer
Correct Option: B

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?
technology architecture

  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

Show answer
Correct Option: B