首页/ 题库 / [单选题]You are the administ的答案

You are the administrator of two Microsoft Windows 2000 advanced server computers. On these servers, you are configuring a database that will store accounting information for your company.The data must be available at all times. Interruptions in data connectivity should not last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers.How should you configure the database?

单选题
2022-01-06 21:52
A、Configure the database on the two servers as a SQL Server 2000 cluster.
B、Configure the database on one server, and then configure a standby database on the second server.
C、Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized.
D、Configure the database as a federated database, and then partition half the data on each server.
查看答案

正确答案
A

试题解析
解析:Explanation: SQL Server 2000 failover clustering provides high availability support by allowing us to configure one failover cluster to automatically, with no manual configuration, fail over to any other node in the failover cluster configuration. In this way, we minimize system downtime and provide high server availability during an operating system failure or a planned upgrade. Before SQL Server 2000 failover clustering can be set up, we must install Windows NT 4.0, Enterprise Edition, Windows 2000 Advanced Server or Windows 2000 Datacenter Server, and the Microsoft Cluster Service (MSCS). In this scenario a cluster would be preferred to a standby server because it would be available immediately. A standby server on the other would require manual configuration and more time to become online.Incorrect Answers:B: A standby server would require you to reconfigure clients to allow it to connect to the standby server when the main server goes down. It would require at least several minutes of manual administration before the standby server would be operational. But the scenario requires that no reconfiguration of the client computers should be necessary. Therefore we should use a SQL Server 2000 cluster not a standby server.Note: A standby server is a second server that contains a copy of the databases on the primary server and that can be brought online in the event of a primary server failure or due to scheduled maintenance on the primary server. This allows users to continue working with databases when the primary server becomes unavailable. When the primary server becomes available again, any changes to the standby server's copies of databases must be restored back to the primary server. C: The Microsoft Distributed Transaction Coordinator coordinates distributed transactions, but would not increase availability.Note: The Microsoft Distributed Transaction Coordinator (MS DTC) is a transaction manager that allows client applications to include several different sources of data in one transaction. MS DTC coordinates committing the distributed transaction across all the servers enlisted in the transaction. An installation of SQL Server 2000 can participate in a distributed transaction by calling stored procedures on remote servers running SQL Server, automatically or explicitly promoting the local transaction to a distributed transaction and enlist remote servers in the transaction, and making distributed updates that update data on multiple OLE DB data sources. If these OLE DB data sources support the OLE DB distributed transaction interface, SQL Server 2000 can also enlist them in the distributed transaction. The MS DTC service coordinates the proper completion of the distributed transaction to ensure that either all of the updates on all the servers are made permanent, or, in the case of errors, all erased.D: With Federated SQL Server 2000 servers, SQL Server 2000 databases can be spread across a group of autonomous database servers. These are capable of supporting the processing growth requirements of the largest Web sites and enterprise data-processing systems built with Microsoft Windows DNA, which divides the processing units of a data processing system into logical tiers. This however does not improve availability.

标签:
感兴趣题目
You are the administrator of a SQL Server 2000 computer. You have two new hard disks on which you will create a database named inventory. You want to insert, update, and delete data as quickly as possible.

Your network contains a server that runs Windows Server 2008 R2. You need to schedule backups of the server. The solution must ensure that multiple versions of the backup are available.
Which two possible backup locations should you use?()

You are the network administrator for All servers run Windows Server 2003.
You are creating a backup schedule for the main file server.
You need to create a schedule so that backup jobs are completed in the shortest
amount of time possible.
What should you do?()

