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.
Questions
What is a Singleton Pattern
- The pattern that creates many instances of a single class in one shot
- This pattern is to have only a single constructor to a class
- Provides a class of which there can be no more than an instance, and provides a single global point of access to that instance
- Creates and maintains a pool of objects, using which a single object can used and returned to the pool
This pattern, which groups a complex object hierarchy and provides a new, simpler interface to access those data.
- Façade Pattern
- Adapter Pattern
- Bridge Pattern
- Proxy Pattern
--- and --- subroutines are used in implementing business tasks.
- Load & PreLoad
- Preload & PostStore
- Load & Store
- Store & PreStore
--- data are passed from one BP (business process) to another.
- All
- Passing Context
- Global Context
- Task Contet
--- is not a status of BTM tasks.
- DONE
- READY
- NOT READY
- INCOMPLETE
Using --- BTM provides rules for managing taskflow.
- DARP Rules Executing Component
- DARP Rules Execution Component
- ARP Rules Executing Component
- ARP Rules Execution Component
_____ provides integration between UI and business Services.
- BTM methods
- UI task
- User task
- Business tasks
_____ is BP task definition table.
- DTGYBBT
- DTGYBBP
- DTWRBBT
- DTWRBBP
____ variables are usually applicaiton specific.
- Global
- Task
- Local
- Application
Which is not a special BTM variable to report information to applications?
- BTM.ActionType
- BTM.ActionTarget
- BTM.PSActionTarget
- BTM.ActionContext
___ launches a BP from another BP.
- BNewBp
- NewBP
- Init
- NewBPNs
___ cannot have load & store subroutines.
- Root
- Container
- Subroutines
- Group
___ is a business unit of work.
- BTM tasks
- Business task
- Business Process
- All the above
____ is a valid BTM Return code.
- TASK_EXECUTING
- TASK_COMPLETE
- TASK_FAILED
- TASK_EXIT
Task behaviours are __, ,.
- STATIC,EXIT,GLOBAL
- GLOBAL,STATIC,DYNAMIC
- EXIT,POSTSTORE,COMPLETE
- STATIC, TEMPORARY,DYNAMIC
____ is not a point for rule execution.
- PreLoad
- PostLoad
- Exit
- AfterLoad
If a task needs to temporarily save information while a UI is presented, it can be saved in ___.
- Content Data Manager
- Uniform Rule Table
- Uniform Data Table
- Content DB
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?
- The variable is only accessible to the first Execute SQL Task
- The variable is accessible to both Execute SQL Task, but not the Script Task
- The variable is accessible to both Execute SQL Task and the Script Task
- The variable is not accessible to any Task
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?
- SQL Server Destination
- OLE DB Destination
- OLE DB Command Transformation
- Data Conversion Transformation
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)
- Define Actions
- Use Visibility properties
- Include Sub Report
- Use Matrix