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.
Question
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)- A71% (27)
- B8% (3)
- C18% (7)
- D3% (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.
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.
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.
Request Management is a SharePoint service for routing and throttling incoming HTTP requests, not for managing SQL Server database connections.
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
Community Discussion
No community discussion yet for this question.