nerdexam
Microsoft

70-339 · Question #134

You are the administrator for a company's SharePoint environment. All SharePoint installations must use SQL aliases. You need to complete the configuration. Which tool should you use?

The correct answer is B. SQL Server Configuration Manager. SQL Server aliases for SharePoint are created with SQL Server Configuration Manager, which exposes the SQL Native Client settings where client-side aliases are defined.

Install and configure SharePoint

Question

You are the administrator for a company's SharePoint environment. All SharePoint installations must use SQL aliases. You need to complete the configuration. Which tool should you use?

Options

  • APsconfig
  • BSQL Server Configuration Manager
  • CSQL Server Management Studio.
  • DClconfig
  • EIIS Manager

How the community answered

(33 responses)
  • B
    94% (31)
  • C
    3% (1)
  • D
    3% (1)

Why each option

SQL Server aliases for SharePoint are created with SQL Server Configuration Manager, which exposes the SQL Native Client settings where client-side aliases are defined.

APsconfig

PSConfig is the SharePoint Products Configuration Wizard used to configure farm topology and run post-installation tasks, and it has no functionality for creating SQL network aliases.

BSQL Server Configuration ManagerCorrect

SQL Server Configuration Manager includes the SQL Native Client Configuration section where an administrator maps a friendly alias name to the actual SQL Server instance name and port number. SharePoint resolves database connections through this alias, allowing the underlying SQL Server to be renamed or migrated without modifying any SharePoint configuration.

CSQL Server Management Studio.

SQL Server Management Studio is used for database administration and query execution, but does not provide an interface for defining SQL Server client-side connection aliases.

DClconfig

CLSConfig is the SharePoint Unified Logging Service configuration tool used for trace log settings and diagnostics, not for configuring SQL Server network aliases.

EIIS Manager

IIS Manager configures web server components such as application pools and bindings for SharePoint web applications, and cannot create or manage SQL Server connection aliases.

Concept tested: SQL Server alias creation via SQL Server Configuration Manager for SharePoint

Source: https://learn.microsoft.com/en-us/sharepoint/administration/add-a-sql-server-alias-for-sharepoint-sites

Topics

#SQL alias#SQL Server Configuration Manager#farm installation#database connectivity

Community Discussion

No community discussion yet for this question.

Full 70-339 Practice