Which of the following artifacts are automatically created by the SQL Adapter?
-
Multipart message types
-
Empty BizTalk orchestration
-
Port Type
-
Role Link Type
Marked correct: Multipart message types, Empty BizTalk orchestration, Port Type, Role Link Type (all four selected as correct for this MC-2 question).
When the BizTalk SQL Adapter's schema/binding wizard is run against a SQL Server database, it generates supporting artifacts to integrate the adapter into an orchestration: multipart message schemas/types representing the request/response, port types describing the operations, and (depending on wizard options) a starter/empty orchestration and associated role links to wire up the send/receive ports. These are standard outputs of BizTalk adapter wizards generally.
This is fairly specialized BizTalk/Visual Studio tooling knowledge, and whether all four are always auto-generated (versus some being optional wizard choices) is hard to confirm with full certainty without hands-on access to the specific BizTalk version's wizard.