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 conn

题目

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?

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 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 conn”相关问题
  • 第1题:

    You are the administrator of a SQL Server 2000 computer. The server contains your company's order processing database. Two-hundred operators take orders by telephone 24 hours a day. Threehundred data entry personnel enter data from orders received by mail.

    To ensure that order data will not be lost, your company's disaster recovery policy requires that backups be written to tape. Copies of these tapes must be stored at an off-site company location. Orders must be entered into the database before they can be filled. If the server fails, you must be able to recover the order data as quickly as possible.

    You need to create a backup strategy that meets the company requirements and minimizes server workload. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.)

    A.Perform. a combination of full database and filegroup backups.

    B.Perform. a combination of full database and file backups.

    C.Perform. a combination of full database, differential, and transaction log backups.

    D.Back up the data to a local tape drive.

    E.Back up the data to a network share, and then use enterprise backup software to write the disk backups to tape.


    正确答案:CE
    解析:Explanation:
    C: Most OLTP backup schemes include a full database, differential, and transaction log backups

    E: In order to recover the data as quickly as possibly we backup the data to network share, and then backup that share to tape. This minimizes the impact of the backup process on the SQL Server computer.

    Note 1: SQL Server 2000 provides three database recovery models. These are the Simple recovery model, the Full Recovery Model and the Bulk-Logged Recovery model. Simple Recovery requires the least administration. In the Simple Recovery model, data is recoverable only to the last full database or differential backup. Transaction log backups are not used, and consequently, minimal transaction log space is required.

    This Recovery Model is not an appropriate choice for production systems where loss of recent changes is unacceptable. Full Recovery and Bulk-Logged Recovery models provide the greatest protection for data. These models rely on the transaction log to provide full recoverability and to prevent work loss in the broadest range of failure scenarios.

    The Full Recovery model provides the most flexibility for recovering databases to an earlier point in time. The Bulk-Logged model provides higher performance and lower log space consumption for certain large-scale operations. It does this at the expense of some flexibility of pointin- time recovery. In this scenario we would want to implement the Full Recovery model as this Recovery model provides complete protection against media failure and provides the ability to recover the database to the point of failure or to a specific point in time.

    To guarantee this degree of recoverability, all operations are fully logged. The backup strategy for full recovery consists of database backups, differential backups, which are optional, and transaction log backups. The differential backups are optional but have less of an effect on the system while they run, as they are smaller than full database backups.

    This is because a differential backup creates a copy of all the pages in a database modified after the last database backup. A transaction log backup makes a copy only of the log file and backs up the changes made to the database after the last full or differential database backup. A log file backup cannot be used by itself to restore a database. A log file is used after a database restore to recover the database to the point of the original failure. The full database, differential, and transaction log backups can be written to a hard disk or other disk storage media such as a tape drive.

    Disk backup devices can be defined on a local disk of a server or on a remote disk on a shared network resource. Tape backup devices are used in the same way as disk devices, with the exception that the tape device must be connected physically to the computer running an instance of SQL Server. SQL Server 2000 thus does not support backing up to remote tape devices.

    Note 2, file backup, filegroup backup: SQL Server 2000 supports backing up or restoring individual files or filegroups within a database. This is a complex backup and the restore process that is usually reserved for large databases with high availability requirements. If the time available for backups is not long enough to support backing up the full database, subsets of the database can be backed up at different times. If a disk holding database files or filegroups fails, the site can restore just the lost files or filegroups. This allows for a quicker recovery because only the damaged files or filegroups are restored in the first step, not the entire database.

    Incorrect Answers:
    A: An OLTP server requires transaction log backups in order to be able to recover up to the point of failure.

    B: An OLTP server requires transaction log backups in order to be able to recover up to the point of failure.

    D: Backing up to a local tape device would minimize cost but it would compared to a backup to a network it would decrease performance of the server more, and it would take more time to recover.

  • 第2题:

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now according to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met: the data collector is used to gather performance information; a single database stores performance information for all instances; performance information that is older than 15 days is deleted; reduce the administrative effort to manage performance to the least. So what action should you perform to achieve this goal? () 

    • A、You should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances. 
    • B、You should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances. 
    • C、You should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances. 
    • D、You should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances. 

    正确答案:B

  • 第3题:

    Your network contains a single Active Directory domain. All servers on the network are members of the domain. You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). Server1 has two NTFS partitions. You create and share a folder named Data in the root of a partition on Server1. You log on to your computer by using the domain Administrator account and discover that you cannot modify files in the Data share. You need to ensure that the Administrator can modify files in the Data share. The solution must use the minimum amount of permissions. What should you do? ()

    • A、Modify the NTFS permissions on the Data folder.
    • B、Modify the share permissions on the Data share.
    • C、Add the domain administrator to the local Administrator’s group on Server1.
    • D、Move the Data folder to a new file allocation table (FAT) partition. Share the folder by using the default permissions.

    正确答案:B

  • 第4题:

    Your company has Windows Server 2008 R2 file servers.   You need to recommend a data recovery strategy that meets the following requirements:   èBackups must have a minimal impact on performance.   èAll data volumes on the file server must be backed up daily.   èIf a disk fails, the recovery strategy must allow individual files to be restored.   èUsers must be able to retrieve previous versions of files without the intervention of an administrator.   What should you recommend?()

    • A、Deploy File Server Resource Manger (FSRM). Use Windows Server Backup to perform a daily backup to an external disk.
    • B、Deploy Windows Automated Installation Kit (Windows AIK). Enable shadow copies for the volumes that contain shared user data. Store the shadow copies on a separate physical disk.
    • C、Use Windows Server Backup to perform a daily backup to an external disk. Enable shadow copies for the volumes that contain shared user data. Store the shadow copies on a separate physical disk.
    • D、Use Windows Server Backup to perform a daily backup to a remote network share. Enable shadow copies for the volumes that contain shared user data. Store the shadow copies in the default location.

    正确答案:C

  • 第5题:

    You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. The application uses Session objects. You are modifying the application to run on a Web farm. You need to ensure that the application can access the Session objects from all the servers in the Web farm. You also need to ensure that when any server in the Web farm restarts or stops responding, the Session objects are not lost.  What should you do?()

    • A、Use the InProc Session Management mode to store session data in the ASP.NET worker process. 
    • B、Use the SQLServer Session Management mode to store session data in a common Microsoft SQL Server 2005 database. 
    • C、Use the SQLServer Session Management mode to store session data in an individual database for each Web server in the Web farm. 
    • D、Use the StateServer Session Management mode to store session data in a common State Server process on a Web server in the Web farm. 

    正确答案:B

  • 第6题:

    You are the network administrator for All network servers run Windows Server 2003. A member server named TestKingA contains two volumes. You need to perform a complete backup of the data on TestKingA. You must ensure that TestKingA can be completely restored in case of hardware failure. Which two actions should you perform? ()(Each correct answer presents part of the solution. Choose two)

    • A、Create an Automated System Recovery (ASR) backup.
    • B、Create a backup of user data.
    • C、Create a Windows Server 2003 bootable floppy disk.
    • D、Create a DOS bootable floppy disk.
    • E、Copy all Windows Server 2003 boot files to the Windows Server 2003 bootable floppy disk.
    • F、Copy only Boot.ini to the Windows Server 2003 bootable floppy disk

    正确答案:A,B

  • 第7题:

    You are the network administrator for TestKing, which employs 1,500 users. The network consists of a single Active Directory domain named All network servers run Windows Server 2003. Most client computers run Windows XP Professional, and the rest run Windows NT 4.0 Workstation. Two terminal servers are available to network users. You install a new application on both terminal servers. Everyone who uses the new application to create data must save the data directly to a folder on the local hard disk. You need to ensure that client disk drives are always available when employees connect to the terminal servers. Which two actions should you perform?() (Each correct answer presents part of the solution. Choose two)

    • A、Create a client connection object with default settings and deploy the object to each terminal server.
    • B、Edit the RDP-Tcp properties by selecting the Connect client drives at logon options.
    • C、Install NetMeeting on all client computers. Configure Remote Desktop Sharing.
    • D、Install the default Windows 2000 Terminal Server Client software on the Windows NT 4.0 workstations.
    • E、Install Remote Desktop Connections on the Windows NT 4.0 workstations.

    正确答案:B,E

  • 第8题:

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. You are going to use the data collector to gather performance data periodically on all instances. You must store all collected data in the same database. This database is hosted on a single instance. Every five hours, you have to collect and load performance data in the management data warehouse. Which data collection process should you implement? () 

    • A、You should create a cached data collection 
    • B、You should create an on-demand non-cached data collection 
    • C、You should create a scheduled non-cached data collection. 
    • D、You should create two different SQL Agent jobs. The two jobs are scheduled at the same time. One job uploads the data collection and the other job creates a data collection.

    正确答案:C

  • 第9题:

    You are a security administrator for your company. The network consists of a single Active  Directory domain. All servers run Windows Server 2003. All client computers run Windows 2000 Professional.   You manage a Windows Server 2003 computer named Server1 that is a domain member server. You use IIS on Server1 to host an Internet Web site. Approximately 4,000 employees of your company connect over the lnternet to access company confidential data on Server1. You control access to data on Server1 by using NTFS file permissions assigned to groups. Different groups are assigned access to different files. Employees must have access only to files that they are assigned access to based on their membership in a group. You enable SSL on Server1 to protect confidential data while it is in transit. You issue each employee an Authenticated Session certificate and store a copy of that certificate with their user account in the Active Directory domain.    You need to ensure that Server1 authenticates users based on possession of their certificate.  What should you do?()

    • A、 Request a Web server certificate from a commercial certification authority (CA).
    • B、 Configure access restrictions based on employee ip address.
    • C、 Enable Digest authentication for Windows domain servers.
    • D、 Configure client certificate mapping.

    正确答案:D

  • 第10题:

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now your company CIO assigns a task to you. The company CIO wants you to configure FILESTREAM data and the two requirements below must be met: you must enable FILESTREAM for file I/O streaming access; remote client computers must be able to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled. Which service should you configure? () 

    • A、You should configure SQL Server VSS Writer 
    • B、You should configure Distributed File System 
    • C、You should configure SQL Server 
    • D、You should configure SQL Server Full Text

    正确答案:C

  • 第11题:

    单选题
    Your company has two branch offices that connect by using a WAN link. Each office contains a server that runs Windows Server 2008 R2 and that functions as a file server.   Users in each office store data on the local file server. Users have access to data from the other office.   You need to plan a data access solution that meets the following requirements: èFolders that are stored on the file servers must be available to users in both offices. èNetwork bandwidth usage between offices must be minimized.   èUsers must be able to access all files in the event that a WAN link fails. What should you include in your  plan?()
    A

    On both servers, implement DFS Replication.

    B

    On both servers, install and configure File Server Resource Manager (FSRM) and File Replication  service (FRS).

    C

    On one server, install and configure File Server Resource Manager (FSRM). On the other server,install and configure File Replication Service (FRS).

    D

    On one server, install and configure Distributed File System (DFS). On the other server, install and configure the Background Intelligent Transfer Service (BITS).


    正确答案: D
    解析: 暂无解析

  • 第12题:

    单选题
    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now according to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met: the data collector is used to gather performance information; a single database stores performance information for all instances; performance information that is older than 15 days is deleted; reduce the administrative effort to manage performance to the least. So what action should you perform to achieve this goal? ()
    A

    You should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances. 

    B

    You should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances. 

    C

    You should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances. 

    D

    You should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances. 


    正确答案: C
    解析: 暂无解析

  • 第13题:

    Your network contains a single Active Directory domain. All servers on the network are members of the domain. You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). Server1 has two NTFS partitions. You create and share a folder named Data in the root of a partition on Server1. You log on to your computer by using the domain Administrator account and discover that you cannot modify files in the Data share. You need to ensure that the Administrator can modify files in the Data share. The solution must use the minimum amount of permissions. What should you do? ()

    • A、Modify the NTFS permissions on the Data folder.
    • B、Modify the share permissions on the Data share.
    • C、Add the domain administrator to the local Administrator’s group on Server1.
    • D、Move the Data folder to a new file allocation table (FAT) partition. Share the folder by using the default permissions.

    正确答案:B

  • 第14题:

    You are a security administrator for your company. All servers run Windows Server 2003. All client computers run Windows XP Professional.    You install Software Update Services (SUS) on a server named Server1. The company’s written security policy states that all updates must be tested and approved before they are installed on network computers.    You need to ensure that SUS uses the minimum amount of disk space on Server1.  What should you do?()

    • A、 Configure Server1 to redirect client computers to the Microsoft Windows Update servers.
    • B、 Compress the folder in which the downloaded updates are stored.
    • C、 Configure Server1 to store only the locales that are needed.
    • D、 Download the updates, and then delete updates that are not approved for client computers.

    正确答案:A

  • 第15题:

    You are the network administrator for All network servers run Windows Server 2003. A server named TK1 contains a mirrored volume that consists of two 36-GB disks. Both disks are used for data storage. TK1 also contains a third unallocated dynamic disk. Next week, a database that currently requires 45 GB of disk space will be installed on TK1. This database will grow at a rate of 10 percent every 6 months. You need to realocate disk space on TK1. Your realocation must satisfy the space requirements of the new database, and it must also ensure that data will remain available in case of disk failure. First, you break the mirror and delete all volumes on the disks. What should you do next?()

    • A、Create a spanned volume.
    • B、Create a stripped volume.
    • C、Create a mirrored volume.
    • D、Create a RAID-5 volume.

    正确答案:D

  • 第16题:

    You are the network administrator for your company, which employs 1,500 users. The network consists of a single Active Directory domain. All network servers run Windows Server 2003. Most client computers run Windows XP Professional, and the rest run Windows NT 4.0 Workstation.Two terminal servers are available to network users. You install a new application on both terminal servers.Everyone who uses the new application to create data must save the data directly in a folder on the local hard disk.You need to ensure that client disk drives are always available when employees connect to the terminal servers.Which two actions should you perform? ()(Each correct answer presents part of the solution. Choose two.)

    • A、Create a client connection object with default settings and deploy the object to each terminal server.
    • B、Edit the RDP-Tcp properties by selecting the Connect client drives at logon option.
    • C、Install NetMeeting on all client computers. Configure Remote Desktop Sharing.
    • D、Install the default Windows 2000 Terminal Server Client software on the Windows NT 4.0 workstations.
    • E、Install Remote Desktop Connection on the Windows NT 4.0 workstations.

    正确答案:C,F

  • 第17题:

    You are the network administrator for The network consists of a single Active Directory domain named All network servers run Windows Server 2003. Your network includes domain controllers, file and print servers, and application servers. The application servers run a variety of programs, including Microsoft SQL Server 2000 and Microsoft Exchange Server 2003. Your staff are responsible for monitoring current system performance on all servers. You need to enable your staff to use System Monitor to gather performance data for each unique server type. The data will be used for trend analysis and forecasting. Which two actions should you perform? ()(Each correct answer presents part of the solution. Choose two)

    • A、For each server, add the most common performance counters and save them as an HTML file.
    • B、For each server, add the most common performance counters and save them as a counter report file.
    • C、Create trace logs based on the file and schedule and trace logs to gather data.
    • D、Create alerts on the file and schedule the alerts to gather data.
    • E、Create counter logs based on the file and schedule the counter logs to gather data.

    正确答案:A,E

  • 第18题:

    Your company has two branch offices that connect by using a WAN link. Each office contains a server that runs Windows Server 2008 R2 and that functions as a file server.   Users in each office store data on the local file server. Users have access to data from the other office.   You need to plan a data access solution that meets the following requirements: èFolders that are stored on the file servers must be available to users in both offices. èNetwork bandwidth usage between offices must be minimized.   èUsers must be able to access all files in the event that a WAN link fails. What should you include in your  plan?()

    • A、On both servers, implement DFS Replication.
    • B、On both servers, install and configure File Server Resource Manager (FSRM) and File Replication  service (FRS).
    • C、On one server, install and configure File Server Resource Manager (FSRM). On the other server,install and configure File Replication Service (FRS).
    • D、On one server, install and configure Distributed File System (DFS). On the other server, install and configure the Background Intelligent Transfer Service (BITS).

    正确答案:A

  • 第19题:

    You are the network administrator for Your network contains a single Active Directory domain named All network servers run Windows Server 2003. One of your application servers runs proprietary software. This server stops responding. After help desk technicians restart the server, it appears to run normally. Two weeks later, the same server stops responding again. You need to gather and store data to diagnose the problem. What should you do?()

    • A、Open Event Viewer and review the security logs on the server.
    • B、Create a System Monitor log that uses memory counters and gather data over time.
    • C、Open Task Manager and gather memory usage statistics.
    • D、Modify Boot.ini to use /maxmem:1536.

    正确答案:B

  • 第20题:

    You need to design a method to encrypt confidential data. Your solution must address the concerns of the chief information officer. What should you do?()

    • A、Encrypt customer information when it is stored and when it is being transmitted
    • B、Require encrypted connections to the public Web site, which is hosted on the Web server on the perimeter network
    • C、Encrypt all marketing information on file servers and client computers
    • D、Require encrypted connections to all file servers

    正确答案:A

  • 第21题:

    Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 (SP2). All client computers run Windows XP Professional Service Pack 3 (SP3). You have a file server that contains two volumes named C and D. Volume C contains a folder named User1data. User1 is the owner of all files in the User1data folder. You copy the User1data folder to volume D. You examine the ownership of the User1data folder on volume D and discover that your user account is listed as the owner. You need to ensure that User1 is the owner of the User1data folder on volume D. What should you do? ()

    • A、Modify the Advanced Security settings for the User1data folder.
    • B、Modify the Advanced Attributes settings for the User1data folder.
    • C、Delete the User1data folder on volume
    • D、From Windows Explorer, move the User1data folder from volume C to volume

    正确答案:A

  • 第22题:

    单选题
    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. You are going to use the data collector to gather performance data periodically on all instances. You must store all collected data in the same database. This database is hosted on a single instance. Every five hours, you have to collect and load performance data in the management data warehouse. Which data collection process should you implement? ()
    A

    You should create a cached data collection 

    B

    You should create an on-demand non-cached data collection 

    C

    You should create a scheduled non-cached data collection. 

    D

    You should create two different SQL Agent jobs. The two jobs are scheduled at the same time. One job uploads the data collection and the other job creates a data collection.


    正确答案: A
    解析: 暂无解析

  • 第23题:

    单选题
    You are a security administrator for your company. All servers run Windows Server 2003. All client computers run Windows XP Professional.    You install Software Update Services (SUS) on a server named Server1. The company’s written security policy states that all updates must be tested and approved before they are installed on network computers.    You need to ensure that SUS uses the minimum amount of disk space on Server1.  What should you do?()
    A

     Configure Server1 to redirect client computers to the Microsoft Windows Update servers.

    B

     Compress the folder in which the downloaded updates are stored.

    C

     Configure Server1 to store only the locales that are needed.

    D

     Download the updates, and then delete updates that are not approved for client computers.


    正确答案: C
    解析: 暂无解析