Free pass4sure Microsoft 70-431 2.93 Download

Microsoft SQL Server 2005 Implementation & Maintenance : 70-431 Exam
Exam Number/Code: 70-431
Exam Name: Microsoft SQL Server 2005 Implementation & Maintenance

“Microsoft SQL Server 2005 Implementation & Maintenance”, also known as 70-431 exam, is a Microsoft certification. With the complete collection of questions and answers Q&as with Expert Explanations, Pass4sure has assembled to take you through 70 Q&As + 30 Labs to your 70-431 Exam preparation. In the 70-431 exam resources, you will cover every field and category in MCITP helping to ready you for your successful Microsoft Certification.

QUESTION 1
You work as the database administrator at www.pass4sure.cc. The www.Pass4sure.ccnetwork consists of a single Active Directory domain named www.pass4sure.cc. All
servers on the www.Pass4sure.ccnetwork run Windows 2000 Server. The www.Pass4sure.ccnetwork contains a SQL Server 2000 database server named PassGuide -DB01 that
runs on Windows 2000 Server. PassGuide -DB01 contains a database named
CK_Sales.
www.Pass4sure.ccintends migrating PassGuide -DB01 to SQL Server 2005 in the near future. To prepare for the migration, you decide to install SQL Server 2005 Express
on a server named PassGuide -SR31. You verify that PassGuide -SR31 exceeds the minimum recommended hardware requirements for SQL Server 2005.
What should you do next?

A. Upgrade PassGuide -SR31 to Windows Sever 2003 and install Service Pack 1.
B. Install and run the SQL Server Upgrade Advisor on PassGuide -SR31. C. Install SQL Server 2000 on PassGuide -SR31.
D. Download and install the .NET Framework 2.0. Answer: D
Explanation: SQL Server 2005 requires the.NET Framework 2.0. This is automatically installed when SQL Server 2005 is installed but is not automatically installed when SQL Server 2005 Express is installed.
Incorrect Answers:
A: You do not need to upgrade PassGuide -SR31 to Windows Sever 2003 Service Pack
1 as SQL Server 2005 Express can be installed on Windows 2000 Server. You will need
to install Service Pack 4 for Windows 2000 Server though.
B: You should run the SQL Server Upgrade Advisor when you want to upgrade an instance
of a SQL Server 2000 database to SQL Server 2005.
C: You do not need to install SQL Server 2000 before installing SQL Server 2005
Express. Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: installing SQL Server Express, before installing

QUESTION 2
You work as a database administrator at www.pass4sure.cc. The www.Pass4sure.ccnetwork consists of a single Active Directory domain named www.pass4sure.cc. All servers on the www.Pass4sure.ccnetwork run Windows Server 2003 with the latest Service Packs and Hotfixes, while the client computers run Windows XP Professional, Windows 98
Second Edition, and Novell NetWare 6.5.
You have received instruction to prepare for a new installation of SQL Server 2005
on a member server named PassGuide -SR21. PassGuide -SR21 will host a
database named CK_Sales. All www.Pass4sure.ccusers must be able to connect to
PassGuide -SR21 by computer name. A www.Pass4sure.ccnetwork administrator

named Rory Allen must ensure that the client computers will be able to connect to
PassGuide -DB01.
Which protocols can www.Pass4sure.ccusers use to PassGuide -SR21?

A. TCP/IP and Named Pipes
B. TCP/IP and IPX/SPX
C. Virtual Interface Adapter (VIA) D. Shared Memory

Answer: A

Explanation: By default, clients have TCP and Named Pipes as available protocols. You can manipulate the protocol ordering by using the SQL Server Client utility.
The client application uses the protocols in the order specified on the client computer. If you are using SQL Server 2005, the protocol order is stored in the ProtocolOrder registry entry under the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0
Incorrect Answers:
B: SQL Server 2005 does not support IPX/SPX. The newer versions of NetWare, such as
NetWare 6.5, support TCP/IP which makes it the common protocol for all clients.
C: The Virtual Interface Adapter (VIA) can be used only by VIA hardware.
D: Shared Memory can only be used on the local computer and cannot be used as a network protocol.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: client connections [SQL Server], about client network connections, choosing a network protocol

QUESTION 3
You work as the database administrator at www.pass4sure.cc. The www.Pass4sure.ccnetwork consists of a single Active Directory domain named www.pass4sure.cc. All
servers on the www.Pass4sure.ccnetwork run Windows 2000 Server. The www.Pass4sure.ccnetwork contains a SQL Server 2000 database server named PassGuide -DB01 that
runs on Windows 2000 Server. PassGuide -DB01 contains a database named
CK_Sales.
www.Pass4sure.ccintends migrating PassGuide -DB01 to SQL Server 2005 in the near future. To prepare for the migration, you decide to install SQL Server 2005 Express
on a server named PassGuide -SR23. PassGuide -SR31 was used for previously
used by application developer and contains Microsoft Visual Studio 2003, .NET Framework 1.2 and Internet Explorer 5.5. You verify that PassGuide -SR23
exceeds the minimum recommended hardware requirements for SQL Server 2005. What should you do next? (Each correct answer provides part of the solution.
Choose THREE.)

