YouareaprofessionallevelSQLServer2005datab

You are a network administrator for your company. All servers run Windows Server 2003.You manage a server that functions as a file server. The data volume on the server is mirrored. Each physical diskis on a separate controller. One of the hard disks that contains the data volume fails. You discover that the failurewas caused by a faulty SCSI controller. You replace the SCSI controller.You need to restore the data volume to its previous state. You need to achieve this goal by using the minimumamount of administrative effort.What should you do?（）

A. Run the diskpart active command to activate the failed volume.

B. Convert both disks to basic disks, and then restore the data.

C. Break the mirror, and then re-create the mirror.

D. Select a disk in the mirror, and then reactivate the volume.

Youareadatabaseadministratorforyourcompany.Thecompanyusesavendorcompany’sapplicationthatisbasedonaproprietarydatabase.YouquerydatafromtheapplicationdatabaseandimportthedataintoaSQLServer2005database.TheapplicationvendorprovidesyouwithanewOLEDBdrivertobeusedwhenqueryingtheapplicationdatabase.CompanypolicyprohibitsconnectionsbetweentheSQLServerdatabaseandtheapplicationdatabase，exceptwhenqueryingthisdata.Youneedtoprovideawaytoquerydatafromtheapplicationdatabase.

Whatshouldyou？（）

You are a network administrator for your company. The network contains a Windows Server 2003 computernamed Server4, which functions as a file server.Server4 contains several applications. One application is named App1. Another application is named App2. Usersreport that App2 is performing poorly. You examine Server4 and discover that App1 was started by using the startapp1 /realtime command.You need to ensure that no other application was started by using the /realtime switch.What should you do? （）

A. Use Performance Monitor to create a trace log. Trace Process creations/deletions.

B. Use Performance Monitor to create a trace log. Trace Thread creations/deletions.

C. Use Task Manager to view processes. View the Base Priority column.

D. Use Task Manager to view performance. On the View menu, select Show Kernel Times.

You are a network administrator for your company. All servers run Windows Server 2003. A server namedServer2 functions as a print server on the network.A high-speed color print device is attached to Server2. You configure a printer named ColorPrinter on Server2.Several other printers are also configured on Server2. The configuration of ColorPrinter is shown in the exhibit.(Click the Exhibit button.)Users in the marketing department report that when they print large files that contain multiple graphics, thedocuments print very slowly, pausing for several seconds between each page.You need to minimize the impact that large print jobs have on the performance of the printer. You need to achievethis goal by using the least administrative effort.What should you do?（）

A. Create a printer pool that includes an additional printer of the same type as ColorPrinter.

B. Add a second printer to Server2 that prints to the same print device as ColorPrinter. Instruct marketing users to submit large print jobs to one device and smaller print jobs to the other.

C. Configure ColorPrinter to start printing after the last page is spooled.

D. Increase the priority of ColorPrinter so that it is higher than all other printers.

You are the administrator of SQL Server computers. One server is named SQL7, and other is named SQL2000. SQL7 is running SQL Server 7.O and SQL2000 is running SQL Server 2000.

The net-libraries on SQL2000 are configured as shown in the exhibit.

SQL7 is configured so that it has the named pipes, TCP/IP, NWlink, IPX/SPX and multiprotocol Net Libraries.

SQL2000 and SQL7 exchange confidential company information. You need to ensure that unauthorized users cannot access this information.

Which two actions should you take? (Each correct answer presents part of the solution. Choose two)

A．On SQL2000, enable the multiprotocol net library.

B．On SQL2000, select the force protocol encryption check box.

C．On SQL7, select the force protocol encryption check box.

D．On SQL2000, install a secure sockets layer (SSL) encryption certificate.

E．On SQL2000 and SQL7, enable multiprotocol encryption.

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 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 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 server 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 data transformation services (DTS) package that imports and transforms the database 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 Microsoft ActiveX script. that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.

You are the administrator of SQL server 2000 computer. The server contains a database named MedicalRecords. Users access medical records by using the PatientID field. This field is the clustered primary key for the Patients table. When users try to access medical records, the database responds slowly. You examine the database options as shown in the exhibit.

You want to accelerate query response time and minimize administrative overhead. How should you reconfigure the database?

A．Create a SQL Server Agent job to execute the UPDATE STATISTICS statement, and schedule the job to run weekly.

B．Select the Auto Update Statistics check box.

C．Run the database maintenance plan wizard, and accept the default settings.

D．Rebuild the primary key as a nonclustered primary key.

E．Clear the Auto Create Statistics check box.

Your company network consists of a single Windows 2003 Active Directory domain.You are a member of the Domain Admins group. The network includes 10 member servers running Windows Server 2003 and 4 domain controllers running Windows Server 2003. The 200 client computers all run Windows XP Professional.The user accounts for employees in the Finance department are located in an Organisational Unit (OU) named Finance. The Finance OU also contains a Global Security group named FinanceUsers. All Finance employees are members of FinanceUsers.An employee named Alice works in the Finance department. Alice reports that she cannot log in the domain. She receives the error message shown in the exhibit:You need to enable Alice to log in to the domain.What should you do?（）

A. Use the dsmod user command line tool to enable Alice‘s user account.

B. Use Active Directory Users and Computers to add Alice‘s user account to the Domain Users group.

C. Use Active Directory Users and Computers to add Alice‘s user account to the Guests group.

D. Use the net accounts command line tool to enable Alice‘s user account.

E. Perform an authoritative restore of Alice‘s user account.

The last paragraph tells us that when you are absolutely scared,

A．you will work hard.

B．you may die and become a stone.

C．you cannot move at all.

D．you may want to find a stone.

You are administering a database stored in Automatic Storage management (ASM). The files are storedin the DATA disk group. You execute the following command:SQL >ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘+data.231.45678’;What is the result?（）

A. The file ‘+data.231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.

B. The file ‘+data.231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.

C. The file ‘+data.231.54769’ remains in the same location and a synonym ‘myfile.dbf‘ is created.

D. The file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+data.231.54769’ in the data dictionary removed.