单选题An administrator is building a server that will run a data warehousing application.The server was ordered with eight 300GB drives.The application requires a dedicated storage location for the OS and one for critical files.The critical file storage need

题目

单选题

An administrator is building a server that will run a data warehousing application.The server was ordered with eight 300GB drives.The application requires a dedicated storage location for the OS and one for critical files.The critical file storage needs fast access but must provide high redundancy.The OS requires 100GB and the file requires 950GB.Which of the following configurations will BEST suit the data warehouse needs？（）

OS：3 Drives，RAID 1 with hot spare；Files：5 Drives，RAID 5 with hot spare

OS：2 Drives，RAID 1；Files：6 Drives，RAID 1

OS：2 Drives，RAID 0；Files：6 Drives，RAID 5

OS：2 Drives，RAID 1；Files：6 Drives，RAID 5 with hot spare

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

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 the 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 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.

正确答案：D
解析：Explanation:ToruntheSQLServerUpgradeWizard,youmusthaveadefaultinstanceofMicrosoftSQLServer2000installedonyourcomputer.IncorrectAnswers:A:ItisnotnecessarytouninstallSQLServer7.0.JustinstallSQLServer2000asthedefaultinstance.WecannotruntheSQLServerupgradewizardunlessSQLServer2000isinstalled.B:ToruntheSQLServerUpgradeWizard,youmusthaveadefaultinstanceofMicrosoftSQLServer2000installedonyourcomputer.C:WewanttoensurethattheSQLServer6.5databasesarelistedintheSQLServer2000installationwizard.TocreateDTStransformationpackagesthatupgradeSQLServer6.5databaseestoSQLServer2000databaseswemustinstallSQLServer2000first.

第2题：

You are the administrator of a SQL Server 2000 computer. Your company purchased an accounting application from a vendor. The application stores its data in a database named Accounting on the server. The tables in this database contain columns that function as primary keys, but PRIMARY KEY and FOREIGN KEY constraints are not used.

You need to replicate data from this database to another SQL Server computer. This server will use the replicated data to generate reports. Most reports will run each month, but the accounting department needs to have the ability to run reports at any time. Reports should be accurate through the last full working day.

You cannot make any changes to the database, but you need to implement replication. Which two actions should you take? (Each correct answer presents part of the solution. Choose two)

A．Implement merge replication.

B．Implement snapshot replication.

C．Implement transactional replication.

D．Schedule replication to run continuously.

E．Schedule replication to run during off-peak hours.

正确答案：BE
解析：Explanation:
B: Snapshot replication is the best solution since we will not be making changes to the Accounting database but need to replicate data from the database to another SQL Server computer and as the accounting department needs to have the ability to run reports that only need to be accurate through the last full working day.

E: Only one snap-shot replication would be necessary per day, and to make as little impact on the daily use of the server this replication should be scheduled during off-peak hours.

Note: SQL Server 2000 provides three types of replication that can be used in distributed applications. These are snapshot replication, transactional replication and merge replication. Each type provides different capabilities.

Snapshot replication is the process of copying and distributing data and database objects exactly as they were at the time the snapshot was taken. Snapshot replication does not require continuous monitoring of changes because changes made to published data are not propagated to the Subscriber incrementally. Subscribers are updated with a complete data set and not individual transactions. As snapshot replication replicates an entire data set at one time, it may take longer to propagate data modifications to Subscribers. This type of replication in helpful in situations when data is mostly static and does not change often; it is acceptable to have copies of data that are out of date for a period of time; replicating small volumes of data; and when sites are often disconnected and high latency (the amount of time between when data is updated at one site and when it is updated at another) is acceptable.

In transactional replication, an initial snapshot of data is propagated to Subscribers, and then when data modifications are made at the Publisher, the individual transactions are captured and propagated to Subscribers. SQL Server 2000 monitors INSERT, UPDATE, and DELETE statements, and changes to stored procedure executions and indexed views. SQL Server 2000 stores the transactions affecting replicated objects and then it propagates those changes to Subscribers continuously or at scheduled intervals. Transaction boundaries are preserved. Transactional replication is used when data modifications must be propagated to Subscribers, often as they occur; transactions must be atomic; subscribers are mostly connected to the Publisher and when the application will not tolerate high latency for Subscribers receiving changes.

Merge replication allows various sites to work autonomously and merge data modifications made at multiple sites into a single, uniform. result at a later time. The initial snapshot is applied to Subscribers and then SQL Server 2000 tracks changes to published data at the Publisher and at the Subscribers. The data is synchronized between servers either at a scheduled time or on demand. Updates are made independently at more than one server, so the same data may have been updated by the Publisher or by more than one Subscriber. Therefore, conflicts can occur when data modifications are merged. This type of replication is helpful when multiple Subscribers need to update data at various times and propagate those changes to the Publisher and to other Subscribers; Subscribers need to receive data, make changes offline, and synchronize changes later with the Publisher and other Subscribers; the application latency requirement is either high or low, and when site autonomy is critical.

Incorrect Answers:
A: No data at the second server will not be changed so there is no need to use merge replication.

C: We don’t need the accuracy of transactional replication. In this scenario high latency is permissible as the reports must be accurate only through the last full working day.

Note: Transactional replication is used when data modifications must be propagated to Subscribers, often as they occur; transactions must be atomic; subscribers are mostly connected to the Publisher and when the application will not tolerate high latency for Subscribers receiving changes.

