Drag and Drop Question You are planning to install an instance of Microsoft SQL Server for a SharePoint 2013 farm. You have the following requirements: - Ensure that databases can be redirected to…

The correct sequence of actions is: 1. Create a named instance of SQL Server. 2. Configure the instance to use a custom port. 3. Create a SQL Server alias and configure the farm to use the alias. Explanation: Box 1: Create a named instance of SQL Server. Box 2: Configure the…

Plan a SharePoint environment

Question

Drag and Drop Question You are planning to install an instance of Microsoft SQL Server for a SharePoint 2013 farm. You have the following requirements: - Ensure that databases can be redirected to other servers. - Minimize potential security threats. You need to install and configure the instance. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Explanation

The correct sequence of actions is:

Create a named instance of SQL Server.
Configure the instance to use a custom port.
Create a SQL Server alias and configure the farm to use the alias.

Explanation: Box 1: Create a named instance of SQL Server. Box 2: Configure the instance to use a custom port. Box 3: Create a SQL Server alias and configure the farm to use the alias.

Note:

To harden the security for SQL server it is highly recommend to install SQL Server with named instance with custom port and block all default SQL specific ports.
After the installation of SQL Server with named instance, we have to assign a custom static port number for the SQL Service.
After the SQL installation we go to the SharePoint side. We have to configure the SQL Client Alias.

Topics

#SQL Server installation#SQL alias#database planning#security hardening

Community Discussion

No community discussion yet for this question.

Full 70-332 Practice