PrepAway - Latest Free Exam Questions & Answers

Which three actions should you perform in sequence?

DRAG DROP
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.)

PrepAway - Latest Free Exam Questions & Answers

Answer: See the explanation

Explanation:
Explanation/Reference:
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. Install & Configure SharePoint 2013 with SQL Client Alias


Leave a Reply