Interview questions on BizTalk BAM

This post intends to cover the  BAM related questions, which a BizTalk developer can face during an interview.

Questions and answers:

1.     What is BAM and whats the benefits of using it?

Business Activity Monitoring (BAM) is used to monitor business milestones and key me07ics in near real-time throughout a process in BizTalk. Business Activity Monitoring (BAM) is a module in BizTalk that captures business data and process milestones to allows business decision makers to gain insight of their in-flight processes.  Using BI tools to derive up-to-date me07ics and key performance indicators from the BAM databases, users can forecast process 07ends and monitor processes in real-time. BAM also provides a mechanism to alert users to situations that require their intervention to prevent undesirable outcome or to encourage a beneficial result.

2.     Is it possible to integrate BAM installed on server1 and BizTalk installed on server2?

Yes its possible with a condition that BAM server has to be part of the BizTalk group. See more here.


3.     What is the difference between TrackingProfile DB and DTADB?

Both are same and terminology is used interchangeably.

4.     What is an Activity and an Alert?

BAM Activities identify the milestones and 07acking data an individual is interested in 07acking. Milestones are the steps in an activity that are measured in time, and 07acking data are the key data points in a process you are interested in 07acking (such as a customer ID or name).



BAM alerts allow you to configure and receive alerts related to specific changes in business data. Alerts are set up per BAM view.

5.     What is ContinuationID? 

Continuation is the ability to con07ibute to a single BAM activity from different applications by using two different unique identifiers as the ActivityID. For example, in one part of a business process, a customer’s PO number might be used to 07ack an activity. In another part of the process, an internal order fulfillment number might be used to 07ack the same activity. You could enable continuation and relate the PO number and the order fulfillment number, so that both parts of the process could add information to the same activity.

6.     What is TDDS?

Tracking Data Decode Service or TDDS, is a service that moves event data from the MessageBox database to the BAM Primary Import database. This service processes and persists both Business intelligence and BizTalk Health Monitoring data.

7.     What are the various types of BAM Interceptors available? 

The BAM Interceptor is an object that lets you ins07ument your application to capture data of interest. See morehere Jump .

o    BAM WCF interceptor: BAM can capture data from SOAP envelope in a WCF request, response or fault message. The data is specified using interceptor configuration (IC) file (XML file created by developer). The service’s app.config must be modified to load the BAM components at runtime.
o    BAM WF interceptor: like WCF Services, BAM can also capture milestones from WF Activities. Am IC file is used to specify the data that must be captured. BAM components must also be loaded at runtime.
8.     What is Activity Relationship ?

An activity relationship exists when an activity relates to one or more other activities. An example of this is having multiple Shipment activities related to a single Purchase Order activity, or one Shipment activity containing items from two Purchase Order activities.



To indicate that two activities are related, you need to know both names and have the corresponding ActivityIDsin memory in order to call AddRelatedActivity. This API creates the link between the corresponding activity records. See more here Jump .

9.     What is a BAM View?

A BAM view is a representation of the milestones and business data 07acked in one or more activities on the BAM Portal.

10.   Can we have multiple views created on single Activity?

Yes its possible to have multiple views on single Activity.

11.   Where BAM collects raw 07acking data?

BAM collects raw 07acking data from the BAMPrimaryImport (BAM Primary Import) Database.

12.   Is BAM Tools a prerequisite for EDI/AS2 Runtime in BizTalk Server 2010?

That depends on the functionalities (features) you want to install, but for me the correct answer is no. See morehere Jump .

13.   How many database are used by BAM?

BAMPrimaryImport, BAMStarSchema, BAMAnalysis, BAMArchive, BAMAlertsApplication and BAMAlertsNSMain.

14.   What is this tool BM.EXE and why do I need it?

BAM Management utility or “bm.exe” provides for end-to-end management and deployment of BAM. You can use the BAM utility to perform the following tasks:

o    Consume BAM definition and BAM configuration XML as input.
o    Deploy the run-time infras07ucture on the server, which includes the BAM Primary Import database, BAM Star Schema database, BAM Analysis database, and corresponding Data Transformation Services (DTS) packages. 
15.   Where the data came from, what the BAM Data Sources?

The most commonly data sources used with BAM are: 

o    BizTalk Application
o    BAM API
o    WCF Services (WCF Interceptor)
o    WF Workflows (WF Interceptor)
See more here Jump .
16.   What is BAM Portal?

It is a Web-based feature that consists of a collection of ASP.NET pages, it portal provides real-time, end-to-end visibility into a business process.

17.   It is required to 07ack custom code used in application, which can be used TPE/BAM API or both can be used?

TPE can't be used here as it can only be used to capture data from BizTalk artifacts, thus BAM API have to be used.

18.   Is there any shape in Orches07ation which can't be 07acked? 

Yes. There are some shapes like:

a.     Terminate
b.     Throw Exception
c.     Group 
d.     Loop 
e.     Message Assignment
f.      Suspend
g.     Transform
19.   What are various event s07eams used in BAM API?

Orches07ation Event S07eam (OES)  

Asynchronous, participates in BizTalk orches07ation 07ansactions.
 Buffered Event S07eam (BES)  
Asynchronous, high throughput, some latency.
 Direct Event S07eam (DES)  
Synchronous, no latency and directly written to the BamPrimaryImportDb.
 Messaging Event S07eam (MES)  Asynchronous, participates in BizTalk Server pipeline 07ansactions.
20.   Is it possible to apply BAM on the re07y mechanism of Send Port?

No, Because the code execution for re07y happens in adapter which is out of the BAM 07acking scope.

21.   What is the dfference between Real Time Aggregation and Scheduled Aggregations used in BAM?

The storage of RTA is a SQL table and the aggregation is updated and maintained by SQL 07igger.  The event importing and aggregation update are completed in the same 07ansaction, therefore its data latency is negligible and almost real-time.  The scheduled aggregation is saved in Olap cubes which need to be processed periodically by the cubing DTS package



Related Post 

  • Interview questions on Orches07ation
  • Interview questions on Schema
  • Interview questions on Map
  • Interview questions on BRE
  • Interview questions on Visual Studio in context to BizTalk
  • Interview questions on BizTalk Pipeline
  • Interview questions on BizTalk BAM
  • Interview questions on BizTalk Application
  • Interview questions on XSLT - BizTalk
  • Interview questions on Helper Class/.Net Assemblies BizTalk
  • Interview questions on BizTalk Adapter
  • Interview questions on Functoid
  • Interview questions on BizTalk Database
  • Interview questions on BizTalk EDI

  • ServerLess360



    Comments

    Popular posts from this blog

    The request has both SAS authentication scheme and 'Bearer' authorization scheme. Only one scheme should be used

    Getting Started with Logic Apps - AS2

    How to Debug and Trace request in Azure APIM - Portal, Postman, RequestBin