计算机类 - 微软认证

不定项选择题

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.

查看答案

不定项选择题

You are the administrator of a SQL Server 2000 computer. The server contains a database named sales. Your company uses the database to store the sales department’s responses to requests for price quotations. The database is configured as shown in the exhibit. Developers in your company create an application used for saving quotations. The application executes the following transact-SQL statement: UPDATE QuotationSummary SET CustomerName = ‘Jean-Paul Deloria’ WHERE QuotationID = 12 When the application executes the statement, the developers receive the following error: Server: Mrh4403, Level 16, Stats 1, Line 1 View or function ‘QuotationSummary’ is not updateable because it contains aggregates: You want developers to be able to use this UPDATE statement without generating errors. What should you do？

A. Create an INSTEAD OF trigger on the view to update the composite tables.
B. Grant the developers UPDATE permissions on each base table.
C. Add a cascading update trigger on each base table.
D. Create a QuotationSummary table and populate the table with data from the base tables.

查看答案

不定项选择题

You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. The database is configured as shown in the exhibit. In the last six months, the database has grown by 4 GB. Users report that query response time has slowed. The options set up on the database are shown in the Database Options exhibit. You want to accelerate query response time. What should you do？

A. Update the database statistics.
B. Add indexes to the foreign key fields.
C. Truncate the transaction log.
D. Run the database maintenance plan wizard.
E. Drop primary keys from all tables.

查看答案

不定项选择题

You are the administrator of a SQL Server 2000 computer. You create several jobs on the server and schedule them to run during the evening. You configure an operator on the server and configure the jobs to send an e-mail to this operator if a job fails for any reason. While testing the jobs, you discover that e-mail messages are not being sent to the operator when a job fails. You use SQL Server Enterprise Manager to confirm that SQL Mail is started. You need to ensure that e-mail messages are sent to the operator whenever a job fails. What should you do？

A. Configure SQLAgentMail to use a valid MAPI profile
B. Configure SQL Mail to use a mailbox that delegates permissions to the operator
C. Use the net send notification method to send the operator e-mail messages
D. Create a job that executes the xp_startmail stored procedure Configure the job to run whenever SQL Server 2000 starts

查看答案

不定项选择题

Your Windows 2000 Server computer has a 10-GB hard disk with two partitions: Drive C and drive D. Windows 2000 Server is installed on Drive D. Both partitions are formatted as NTFS. Your office experiences a power failure that causes your Windows 2000 Server computer to restart. When the computer is restarting, you receive the following error message "NTLDR is missing. Press any key to restart". What should you do？

A. Start the computer by using Windows 2000 Server computer CD-ROM and choose to repair the installation. Select the Recovery Console and copy the NTLDR file on the CD-ROM to the root of the system partition.
B. Start the computer in debugging mode. Copy the NTLDR file on the CD-ROM to the root of the system partition.
C. Start the computer by using the Windows 2000 bootable floppy disk. From a command prompt, run the sfc/scanboot command.
D. Start the computer by using a Windows 2000 bootable floppy disk. Run the File Signature Verification utility.

查看答案

不定项选择题

You are the administrator of a SQL Server 2000 computer. The server contains a database named Accounting. The data files are configured as shown in the exhibit. The database has grown to 7 GB. The server has no more available disk space. You need to make more disk space available in the accounting database without affecting system performance. What should you do？

A. Compress drive E.
B. Add a new hard disk to the server. Create a new file on the new hard disk as part of the PRIMARY filegroup.
C. Add a new hard disk to the server. Create a new file on the new hard disk as part of a new filegroup.
D. Map a network drive to the server. Create a new data file on the network drive as part of the PRIMARY filegroup.
E. Map a network drive on the server. Create a new data file on the network drive as part of a new filegroup.

查看答案

不定项选择题

You are the administrator of a SQL Server 2000 database. Using the default options configures the database. You drop indexes to facilitate a large import of data, and rebuild them after the import is complete. Users report that response times from a stored procedure have become slower. In the stored procedure, you examine the following code. CREATE PROCEDURE GetCustomer (@CustomerID Int ) AS SELECT FirstName, LastName, Address1, Address2, City, State, Zip, MAX(PurchaseDate) AS LastPurchase FROM Customers C JOIN Addresses A ON A.AddressID = C.AddressID JOIN Purchases P ON P.CustomerID = C.CustomerID WHERE C.CustomerID = @CustomerID GROUP BY FirstName, LastName, Address1, Address2, City, State, Zip You want to improve the performance of the procedure by using the least amount of administrative effort. What should you do？

A. Recompile the stored procedure.
B. Update the database statistics.
Check the consistency of the database and repair errors.
D. Create a view and modify the stored procedure to use the view.

查看答案

不定项选择题

You want to automate the installation process as much as possible, in the least possible amount of time. What should you do？

A. Run Makebt32.exe to create four installation startup disks and add the Unattend.txt file to the first disk. Instruct an employee at each office to start the installation by using these disks.
B. Create a Microsoft MS-DOS network boot disk that makes a connection to the network shared distribution folder and runs the winnt command with the /s and /u switches. Instruct an employee at each office to start the installation by using this disk.
Create a floppy disk that contains only the Unattend.txt file. Instruct an employee at each office to start the installation by using the Windows 2000 Server compact disc, with the floppy disk inserted.
D. Create a Windows 2000 folder on a hard disk. Copy the Windows 2000 Server compact disc to the folder. Add the Unattend.txt file to the folder. Copy the folder to a writeable CD. Instruct an employee at each office to start the installation by suing this CD.

查看答案

不定项选择题

You want to automate the installation process as much as possible in the least possible amount of time. What should you do？

A. Use Makebt32.exe to create four installation startup disks and add the SIF to the first disk. Instruct an employee at each office to start the installation by using these disks.
B. Create an MS-DOS boot disk that contains CD ROM drivers and the SIF and that runs the Winnt/S: D:\i386 command. Instruct an employee at each office to start the installation by using this disk.
Create a floppy disk that contains only the SIF. Instruct an employee at each office to start the installation by using the Windows 2000 Server CD-ROM, with the floppy disk inserted.
D. Create a Windows 2000 folder on a hard disk. Copy the Windows 2000 Server CD-ROM to the folder. Add the SIF to the folder. Copy the folder to a writable CD. Instruct an employee at each office to start the installation by using this CD.

查看答案

不定项选择题

You are the administrator of a SQL Server 2000 computer. You are creating a data transformation services package. As the first step in this process, you need to load data from text files into a database table. These text files contain data on new stores that join your franchise. The text files list the data columns in the following format StoreID, StoreName, Address, City, State, PostalCode, ManagerID, StoreTypeID, FacilityID. The destination table is configured as shown in the exhibit. You want to load the data into the table as quickly as possible. What should you do？

A. Use a Bulk Insert Task to read the data into a temporary table. Use an Execute SQL task to import the appropriate data into the destination table.
B. Create and edit a format file to select the columns you want to import. Use a Bulk Insert Task, and then specify the format file to import the appropriate data into the destination table.
C. Use a transform. data task to import the data. Use Microsoft ActiveX transformation scripts to write the appropriate data to the appropriate columns in the destination table.
D. Create and edit a format file to select the columns you want to import. Use a transform. data task, and then specify the format file to import the appropriate data into the destination table.

查看答案

You want to automate the installation process as much as possible, in the least possible amount of time.<br>What should you do？

You want to automate the installation process as much as possible in the least possible amount of time.<br>What should you do？