Top 25 Oracle BAM Interview Questions and Answers

25 Oct 2020 oracleappsadmin

The blog provides the commonly asked Oracle SOA BAM (Business Activity Monitoring) Interview questions & answers to be helpful for beginners and experienced professionals.

1) Explain the usage of Business Activity Monitoring (BAM) in SOA Suite ?

The Business Activity Monitoring (BAM) is useful in monitoring the business activities, helps in generating business reports, provides BAM Alerts when the specified threshold is reached or surpassed. It allows to perform analytical decisioning for the business data. 

2) Describe the New and changed features in SOA 12c for Business Activity Monitoring (BAM) ?

  • BAM provides support for JavaScript Extension Toolkit (JET) treemap view
  • allows support for group filters in the group queries
  • allows  aggregated field based filters in run time filters
  • allows to pass runtime parameter value to the target dashboards through  configuration
  • allows text wrapping in table data
  • allows column width in pivot tables

3) What are the components of Business Activity Monitoring (BAM) ?

The Business Activity Monitoring (BAM) provides the below given components:

  • Oracle Metadata Services Repository
  • Persistent Engine
  • Continuous Query Service
  • Report Cache
  • Alert Service
  • Data objects and the Process Star Schema
  • BAM Dashboards

4) For what purpose BAM Adapter can be used ? 

The Oracle BAM Adapter is useful for the monitoring process 

  • Monitoring at Composite Level
  • Monitoring the full message

5) What tasks can be performed by “Viewers” in

Business Activity Monitoring (BAM) ? 

Viewers perform the below given tasks:

  • Allows to View Dashboards indicating the real-time data with collections of tables and charts
  • Allows to Filter data using Type parameter values with different values in the dashboard
  • Allows to  View Alert notification 
  • Allows to  View Alert history data

6) What tasks can be performed by “Creators” in

Business Activity Monitoring (BAM) ? 

Creators perform the below given tasks:

  • Allows to View  Alert and tasks for dashboard as per given access
  • Allows to Create projects containing set of BAM entities
  • Allows to Add data objects to existing projects
  • Allows to Create queries and KPIs to fetch data objects
  • Allows to Create Business Views to display data in tables and charts
  • Allows to Create Alerts to notify users for out of range data
  • Allows to Create parameters for filter data in the dashboard

7) What tasks can be performed by “Architects” in

Business Activity Monitoring (BAM) ? 

Architects perform the below given tasks:

  • Allows to Create & Manage BAM data objects
  • Allows to Configure Enterprise Message Sources (EMS)
  • Allows to Run data simulators
  • Allows to Import, Export , Migrate Data Objects, Enterprise Message Sources (EMS)
  • Allows to Use BAM services for managing data objects

8) What tasks can be performed by “Administrators” in

Business Activity Monitoring (BAM) ? 

Administrators perform the below given tasks:

  • Provide Access to All Viewer, Creator, and Architect tasks, for the projects based on role
  • Allows to monitor continuous queries
  • Allows to Monitor Viewsets
  • Allows to Configure BAM Server Properties
  • Allows to Configure BAM Server Availability
  • Allows to Configure BAM Diagnostics
  • Allows to Configure BAM Security
  • Allows to Run BAM scripts in test & production
  • Allows to Import, Export , Migrate Data Objects, Enterprise Message Sources (EMS)
  • Allows to Use BAM services for managing data objects

9) When is the benefit of using sensors in the BAM Adapter ?

Sensors in BAM Adapter are used when monitoring is to be done at variable or at activity level.

10) What are the possible ways for monitoring SOA Services ?

The SOA Services can be monitored using below given options

  • BAM Adapter
  • Sensors

11) What are the types of sensor actions ?

The sensor actions are primarily divided into 2 types:

  • Sensor Action
  • BAM Sensor Action

12) What is sensor action ? 

Sensor action is the action linked to sensor to perform on the sensor data to publish data to Database, JMS Queue/ Topic, Custom Java Handler.

13) What is the purpose of BAM Sensor Data ?

BAM Sensor data can be used when we need to send the sensor data to the BAM data object.

14) What is BAM Alert ?

BAM provides the Alert feature to perform action based on data insertion or data change. 

15) Is it possible to use BAM Alert to invoke external web service ?

Yes, BAM Alerts can invoke external web service.

16) What all data can be updated as when BAM11g is upgraded to BAM12c ?

The below given data objects are updated as part of Upgrade Activity 

  • Data Object Data
  • Data Object Metadata
  • Enterprise Message Sources (EMS) Metadata

17) Is it possible to migrate BAM Data Objects from Source Environment to Test or Production Environment including the configurations ?

Yes, BAM can be moved from one environment to another as Oracle Fusion Middleware provides scripts to copy an Oracle home and domains, as well as the configuration of BAM. The move plan can be updated with the environment specific properties.

18) Name the Real -Time Data Sources for Oracle BAM ?

  • Java Message Service
  • Oracle BAM Adapter
  • Enterprise Java Beans
  • Oracle Web Services
  • Oracle® Data Integrator

19) Describe the tuning option for designing Dashboard in Oracle BAM ?

The below tuning options can be performed:

  • Dashboard should be designed for specific group
  • Create a report which is “management by exception”
  • Provides user access based on role 
  • Usage of Logical Data Object filter and dashboard parameters to filter data
  • Dashboard should be restricted to 4-5 views or should have multiple tabs to reduce overall data loading time
  • Limit the Data Object List View to 2000 -3000 records

20) Describe the Tuning options for Data Archiving & Purging in Oracle Business Activity Monitoring (BAM) ? 

The below tuning options can be performed:

  • Implement Database Partition to improve overall performance
  • Data Objects should be available with the necessary data only
  • Historical data should be kept in separate data objects specific for reporting
  • Schedule data retention during non- business hours and enable alert notification
  • Use Oracle Data Integrator Service to purge the data
  • Use Alerts to allow filter based purging

21) Describe the components of Business Activity Monitoring (BAM) ?

The Business Activity Monitoring (BAM) provides the below given components:

  • Active Viewer
  • Active Studio 
  • Architect
  • Administrator