BIZTALK SCHEMA INTERVIEW QUESTIONS

Most Important Frequently Asked Biztalk Schema Interview Questions

Interview Quesions on Biztalk Schema

1. Question 1. What Is The Purpose Of A Document Schema?

   Answer :

   The schema is basically a contract of your message and defines it. The XML Schema definition (XSD) language defines the structure of an XML instance message, and this is the intended purpose of XSD, such schemas use XSD in a straightforward way.

   The schema is basically a contract of your message and defines it. The XML Schema definition (XSD) language defines the structure of an XML instance message, and this is the intended purpose of XSD, such schemas use XSD in a straightforward way.

2. Question 2. What Is The Purpose Of A Property Schema?

   Answer :

   • Property schema is a special type of schema, not created to describe messages.
   • Instead it describes context properties.
   • It consists of only child node under a root node.

MSBI Interview Questions

3. Question 3. What Is The Purpose Of An Envelope Schema?

   Answer :

   • An envelope schema is a special type of XML schema.
   • Envelope schemas are used to define the structure of XML envelopes, which are used to wrap one or more XML business documents into a single XML instance message.
   • When you define an XML schema to be an envelope schema, a couple of additional property settings are required, depending on such factors as whether there is more than one root record defined in the envelope schema.

4. Question 4. What Is The Purpose Of A Flat File Schema?

   Answer :

   • A flat file schema defines the structure of a class of instance messages that use a flat file format, either delimited or positional or some combination thereof.
   • Because the native semantic capabilities of XSD do not accommodate all of the requirements for defining the structure of flat file instance messages—such as the various types of delimiters that might be used for different records and fields within the flat file.
   • BizTalk Server uses the annotation capabilities of XSD to store this extra information within an XSD schema.
   • BizTalk Server defines a rich set of specific annotation tags that can be used to store all of the required additional information.

Testing Tools Tutorial

5. Question 5. What Is The Target Namespace For Schema?

   Answer :

   Target Namespace is to schema what a namespace is to .Net Object and root node as a class name.

Testing Tools Interview Questions

6. Question 6. Is It Possible To Create A Custom Data Type And Use It In A Schema?

   Answer :

   Yes, it's possible to create custom data types and it can be used across the schema. 

7. Question 7. Can Schema Have Two Nodes With The Same Name And Different Data Types?

   Answer :

   Yes, as long as they are not in the same scope.

Microsoft Azure Tutorial SSIS(SQL Server Integration Services) Interview Questions

8. Question 8. Can Schema Have Multiple Root Nodes?

   Answer :

   • Yes, a schema (XSD) can have multiple root nodes.
   • In case you have a schema with multiple root nodes you will end up with multiple message types declared in BizTalk,one for every root node.
   • So when you want to create a message you will need to specify exactly which message type you are going to use! 

9. Question 9. Is It Possible To Include And Import In A Single Schema?

   Answer :

   • Yes, it is possible, both are the ways to utilize already existing schema.
   • The only condition is the schema which is included should have same TargetNamespace or no namespace.

BizTalk Admin Interview Questions

10. Question 10. By Default, What Is The Data Type Of Elements In A Schema?

    Answer :

    xs:string

Windows Presentation Foundation(WPF) Tutorial

11. Question 11. What Is The Difference Between Group Max Occurs, Group Min Occurs And Max Occurs, Min Occurs?

    Answer :

    These are all node properties.

    Group Max Occurs: Specifies the maximum number of times that to the underlying group content of the selected All Group node can occur.

    Group Min Occurs: Specifies the minimum number of times that the underlying group content of the selected All Group node can occur.

    Max Occurs: Specifies the maximum number of times that the element corresponding to the selected Record node can occur.

    Min Occurs:  Specifies the minimum number of times that the element corresponding to the selected Record node can occur.

Microsoft Azure Interview Questions

12. Question 12. What Is Block Default Property Used For?

    Answer :

    Use the Block Default property to prevent or restrict the types of derivatives that can be used in instance messages for all data types defined by the schema being edited.

MSBI Interview Questions

13. Question 13. What Is A Canonical Schema?

    Answer :

    • A canonical schema is a design pattern, which is applied within a service oriented paradigm, and within BizTalk server context establish the loose coupling between systems.
    • Through performing the transformation of messages from one system to canonical schema and from the canonical schema to message of another system, systems have no direct relation with each other.
    • The canonical schema can also be viewed as an internal schema in BizTalk and aid you in structuring your solution through best practice of creating separate projects for maps, orchestrations, internal and external schemas. Another advantage of using a canonical schema is that it reduces the number of transformations you need.
    • If you need a to map a few types of inbound message coming from different parties to a few outbound messages, you can create a map to your canonical schema for each inbound schema and then a map from your canonical schema to each outbound schema.
    • If for example you have three types of incoming that needs to be mapped to three types of outgoing messages you will only need to build and maintain six maps instead of nine.

