计算机类 - 微软认证

不定项选择题

One of the file servers in the domain is a Windows 2000 Server computer named Ezonexamfiles. Ezonexamfiles contains a shared folder named Accounting, which is used to store data for the company's accounts payable department. The permissions on the Accounting folder are configured as shown in the following table. Mr. King is an employee in the operations department. He uses a Windows 2000 Professional client computer. His manager requests that King be granted access to the files in the Accounting folder. You add King's user account to the AcctPay domain local group, but he still cannot access the files in the Accounting folder. You need to ensure that King can access the files. What should you do？

A. Instruct King to log off his computer and log on again.
B. Move King's user account to the same Active Directory organizational unit (OU) as Ezonexamfiles.
C. Modify the NTFS permissions on the Accounting folder to grant King Full Control permissions.
D. Modify the NTFS permissions on the Accounting folder to grant the AcctPay domain local group Full Control permission.

查看答案

不定项选择题

The tasks gets data from two text files named Customers and Sales. The DTS package is configured as shown in the exhibit. You do not want the DTS package to add any data to the server unless both transform. data tasks complete successfully. You select the use transactions check box of DTS package and the Join transaction of present check box of both transform. data tasks. You then select the fail package on step failure check box of both transform. data tasks. You want to use the DTS package to import data from the text files to the server. You want to ensure that changes are committed if all imported data is successfully transformed. What should you do？

A. Select the commit on successful completion check box of the DTS package.
B. Select the commit transaction on successful completion of this step check box of the customers transform. data task.
C. Select the commit transaction on successful completion of this step check box of the sales transform. data task.
D. Select the commit transaction on successful completion of this step check box of both transform. data tasks.

查看答案

不定项选择题

You configure a multiserver job on the server in your company's New York City office. You configure this server as a master server, and designate the remaining 11 servers as target servers. After the job completes successfully, you decide to set up a new SQL Server 2000 computer as the master server. The new server will be named JobMaster and the other 12 servers will be target servers. You need to make the New York City server a target server instead of a master server. What should you do？

A. On the New York City server, defect all 11 target servers. On the JobMaster server, enlist the 12 servers as target servers.
B. On the JobMaster server, enlist all other servers as target servers.
C. On the New York City server enlist the JobMaster server as a target server. Transfer the multiserver jobs from the New York City server to the JobMaster server.
D. On the JobMaster server, enlist the New York City server as a target server. On the JobMaster server, enlist the other 11 servers as target servers. On the JobMaster server, defect the New York City server.

查看答案

不定项选择题

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

查看答案

不定项选择题

You are the administrator of a SQL Server 2000 computer. The server contains a database that has the torn page detection database option enabled. Backups of the database are made daily. The server loses power for one minute. When power is restored, torn pages are detected. You notice in SQL Server Enterprise Manager that the database is marked suspect. You need to correct the problem. What should you do？

A. Execute the DBCC CHECKDB statement, and then specify the PHYSICAL_ONLY option.
B. Execute the DBCC CHECKDB statement, and then specify the REPAIR_REBUILD option.
C. Execute the sp_resetstatus stored procedure.
D. Restore the suspect database from backups.

查看答案

不定项选择题

You need to configure the IIS and SQL Server 2000 computers to allow access to data by means of the IIS virtual directory. IIS uses Basic Authentication to allow access to the virtual directory. Only company partners should have access to the SQL Server computer by means of the Internet. The partners should not be allowed to make ad hoc queries. You want to be able to audit successful and failed logins to the SQL Server computer. You want to allow the partners access to the SQL Server computer while keeping your security scheme as simple as possible. Which two actions should you take？ (Each correct answer represents part of the solution. Choose two.)

A. Configure the IIS virtual directory to allow URL queries.
B. Configure the IIS virtual directory to allow template queries.
Create a new Windows user account. Create a corresponding Windows Authenticated login on the SQL Server computer. Configure the IIS virtual directory to always use this login when connecting to the SQL Server computer.
D. Create a Windows Authenticated login on the SQL Server computer for the IIS Internet Guest Account. Configure the IIS virtual directory to always use the Internet Guest Account when connecting to the SQL Server computer.
E. Create a Windows Authenticated login for each company partner on the SQL Server computer. Configure the IIS virtual directory to use Windows Integrated Authentication when connecting to the SQL Server computer.

查看答案

不定项选择题

Company policy requires that bid information be removed permanently from the database one year after the bid closes. You need to comply with this policy and minimize server overhead. What should you do？

A. Create a Data Transformation Services (DTS) package to remove bids that have a closing data older than one year.
B. Create a trigger to delete any bids that have a closing data older than one year. Bind the trigger to the bids table for all INSERT, UPDATE, and DELETE events.
Create a stored procedure to delete any bids that have a closing data order than one year. Use SQL server agent to schedule the stored procedure to run every night.
D. Create a view that contains a WHERE clause to exclude bids that have a closing date older than one year.

查看答案

不定项选择题

You want to install the customized HAL designed for the computer. What should you do？

A. During the text mode portion of the Windows 2000 setup, install the customized HAL.
B. After the text mode portion of Windows 2000 Setup is complete, use the Recovery Console to copy the customized HAL to the system32 folder on the boot partition, and then continue Windows 2000 Setup
C. After the text mode portion of windows 2000 Setup is complete, use the Emergency Repair process to replace the existing HAL with the customized HAL, and then continue the windows 2000 Setup.
D. After the Windows 2000 Setup is complete, use Device Manager to scan for Hardware changes. When prompted, install the customized HAL.

查看答案

不定项选择题

You are the administrator of a SQL Server 2000 computer. The server contains a database that is heavily indexed and that company users query extensively. The database has grown and query response time has slowed. The database is stored in a single data file. You want to accelerate query response time. What should you do？

A. On a new hard disk, create a new filegroup. Drop the existing nonclustered indexes, and then re-create them on the new filegroup.
B. On a new hard disk, add a new file to the PRIMARY filegroup. Drop the existing nonclustered indexes, and then re-create them on the PRIMARY filegroup.
C. On the existing hard disk, create a new filegroup. Drop the existing nonclustered indexes, and then re-create them on the new filegroup.
D. On the existing hard disk, add a new file to the primary filegroup. Drop the existing nonclustered indexes, and then re-create them on the PRIMARY filegroup.

查看答案

不定项选择题

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.

查看答案

Company policy requires that bid information be removed permanently from the database one year after the bid closes. You need to comply with this policy and minimize server overhead.<br>What should you do？

You want to install the customized HAL designed for the computer. What should you do？

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.<br>What should you do？