Passguide Microsoft Mcdba 70-431 Exam

passguide Microsoft: 70-431 Exam
Questions & Answers 70-431 – Questions & Answers
Interactive Testing Engine Included!
289 Questions
Updated : 07/21/2008
Price : $76.99 $69.99

Audio Exams 70-431 – Audio Exams
Updated : 03/15/2008
Price : $27.49 $24.99

Preparation Labs 70-431 – Preparation Labs
12 Labs
Updated : 03/11/2008
Price : $38.49 $34.99

Passguide Materials do not contain actual questions and answers
from Microsoft’s Certification Exams

Donwload Free PassGuide Braindumps-The Most Realistic Practice Questions and Answers,Help You Pass any Exams

QUESTION 1:
You work as the database administrator at Chinatag .com. The Chinatag .com
network consists of a single Active Directory domain named Chinatag .com. All
servers on the Chinatag .com network run Windows 2000 Server. The Chinatag .com
network contains a SQL Server 2000 database server named Chinatag -DB01 that
runs on Windows 2000 Server. Chinatag -DB01 contains a database named
CK_Sales.
Chinatag .com intends migrating Chinatag -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 Chinatag -SR31. You verify that Chinatag -SR31 exceeds
the minimum recommended hardware requirements for SQL Server 2005.
What should you do next?
A. Upgrade Chinatag -SR31 to Windows Sever 2003 and install Service Pack 1.
B. Install and run the SQL Server Upgrade Advisor on Chinatag -SR31.
C. Install SQL Server 2000 on Chinatag -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 Chinatag -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 Chinatag .com. The Chinatag .com network
consists of a single Active Directory domain named Chinatag .com. All servers on the
Chinatag .com network 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 Chinatag -SR21. Chinatag -SR21 will host a
database named CK_Sales. All Chinatag .com users must be able to connect to
Chinatag -SR21 by computer name. A Chinatag .com network administrator
named Rory Allen must ensure that the client computers will be able to connect to
Chinatag -DB01.
Which protocols can Chinatag .com users use to Chinatag -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 Chinatag .com. The Chinatag .com
network consists of a single Active Directory domain named Chinatag .com. All
servers on the Chinatag .com network run Windows 2000 Server. The Chinatag .com
network contains a SQL Server 2000 database server named Chinatag -DB01 that
runs on Windows 2000 Server. Chinatag -DB01 contains a database named
CK_Sales.
Chinatag .com intends migrating Chinatag -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 Chinatag -SR23. Chinatag -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 Chinatag -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 Chinatag -SR23 to Windows Sever 2003 and install Service Pack 1 for
Windows Sever 2003.
B. Install Service Pack 4 for Windows 2000 Sever on Chinatag -SR23.
C. Upgrade the .NET Framework 1.2 to .NET Framework 2.0 on Chinatag -SR23.
D. Uninstall the .NET Framework 1.2 and install the .NET Framework 2.0 on
Chinatag -SR23.
E. Upgrade Internet Explorer 5.5 to Internet Explorer 6.0 and install Service Pack 1 for
Internet Explorer 6.0 on Chinatag -SR23.
F. Upgrade Microsoft Visual Studio 2003 to Microsoft Visual Studio 2005 and install
Service Pack 1 for Microsoft Visual Studio 2005 on Chinatag -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 Chinatag -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 work as the database administrator at Chinatag .com. The Chinatag .com
network consists of a single Active Directory domain named Chinatag .com. All
servers on the Chinatag .com network run Windows 2000 Server. The Chinatag .com
network contains a SQL Server 2000 database server named Chinatag -DB01 that
runs on Windows 2000 Server Service Pack 4. Chinatag -DB01 contains a
database named CK_Trading.
Chinatag .com wants to migrate Chinatag -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
Chinatag -DB01 exceeds the minimum recommended hardware requirements for
SQL Server 2005.
What should you do next?
A. Upgrade Chinatag -DB01 to Windows Sever 2003 Service Pack 1.
B. Run the SQL Server Upgrade Advisor on Chinatag -DB01.
C. Detach the CK_Trading database on Chinatag -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 Chinatag -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
2005 Setup utility. 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.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: updating databases, detaching
and attaching databases
QUESTION 5:
You work as the database administrator at Chinatag .com. The Chinatag .com
network consists of a single Active Directory domain named Chinatag .com. All
servers on the Chinatag .com network run Windows 2000 Server. The Chinatag .com
network contains a SQL Server 7.0 database server named Chinatag -DB01 that
runs on Windows 2000 Server. Service Pack 4 for Windows 2000 Server id installed
on Chinatag -DB01.
Chinatag .com wants to migrate Chinatag -DB01 to SQL Server 2005. You decide
to perform an in-place upgrade to SQL Server 2005. You verify that
Chinatag -DB01 exceeds the recommended hardware requirements for SQL
Server 2005.
What should you do next?
A. Upgrade Chinatag -DB01 to Windows Sever 2003.
B. Install Service Pack 4 for SQL Server 7.0 on Chinatag -DB01.
C. Upgrade SQL Server 7.0 on Chinatag -DB01 to SQL Server 2000.
D. Run the SQL Server 2005 Setup utility on Chinatag -DB01 and upgrade directly to
SQL Server 2005.
Answer: B
Explanation: You can upgrade from SQL Server 7.0 with Service Pack 4 directly to
SQL Server 2005. Thus you need only install Service Pack 4 for SQL Server 7.0.
Incorrect Answers:
A: You do not need to upgrade Chinatag -DB01 to Windows Sever 2003 as SQL
Server 2005 can be installed on Windows 2000 Server with Service Pack 4.
C: You do not need to upgrade Chinatag -DB01 to SQL Server 200 as SQL Server 7.0
with Service Pack 4 can be upgraded directly to SQL Server 2005. Besides, you will need
to install Service Pack 3 for SQL Server 2000 before you can upgrade it to SQL Server
2005.
D: You need to install Service Pack 4 for SQL Server 7.0 before you can upgrade it
directly to SQL Server 2005.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: upgrading SQL Server,
upgrading to SQL Server 2005
QUESTION 6:
You work as the database administrator at Chinatag .com. The Chinatag .com
network consists of a single Active Directory domain named Chinatag .com. All
servers on the Chinatag .com network run Windows Server 2003 and all client
computers run Windows XP Professional. The Chinatag .com network contains two
SQL Server 2000 database servers named Chinatag -DB01 and
Chinatag -DB02 that are configured fro log shipping. Chinatag -DB01 is the
primary server and hosts a database named CK_Trading. Both Chinatag -DB01
and Chinatag -DB02 have Service Pack 3 for SQL Server 2000 installed.
Chinatag .com wants to upgrade Chinatag -DB01 and Chinatag -DB02 to SQL
Server 2005 Enterprise Edition but the CK_Trading database must remain
available during the upgrade process. You verify that both Chinatag -DB01 and
Chinatag -DB02 exceed the recommended hardware requirements for SQL
Server 2005 Enterprise Edition. You then install Service Pack 1 for Windows Server
2003 on Chinatag -DB01 and Chinatag -DB02.
What should you do next?
A. Install Service Pack 4 for SQL Server 2000 on both database servers.
B. Enable failover in the SQL Server 2000 log shipping configuration and upgrade
Chinatag -DB02 to SQL Server 2005.
C. Run the Database Maintenance Plan Wizard on Chinatag -DB01 to upgrade it to
SQL Server 2005.
D. Upgrade Chinatag -DB02 to SQL Server 2005 and then upgrade Chinatag -DB01
to SQL Server 2005.
Answer: B
Explanation: SQL Server 2005 does not support the Database Maintenance Plan
Wizard which was integral to log shipping in SQL Server 2000. Hence, log shipping
stops functioning when you upgrade a SQL Server 2000 log shipping configuration
directly to SQL Server 2005. To upgrade log shipping to SQL Server 2005, you must
migrate the database servers to SQL Server 2005. If you want the database to
remain available during the migration process, you must migrate with failover. To
migrate with failover you must enable failover and upgrade Chinatag -DB02.
Then you need to failover to Chinatag -DB02 and upgrade Chinatag -DB01.
Then configure log shipping with the Chinatag -DB02 becoming the primary
server and Chinatag -DB01 becoming the secondary server.
Incorrect Answers:
A: You do not need to install Service Pack 4 for SQL Server 2000 on the database
servers as SQL Server 2000 with Service Pack 3 can be upgraded to SQL Server 2005.
However, SQL Server 2005 does not support the Database Maintenance Plan Wizard
which was integral to log shipping in SQL Server 2000. Hence, log shipping stops
functioning when you upgrade a SQL Server 2000 log shipping configuration directly to
SQL Server 2005.
C: SQL Server 2005 does not support the Database Maintenance Plan Wizard which was
integral to log shipping in SQL Server 2000. Hence, log shipping stops functioning when
you upgrade a SQL Server 2000 log shipping configuration directly to SQL Server 2005.
D: Removing log shipping from Chinatag -DB02 and upgrading Chinatag -DB01 to
SQL Server 2005 will not ensure that the CK_Trading database remains available.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: log shipping [SQL Server],
upgrading
QUESTION 7:
You work as the database administrator at Chinatag .com. The Chinatag .com
network consists of a single Active Directory domain named Chinatag .com. All
servers on the Chinatag .com network run Windows Server 2003. The Chinatag .com
network contains a Domain Controller named Chinatag -DC01 and a member
server named Chinatag -SR21.
Chinatag .com wants to implement a SQL Server 2005 database that will store sales
data. All Chinatag .com users will require access to the Sales_DB database. You have
been instructed to install SQL Server 2005 on Chinatag -SR21 and to create a
database named Sales_DB. You need to ensure that Chinatag .com users and
applications can connect to the database instance by using only the computer name.
What should you do during the installation of SQL Server 2005 on
Chinatag-SR21?
A. Select the Named Instance and use MSSQLSERVER as the instance name.
B. Select the Named Instance and use Chinatag -DC01 as the instance name.
C. Select the Default Instance and accept the default instance name.
D. Select the Named Instance and use Chinatag -SR21 as the instance name.
Answer: C
Explanation: To ensure that users and applications can connect to the instance
using the computer name, you should select the Default Instance and accept the
default instance name, MSSQLSERVER.
Incorrect Answers:
A, B, D: You cannot use a Named Instance as users and applications will need to specify
the server name and the instance name when connection to the database.
QUESTION 8:
You work as the database administrator at Chinatag .com. The Chinatag .com
network consists of a single Active Directory domain named Chinatag .com. All
servers on the Chinatag .com network run on Windows Server2003 while the client
computers run Windows XP Professional, Windows 98 Second Edition, and Novell
NetWare 6.5. All computers are members of the Chinatag .com Active Directory
domain. The Chinatag .com network contains a SQL Server 2005 database server
named Chinatag -DB01 that hosts a database instance named MSSQLSERVR.
Chinatag .com wants to implement another SQL Server 2005 instance for a database
named Sales_DB. Sales_DB will store sales data for the company. All Chinatag .com
users will require access to the Sales_DB database. You have been instructed to
create the SQL Server 2005 instance for the Sales_DB database. You need to ensure
that all users will be able to connect to the Sales_DB database. You cannot make
configuration changes to the client computers. Your solution must optimize network
traffic.
What should you do?
A. Install the instance as a Named Instance and configure it to support Mixed Mode
Authentication. The enable TCP/IP for the instance.
B. Install the instance as a Default Instance and configure it to support Windows
Authentication. The enable TCP/IP for the instance.
C. Install the instance as a Named Instance and configure it to support SQL
Authentication. The enable IPX/SPX for the instance.
D. Install the instance as a Default Instance and configure it to support Windows
Authentication. The enable IPX/SPX for the instance.
Answer: A
Explanation: The default instance is named MSSQLSERVER. This instance name is
already in use; therefore you should use a Named Instance. You should use Mixed
Mode Authentication to support NetWare users.
Incorrect Answers:
B: You cannot use the Default Instance as the default instance is named
MSSQLSERVER and is already in use. Furthermore, you need to use Mixed Mode
Authentication as Windows Authentication does not support NetWare users.
C: You can use SQL Authentication, but this will require that you create SQL Logins for all
users and groups. It would be easier to use Windows Authentication for clients that user
Windows XP Professional and Windows 98 SE, and create SQL Logins for the NetWare
6.5 users. Also, 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.
D: You cannot use the Default Instance as the default instance is named
MSSQLSERVER and is already in use. Furthermore, you need to use Mixed Mode
Authentication as Windows Authentication does not support NetWare users. Also, 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.
QUESTION 9:
You work as the database administrator at Chinatag .com. The Chinatag .com
network consists of a single Active Directory domain named Chinatag .com. All
servers on the Chinatag .com network run on Windows Server2003 and all client
computers run Windows XP Professional. The Chinatag .com network contains two
SQL Server 2005 database servers that are configured in a cluster with two nodes
named NodeA and NodeB. NodeA hosts a default database instance named
MSSQLSERVR.
Chinatag .com wants to implement another SQL Server 2005 instance for a database
named Sales_DB. Sales_DB will store sales data for the company. All Chinatag .com
users will require access to the Sales_DB database. You have been instructed to
create the SQL Server 2005 instance for the Sales_DB database on Node
A. You need to ensure that all users will be able to connect to the Sales_DB database.
What should you do?
A. Run the SQL Server 2005 Setup utility on NodeA and select a Named Instance for the
Sales_DB database.
B. Run the SQL Server 2005 Setup utility on NodeA and select the Default Instance for
the Sales_DB database.
C. Move the existing instance from NodeA to NodeB. Run the SQL Server 2005 Setup
utility on Node
A. Select the Default Instance and accept the default instance name
D. Run the SQL Server 2005 Setup utility on NodeB and select a Named Instance for the
Sales_DB database.
Answer: A
Explanation: The default instance is named MSSQLSERVER. This instance name is
already in use on NodeA; therefore you should use a Named Instance.
Incorrect Answers:
B: You cannot use the Default Instance as the default instance is named
MSSQLSERVER and is already in use.
C: You do not need to move the existing instance as you can install up to 50 instances on
a SQL Server 2005 database server.
D: You need to install the instance on NodeA not NodeB. You can install a new instance
on NodeA if you use a Named Instance.
Reference:
QUESTION 10:
You work as the database administrator at Chinatag .com. The Chinatag .com
network consists of a single Active Directory domain named Chinatag .com. All
servers on the Chinatag .com network run on Windows Server2003 and all client
computers run Windows XP Professional. The Chinatag .com network contains two
SQL Server 2005 database servers that are configured in a cluster with two nodes
named NodeA and NodeB.
NodeA contains two physical hard disk drives, one of which hosts the Quorum
resource and contains a single partition while the other contains two logical
partitions. NodeB also has two physical hard disk drives each of which contain a
single logical partition. None of the hard disks in the cluster have any unallocated
space left. The SQL Server 2005 cluster currently hosts four database instances.
Chinatag .com wants to implement another SQL Server 2005 instance for a database
named Manufacturing_DB. Manufacturing_DB will store data from the
Chinatag .com Manufacturing department. You have been instructed to create the
SQL Server 2005 instance for the Manufacturing_DB database.
What should you do?
A. Run the SQL Server 2005 Setup utility on NodeB and select a Named Instance for the
Manufacturing_DB database.
B. Create a second logical partition on one of the physical disk drives on NodeB. Run the
SQL Server 2005 Setup utility on NodeB and select a Named Instance for the
Manufacturing_DB database.
C. Add a third physical disk drive on one of the nodes. Run the SQL Server 2005 Setup
utility on that node and select Named Instance for the Manufacturing_DB database.
D. Run the SQL Server 2005 Setup utility on NodeA and select a Named Instance for the
Manufacturing_DB database.
Answer: C
Explanation: A single SQL Server 2005 database server can host up to 50 instances
but a clustered SQL Server 2005 configuration can only host one instance per
logical disk drive. There are currently five logical disk drives in the cluster but one
is used for the Quorum resource this leaves you with four logical disk drives that
can support a total of four instances. To add another instance, you would need to
add another logical disk drive. As none of the hard disks have unallocated free
space, you would need to add another hard disk to the cluster.
Incorrect Answers:
A, D: You cannot add another instance to any of the two nodes as a clustered SQL Server
2005 configuration can only host one instance per logical disk drive. There are currently
five logical disk drives in the cluster but one is used for the Quorum resource this leaves
you with four logical disk drives that can support a total of four instances. To add another
instance, you would need to add another logical disk drive. As none of the hard disks
have unallocated free space, you would need to add another hard disk to the cluster.
B: You cannot create another partition on any of the physical drives on NodeB as none of
the hard disks in the cluster has unallocated free space that you can use to create another
partition. You will need to add another hard disk to the cluster for the new instance.

 