Java XML Tutorial

14. Question 14. What Is The Correlation Property Schema?

    Answer :

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

15. Question 15. Difference Between Flat File Schema And Xml Schema?

    Answer :

    • A flat file schema defines the structure of a class of instance messages that use a flat file format, either delimited or positional or some combination thereof.
    • Because the native semantic capabilities of XSD do not accommodate all of the requirements for defining the structure of flat file instance messages.
    • such as the various types of delimiters that might be used for different records and fields within the flat file—BizTalk Server uses the annotation capabilities of XSD to store this extra information within an XSD schema.
    • BizTalk Server defines a rich set of specific annotation tags that can be used to store all of the required additional information.

Microsoft Office SharePoint Server (MOSS) Interview Questions

16. Question 16. Can We Have Schema Without A Targetnamespace? What Will Be Its Message Type?

    Answer :

    Yes, we can have a schema without target namespace and it's message type will be the Root node.

DocumentDB Tutorial

17. Question 17. Which Property Is Only Available For The Flat File Schema?

    Answer :

    Custom Date/time property is only available for flat file schema.

Windows Presentation Foundation(WPF) Interview Questions

18. Question 18. What Is The Message?

    Answer :

    • Each message in BizTalk Server is considered a multi-part message and is made up of zero or more parts.
    • Each message with one or more parts has one of these parts identified as the body part.
    • Each part consists of a binary chunk of data which can represent an XML document, a flat file, a serialized .NET class, or other binary stream of data.
    • You use the body part of the message to identify the type of the message that can be used for routing.

Testing Tools Interview Questions

19. Question 19. What Is The Difference Between Biztalk (schema) Editor And Biztalk Schema Generator?

    Answer :

    • BizTalk Editor resides within the Microsoft Visual Studio shell. Some of the functionality within BizTalk Editor relies upon existing user interface elements within the Visual Studio shell
    • BizTalk can automatically create the schema from DTD, well formed XML, XDR. To do this schema generator is used.

XML DOM Tutorial

20. Question 20. How Is Schema Generator Invoked?

    Answer :

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

Java XML Interview Questions

21. Question 21. What Is Installwfx.vbs Script?

    Answer :

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

22. Question 22. Can "edi" Be A Part Of Namespace?

    Answer :

    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.

XSD Tutorial

23. Question 23. Is It Possible To Promote Xml Record Of Complexcontent ?

    Answer :

    No. To promote XML record its ContentType property should be set SimpleContent.

DocumentDB Interview Questions

24. Question 24. What Is The Maximum Length Allowed For Promoted Properties?

    Answer :

    255 characters

SSIS(SQL Server Integration Services) Interview Questions

25. Question 25. What Is The Maximum Length Allowed For Distinguished Fields?

    Answer :

    It can be of any length, no limits.

26. Question 26. How To Create An Xpath Alias To A Field Which Can Be Used In Decision Making In Orchestration?

    Answer :

    Distinguished field  is a XPath alias to the field.To create it , right click the element-->Promote-->Show promotion-->Add

Advanced C# Interview Questions

27. Question 27. What Is < Any > Element?

    Answer :

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

BizTalk Admin Interview Questions

28. Question 28. What Is The Root Node?

    Answer :

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

29. Question 29. How Biztalk Engine Identifies A Unique Schema?

    Answer :

    • BizTalk uses a combination of namespace#rootnode to define the schema type of a message, thereby making a MessageType unique.
    • In other words, BizTalk uses this combination to identify and resolve schemas references.

Biztalk Server Interview Questions

30. Question 30. How Biztalk Engine Performs A Validation Of An Instance Of The Message Against The Schema?

    Answer :

    • By default, BizTalk Server will examine only the namespace and the root node name of a message to identify and validate the schema, and will not detect extra elements in the message body.
    • To perform a deep validation of a message format, you have to create a Custom Pipeline with the XML Disassembler component

31. Question 31. What Are Encoding Options Available Used By Biztalk When Creating Schema?

    Answer :

    There are various options but BizTalk always uses UTF-16 encoding for their schemas

Topic: Biztalk Schema Interview Questions
Interview Quesions on Biztalk Schema