Business Process Management and Software Architecture

Covers business process management (BTM), data integration with SQL Server tools (SSIS, SSRS), and software design patterns including Façade and Singleton patterns.

20 Questions Published

Questions

Question 1 Multiple Choice (Single Answer)

What is a Singleton Pattern

  1. The pattern that creates many instances of a single class in one shot
  2. This pattern is to have only a single constructor to a class
  3. Provides a class of which there can be no more than an instance, and provides a single global point of access to that instance
  4. Creates and maintains a pool of objects, using which a single object can used and returned to the pool
Question 2 Multiple Choice (Single Answer)

This pattern, which groups a complex object hierarchy and provides a new, simpler interface to access those data.

  1. Façade Pattern
  2. Adapter Pattern
  3. Bridge Pattern
  4. Proxy Pattern
Question 3 Multiple Choice (Single Answer)

--- and --- subroutines are used in implementing business tasks.

  1. Load & PreLoad
  2. Preload & PostStore
  3. Load & Store
  4. Store & PreStore
Question 4 Multiple Choice (Single Answer)

--- data are passed from one BP (business process) to another.

  1. All
  2. Passing Context
  3. Global Context
  4. Task Contet
Question 5 Multiple Choice (Single Answer)

--- is not a status of BTM tasks.

  1. DONE
  2. READY
  3. NOT READY
  4. INCOMPLETE
Question 6 Multiple Choice (Single Answer)

Using --- BTM provides rules for managing taskflow.

  1. DARP Rules Executing Component
  2. DARP Rules Execution Component
  3. ARP Rules Executing Component
  4. ARP Rules Execution Component
Question 7 Multiple Choice (Single Answer)

_____ provides integration between UI and business Services.

  1. BTM methods
  2. UI task
  3. User task
  4. Business tasks
Question 8 Multiple Choice (Single Answer)

_____ is BP task definition table.

  1. DTGYBBT
  2. DTGYBBP
  3. DTWRBBT
  4. DTWRBBP
Question 9 Multiple Choice (Single Answer)

____ variables are usually applicaiton specific.

  1. Global
  2. Task
  3. Local
  4. Application
Question 10 Multiple Choice (Single Answer)

Which is not a special BTM variable to report information to applications?

  1. BTM.ActionType
  2. BTM.ActionTarget
  3. BTM.PSActionTarget
  4. BTM.ActionContext
Question 11 Multiple Choice (Single Answer)

___ launches a BP from another BP.

  1. BNewBp
  2. NewBP
  3. Init
  4. NewBPNs
Question 12 Multiple Choice (Single Answer)

___ cannot have load & store subroutines.

  1. Root
  2. Container
  3. Subroutines
  4. Group
Question 13 Multiple Choice (Single Answer)

___ is a business unit of work.

  1. BTM tasks
  2. Business task
  3. Business Process
  4. All the above
Question 14 Multiple Choice (Single Answer)

____ is a valid BTM Return code.

  1. TASK_EXECUTING
  2. TASK_COMPLETE
  3. TASK_FAILED
  4. TASK_EXIT
Question 15 Multiple Choice (Single Answer)

Task behaviours are __, ,.

  1. STATIC,EXIT,GLOBAL
  2. GLOBAL,STATIC,DYNAMIC
  3. EXIT,POSTSTORE,COMPLETE
  4. STATIC, TEMPORARY,DYNAMIC
Question 16 Multiple Choice (Single Answer)

____ is not a point for rule execution.

  1. PreLoad
  2. PostLoad
  3. Exit
  4. AfterLoad
Question 17 Multiple Choice (Single Answer)

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

  1. Content Data Manager
  2. Uniform Rule Table
  3. Uniform Data Table
  4. Content DB
Question 18 Multiple Choice (Single Answer)

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
Question 19 Multiple Choice (Single Answer)

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
Question 20 Multiple Choice (Multiple Answers)

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)

  1. Define Actions
  2. Use Visibility properties
  3. Include Sub Report
  4. Use Matrix