Which three statements are true about configuring database mirroring for the BlackBerry Configuration Database? (Choose three.)

Question

Options

• ABoth Microsoft SQL servers are required to be the same version
• BBoth Microsoft SQL servers require a LAN connection
• CBoth Microsoft SQL servers are required to have the same instance name
• DBoth Microsoft SQL servers are required to use Microsoft SQL servers 2005 SP2 or later
• EBoth Microsoft SQL servers are required to use dynamic SQL ports

• A
  76% (39)
• C
  6% (3)
• E
  18% (9)

Explanation

Configuring database mirroring for the BlackBerry Configuration Database requires both SQL servers to run the same SQL Server version (A) to ensure binary-level compatibility between the principal and mirror. A LAN connection (B) is mandatory because mirroring relies on synchronous log shipping, which demands low-latency, high-bandwidth connectivity - WAN links introduce too much latency. BlackBerry also mandates SQL Server 2005 SP2 or later (D) as the minimum supported version, since database mirroring matured and became reliable only from that release onward.

Why the distractors are wrong:

• C (same instance name): Instance names are independent identifiers and do not need to match between the principal and mirror servers - only the version and edition compatibility matter.
• E (dynamic SQL ports): Mirroring actually requires static (fixed) SQL ports, not dynamic ones, so that the endpoints can be consistently addressed. Dynamic ports would break endpoint communication.

Memory tip: Think of the three requirements as "SVL" - Same version, Valid LAN, Licensed minimum (2005 SP2). If any of these three pillars are missing, mirroring will fail to establish or maintain synchronization.

No community discussion yet for this question.