About Me

My photo
Northglenn, Colorado, United States
I'm primarily a BI Developer on the Microsoft stack. I do sometimes touch upon other Microsoft stacks ( web development, application development, and sql server development).

Tuesday, December 12, 2006

BizTalk Query: Find what schemas are deployed.

use biztalkmgmtdb
select msgtype, body_xpath, clr_namespace, clr_typename, clr_assemblyname, schema_root_name,
docspec_name
from bt_DocumentSpec
order by msgtype --(which is the schema-name)
--order by date_modified desc -- (probably the date deployed?)

BizTalk Assessment Question: Recoverable Interchange

You are a Microsoft(R) BizTalk(R) Server 2006 technology specialist for your company. You need to enable and configure the new recoverable interchange feature in BizTalk Server 2006.
Where can you enable and configure this feature? (Each correct answer presents a complete solution. Choose two.)

  • In Microsoft Visual Studio(R) 2005 while you are defining an orchestration
  • In the Tracking Profile Editor
  • In the BizTalk Server Administration Console
  • In the Business Activity Monitoring (BAM) portal
  • In Microsoft Visual Studio(R) 2005 while you are defining a custom pipeline

There are two ways of setting up the recoverable interchange in BizTalk 2006 either through the pipeline's XMLDisassembler component or through the Admin Console

BizTalk Assessment Question: MQSeries adapter

You are a Microsoft(R) BizTalk(R) Server 2006 application developer. You want to retrieve XML messages from an MQSeries queue. You want to do this in the easiest way possible.
What should you do?
  • Download and install a community-supported MQSeries adapter.
  • Use the built-in MQSeries adapter.
  • Use the MQSeries application programming interface (API) to write your own MQSeries adapter.
  • Download and install the Microsoft-supported MQSeries adapter.

Well this one is kinda obvious, Use the built-in MQSeries adapter.

"For BizTalk Server 2004 the MQSeries adapter was available as a Web
download. In BizTalk Server 2006, the MQSeries support comes built-in. With the
MQSeries adapter, organizations can use XML-enabled MQSeries investments, making it possible to more securely and reliably integrate disparate applications."

BizTalk Assessment Question: Zoom feature

Which Microsoft(R) BizTalk(R) Server 2006 designer has a new zoom feature?

  • Mapper tool
  • Schema Designer
  • Pipeline Designer
  • Orchestration Designer

"Orchestration zooming. In BizTalk 2004, working with
complex orchestrations in the Orchestration Designer sometimes requires a lot of
scrolling on the design surface to view different parts of the orchestration. In
BizTalk Server 2006, the designer has been enhanced to provide the ability to
zoom in and out on an orchestration, allowing a developer to view only those
parts of an orchestration of current interest. "

Monday, December 11, 2006

BizTalk Assessment Question: Make a schema from a postionial flat file

You are a Microsoft(R) BizTalk(R) Server 2006 application developer. You want to create a schema that is based on a positional document.

What should you do?

  • Purchase a third-party tool that converts positional documents to XML documents.
  • Count and record the starting position of each field.
  • Count and record the length of each field.
  • Count and record the ending position of each field.
  • Run the Flat File Wizard.
I think this one is kinda obvious, of course Microsoft is going to boast about the Flat File Wizard.

There are basically 3 types of flat files:
  • Delimited flat file.
  • Positional flat file.
  • A flat file with combination of Delimited and Positional records.

BizTalk Assessment Question: Allow business users to view BAM alerts and aggregations.

You are a Microsoft(R) BizTalk(R) Server 2006 technology specialist for your company. You want to allow business users to view Business Activity Monitoring (BAM) alerts and
aggregations.

What new feature of BizTalk Server 2006 should you use?
  • BAM Web service
  • Tracking Profile Editor
  • BizTalk Server Administration Console
  • BAM portal

The best answer here would be the BAM portal, where business users can set up queries and alerts on a single interface.

