Re: SQL Server 2005 Cluster Setup Quiz

Lets give this a try.

Answers Inline

"Ray Schueler[MSFT]" <RaySchuelerMSFT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:411EC245-ED72-4F49-A21E-A6E58416A909@xxxxxxxxxxxxxxxx
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

B.
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

B.
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%

D.
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.

B.
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

A. -- Same as for SQL 2000 SP4 and later hotfixes.
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.

D. --And you don't have to hack the registry anymore.

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.

B. -- And it's about time.

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

B.
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

A.
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.

A

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

A. But I am guessing here.


.

Relevant Pages

  • Re: Create SQL cluster on 2003
    ... Since you are in a cluster configuration, ... Microsoft SQL Server MVP ... We only about about 20 databases - all ... Move Databases Between Computers That Are Running SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: A complicate cluster configuration...
    ... The SQL Server 2000 EE will be running just in one node, ... It is possible that an operator can manage the cluster from a terminal ... > and SFTPs them to a remote machine. ...
    (microsoft.public.windows.server.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... the first instance on the cluster. ... SQL Server 2005 failover cluster has been installed? ... drive of a SQL Server 2005 failover cluster installation? ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)