You are the administrator of a SQL server 2000 computer that contains a database named Acct. The database contains 1.5 GB of data. The server has one 9-GB hard disk that is configured as shown in the Exhibit.You need to import data into the database witho

题目内容(请给出正确答案)

You are the administrator of a SQL server 2000 computer that contains a database named Acct. The database contains 1.5 GB of data. The server has one 9-GB hard disk that is configured as shown in the Exhibit.

You need to import data into the database without adversely affecting database performance. The data will require an additional 2GB of storage space.

What should you do?

A．Add another data file on drive E, and then add the file to the PRIMARY filegroup.

B．Move the transaction log file to drive E, and set the file growth of Acc_Data.mdf by selecting the Unrestricted file growth option.

C．Rebuild all clustered indexes so that they have a fill factor of 100.

D．Compress drive D.

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

更多相关问题

第1题

You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe. database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe. database.You want to enable the server in Sydney to connect to the mainframe. database. What should you do?A．Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.B．Modify the workflow in the DTS package so that the server in Sydney is included.C．On the server in Sydney, install an OLE DB provider for the mainframe. database.D．On the server in Sydney, delete and then re-create the DTS package.

点击查看答案
第2题

Your network contains a database server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2).Server1 has the following hardware configurations:·A single processor that supports hyper-threading·Dual processor motherboard·Two hard disks·2 GB of RAMThe first disk contains all the files for the operating system and applications. The second disk is empty.Hyper-threading is disabled in the BIOS.Users report a slow response when they query the database on Server1.You monitor Server1 for one day and receive the performance statistics shown in the following table.You need to improve database performance.What should you do? （）A. Upgrade the RAM to 4 gb.B. Install a second processor.C. Enable hyper-threading in the bios.D. Move the database to the second disk.

点击查看答案
第3题

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 lockup 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.ndfB. Create a 95-MB data file named geography.ndfC. Create a 60-MB data file named geography.mdfD. Create a 95-MB data file named geography.mdfE. Place the table in the PRIMARY filegroup.F. Place the table in a new filegroup named LOCATION.

点击查看答案
第4题

You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.What should you do?A．Enable the torn page detection database option for each database.B．Disable write caching on all disk controllers.C．Ensure that write caching disk controllers have battery backups.D．Create a database maintenance plan to check database integrity and make repairs each night.

点击查看答案
第5题

You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.What should you do?A．Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.B．Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.C．Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.D．Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.

点击查看答案
第6题

Your Windows 2000 Server computer named EzonexamSrv contains a single 18-GB hard disk. The drive is configured as a basic disk and has two partitions. Partition C is 2 GB in size and contains the operating system files. Partition D is 16 GB in size and contains user data that is updated frequently.Both partitions are formatted as NTFS. Both partitions are backed up to a tape every evening at 10:00 P.M.You have a current Emergency Repair Disk (ERD) for EzonexamSrv, and the Recovery Console is installed on the computer.One day at4:00 P.M., the server fails. You attempt to restart EzonexamSrv, but you receive the following error message:"Boot disk or operating system not found".You use Recovery Console to discover that the files on partition C are corrupted.You need to recover EzonexamSrv from the failure as quickly as possible. You also must recover as much user data as possible.What should you do?A．Use the ERD to start the computer. Replace the corrupted files on partition C by copying them from a Windows 2000 Server CD-ROM.B．Boot the Recovery Console. Copy any files that have changed since 10:00 P.M. the previous evening to a second server. Use the most recent tape backup to restore the remaining user data to the second server.C．Start the computer by using a Windows 2000 Server CD-ROM. Select the Repair option in Setup.D．Install a second hard disk in the computer. Install Windows 2000 Server on the new hard disk. Re-create the shared folders on the first hard disk.

点击查看答案
第7题

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.

点击查看答案

You are the administrator of a SQL server 2000 computer that contains a database named Acct. The database contains 1.5 GB of data. The server has one 9-GB hard disk that is configured as shown in the Exhibit.You need to import data into the database witho

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容