A. Upgrade PassGuide -SR23 to Windows Sever 2003 and install Service Pack 1 for
Windows Sever 2003.
B. Install Service Pack 4 for Windows 2000 Sever on PassGuide -SR23.

C. Upgrade the .NET Framework 1.2 to .NET Framework 2.0 on PassGuide -SR23.
D. Uninstall the .NET Framework 1.2 and install the .NET Framework 2.0 on
PassGuide -SR23.
E. Upgrade Internet Explorer 5.5 to Internet Explorer 6.0 and install Service Pack 1 for
Internet Explorer 6.0 on PassGuide -SR23.
F. Upgrade Microsoft Visual Studio 2003 to Microsoft Visual Studio 2005 and install
Service Pack 1 for Microsoft Visual Studio 2005 on PassGuide -SR23. Answer: B, D, E
Explanation: SQL Server 2005 requires Service Pack 4 for Windows 2000 Sever, Internet Explorer 6.0 with Service Pack 1 and the .NET Framework 2.0. The .NET Framework 2.0 is automatically installed with other versions of SQL Server 2005 but is not automatically installed with SQL Server 2005 Express. You can upgrade
.NET Framework 1.0 and upgrade .NET Framework 1.1 to .NET Framework 2.0
but .NET Framework 1.2 must be uninstalled first. Incorrect Answers:
A: You do not need to upgrade PassGuide -SR31 to Windows Sever 2003 Service Pack
1 as SQL Server 2005 Express can be installed on a Windows 2000 Server once you install Service Pack 4 for Windows 2000 Server.
C: You can upgrade .NET Framework 1.0 and upgrade .NET Framework 1.1 to .NET Framework 2.0 but .NET Framework 1.2 must be uninstalled first.
F: SQL Server 2005 Express does not require any version of Microsoft Visual Studio. Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: installing SQL Server Express, before installing

QUESTION 4
You are employed as a database administrator at www.pass4sure.cc. The www.Pass4sure.ccnetwork consists of a single Active Directory domain named www.pass4sure.cc.
You have received instruction from the CIO to prepare a new installation of SQL Server 2005. The new SQL Server 2005 database server is named
PassGuide -DB01. A www.Pass4sure.ccuser named Mia Hamm is a member of the Marketing department. You instruct her to identify the protocols that the client computers might use to connect to the server. Mia Hamm needs to identify the protocols that are needed to accomplish this goal.
What should she identify? (Choose all that apply)

A. She should use the Multiprotocol.
B. Mia Hamm should use the Named Pipes. C. She should use the Shared Memory.
D. She should use the TCP/IP
E. Mia Hamm should use the Virtual Interface Adapter (VIA). Answer: B, D

Explanation: The clients have by default TCP and Named Pipes as available
protocols. You can make use of the SQL Server Client utility to manipulate the protocol ordering. The client application uses the protocols in the order specified on
the client computer. When you make use of the SQL Server 2005, the protocol order
is stored in the ProtocolOrder registry entry under the following registry subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0
Incorrect Answers:
C: Shared Memory can only be used on the local computer and cannot be used as a network protocol.
E: The Virtual Interface Adapter (VIA) can be used only by VIA hardware. Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: client connections [SQL Server], about client network connections, choosing a network protocol

QUESTION 5
You work as the database administrator at www.pass4sure.cc. The www.Pass4sure.ccnetwork consists of a single Active Directory domain named www.pass4sure.cc. All
servers on the www.Pass4sure.ccnetwork run Windows 2000 Server. The www.Pass4sure.ccnetwork contains a SQL Server 2000 database server named PassGuide -DB01 that
runs on Windows 2000 Server Service Pack 4. PassGuide -DB01 contains a database named CK_Trading.
www.Pass4sure.ccwants to migrate PassGuide -DB01 to SQL Server 2005 but wants to retain the CK_Trading database with the same instance name. You decide to
perform an in-place upgrade to SQL Server 2005. You verify that
PassGuide -DB01 exceeds the minimum recommended hardware requirements for
SQL Server 2005.
What should you do next?

A. Upgrade PassGuide -DB01 to Windows Sever 2003 Service Pack 1. B. Run the SQL Server Upgrade Advisor on PassGuide -DB01.
C. Detach the CK_Trading database on PassGuide -DB01. D. Run the SQL Server 2005 Setup utility.

Answer: B

Explanation: Before you perform an in-place upgrade of an existing database, you should run the SQL Server Upgrade Advisor. The SQL Server Upgrade Advisor produces a list of items that must be addressed before and after performing the upgrade. This list of items is specific to the existing installation.
Incorrect Answers:
A: You do not need to upgrade PassGuide -DB01 to Windows Sever 2003 Service Pack
1 as SQL Server 2005 can be installed on Windows 2000 Server with Service Pack 4.
C: You need to detach a database when you need to move the database to another database instance or another database server. You do not need to detach the database before performing an in-place upgrade.
D: You should run the SQL Server Upgrade Advisor before you run the SQL Server

pass4sure 70-431 2.93
Questions and Answers : 70 Q&As + 30 Labs
Expected Date: October 21st , 2008
Price: $129.99 $89.99

Free Down: Pass4sure Microsoft 70-431 2.93
Free Down: PassGuide microsoft 70-431 2.93