Microsoft認證所有考試科目

70-086 Implementing and Supporting Systems Management Server 2.0
70-089 Planning, Deploying, and Managing Microsoft Systems Management Server 2003
70-121 Designing and Providing Microsoft Volume Licensing Solutions for Small and Medium Organizations
70-122 Designing and Providing Microsoft Volume Licensing Solutions to Large Organizations
70-123 Planning, Implementing and Maintaining a Software Asset Management (SAM) Program
70-210 Installing, Configuring and Administering Microsoft Windows 2000 Professional
70-214 Implementing and Administering Security in a Microsoft Windows 2000 Network
70-215 Installing, Configuring and Administering Microsoft Windows 2000 Server
70-216 Implementing and Administering a Microsoft Windows 2000 Network Infrastructure
70-217 Implementing and Administering a Microsoft Windows 2000 Directory Services Infrastructure
70-218 Managing a Microsoft Windows 2000 Network Environment
70-219 Designing a Microsoft Windows 2000 Directory Services Infrastructure
70-220 Designing Security for a Microsoft Windows 2000 Network
70-221 Designing a Microsoft Windows 2000 Network Infrastructure
70-223 Configuring and Administering Microsoft Clustering Services by using Microsoft Windows 2000 Advanced
70-224 Installing, Configuring and Administering Microsoft Exchange 2000
70-227 Installing, Configuring, and Administering Microsoft Internet Security and Acceleration (ISA) Server
70-228 Installing, Configuring and Administering Microsoft SQL Server 2000, Enterprise Edition
70-229 Designing and Implementing Databases with Microsoft SQL Server 2000, Enterprise Edition
70-232 Implementing and Maintaining Highly Available Web Solutions with MS W2K Server Technologies
70-234 Designing and Implementing Solutions with Microsoft Commerce 2000 Server
70-235 TS:Devlping Busin Process & Intgrtion Sol Using MS Biz TIK
70-236 TS: Exchange Server 2007, Configuring
70-237 Designing Messaging Solutions with Microsoft Exchange Server 2007
70-238 Pro:Deploying Messaging Solutions w/MS Exchange Server 2007
70-244 Supporting and Maintaining a Microsoft Windows NT Server 4.0 Network
70-262 TS:MS Office Live Communc Serv 2005-Implem, Manage, Trblshtin
70-270 Installing, Configuring, and Administering Microsoft Windows XP Professional
70-271 Supporting Users and Troubleshooting a MS Windows XP OS
70-272 Supporting Users and Troubleshooting Desktop Applications
70-281 Planning, Deploying, and Managing an Enterprise Project Management Solution
70-282 Designing, Deploying, and Managing a Network Solution for a Small- and Medium-Sized Business
70-284 Installing, Configuring, and Administering Microsoft Exchange 2003 Server
70-285 Designing a Microsoft Exchange Server 2003 Organization
70-290 Managing and Maintaining a Microsoft Windows Server 2003 Environment
70-291 Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
70-292 Managing and Maintaining a Microsoft Windows Server 2003 Environment for a W2K
70-293 Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
70-294 Planning, Implementing, and Maintaining a Microsoft Windows Server 2003 AD Infrastructure
70-296 Planning, Implementing, and Maintaining a Microsoft Windows Server 2003 Environment
70-297 Designing a Microsoft Windows Server 2003 Active Directory and Network Infrastructure
70-298 Designing Security for a MS Windows Server 2003 Network
70-299 Implementing and Administering Security in a Microsoft Windows Server 2003 Network
70-300 Analyzing Requirements and Defining Microsoft .NET Solution Architectures
70-301 Managing, Organizing, and Delivering IT Projects by Using Microsoft Solutions Framework 3.0
70-305 Developing and Implementing Web Applications with Microsoft Visual Basic.NET
70-306 Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET
70-310 XML Web Services and Server Components with Visual Basic.NET
70-315 Developing and Implementing Web Applications with Microsoft Visual C# .NET
70-316 Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET
70-320 XML Web Services and Server Components with C#.NET
70-330 Implementing Security for Applications with Microsoft Visual Basic .NET
70-340 Implementing Security for Applications with Microsoft Visual C# .NET
70-350 Implementing Microsoft Internet Security and Acceleration (ISA) Server 2004
70-351 MS Internet Security & Acceleration Serv 2006, Configuring
70-400 TS: Microsoft System Center Operations Manager 2007, Configuring
70-401 MS System Center Configuration Manager2007, Configuring
70-431 Microsoft SQL Server 2005 Implementation & Maintenance
70-441 Designing Database Solutions by Using MS SQL Serv 2005
70-442 Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 is in Development
70-443 Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
70-444 Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
70-445 TS:MS SQL Server 2005 Business Intelligence-Implem & Mainte
70-446 PRO:Design a Business Intellig Infrastr Usi MS SQL Serv 2005
70-447 UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005
70-448 TS:MS SQL Server 2008.Business Intelligence Dev & Maintenan
70-454 UPG: Transiton MCITP SQL Serv 2005 to SQL Serv 2008 DBD
70-500 TS:MS Windows Mobile Designing, Implementing, and Managing
70-501 Planning.Deploying.and Managing a Hosting Environment
70-502(C#) TS: MS.NET Frmewrk3.5, Wndws Presentation Fndation App Dev
70-502(VB) TS: MS.NET Frmewrk3.5, Wndws Presentation Fndation App Dev
70-503(C#) TS: MS.NET Frmwrk 3.5, Wndws Commun Fndtion App Dev
70-503(VB) TS: MS.NET Frmwrk 3.5, Wndws Commun Fndtion App Dev
70-504(VB) TS: MS.NET Frmewk 3.5, Workflow Foundation App Dev
70-505 TS: Microsoft .NET Framework 3.5,Windows Forms Application Development
70-510 TS:Visual Studio 2005 Team Foundation Server
70-526 Microsoft .NET Framework 2.0 – Windows-based Client Development is in Development
70-528(C#) MS.NET Framework 2.0-Web-based Client Development
70-529 MS.NET Framework 2.0 – Distributed Appl Development
70-536 TS:MS.NET Framework 2.0-Application Develop Foundation
70-540 TS:Microsoft Windows Mobile Application Development
70-540(VB) TS: MS.NET Frmewk 3.5, Workflow Foundation App Dev
70-541(C#) TS:MS Windows SharePoint Srvcs 3.0 Application Development
70-541(VB) TS:MS Windows SharePoint Srvcs 3.0 Application Development
70-542(C#) MS Office SharePoint Server 2007-Application Development
70-542(VB) MS Office SharePoint Server 2007-Application Development
70-543(VB) TS: Visual Studio Tools for 2007 MS Office System (VTSO)
70-544(VB) TS: Ms Virtual Earth 6.0, Application Development
70-545(C#) TS:Microsoft Visio 2007, Application Development
70-545(VB) TS:Microsoft Visio 2007, Application Development
70-547(C#) PRO:Design and Develop Web-Basd Apps by Using MS.NET Frmwk
70-547(VB) PRO:Design and Develop Web-Basd Apps by Using MS.NET Frmwk
70-548(C#) PRO:Design & Develop Wdws-Based Appl by Using MS.NET Frmwk
70-548(C++) PRO:Design & Develop Wdws-Based Appl by Using MS.NET Frmwk
70-548(VB) PRO:Design & Develop Wdws-Based Appl by Using MS.NET Frmwk
70-549(C++) PRO:Design & Develop Enterprise Appl by Using MS.NET Frmwk
70-549(VB) PRO:Design & Develop Enterprise Appl by Using MS.NET Frmwk
70-551(VB) UPGRADE:MCAD Skills to MCPD Dvlpr by Using the MS.NET Frmwk
70-552(VB) UPGRADE:MCAD Skills to MCPD Wdws Dvlpr by Using MS.NET Frmwk
70-553 UPGRADE:MCSD MS.NET Skills
70-554 UPGRADE:MCSD MS.NET Skills
70-555 TS:Microsoft Office Groove 2007.Configuring
70-556 TS: MS Office PerformancePoint Server 2007, Applications
70-557 TS:Microsoft Forefront Client and Server,Configuring
70-562 .NET Framework 3.5, ASP.NET Application
70-564 PRO: Designing and Developing ASP.NET Applications using Microsoft .NET Framework 3.5
70-571 TS:Microsoft Windows Embedded CE 6.0. Developing
70-620 Microsoft Windows Vista, Configuring
70-621 Pro:Upgrading Your MCDST Cert to MCITP Enterprise Support
70-622 Pro:Microsoft Desktop Support – Enterprise.
70-623 Pro:Microsoft Desktop Support Consumer
70-624 TS:Deploying & Maintaining Vista & Client Office System 07 DT
70-630 TS: Microsoft Office SharePoint Server 2007, Configuring
70-631 TS: Microsoft SharePoint Services 3.0, Configuring
70-632 TS:Microsoft Office Project 2007. Managing Projects
70-633 TS:MS Office Project Server 2007, Managing Projects
70-634 Pro:MS Office Project Server 2007. Managing Projects & Prgms
70-638 TS:MS Office Communications Server 2007, Configuring
70-639 TS: MSOffice Proj Serv 2007, Config, For MS Cert Parthers
70-640 Windows Server 2008 Active Directory. Configuring
70-642 Windows Server 2008 Network Infrastructure, Configuring
70-643 Windows Server 2008 Applications Infrastructure, Configuring
70-646 Windows Server 2008, Server Administrator
70-647 Windows Server 2008,Enterprise Administrator
70-648 TS: Upgrading MCSA on Windows serv 2003 to Windows Serv 2008
70-649 Upgrading MCSE on Wndws Serv 2003 to Wndws Serv 2008
70-652 TS: Windows Server Virtualization, Configuring
70-656 TS:Microsoft Desktop Optimization Pack, Configuring
70-671 Design & Providing MS Vol Licensing Solutions to Small & Med
70-910 Microsoft Certification Exam
70-563 Designing and Developing Windows Applications Using the Microsoft .NET Framework 3.5
70-653 TS: Windows@ Small Business Server 2008, Configuring
70-561(C++) TS: MS .NET Framework 3.5, ADO.NET Application Development
70-561(VB) TS: MS .NET Framework 3.5, ADO.NET Application Development
70-640Big5 TS: Windows Server 2008 Active Directory, Configuring
70-536(C#) TS:MS.NET Framework 2.0-Application Develop Foundation
70-536(VB) TS:MS.NET Framework 2.0-Application Develop Foundation
70-225 Designing and Deploying a Messaging Infrastructure with Microsoft Exchange 2000 Server
70-433 TS: Microsoft SQL Server 2008, Database Development
70-432 TS:MS SQL Server@ 2008,Implementation and Maintenance
70-293Big5 MCSE 2003 Security Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
70-620Big5 TS:Configuring Windows Vista Client
70-642Big5 TS: Windows Server 2008 Network Infrastructure, Configuring
70-646Big5 Pro:Windows Server 2008, Server Administrator
70-647Big5 Pro:Windows Server 2008, Enterprise Administrator
70-568 Upgrade: Transition your MCPD Enterprise Application Developer Skills to MCPD Enterprise Applications Developer 3.5, Part 1
70-569 Upgrade: Transition your MCPD Enterprise Application Developer Skills to MCPD Enterprise Applications Developer 3.5, Part 2
70-672 Design & Providing MS Vol Licensing Solutions to Large Orgs
70-673 TS: Designing, Assessing, and Optimizing Software Asset Management (SAM)
70-451 PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008
70-451 PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

如需購買Microsoft認證考古題請到TestPassPort官方網站購買（www.testpassport.net），TestPassPort優惠活動購買上述考題可以享受特殊優惠，購買時輸入testpassport即可享受九五折優惠，購買壹科優惠5% 兩科優惠10% 三科優惠15% 四科優惠20% 五科優惠… 可以累積計算，無時間限制！

Tags:
Comments Closed 2009-08-10 (Mon) 20:12 | Posted in MCAD.NET, MCDBA, MCITP, Microsoft, mcse | admin

TestPassport IT證照考古題

TestPassport  IT證照考古題

 

作為臺灣地區最專業的IT認證題庫提供商，我們對所有購買題庫的客戶提供跟蹤服務，在您購買考題後的60天內，享受免費升級考題服務。

 

我們承諾使用“TestPassport 全真模擬測試考題”的考生可以一次性通過相關認證考試(Exam)，100%包你滿意。我們會對一次不過的考試全額退款，避免您的後顧之憂。

 

無法取得高薪、國際IT認證太過難考？TestPassport助您輕鬆通過考試！

 

專業的態度，完善的服務，結合多年實踐經驗造就我們金牌服務品質。

 

如何購買       考試軟體         常見問題         所有認證

 

熱門認證：

Adobe SUN VMWare Apple Network Appliance  Oracle

Cisco CompTIA EMC EXIN.Inc HP IBM  Microsoft

推薦認證科目：

 

MCSE  MCP  CCNA  CCDA  HP  IBM DB2  10g DBA  A+ 70-291 70-620  640-802  642-901  SY0-101  N10-003  IK0-002  350-001 642-901 642-845 640-863 VCP-310 N10-003 350-030 SY0-101 220-603 IK0-002 70-620  70-649 70-290 640-802 000-331 70-431 000-101 VCP-310  646-563 050-701  351-001  642-892  117-102  RH-302  E20-455

 

相關連接 全額退款詳情 所有認證

 

Tags:
Comments Closed 2009-05-06 (Wed) 22:32 | Posted in 3com, Accessdata, COMPTIA, Cisco, EMC, HP, MCDBA, Microsoft, Oracle, Sun, ibm, mcse | admin

70-290 Managing and Maintaining a Microsoft Windows Server 2003 Environment

MCP 70-290 考試題庫由我們的資深IT認證講師及產品專家精心打造，包括了當前最新的全套全真70-290考試試題，全部附有正確答案。所有購買本站認證考題的客戶都將得到60天的免費升級服務，保證了對Managing and Maintaining a Microsoft Windows Server 2003 Environment考試題庫的完整覆蓋。 助妳壹次通過 Managing and Maintaining a Microsoft Windows Server 2003 Environment 認證考試，壹次不過全額退款！
 70-290：管理和維護 Windows Server 2003 系統環境
Managing and Maintaining Physical and Logical Devices
Manage basic disks and dynamic disks.
Monitor server hardware. Tools might include Device Manager, the Hardware Troubleshooting Wizard, and appropriate Control Panel items.
Optimize server disk performance.
Implement a RAID solution.
Defragment volumes and partitions.

Troubleshoot server hardware devices.
Diagnose and resolve issues related to hardware settings.
Diagnose and resolve issues related to server hardware and hardware driver upgrades.

Install and configure server hardware devices.
Configure driver signing options.
Configure resource settings for a device.
Configure device properties and settings.

Managing Users, Computers, and Groups
Manage local, roaming, and mandatory user profiles.
Create and manage computer accounts in an Active Directory environment.
Create and manage groups.
Identify and modify the scope of a group.
Find domain groups in which a user is a member.
Manage group membership.
Create and modify groups by using the Active Directory Users and Computers Microsoft Management Console (MMC) snap-in.
Create and modify groups by using automation.

Create and manage user accounts.
Create and modify user accounts by using the Active Directory Users and Computers MMC snap-in.
Create and modify user accounts by using automation.
Import user accounts.

Troubleshoot computer accounts.
Diagnose and resolve issues related to computer accounts by using the Active Directory Users and Computers MMC snap-in.
Reset computer accounts.

Troubleshoot user accounts.
Diagnose and resolve account lockouts.
Diagnose and resolve issues related to user account properties.

Troubleshoot user authentication issues.
Managing and Maintaining Access to Resources
Configure access to shared folders.
Manage shared folder permissions.

Troubleshoot Terminal Services.
Diagnose and resolve issues related to Terminal Services security.
Diagnose and resolve issues related to client access to Terminal Services.

Configure file system permissions.
Verify effective permissions when granting permissions.
Change ownership of files and folders.

Troubleshoot access to files and shared folders.
Managing and Maintaining a Server Environment
Monitor and analyze events. Tools might include Event Viewer and System Monitor.
Manage software update infrastructure.
Manage software site licensing.
Manage servers remotely.
Manage a server by using Remote Assistance.
Manage a server by using Terminal Services remote administration mode.
Manage a server by using available support tools.

Troubleshoot print queues.
Monitor system performance.
Monitor file and print servers. Tools might include Task Manager, Event Viewer, and System Monitor.
Monitor disk quotas.
Monitor print queues.
Monitor server hardware for bottlenecks.

Monitor and optimize a server environment for application performance.
Monitor memory performance objects.
Monitor network performance objects.
Monitor process performance objects.
Monitor disk performance objects.

Manage a Web server.
Manage Internet Information Services (IIS).
Manage security for IIS.

Managing and Implementing Disaster Recovery
Perform system recovery for a server.
Implement Automated System Recovery (ASR).
Restore data from shadow copy volumes.
Back up files and System State data to media.
Configure security for backup operations.

Manage backup procedures.
Verify the successful completion of backup jobs.
Manage backup storage media.

Recover from server hardware failure.
Restore backup data.
Schedule backup jobs.

Tags:
Comments Closed 2008-12-18 (Thu) 2:07 | Posted in MCDBA, Microsoft | admin

Questions and answers of killTest70-228(10)

13.You are the database administrator for an accounting company. You are insta lling SQL Server 2000 on a new Microsoft Windows 2000 Server computer. The computer will run two client/server database applications that your company has purchased. Each application uses a separate database.During the installation,you specify SQL_Latin1_General_CP1_CI_AI as the default collation for the SQL Se rver computer.

After completing the installation, you discover that one of the new appl ications, named Financials, is sorting information incorrectly.

You contact the application vendor and discover that the Financials application

requires the SQL_Latin1_General_CP437_BIN collation. You need to configure the

correct collation for the applications without diminishing the performance of the SQL

Server computer.

What should you do?

A. Rerun SQL Server Setup and specify the SQL_Latin1_General_CP437_BIN collation.

B. Run the rebuildm utility and specify the SQL_Latin 1_General_CP437_BIN collation.

C. Use the ALTER DATABASE statement to specify the

SQL_Latin1_General_CP437_BIN collation for the Financials database.

D. Use the ALTER TABLE statement to specify the SQL_Latin1_General_CP437_BIN

collation for each table in the Financials database.

 

Answer: C

 

14.You are the administrator of a SQL Server 7.0 computer. Developers in your com pany use this server to create client/server applications. You want to install SQL Server 2000 on this server. You want to ensure that developers can begin migrating their applications to the server. You need to maintain the SQL Server 7. 0 installation until the migration is complete.

You need to install SQL Server 2000 to support the migration. What are two possible

ways of installing SQL Server 2000 to achieve your goal? (Each correct answer presents a complete solution. Choose two.)

A. as a named instance

B. as the default instance

C. on a second computer

D. on a separate partition

E. in the C:\MSSQL7 folder

Answer: AC

Comments Closed 2008-11-12 (Wed) 4:36 | Posted in MCDBA | admin

Questions and answers of killTest70-228(11)

15.You are the administrator of a SQL Server computer. The server is running SQL

Server 6.5 and SQL Server 7.0. You install a named instance of SQL Server 2000, and

then run the SQL Server Upgrade Wizard. On the Database Selection screen, some of the

SQL Server 6.5 databases are not listed. You cancel the SQL Server Upgrade Wizard.

You need to ensure that the SQL Server 6.5 databases are listed in t he wizard. What

should you do?

 

A. Uninstall SQL Server 7.0, and then rerun the SQL Server Upgrade Wizard.

B. Run the Microsoft SQL Server-Switch application, and then rerun the SQL Server

Upgrade Wizard.

C. Create a Data Transformation Services (DTS) package that imports the databases

from SQL Server 6.5 to SQL Server 2000, and then execute the package.

D. Uninstall SQL Server 2000, and then reinstall SQL Server 2000 as the default instance.

 

Answer: B

 

16.You are the administrator of a SQL Server 2000 computer. Your company uses the

server to store service contract information for its customers.

You are also the administrator of an Oracle relational database management system

(RDBMS) server. This server is used to store your company’s financial information. The

financial information is updated frequently throughout the day.

You need to create a series of reports that combine the service contract information and

the financial information. These reports will be updated several times a day.

You want to create these reports on the SQL Server computer by using the minimum

amount of disk space. What should you do?

 

A. Set up SQL Server replication to replicate the data from the Oracle serv er to the SQL

Server computer.

B. Set up the Oracle server as a linked server. Create a view that joins the service

contract information and the financial information.

C. Set up a Data Transformation Services (DTS) package that imports and trans forms the

data from the Oracle server to the SQL Server computer.Use SQL Server Agent to

execute the DTS package throughout the day as needed.

D. Set up a Microsoft ActiveX script that connec ts to the Oracle server and imports the

financial information into a SQL Server temporary table.Create a view that joins the

service contract information and the temporary table.

 

Answer: B

Comments Closed 2008-11-12 (Wed) 4:33 | Posted in MCDBA | admin

Questions and answers of killTest70-228(12)

17.You are the administrator of several SQL Server 2000 computer s. You configure these servers to send e-mail messages to SQL Server operators whenever a SQL Server Agent job fails or encounters an error. Your company’s software developers create a set of stored procedures that send query results in e-mail messages. The developers report, however, that attempts to send the e-mail messages by the stored procedures have not been successful. By using a MAPI profile named MS Exchange Settings you verify that SQLAgentMail is correctly configured and working properly. You nee d to configure the servers so that the stored procedures function correctly. Which two actions should you take? (Each correct answer presents part of the solution. Choose two.)

A. Set the security permissions on your e-mail server to permit multiple connections to the SQL Server mailbox.

B. Set the security permissions on your e-mail server to permit connections from the MSSQLServer service account.

C. Configure the MSSQLServer service to use the same service account as the SQLServerAgent service.

D. Configure the SQLServerAgent service to use the same service accou nt as the  MSSQLServer service.

E. Configure SQL Mail to use the MS Exchange Settings MAPI profile.

F. Configure SQL Mail to use the Default Settings MAPI profile.

 

Answer: CE

 

18.You are the administrator of a SQL Server 2000 computer. Approximately 500 users access the server by means of the Internet and the company LAN. The server has the Named Pipes and TCP/IP Net-Libraries installed. You install a named instance of SQL Server 2000 on the server to support a new application. Approximately 100 additional users will access the application by means of the Internet. After the installation, users can connect to the new application from the company LAN. However, users cannot connect to the server from the Internet to run the application. These users can conne ct to the original instance of SQL Server 2000. You need to allow the Internet users to connect to the new instance of SQL Server 2000. You want to make the minimum number of changes necessary to your present configuration. What should you do?

A. Configure the application to connect to TCP/IP port 1433 through a Virtual Private Network (VPN).

B. Reconfigure the TCP/IP Net-Library on the new instance to listen to the standard SQL Server TCP/IP port.

C. Specify a static port for the TCP/IP Net-Library on the new instance, and configure the application to connect to this port.

D. Configure the TCP/IP Net-Library on the client computers so that the library always connects to TCP/IP port 1433.

 

Answer: C

Comments Closed 2008-11-12 (Wed) 4:29 | Posted in MCDBA | admin

Practice exam of killTest 70-228 (13)

20. A customer has a database application and a Web server application running on the

same p5-570 server in a single partition. Recently there have been a number of instances

where the increased load on the database server has impacted the performance of the

Web server. What can the technical specialist recommend to keep the database

application from impacting the performance of the Web server?

A. Create a VLAN between the web server and database server.

B. Purchase APV and install the VIOS.

C. Increase the priority of the Web server.

D. Create separate LPARs for Web and database workloads.

Answer: D

21. A customer is adding a new I/O drawer to an existing p5 -570 with four LPARs and

wants to re-balance the network cards in the I/O drawers. What is t he best way to

accomplish this?

A. Add the devices as virtual adapters to a VIO server first, then add the I/O drawer and

create the Shared Ethernet Adapters.

B. Power down the partitions, run the diag -a command when the system is brought back

up and reconfigure the network cards.

C. Use the rmdev command to remove the devices, shut down the partitions and move the

cads, then run the cfgmgr command after reboot.

D. Detach the network cards, run rmdev on the devices and then dynamically reassign the

adapters to the partitions and reconfigure.

Answer: D

22. A customer wants to reassign a host bus adapter (HBA) from one partition to another

to handle increased I/O workload on that partition. What needs to be don e to dynamically

move the card?

A. Use the rmdev command to remove the card from the current partition before doing the

DLPAR process.

B. Take the source partition down and do the DLPAR fu nction on the target partition.

C. Assign the card to the required section of the t arget partition and run cfgmgr.

D. Dynamically remove the card from the source and add t o target profile then reactivate

the target profile.

Answer: A

Comments Closed 2008-11-12 (Wed) 4:28 | Posted in MCDBA | admin

Questions and answers of killTest 70-228(14)

23.You are the administrator of a new Microsoft Windows 20 00 Server computer named HQSQL5. HQSQL5 is a member server in your company’s Windows NT 4.0 domain, which is named HQMAIN. After installing SQL Server 2000 on HQSQL5, you configure the MSSQLServer service account to use the HQMAIN\sqladmin user account, which is a member of the local Administrators group on HQSQL5. You can use the HQMAIN\sqladmin user account to log on to HQSQL5. However, the MSSQLServer service fails to start. You need to start the service. What should you do?

 

A. Revoke Log on interactively rights for the HQMAIN\sqladmin user account.

B. Add the HQMAIN\sqladmin user account to the HQMAIN\Domain Admins group.

C. Select the Password Never Expires check box for the HQMAIN \sqladmin user account.

D. Grant Log on as a service rights to the HQMAIN\sqladmin user account.

 

Answer: D

 

24.You are the administrator of a group of Microsoft Windows 2000 Server com puters.You are installing SQL Server 2000 on these computers. You run SQL Server Setup on a server named CORPMAST. You install SQL Server 2000 remotely on a server named CORPSQL2. During the remote installation, the Setup program displays the following error message: “Setup could not verify the target path \\CORPSQL2\C$\Program  Files\Microsoft SQL Server. Please verify the target UNC.” You verify that \\CORPSQL2\C$\Program Files\Microsoft SQL Server is accessible for the remote

installation. You need to correct the problem so that the Setup program can continue.

What should you do?

 

A. On CORPSQL2, share drive C as CDrive.Change the installation path to

\\CORPSQL2\CDrive\Program Files\Microsoft SQL Server.

B. On CORPMAST, log off, and then log on again with credentials that also have

administrative rights on CORPSQL2.Rerun the Setup program.

C. On CORPSQL2, change the installation path to a drive that has sufficient room for

the SQL Server 2000 installation.

D. On CORPMAST and CORPSQL2, configure the network protocols so that the

servers share at least two network protocols.

 

Answer: B

Comments Closed 2008-11-12 (Wed) 4:27 | Posted in MCDBA | admin

KillTest Practice Exams of 70-228

KillTest Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

 

 

25.You are the administrator of a SQL Server 2000 database. You import a table of geographic information from a Microsoft Access database into a SQL Server 2000 database. The table has 12,000 rows. Each row averages 5,000 bytes. The table contains lookup data that does not change. You want to minimize the size of the data file and the time required to back up the data. Which two actions should you take? (Each correct answer presents part of the solution. Choose two.)

A. Create a 60-MB data file named Geography.ndf.

B. Create a 95-MB data file named Geography.ndf.

C. Create a 60-MB data file named Geography.mdf.

D. Create a 95-MB data file named Geography.mdf.

E. Place the table in the PRIMARY filegroup.

F. Place the table in a new filegroup named LOCATION.

Answer: BF

 

26.You are the administrator of a SQL Server 2000 computer. You have two ne w hard disks on which you will create a database named Inventory. You want to insert, update, and delete data as quickly as possible. Which two actions should you take? (Each correct answer presents part of the solution. Choose two.)

A. Configure the hard disks as two mirrored NTFS volumes.

B. Configure the hard disks as one mirrored NTFS volume.

C. Configure the hard disks as two independent NTFS volumes.

D. Configure the hard disks as one extended NTFS volume.

E. Place Inventory_data.mdf on the first volume and Inventory_log.ldf on the second

volume.

F. Place Inventory_data.mdf and Inventory_log.ldf on the first volume and

Inventory_data2.ndf and Inventory_log2.ldf on the second volume.

G. Place Inventory_data.mdf and Inventory_log.ldf on the same volume.

Answer: CE

Comments Closed 2008-11-12 (Wed) 4:25 | Posted in MCDBA | admin

Microsoft Certified Solution Developer (MCSD) credential

Definition: The Microsoft Certified Solution Developer (MCSD) credential is the premier certification for professionals who design and develop leading-edge business solutions with Microsoft development tools, technologies, platforms, and the Microsoft Windows® architecture.

 

To Obtain:

·  Must pass the following core exam:

·         Exam 70-300—Analyzing Requirements and Defining .NET Solution Architectures

       Must pass one of the following core exams:

·         Exam 70-305—Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET or

·         Exam 70-315—Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET

       Must pass one of the following core exams:

·         Exam 70-306—Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET or

·         Exam 70-316—Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET

       Must pass one of the following core exams:

·         Exam 70-310—Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework or

·         Exam 70-320—Developing XML Web Services and Server Components with Microsoft Visual C# and the Microsoft .NET Framework

       Must pass one of the following electives:

·         Exam 70-229—Designing and Implementing Databases with Microsoft SQL Server 2000, Enterprise Edition or

·         Exam 70-230—Designing and Implementing Solutions with Microsoft BizTalk Server 2000, Enterprise Edition or

·         Exam 70-234—Designing and Implementing Solutions with Microsoft Commerce Server 2000

       .

Re-certification is not required but as exams are retired or tracks are redesigned you must pass the replacement exam(s).

Comments Closed 2008-11-12 (Wed) 4:08 | Posted in MCDBA | admin
« Older Entries
TestPassport證照信息 © Copyright 2009, All Rights Reserved.