Free down: Passguide Microsoft Mcdba 70-431 Exam

Free down:Passguide 70-431 v2.93

password:www.certbible.org

PassGuide Cisco Exams Questions & Training Materials

  1. Free Passguide Microsoft Mcdba certification training Exam
  2. Free Passguide mcse mcdba 70-293 Exam
  3. Free passguide Microsoft MB3-409
  4. Free Microsoft Certified Database Administrator (MCDBA)
  5. Free MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server(TM) 2000 System Administration, Exam 70-228, Second Edition (Pro-Certification) (Paperback)
  6. Free Passguide microsoft Mcdba mcse 70-291 Exam
  7. Free passguide Microsoft MB4-212
  8. Free passguide Microsoft MB4-211
  9. Free Passguide mcse mcdba 70-290 exam
  10. Free Passguide Microsoft Windows SharePoint Services 3.0 Exam 70-631 v.273 vce
  11. Free PassGuide microsoft 70-662 pdf
  12. Free Passguide Microsoft Mcdba 70-216 v2.93

About the Author

PassGuide Free Certification Exam Download has written 6442 stories on this site.

If you have any doubts about legality of content or you have another suspicions, feel free to contact us:CertGuard@Gmail.com

2 Comments on “Passguide Microsoft Mcdba 70-431 Exam”

  • Ali wrote on 27 February, 2011, 1:41

    Exercise Running the SQL Server Installation Wizard

    Exercise Running the SQL Server Installation Wizard Load SQL Server 2008 DVD media in your computer’s DVD drive and start the installation as follows 1. After you load the DVD, the Autorun feature will open the Start screen, which displays [...]

    for more visit this url
    http://server2008.org/?p=768

Write a Comment

Gravatars are small images that can show your personality. You can get your gravatar for free today!

You must be logged in to post a comment.

Copyright © 2018 CertBible – IT certifications Exams,Study Guide,Practice Test,Training Materials.. PassGuide,Testinside,Pass4side,Certifyme,Transcender,Examworx,Topcerts,Actualtests. microsoft Comptia MCSE Oracle hp ibm citrix Sitemap