SQL Server 2005 Cluster Setup Quiz

This quiz consists of 10 multiple choice questions and 1 extra credit
question. This is an "open book" quiz. Feel free to use any resources at your
disposal.

Feedback is welcome.
Ray

This posting is provided "AS IS" with no warranties, and confers no rights.
------------------------------------------------------------------------------
1. Where is sqlserver.exe located for the named instance "STPNAMED"? This is
the first instance on the cluster. (Assume the default directory is used.)

a) ..\Microsoft SQL Server\MSSQL$STPNAMED\Binn\sqlservr.exe
b) ..\Microsoft SQL Server\MSSQL.1\Binn\sqlservr.exe
c) ..\Microsoft SQL Server\MSSQL$STPNAMED\MSSQL\Binn\sqlservr.exe
d) ..\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe

2. How many cluster nodes does SQL Server 2005 Enterprise Edition support on
x86, x64 and IA64 platforms?

a) Infinite
b) 8 nodes
c) 4 nodes
d) 2 nodes

3. Where are the SQL Server 2005 setup log files found?

a) "\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG"
b) %temp%
c) ''\Program Files\Microsoft SQL Server\90\Shared"
d) %windir%

4. What is the template.ini used for?

a) Diagnosing setup failures
b) Provide a template for unattended setup command lines.
c) Provide a template on how to read SQL Server 2005 setup log files.
d) Provide a template for writing stored procedures.

5. When installing a SQL Server 2005 failover cluster, what service runs
setup on remote nodes?

a) Task Scheduler service
b) SQLSETUP service
c) Cryptographic service
d) SQL service

6. How do you change the IP address of the SQL IP cluster resource after a
SQL Server 2005 failover cluster has been installed?

a) Run setup.exe from CD, select maintenance, select change IP.
b) Click on the SQL Server 2005 entry in Add/Remove Programs, select
maintenance, select change IP.
c) Uninstall SQL Server 2005 cluster, Reinstall with new IP address.
d) Change the IP in cluster administrator.

7. What is different about the remote setup dialog in SQL Server 2005
compared to SQL Server 2000?
Reminder: This is an "open book" quiz.

a) A login and password need to be entered for each node.
b) The remote setup dialog has been removed.
c) There is no change in the dialog.
d) Only the password of the logged-on account can be entered.

8. You select all components on the component selection dialog, including
SQL Server and Analysis Services to be installed as a failover cluster. On
your 2 node cluster, what components will be installed on both nodes?

a) Management Tools
b) All components
c) SQL Server Engine and Management Tools
d) SQL Server Engine and Analysis Services

9. What are 5 cluster specific command line options for unattended cluster
setup?

a) VS, INSTALLVS, IP, GROUP, ADDNODE
b) VS, INSTALLSQLDIR, TARGETCOMPUTER, ADDLOCAL, SAPWD
c) INSTANCENAME, IP, GROUP, CLUSTER, TARGETCOMPUTER
d) INSTANCENAME, ADMINACCOUNT, ADMINPASSWORD, IP, GROUP

10. How have the permissions changed on files and folders on the shared
drive of a SQL Server 2005 failover cluster installation?

a) SQL service accounts are given access to files and folders.
b) Local groups are given access to files and folders.
c) Local administrator access is removed from files and folders.
d) Domain groups are given access to files and folders.


11. Extra Credit:

Installation Order:
Instance 1 - Standalone default instance installed on node 1
Instance 2 - SQL Engine failover cluster named instance installed on nodes 1
and 2.
Instance 3 - Standalone named instance installed on node 2.

Where will sqlservr.exe be found in the default location of the 3rd instance
on node 1?

a) ..\Microsoft SQL Server\MSSQL.1\Binn\sqlservr.exe
b) ..\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\sqlservr.exe
c) ..\Microsoft SQL Server\MSSQL.2\Binn\sqlservr.exe
d) ..\Microsoft SQL Server\MSSQL.3\MSSQL\Binn\sqlservr.exe

.

Relevant Pages

  • Re: 4 Queries about DB clustering
    ... multi-instance cluster ... > I support the Professional Association for SQL Server ... The installer writes the executable files to each host node ... > you choose as part of the installation. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Migrating stand-alone SQL server to cluster
    ... applying binaries on one node in a virtual installation. ... The problem is that if you try to reapply the service pack as you would a ... Mixed Cluster configuration that caused our problems. ... This will reinstall SQL Server on the new ...
    (microsoft.public.sqlserver.clustering)
  • RE: Error Code: 1073807364 sql server 2005
    ... contain the files that are required during the installation of SQL Server ... In the D:\SQLServer2005 folder, ... Setup.exe to start the SQL Server 2005 Setup program. ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot install 2005 Developer Edition x64 on new XP x64
    ... OS Name MicrosoftWindowsXP Professional x64 Edition ... and try to run the Setup from the media yourself. ... corrupted SQL Server installation and then try to run SQL Server Setup ...
    (microsoft.public.sqlserver.setup)
  • Re: evicting a node from multi instance cluster
    ... Even though you are running "setup", ... Setup can also be used if not evicting a node from the cluster. ... I have a three node cluster with three virtual sql server 2005 installed. ...
    (microsoft.public.sqlserver.clustering)