nerdexam
Microsoft

70-332 · Question #76

You are preparing to migrate to the new SharePoint environment. You need to configure SQL Server connectivity. What should you do?

The correct answer is A. Configure a SQL Server client alias. A SQL Server client alias abstracts the actual SQL Server instance name, allowing SharePoint to connect to SQL Server using a logical name that can be redirected without changing SharePoint configuration.

Plan a SharePoint environment

Question

You are preparing to migrate to the new SharePoint environment. You need to configure SQL Server connectivity. What should you do?

Options

  • AConfigure a SQL Server client alias.
  • BConfigure a CNAME alias for SQL1.
  • CConfigure Request Management and specify a routing rule for database connections.
  • DConfigure a SQL Server failover cluster.

How the community answered

(38 responses)
  • A
    71% (27)
  • B
    8% (3)
  • C
    18% (7)
  • D
    3% (1)

Why each option

A SQL Server client alias abstracts the actual SQL Server instance name, allowing SharePoint to connect to SQL Server using a logical name that can be redirected without changing SharePoint configuration.

AConfigure a SQL Server client alias.Correct

A SQL Server client alias, configured via SQL Server Configuration Manager, maps a logical alias name to the actual SQL Server instance name and port. This is the standard SharePoint guidance for SQL connectivity because it allows the underlying SQL Server to be renamed or moved without reconfiguring every SharePoint server, which is critical during a migration where the SQL instance name may change.

BConfigure a CNAME alias for SQL1.

A CNAME DNS record aliases one hostname to another at the network level but does not provide SQL Server-specific connectivity configuration such as protocol or port mapping.

CConfigure Request Management and specify a routing rule for database connections.

Request Management is a SharePoint service for routing and throttling incoming HTTP requests, not for managing SQL Server database connections.

DConfigure a SQL Server failover cluster.

A SQL Server failover cluster provides high availability for SQL Server but does not configure how SharePoint locates or connects to the SQL instance during migration.

Concept tested: SQL Server client alias configuration for SharePoint connectivity

Source: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/create-or-delete-a-server-alias-for-use-by-a-client

Topics

#SQL Server client alias#database connectivity#migration planning#SQL alias

Community Discussion

No community discussion yet for this question.

Full 70-332 Practice