You are the network administrator for Ezonexam. You are planning to upgrade 35 Windows NT Server 4.0 computers to Windows 2000 Server. You want to accomplish the upgrades by using a distribution server. The Windows NT Server 4.0 computers support a tight production schedule that requires them to be online from 8:00 A.M. to midnight, seven days a week. You schedule the upgrade to run during non-business hours. Because of the limited amount of time the upgrades must be performed as quickly as possible.You want to complete the upgrades before production begins in the morning.What should you do?
A network administrator changes the configuration register to 0x2142 and reboots the router. What are two results of making this change?()
All client computers on your company network run Windows 7 and are members of a Windows Server 2008 R2 domain. The R&D department staff are local administrators on their computers and are members of the R&D global security group. A new version of a business software application is available on the network. You plan to apply an AppLocker security policy to the R&D group. You need to ensure that members of the R&D group are not allowed to upgrade the software. What should you do?()
You are the desktop administrator of your Windows 2000 Professional computer.
You are the network administrator for All servers run Windows Server 2003. You are creating a backup schedule for the main file server. You need to create a schedule so that backup jobs are completed in the shortest amount of time possible. What should you do?()
You are employed as the exchange administrator at Company.com.the Company.com organization makes use of microsoft exchange server 2010 as their messaging solution.Company.com has its headquarters in stockholm where you are located.you are responsible for an exchange server 2010 mailbox server named - ex01.during the course of the day you receive notification from management to determine which users that have the biggest mailboxes on - ex01.What should you do?()
You work as a network exchange administrator at Company.com.the Company.com network currently consists of a single active directory forest named Company.com which makes use of microsoft windows server 2008.The Company.com organization makes use of Microsoft exchange server 2010 as their messaging solution.The Company.com organization contains a computer named -ex01 which runs the hub transport server role.During the course of the day - ex01 fails and you delete the computer account with references of ex01 from active directory.Company.com has recently requested that you replace the hub transport server role on a new computer whilst ensuring you use the least amount of administrative effort.What should you do?()
You are the network administrator for Active Directory. Another system administrator installs Software Update Services (SUS) on a production Windows Server 2003 computer. You are assigned to manage the SUS computer. You need to ensure that you can recover SUS if the server fails. You need to back up all components that are required to restore SUS to its current configuration. Because of limited space, you must not back up unnecessary data. What action or actions should you perform? Select all that apply.()
You are the network administrator for Active Directory. Another system administrator installs Software Update Services (SUS) on a production Windows Server 2003 computer. You are assigned to manage the SUS computer. You need to ensure that you can recover SUS if the server fails. You need to back up all components that are required to restore SUS to its current configuration. Because of limited space, you must not back up unnecessary data. What action or actions should you perform? Select all that apply.()
相关题目

You are the network administrator for The network consists of a single Active Directory domain named All 40 network servers run Windows Server 2003, and all 1,500 client computers run Windows XP Professional.
The servers are located in seven different buildings. All are configured to allow Remote Desktop connections.
A new administrator named Tess King is hired to help you configure applications and perform disk defragmentation on all 40 servers.
You need to enable Tess King to manage the servers remotely by using Remote Desktop for Administration.
What should you do?()

As the Ezonexam network administrator, you are required to have a firm understanding of the OSI model. Why does the data communication industry use the layered OSI reference model? (Choose two)
As a Ezonexam employee you are the desktop administrator of a Windows 2000 Professional computer.The Windows 2000 Professional computer has 25 MB of free disk space drive C and 800 MB of free disks pace on drive E. You are unable to print large documents because if inadequate disk space on drive C.You want to be able to use the space on drive E to print large documents.What should you do?
You want to upgrade 400 computers from Windows 95 to Windows 2000 Professional. Most of the computers in your company use the same hardware. However, several different peripheral devices are used throughout the company.You want to verify that the hardware in use is compatible with Windows 2000 Professional. You want to accomplish this with least amount of administrative effort.What should you do?
You are the network administrator for Ezonexam. You are planning to upgrade Windows NT Server 4.0 computers to Windows 2000 Server. You want to perform. the upgrades by means of a distribution folder. You want to install a custom application as part of the upgrade.You need to include the necessary commands so that the custom application is automatically installed as part of the upgrade process.What should you do?
The Ezonexam network administrator needs to determine what LAN devices to install on the Ezonexam network. What are two advantages of using Layer 2 Ethernet switches over hubs? (Choose two)
You are the administrator of a Windows NT Server 4.0 computer named Ezonexam1.

