Microsoft 70-228 Real Exam Questions

February 22, 2011 admin Certification Vendors, MICROSOFT

Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition

Exam 70-228 became available in January 2001. This exam is scheduled to retire in March 2009.

1: You are the administrator of several SQL Server 2000 computers. You want to retrieve some information from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CP437_BIN collation. However, all existing SQL Server computers in your office are configured to use the SQL_Latin1_General_CP1_CI_AS collation.You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort.What should you do?
A.Use the rebuildm utility to rebuild the system databases on an existing SQL Server computer. Configure all the databases on that server to use the SQL_Latin1_General_CP437_BIN collation. Restore the inventory database to the server.
B.Restore the inventory database to an existing SQL Server computer. Accept the SQL_Latin1_General_CP437_BIN collation for that database.
C.Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CP437_BIN collation. Restore the inventory database to the named instance.
D.Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CP437_BIN collation. Restore the inventory database to the new server.
Correct Answers: B

2: You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and added to the database. You currently use the following BULK INSERT statement to add the account information.BULK INSERT finance.dbo.customersFROM ‘d:\bulk\accts143_10142000.txt’WITH DATAFILETYPE = ‘char’, FIELDTERMINATOR = ‘\t’, ROWTERMINATOR = ‘\n’, TABLOCKYou want to ensure that response times do not slow when new account information is added to the database. What should you do?
A.Drop the indexes for the Customers table before the data load, and then re-create the indexes after the data load is complete.
B.Remove the TABLOCK option from the BULK INSERT statement.
C.Add the BATCHSIZE option to the BULK INSERT statement, and then set the option equal to 10 percent of the number of rows to be loaded.
D.Add the ROWS_PER_BATCH option to the BULK INSERT statement, and then set the option equal to 10 percent of the number of rows to be loaded.
Correct Answers: B

3: You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. You perform full database backups every two days. You also run regular database consistency checks on the server. The most recent check of the Sales database returns the following message.CHECKDB found 0 allocation errors and 3 consistency errors in table ‘Orders’ (object ID 214575782).You want to correct the data integrity errors while minimizing the amount of data lost. What should you do?
A.Disconnect users from the Sales database. Enable the single user database option. Execute the DBCC CHECKTABLE statement for the Orders table, and specify the REPAIR_REBUILD option.
B.Disconnect users from the Sales database. Enable the dbo use only database option. Execute the DBCC CHECKALLOC statement for the Orders table, and specify the REPAIR_REBUILD option.
C.Disconnect users from the Sales database. Execute the RESTORE DATABASE statement for the Sales database.
D.Execute the DBCC CLEANTABLE statement for the Orders table.
E.Execute the sp_table_validation stored procedure for the Orders table.
Correct Answers: A

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 protect 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.
Correct Answers: C

5: You are the administrator of two SQL Server 2000 computers. Each server contains data for one of your company’s two regional divisions. Company employees currently use a single data entry application. Your company installs an additional data entry application on client computers.After the new application is installed, query response times slow. You want to monitor server traffic during business hours to help diagnose this problem.What should you do?
A.Run SQL Profiler, and create one trace to monitor both servers. Configure the trace to include data from the new data entry application only.
B.Run two instances of SQL Profiler, and create a trace to monitor each server. Configure the traces to include data from both data entry applications.
C.Run the sqldiag utility from a command prompt. Write diagnostic data to a text file.
D.Execute the sp_monitor stored procedure. Save the output to a text file.
Correct Answers: B

6: You are the administrator of three SQL Server 2000 computers at Five Lakes Publishing. One server, FLPSQL01, stores order data. You want to be able to use the other two servers, FLPSQL02 and FLPSQL03, to answer queries and run reports. The planned network configuration is shown in the exhibit. (Click the Exhibit button.)You want to use the Database Maintenance Plan Wizard to configure log shipping from FLPSQL01 to FLPSQL02 and FLPSQL03. You do not want users to add any new data on FLPSQL02 or FLPSQL03, but they must be able to run queries and reports.Which two actions should you take? (Each correct answer presents part of the solution. Choose two.)
A.Set the database load state for each destination server to No recovery mode.
B.Set the database load state for each destination server to Standby mode.
C.Enable the Allow database to assume primary role option for both destination servers.
D.Enable the Allow database to assume primary role option for one destination server, and then disable this option for the other destination server.
E.Disable the Allow database to assume primary role option for both destination servers.
Correct Answers: B E

7: You are the administrator of a Microsoft Windows NT Server 4.0 computer. The server is the PDC in your domain and also runs SQL Server 2000. The server has four processors and 1 GB of RAM.Your network consists of 500 client computers that are running Microsoft Windows Millennium Edition. Users report that when they log on in the morning their computers respond slowly and occasionally return error messages.You use System Monitor to monitor processor performance and RAM utilization. You discover that the % Total Time and % User Time counters average 90 percent and the % Privileged Time counter averages 20 percent. The Available Mbytes counter averages 800 MB. You need to improve server performance for user logons. What should you do?
A.Increase the physical RAM on the computer to 2 GB.
B.Increase the virtual RAM on the computer to 4 GB.
C.Configure SQL Server to use only processors 1, 2, and 3.
D.Configure SQL Server to use only processors 0, 1, and 2.
Correct Answers: C

8: You are the administrator of a SQL Server 2000 computer. You configure a set of alerts on the server to notify you whenever certain operations fail or encounter errors. The notifications are sent to your Microsoft Windows 2000 Professional computer by using the net send command.You successfully test the alerts. After several days, however, you stop receiving notifications when operations fail or encounter an error. You verify that the SQLServerAgent service is started.You need to make sure that you continue to receive alert notifications. What should you do?
A.Stop and restart the SQLServerAgent service.
B.Clear the application log on the SQL Server computer.
C.Clear the system log on your Windows 2000 Professional computer.
D.Install the SQL Server 2000 administrative tools on your Windows 2000 Professional computer.
Correct Answers: B

9: You are the administrator of a SQL Server 2000 computer. Each night, you need to send a copy of the server’s msdb database in an e-mail message to the administrator of another SQL Server computer.You create a job that contains the following steps.Detach the msdb database. Send the database to the administrator in an e-mail message. Reattach the msdb database. You test the job, and it fails on the first step. You need to ensure that the msdb database is mailed to the administrator every night.What should you do?
A.Ensure that the SQLServerAgent service is running under a user account that has database owner access to the msdb database.
B.Delete the first and last steps in the job.
C.Configure the job to back up the msdb database to a temporary file. Send the file to the administrator in an e-mail message.
D.Insert a new job step before the first step. Configure the new step to terminate all processes that use the msdb database.
Correct Answers: C

10: You are the administrator of a SQL Server 2000 computer. You create a job that performs several maintenance tasks on the server’s databases. You want the job to run whenever the server’s processor utilization falls below 5 percent.You create a new schedule for the job and specify the Start whenever the CPU(s) become idle option. After several days, you notice that the job has never executed although the server’s processor utilization has fallen below 5 percent several times. What should you do?
A.Modify SQL Server Agent properties and specify a smaller idle time.
B.Modify SQL Server Agent properties and specify a larger idle time.
C.Write a stored procedure that executes the job whenever the @@IDLE system variable is less than 5.
D.Write a stored procedure that executes the job whenever the @@IDLE system variable is greater than 1.
Correct Answers: A

Download | Password: certificatexam.com