nerdexam
Microsoft

70-332 · Question #129

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 aliases used by SharePoint to connect to SQL Server are created and managed through SQL Server Configuration Manager, not SharePoint or IIS tools.

Configure and manage SharePoint environment

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.
  • DCiconfig
  • EIIS Manager

How the community answered

(35 responses)
  • B
    89% (31)
  • C
    3% (1)
  • D
    3% (1)
  • E
    6% (2)

Why each option

SQL aliases used by SharePoint to connect to SQL Server are created and managed through SQL Server Configuration Manager, not SharePoint or IIS tools.

APsconfig

Psconfig.exe is the SharePoint Products Configuration Wizard command-line tool used for farm provisioning and upgrade tasks, and has no capability to create SQL client connection aliases.

BSQL Server Configuration ManagerCorrect

SQL Server Configuration Manager includes the SQL Server Native Client configuration section where administrators create client aliases that map a logical alias name to an actual SQL Server instance name and port. SharePoint servers use these aliases at the OS/driver level to connect to SQL Server, allowing the underlying server name or instance to change without reconfiguring SharePoint connection strings.

CSQL Server Management Studio.

SQL Server Management Studio is used for database administration tasks such as T-SQL queries and schema management, but does not expose an interface for creating SQL client aliases on the application servers.

DCiconfig

Ciconfig is not a recognized standard tool for configuring SQL aliases in a SharePoint or Windows Server environment.

EIIS Manager

IIS Manager configures web server bindings, application pools, and site settings, and has no role in creating or managing SQL Server connection aliases.

Concept tested: SQL client alias creation using SQL Server Configuration Manager

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 alias#SQL Server Configuration Manager#database connectivity

Community Discussion

No community discussion yet for this question.

Full 70-332 Practice