Biztalk Database Interview Questions And Answers

BizTalk Server Management database, MessageBox databases, Tracking database, and SSO database are four databases which are used by BizTalk server runtime operations. It is the component that encapsulates and abstracts the database component and is the interface used by BizTalk Server to interact with the MessageBox. The Message Agent is a Component Object Model (COM) component that provides interfaces for publishing messages, subscribing to messages, retrieving messages, and so on. This interface is the only mechanism used by other BizTalk Server components, including the adapter framework and orchestrations, to interact with the MessageBox.

There are two ways for upgrading
1.In Place upgrade
2.Transfer Upgrade.

Monitor BizTalk Server, this job scans the BizTalkMgmtDb, BizTalkMsgBoxDb and BizTalkDTADb database for any known issues, including orphaned instances.

☛ MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb determines when a message is no longer referenced by any subscriber.
☛ When no subscriber found it starts MessageBox_Message_Cleanup_BizTalkMsgBoxDb which removes the unused message.

It's a node within a BizTalk Server schema that represents the outermost XML element in the business document specified by the schema.

Correlation types define a set of properties on which you will be correlating messages. These can be any properties which were previously defined in a property schema (see question 2) and deployed with some BizTalk Project including "system" properties deployed with the GlobalPropertySchemas which is installed as part of the base BizTalk install. A correlation set defines a set of properties and values for these properties that a message must contain to be processed by a particular orchestration.

When the new host is created it results in a new entry in the Host table in the Management database and also a new Host queue in the MessageBox.

Yes. An entry is added in subscription table.

In addition to the default 4 databases only one database, i.e. Rule Engine Database.

Messaging objects viz. Receive Ports, Receive Locations, Send ports, etc. are stored in the Management Database.

Right click the project in Solution Explorer and select Add Generated Items --> Generate Schemas.

Messaging objects viz. Receive Ports, Receive Locations, Send ports, etc. are stored in the Management Database.

An <Any> element in a schema designates a specific location in the schema where new elements or attributes can be added. When BizTalk uses the schema to process a message containing unknown elements or attributes in the designated location, the schema will still consider the message valid.

MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb is the job which runs continuously in spite of scheduled to run once per minute.

Monitor BizTalk Server, this job scans the BizTalkMgmtDb, BizTalkMsgBoxDb and BizTalkDTADb database for any known issues, including orphaned instances.

Single Sign-On database (SSODb) securely stores the configuration information for receive locations, other known secret information is stored in the BizTalkMgmtDb.

The database is used to store the data about the Message and other data required for processing it, along with the help of SQL Server Agent Jobs.

Difference between XSD and DTD are listed below:
☛ o XSD are written in XML.
☛ o XSD support data types.
☛ o XSD support namespaces.
☛ o XSD is extensible to future additions.
☛ o XSD is richer and more powerful than DTDs.

It can be but it should be avoided in the projects that uses BizTalk EDI engine as during run time there can be conflicts with this and expected results might not be seen.

MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb is the job which runs continuously in spite of scheduled to run once per minute.

Yes. BAM Analysis, BAM Archive, BAMAlertsApplication, BAMAlertsNSMain, BAM Primary Import database and BAM Star Schema can be used to implement BAM solution.

The database is used to store the data about the Message and other data required for processing it, along with the help of SQL Server Agent Jobs.

In this type of upgrade, you simultaneously upgrade the version of SQL Server and move the databases to a new instance of SQL Server or to a new location entirely. You must manually move the databases and other objects (such as logons and jobs) to the new location. The procedure for a transfer upgrade is based on the procedure described in this topic, with the addition of the steps needed to move the databases to a new server or a new instance of SQL Server.

MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb determines when a message is no longer referenced by any subscriber. When no subscriber found it starts MessageBox_Message_Cleanup_BizTalkMsgBoxDb which removes the unused message.

It is a script which when run installs the BizTalk Schema Generator. It is used when generating schema from existing items. It's likely to get error first time or after updates "WFX to XSD Schema generation module is not installed". Then this script can be used to install the schema generator.