D: As the reports must be accurate through the last full working day, it not necessary to run replication continuously. Running replication continuously will place locks on the destination database, which would hamper the performance of queries and actions run against the destination database.

第3题：

You are the network administrator for Litware, Inc. All network servers run Windows Server 2003.Your IIS server is named Server6. Its configuration is shown in the exhibit. (Click the Exhibit button.)Users access the internal network by connecting to http://server6.litwareinc.intra.A folder named Marketing_Data stores the Web interface for the company‘s client management tool. Currently,users in the marketing department access this tool by connecting to http://server6.litwareinc.intra/Marketing_Web.You share Marketing_Data on a server named Server2.You need to modify Server6 to ensure that marketing users can access Marketing_Data through the internal network.What should you do? （）

A. Create a new virtual directory named Marketing_Web under the default Web site. Specify \\server2\Marketing_Data as the Web site content directory.

B. Create a new Web site named Marketing_Data. Specify \\server2\Marketing_Data as the Web site home directory.

C. Create a new Web site named Marketing_Data. Specify Marketing_Data as the host header name of the Web site.

D. Redirect the default Web site home directory to http://server2/Marketing_Data. Specify Marketing_Data as the host header name of the default Web site.

参考答案：A

第4题：

You are the network administrator for TestKing. All servers run Windows 2003. All client computers run Windows XP Professional. You log on to a server named Testking15 by using the local Administrator account. You start the installation of a new server application. After you start the installation, you return to your office, which is located in another building. You need to find out the status of the installation that is in progress on Testking15. What should you do?（）

A、Select the Remember server connections option in Terminal Service Manager.
B、Use Terminal Service Manager to connect to Testking15.
C、Use Remote Assistance from a client computer.
D、Use the Remote Desktop Client to connect to the console session on Testking15

正确答案:D

第5题：

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

第6题：

An administrator receives a contract for a server install at a new building. Which of the followingshould be completed after installing the server?()

A. Log the administrator password used

B. Test the air temperature

C. Update the network diagram

D. Review the evacuation procedures

参考答案：C

第7题：

You are the network administrator for TestKing.com. All network servers run Windows Server 2003.A member server named ServerTK1 is configured to run shadow copies without a storage limit. ServerTK1 has the disk configuration shown in the following table.You need to create additional free space on DATA1. You also need to improve the performance of ServerTK1 and ensure that it has sufficient space for shadow copies in the future.Which two actions should you perform? （）(Each correct answer presents part of the solution. Choose two)

A. Delete the shadow copies of DATA1.

B. Delete Backup.bkf on DATA3.

C. In the properties of DATA1, relocate the shadow copies to DATA2.

D. In the properties of DATA1, relocate the shadow copies to DATA3.

E. Delete DATA3 and extend the DATA1 partition to include the space on DATA3.

参考答案：A, D

第8题：

You are an administrator of Ezonexam.com's network. You want to perform. routine upgrades on your Windows 2000 Server computer. You use your non-administrator user account in the domain to logon to the server.

You want to upgrade all of the critical system files and patches on the server in the shortest possible time.

What should you do?

A．Use Windows Update.

B．Run System File Checker.

C．Log on as administrator and run Windows Update.

D．Log on as administrator and run System File Checker.

正确答案：C
解析：Explanation:WindowsUpdateisusedtoupgradethesystemfilesandtoretrieveandapplythelatestservicepacksandpatchesfortheoperatingsystem.AllnecessaryfilesaredownloadedthroughtheInternet.TobeabletorunWindowsUpdatewemusthaveadministrativerights.Incorrectanswers:A:Thenon-administrativeuseraccountcannotbeusedtorunWindowsUpdate.TorunWindowsUpdatewemusthaveadministrativerights.B:SystemFileCheckercheckstheintegrityofthesystemfiles.Itcannotbeusedtoupgradethesystemfilesortoretrieveandapplythelatestservicepacksandpatchesfortheoperatingsystem.D:SystemFileCheckercheckstheintegrityofthesystemfiles.Itcannotbeusedtoupgradethesystemfilesortoretrieveandapplythelatestservicepacksandpatchesfortheoperatingsystem.

第9题：

You have a domain controller named Server1 that runs Windows Server 2003 Service Pack 2 (SP2).You start Server1 in Directory Services Restore Mode and attempt to log on by using the username administrator and a password of Pa$$w0rd. The logon attempt fails.You restart Server1 normally and successfully log on to the server by using the username administrator and a password of Pa$$w0rd.You need to ensure that you can log on to Server1 in Directory Services Restore Mode.What should you do? （）

A. From ntdsutil.exe, run Set DSRM Password.

B. From ntdsutil.exe, run Security account management.

C. From Active Directory Users and Computers, select the Account is trusted for delegation option for the Administrator account.

D. From Active Directory Users and Computers, select the Store password using reversible encryption option for the Administrator account.

参考答案：A

第10题：

Which of the following commands should the administrator run to check if the SMTP services are still active？（）

A、 Telnet <Server name> 25
B、 Ping <Server name>
C、 net send <Server name> test mail
D、 nbtstat a <Server name>

正确答案:A

An administrator is building a server that will run a data w

题目

相似问题和答案

更多相关问题

相关内容