BizTalk Assessment Question: Send notification to business users.

You are a Microsoft(R) BizTalk(R) Server 2006 technology specialist for your company. You need to provide notification in real time to business users about changes to their
business processes.

What feature of BizTalk Server 2006 meets this need?

  • Business Activity Monitoring (BAM) activity
  • Business Activity Monitoring (BAM) alerts
  • Business rules
  • Orchestrations

In my opinion, BAM alerts would be the best answer here, since you can set it up to send notification when a certain parameter has been reached. BAM activity are just like queries which can be used in the alerts. Business rules and orchestration are more internal but still possible to send out notifications with the use of both of these, but not necessary if you have BAM setup.

BizTalk Assessment Question: What are the two BAM web services?

What two categories can you find in Business Activity Monitoring (BAM) Web services in Microsoft(R) BizTalk(R) Server 2006? (Each correct answer presents part of the
solution. Choose two.)

  1. Human Workflow Services (HWS) service
  2. BAM portal BizTalk artifacts
  3. BAM query service
  4. BAM management service

Answer: BAM query service and BAM management service

1. BAM Query Service – The service is used
by the BAM Portal to retrieve BAM instance data. The service supports the
infrastructure and is not intended to be used directly from your code. The
service is not supported and is not documented. To retrieve instance, use the
supported techniques described at http://msdn.microsoft.com/library/en-us/BTS06BizProcessMgmnt/html/ae4a8854-d5c2-4b36-a0ef-3f74e138306e.asp?frame=true.
2. BamManagementService – The following service provides, consumers the ability to manage subscriptions and alerts among other management operations

BizTalk Assessment Question: Best way for deploying

What type of file is used in Microsoft(R) BizTalk(R) Server 2006 to make application deployment and management easier by using the new application concept?

  • Batch files
  • .msi files
  • XML files
  • Microsoft Windows(R) Management Instrumentation (WMI) files
  • Flat files

MSI makes the most sense here. It allows for minipulation to allow for a set of smaller MSI files instead of one large MSI file, and you can manipulate the MSI file with pre and post processing scripts.

BizTalk Assessment Question: What is needed for complete installation?

Which products are required for a complete installation of all features of Microsoft(R) BizTalk(R) Server 2006? (Each correct answer presents part of the solution. Choose
three.)
  1. Microsoft .NET Framework 2.0
  2. Microsoft Internet Explorer 7
  3. Microsoft Commerce Server 2006
  4. Microsoft Office Excel(R) 2003 with Service Pack 2
  5. SQLXML 3.0 with Service Pack 3
  6. Microsoft Office OneNote(R) 2003 with Service Pack 1

Answer found: SQLXML 3.0 with Service Pack 3, Microsoft Office Excel(R) 2003 with Service Pack 2, and Microsoft .Net Framework 2.0

BizTalk Assessment Question: BizTalk 2006 supports what SQL Servers

What versions of Microsoft(R) SQL Server(TM) are supported by Microsoft BizTalk(R) Server 2006? (Choose all that apply.)
  • Microsoft SQL Server 6.5
  • Microsoft SQL Server 2000
  • Microsoft SQL Server 2000 with Service Pack 4
  • Microsoft SQL Server 2005
  • Microsoft SQL Server 7.0

Answer found: Microsoft SQL Server 2005 or Microsoft SQL Server 2000 with Service Pack 4

BizTalk Assessment Question: Bypass pre-reqs

You are performing a silent installation of Microsoft(R) BizTalk(R) Server 2006.
You want to bypass checks for downloadable prerequisites.

What new command line parameter should you use?

  1. /IGNOREDEPENDENCIES
  2. /ADDLOCAL ALL
  3. /PASSIVE
  4. /COMPANYNAME
1) Bypasses the checks for downloadable prerequisites.
2) Installs all features.
3) Performs a passive installation. The setup program only displays the progress bar.
4) Sets the company name.