You use Microsoft .Net Framework 4 to create a Windows Form application.
You created a new application, you then wrote the code below:
Thread.CurrentThread.CurrentUICulture = Thread.CurrentThread.CurrentCulture
Which of the following options are TRUE? ()

You are working as an administrator at TestKing, and you need to set the bandwidth of your routers serial port to 56K. Which of the following commands would you use?()
You are the administrator of two Microsoft Windows 2000 advanced server computers. On these servers, you are configuring a database that will store accounting information for your company.The data must be available at all times. Interruptions in data connectivity should not last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers.How should you configure the database?
Your workgroup contains computers that run Microsoft Windows Vista and Microsoft Windows XP Professional. Employees that use Windows XP Professional do not appear in the Invite people list of a Microsoft Windows Meeting Space meeting. You need to ensure that all employees are invited to Windows Meeting Space meetings. Which two actions should you perform?()
Your workgroup contains computers that run Microsoft Windows Vista and Microsoft Windows XP Professional. Employees that use Windows XP Professional do not appear in the Invite people list of a Microsoft Windows Meeting Space meeting. You need to ensure that all employees are invited to Windows Meeting Space meetings. Which two actions should you perform?()
You are installing Windows 2000 server on Windows NT using an unattended installation. You find out the SCSI adapter is not supported by Microsoft HCL. You find out from the manufacturer that a new driver is available for installing on Windows 2000. How should you enter this information in the unattended installation?
You are the network administrator for The network consists of a single Active Directory domain named The domain contains 15 Windows Server 2003 computers and 3,000 Windows XP Professional computers. All client computers are running the most recent service pack. You install and configure Software Update Services (SUS) on a server named Testking1. You install the Automatic Updates client on all client computers. All client computer accounts are in the Clients organization unit (OU). Currently all client computers obtain their Windows security updates from Windows Update. You want all client computers, and no other computers, to obtain their updates from Testking1. You need to configure all client computers to obtain Windows security updates from Testking1. You need to accomplish this task with the minimum amount of administrative effort. What should you do?()
You are the administrator of a Windows 2000 network.  Your network includes 50 Windows 98 computers. You are adding 40 new PXE compliant computers to the network. The hardware on each new computer is configured identically. You are using a Remote Installation Services (RIS) image to deploy Windows 2000 Professional to the 40 computers. You successfully install Windows 2000 Professional on the first 10 computers. However, you cannot install Windows 2000 Professional on the remaining 30 computers. You want to install Windows 2000 Professional on the remaining 30 computers. What network component do you need to change? 
You are the administrator of a SQL Server 2000 computer. You want to set up snapshot replication on the server. The server will serve as Publisher and Distributor for a minimum of 40 Subscribers.

You are the network administrator for . You administer a Windows Server 2003 computer named TestKing7. Users report that they experience poor performance when they access resources located on TestKing7. You suspect a disk bottleneck. You need to set up performance counters to monitor TestKing7.
You need to decide which performance objects to monitor.
Which two counters should you choose? ()(Each correct answer presents part of the solution. Select two.)

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which contains a database. According to the company requirement, you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the use of features.  These features will be discontinued. What should you do? ()
You are employed as the enterprise exchange administrator at Company.com..com makes use of Microsoft exchange server 2010 messaging solution.you are responsible for managing the exchange network for Company.com.you are experiencing various problems in the exchange environment.you decide to determine whether one of the other administrators executed any configuration changes in the organization.What should you do?()
You are the administrator of a new multiprocessor SQL Server 2000 computer. You are migrating data from other database management systems to this server. You need to load data from two data files into a new table on the server. The table is empty and has no indexes.
广告位招租WX:84302438

免费的网站请分享给朋友吧