Biztalk Database Interview Preparation Guide
Biztalk Database Frequently Asked Questions in various Biztalk Database job interviews by interviewer. The set of questions are here to ensures that you offer a perfect answer posed to you. So get preparation for your new job interview28 Biztalk Database Questions and Answers:
1 :: Explain me what databases are part of every solution?
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.
2 :: Tell me what are the options for upgrading BizTalk Server Database?
There are two ways for upgrading
1.In Place upgrade
2.Transfer Upgrade.
1.In Place upgrade
2.Transfer Upgrade.
3 :: Explain which service looks after known issues in the database?
Monitor BizTalk Server, this job scans the BizTalkMgmtDb, BizTalkMsgBoxDb and BizTalkDTADb database for any known issues, including orphaned instances.
4 :: Tell me messages without subscribers are removed, how?
☛ 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.
☛ When no subscriber found it starts MessageBox_Message_Cleanup_BizTalkMsgBoxDb which removes the unused message.
5 :: Tell me what is the Root Node?
It's a node within a BizTalk Server schema that represents the outermost XML element in the business document specified by the schema.
6 :: Explain me what is the correlation property 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.
7 :: Tell me what effect does creating a new Host have on the Database?
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.
8 :: Tell me is there any change in the database when the filter is added to Send port or when Activate property of Receive shape is set to true?
Yes. An entry is added in subscription table.
9 :: Explain me how many databases are used for implementing BRE?
In addition to the default 4 databases only one database, i.e. Rule Engine Database.
10 :: As you know the MessageBox database holds all the messages that are processed, what about messaging Objects?
Messaging objects viz. Receive Ports, Receive Locations, Send ports, etc. are stored in the Management Database.