BizTalk Admin Interview Questions & Answers

Question 1. What Jobs Do You Need To Configure When You Install Biztalk?

Answer :

• The Backup BizTalk job (location of Full and Log backups). 
• The DTA Purge and Archive job (at least the location where you want to Archive Tracking data.
• After you have configured the jobs, don't forget to enable them 

Question 2. What Are Thresholds?

Answer :

From a BizTalk perspective, these are numeric values, which can be configured on your Hosts and host instances, and lead to Throttling situations once they are crossed. 

Question 3. Why Do You Have Automatic Throttling States And What Can It Be Used For?

Answer :

To warn the BizTalk Administrator that BizTalk is under stress or something abnormal is happening to the environment, these may only affect certain hosts or all hosts in the environment depending on the throttling state

Question 4. What Does A “high Available Environment” Mean?

Answer :

BizTalk can be configured in that it uses a Failover- or Load Balanced cluster.
By doing so, BizTalk uses several physical or virtual machines to spread the workload.
In case one of the machines goes down, BizTalk is still able to process workload on the other machine(s). 

Question 5. What Is Nlb?

Answer :

• This stands for Network Load Balancing.
• It's one of the possibilities to make IIS high available on machines where BizTalk is installed.
• BizTalk itself however has its own load balacing.

Question 6. What Is Host Architecture?

Answer :

A Host Architecture describes how BizTalk uses Hosts and Host Instances for spreading its workload. Normally you have Hosts for Receiving messages, Processing orchestrations, Sending messages and Tracking completed messages.

Question 7. How Do You Route Messages By Receive Port Name?

Answer :

By adding a filter on a Send Port, which points to that Receive Port.

Question 8. How Do You Measure Performance For Biztalk?

Answer :

By using PerfMon and configure counters for CPU, Memory, I/O, Throttling. Besides using Perfmon, you can use tools like PAL, SQLIO, SQLProfiler, and IOMeter. 

Question 9. Which Are The Four Most Important Biztalk Databases?

Answer :

• BizTalkMgmtDb (contains the configuration of a BizTalk Group)
• BizTalkMsgBox (contains the messages and work in progress)
• BizTalkDTADb (contains information about the completed processes)
• SSODb (contains credential information)

Question 10. What Are The Dangers Of Filters Combined With Send Port Groups And Multiple Send Ports?

Answer :

There is the risk that Send Ports which are also used in Send Port Groups, pick up the message multiple times, leading to the danger that the message is processed multiple times, where it should be processed only once. 

Question 11. What Needs To Be Backed Up For A Complete Disaster Recovery?

Answer :

Besides the databases, the Master Secret Key and all application and programs on the BizTalk Machine.

Question 12. What Is An Orphan Message?

Answer :

An orphaned messages is a message that has completed and finished its processing in the BizTalk message box however the information of this is not updated in the tracking database and will hold space in the tracking database until manually deleted or updated.

Question 13. What Is A Zombie Message?

Answer :

A zombie messages is a messages that arrives after an orchestration has finished, and can no longer reference back to the orchestration of it origin.

Question 14. Where Can You Locate Configuration Of Your Environment?

Answer :

You can locate configuration information both on the BizTalk machines and the BizTalkMgmtDb.

Question 15. How Many Host Can We Have?

Answer :

There is no rule about how many hosts you may have. However there are certain guidelines and its recommended to have hosts for the following 
Receive Host : Used for all in process receiving 
Processing Host : Used for all Orchestration 
Isolated Host : Used for all IIS receiving
Send Host : Used for sending of messages 
Tracking Host : Used for moving data from MessageBox to Tracking database 
There may be more then one for each of these jobs depending on the workload and resource usage including host settings etc.

Question 16. Why Biztalk Messageboxdb Maxdop Value Should Be 1?

Answer :

• DOP stands for Degree of Parallelism. BizTalk Server database queries are relatively small, and they execute quickly.
• Therefore, BizTalk Server database queries do not benefit from a Parallelism setting that specifies using more than one processor.
• Changing the Parallelism setting to specify using more than one processor may have an adverse effect on BizTalk Server database queries

Question 17. What Is The Maximum Size Of Message, Biztalk Can Process?

Answer :

While BizTalk Server imposes no restriction on message size, practical limits and dependencies might require you to minimize the size of your messages because large messages require more processing resources.

Question 18. Importance Of Strong Name And How It Helps For Administration?

Answer :

• A strong name ensures that each assembly name is unique.
• Each assembly in your BizTalk project requires a strong name in order to deploy successfully.

Question 19. What Is Difference Between Dehydrated Orchestration And Suspended Orchestration?

Answer :

• Dehydration is the process of serializing the state of an orchestration into a SQL Server database.
• Rehydration is the reverse of this process: deserializing the last running state of an orchestration from the database.
• When a failure occurs within an orchestration and no error handling is implemented it will be suspended.

Question 20. What Is Btsntsvc.exe.config File?

Answer :

This is the configuration file for BTSNTSVC.exe, which runs as a Windows Service and is a Host Instance, information regarding the configuration of the hosts. 

Question 21. What Is The Main Difference Between Bam And Dta?

Answer :

• BAM (Business Activity Module) has a business driver, while DTA (Data Tracking Architecture ) is used for Tracking purposes.
• With BAM Users can define Views and Notifications based on certain (Business) events.
• These views can be used from a SharePoint portal.
• This portal is also the place where Notifications are created.

Question 22. How Do You Turn Off Global Tracking In Biztalk 2006 - 2006 R2?

Answer :

In BizTalk Server 2006/2006 R2 the Global Tracking can be turned off through a manual action in BizTalk Management Database

Question 23. What Is Msmq Used For?

Answer :

•  MSMQ stands for Microsoft Message Queue.
• It's a queuing mechanism which comes out-of-the-box with Windows Server.
• Be aware that MSMQ lacks a locking mechanism and therefore has to be accessed from a single Host Instance.
• Use a Failover cluster to make this Host Instance high available.

Question 24. What Is A Trusted / Un-trusted Host?

Answer :

BizTalk Server enables hosts identified as authentication trusted to indicate that the sender of a message that the trusted host is queuing to the MessageBox database is an entity other than the trusted host itself.

The primary purposes of authentication trust are to enable pipelines to resolve to a Product ID (PID) and pass that PID along to consuming services for use in authorization and outbound party resolution, and to enable the transmission of the sender Windows Security ID (SSID) along to consuming services for use in orchestration action authorization.

Question 25. What Can You Use The Tracking Database For?

Answer :

• This database stores health monitoring data tracked by the BizTalk Server tracking engine.
• It stores data of completed processes which comes from the MessageBox
• It stores data of suspended/terminated processes which comes from the MessageBox
• Can be used for report generation  
• Can be used for monitoring 
• Can be used for analysis 
• Can be used for Orchestration debugging 

Question 26. What Should Be Included In A Basic Guideline?

Answer :

A BizTalk guideline will give you the benefits of having the availability to improve stability, optimize the work flow for BizTalk and keep a track of information regarding your environment, and the way these things work at your company.

This will make it easier for new people coming in working for or at your company to understand how BizTalk works at your company.

 What the guidelines for your company should contain is all up to what you need.

You need to keep information regarding routines, setup, configuration, backup routines etc.

So all knowledge regarding the company structure for BizTalk is saved and stored whenever someone quits or for instance hiring a consultant.

The guidelines can also provide values needed to improve the communication between developers and administrators.

Question 27. How Can You Solve Slow Administration Consoles?

Answer :

When administration console is slow then you need to check a few things concerning SQL Server like size of BizTalk databases, connectivity with SQL Server, or set the Recovery Mode of all BizTalk databases from Full to Simple (not recommended in production.

Question 28. How Does The Biztalk Administration Console Cache Applications?

Answer :

The BizTalk Administration Console maintains a local cache and when the administration console is opened it caches the entire configuration in one go. The refresh interval can be configured, default is 60 seconds.

Question 29. Which Tool Was Removed In Biztalk 2009?

Answer :

In BizTalk 2009 the HAT (Health and Activity Tracker) has been removed.
Its functionality, track and display information relating to live and historical message data, is now available from the Group Hub.

Question 30. Which Sql Agent Job Came In Biztalk 2010?

Answer :

A job that monitors certain aspects of BizTalk Server which are mainly related to Message and Instance reference counts.

Question 31. What Is Special About The Biztalk Backup Job?

Answer :

It is special, because this job represents the only correct way to make backups from BizTalk, the job also performs a transactional backup so a restore will happen without having invalid and out of sync databases.

Question 32. What Is Required To Install The Sharepoint Adapter In Biztalk 2010?

Answer :

BizTalk Server 2010 support the following SharePoint versions: SharePoint Services 2010, SharePoint Foundation 2010, WSS 3.0 with Service Pack 2 (SP2), and Microsoft Office SharePoint Server 2007 Service Pack 1 (SP1) (MOSS).
 One of this components must be installed because is required for using WSS Adapter

Question 33. What Is The Esb Toolkit?

Answer :

The BizTalk ESB Toolkit provides architectural guidance, patterns, and a collection of BizTalk Server and .NET Framework components to simplify the development of an Enterprise Service Bus (ESB) on the Microsoft platform and to allow Microsoft customers to extend their own messaging and integration solutions

Question 34. What Is The Biztalk Adapter Pack?

Answer :

The BizTalk Adapter Pack is a package which contains several adapters for LoB systems. adapters for SAP, Siebel and Oracle.

Question 35. What Is A Cumulative Update?

Answer :

One cumulative update package for Microsoft BizTalk Server and contains hotfixes for BizTalk Server, issues that were resolved after the release of a particular version of the BizTalk Server and includes all the component packages.
Cumulative Update package take some minutes to install, and you'll need to restart the server after you apply the CU.
The cumulative update should be installed on all servers that run BizTalk components.
 Important note: The cumulative update package updates only those components that are installed on the system.
In BizTalk 2013 the updates for BizTalk is pushed to regular updates, versions prior to this has to be downloaded and installed manually.

Question 36. What Is The Difference Between Biztalk 2009 And 2010?

Answer :

Much better mapper tool, support SQL Server 2008 and SQL Server 2008 R2.
Better administration console. VS 2010(!) is used for development.
There have also been a lot of changes and all host settings have been transferred and moved into the administration console.

Question 37. What Is Global Tracking And What Does It Track When Global Tracking Is On?

Answer :

• Global Tracking is the general Tracking switch.
• If it's turned off, nothing will be tracked.
• If it's turned on, by default it tracks instances, in and out events for all pipelines.
• All application containing orchestration exported from Visual Studio will by default have all orchestration event tracking turned on, it's recommended to turn this off in any production environment.

Question 38. What Are Best Practices For Tracking In Production?

Answer :

Just use it when it's absolutely necessary! Turn off any non-default tracked artifacts as soon as possible! It's a pain for your overall performance

Question 39. What Is Tdds?

Answer :

TDDS stands for Tracking Data Decode Service.
This service is responsible for moving tracking event data from the BizTalk Server MessageBox database to the BizTalk Server tracking database and BAM is BAM is used.

Question 40. Which Default Adapters Can Only Run With A Single Host Instance?

Answer :

All the adapters which lack a locking system, like FTP, POP3, and MSMQ.For a high available BizTalk Group these adapters need to be clustered.

Question 41. Which Default Adapters Cannot Run With 64 Bit Os?

Answer :

• FTP-adapter 
• POP3-adapter 
• SQL-adapter

Question 42. What Is Meant By “parties”?

Answer :

• A party is an entity outside of BizTalk Server that interacts with an orchestration.
• In BizTalk Server, each organization with which you exchange messages is represented by a party.
• You can define how the party interacts by enlisting it in a role.

Question 43. How Can You Improve Performance For Biztalk?

Answer :

• Scaling up =>add better CPU's, more RAM in the current servers.
• Scaling out => add more servers, create Failover- and Load Balanced clusters, add MessageBoxes.
• Increase resources available for hosts.
• Locate problem integration and prevent possible build ups in the databases.

Question 44. What Is A Dns Server?

Answer :

That's a Domain Name Server.
It is a software component which is part of Windows Server and becomes used for looking up IP addresses by domain names.

Question 45. What Are Different Types Of Subscriptions In Biztalk?

Answer :

In BizTalk there are two types of subscriptions. Activation subscription and Instance Subscriptions.
Activation Subscription: It is a subscription which indicates that when the a message which satisfies the subscription should create a new insatnce of the subscriber(Orchestration/Send Port).
Instance Subscription: It is a subscription which indicates that when a message which satisfies the subscription should be routed to already running instance.