Interview questions on BizTalk Database

This post is intended to cover the questions related to BizTalk Database which a BizTalk developer can face during an interview.

 Questions and Answers:

 1.     What effect does creating a new Host have on the Database?    When the new host is created it results in a new en07y in the Host table in the Management database and also a new Host queue in the MessageBox.


2.     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.

3.     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 07ue?

Yes. An en07y is added in subscription table.

4.     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 abs07acts 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, re07ieving messages, and so on. This interface is the only mechanism used by other BizTalk Server components, including the adapter framework and orches07ations, to interact with the MessageBox.

5.     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.

6.     How would you define database role in context to BizTalk?

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.

7.     Which SQL Agent job runs continuously?

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

8.     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.

9.     Does implementing BAM require more database?

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

10.   Which database stores the configuration information for receive locations?

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

11.   How many databases are used for implementing BRE?

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

12.   What are the options for upgrading BizTalk Server Database?

There are two ways for upgrading 

1.In Place upgrade 

2.Transfer Upgrade.






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

    Post a Comment

    Popular posts from this blog

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

    Image
    While doing testing after doing a POC on Securing Logic App with Azure Active Directory authentication , where I have put logic app behind APIM and before passing the request to logic app, apim does validation of the token.  I was encountered with an error "The request has both SAS authentication scheme and 'Bearer' authorization  scheme.  Only one scheme should be used." Why it happened After validating the token which is part of the header i.e. Authorization, APIM forwards the request as it is to backend. As  Logic app is configured as  back end , it's url already consist of SAS signature plus the request also has Authorization section and this is the problem. By default every request endpoint on a logic app has a Shared Access Signature (SAS) in the endpoint's URL, which follows this format: https://<request-endpoint-URI>sp=<permissions>sv...
    Read more

    Getting Started with Logic Apps - AS2

    Image
    What is AS2? Every enterprise requires some kind of product, service or counselling from another enterprises thus there happens a B2B(business to business) communications, some of the communication is unique whereas most of the communications are common for most of the enterprises e.g., Purchase Order. But every enterprise has there own way(format) of sending the messages, leading to difficult management when number of partners increased.  Considering this the Enterprise leaders decided to have some standards/rules defined across the communication leading to B2B protocol standards which provide guidelines for trading partners to follow when conducting business between enterprises. EDI X12, EDIFACT, TRADACOM etc. AS2 stands for Applicability Statement 2 and is a B2B messaging protocol used to transmit Electronic Data Interchange (EDI)/Business documents from one organization to another. So EDI standards define how to format data and AS2 specifies how to securely transport...
    Read more

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

    Image
    Introduction  APIM is a great option to expose API's with out of box features for applying restrictions, preprocessing, postprocessing etc. You can leverage existing API's,  by importing it and it gets added as a new API with all the operations associated with it. And based on the requirements you  apply policies at the stage/level (Inbound,Backend/Outbound) and you are ready to use the API. Before it is shared, we do some testing to make sure everything is working as per the expectation and this is where Debugging and Tracing request becomes important. APIM does provide a way to Trace a call with the help of  Ocp-Apim-Trace http header. So whichever request/call is to be traced, it needs to include this in header  with the value set to true and it has dependency on another header, so that also needs to be passed i.e.  Ocp-Apim-Subscription-Key Note: The api on which Tracing is to applied , it requires the subscription key to be en...
    Read more