计算机类 - 微软认证

不定项选择题

You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. The Inventory database has a table named StorageLocations that stores the location of parts contained in your company's warehouses. The StorageLocations table is configured as shown in the exhibit. The LocationDescription field is usually described with a name 10 to 25 characters in length. The locations never store more than 100,000 units of any given part. You want to modify the table's schema to save space. You cannot lose any existing data. You want to do this by using the minimum amount of administrative time and server resources. Which Transact-SQL statement should you execute？

ALTER TABLE [dbo].[StorageLocations] ALTER COLUMN [UnitsStored] [int] NOT NULL
B. ALTER TABLE [dbo].[StorageLocations] [LocationDescription] [char] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
C. ALTER TABLE [dbo].[StorageLocations] ALTER COLUMN [UnitsStored] [smallint] NOT NULL
D. ALTER TABLE [dbo].[StorageLocations] [LocationDescription] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL

查看答案

不定项选择题

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. The server contains a Data Transformation Services (DTS) package that queries multiple databases and writes the results to a text file. You run this package by using a Microsoft Windows batch file. The batch file uses the dtsrun utility to execute the DTS package. You want to ensure that connection properties, such as login names and passwords, cannot be read or modified by users. Which two actions should you take？ (Each correct answer represents part of the solution. Choose two.)

A. Save the DTS package so that it has an owner password.
B. Save the DTS package so that it has a user password.
C. Encrypt the DTS package details in the command line of the dtsrun utility.
D. Store the DTS package in the Meta. Data Services repository.
E. Store the DTS package as a Microsoft Visual Basic file.

查看答案

不定项选择题

You are the administrator of Ezonexam.com's Windows 2000 network. Your computer is configured to use both Windows 2000 Professional and Windows NT Workstation 4.0 Service Pack 3. Your computer has three hard disks: Disk 0, Disk1, and Disk2. Windows NT Workstation 4.0 is installed on Disk 0. Windows 2000 Professional is installed on Disk1. You want to store your project files on Disk2. You configure Disk2 as a basic volume and format the volume as NTFS in Windows 2000 Professional. You then start Windows NT Workstation 4.0. You find that you cannot access your project files. You want to be able to access your project files when using either of the operating systems. What should you do？

A. Upgrade Windows NT Workstation 4.0 to Service Pack 4 or later.
B. Configure Disk 2 as a dynamic volume then format as an NTFS partition.
Configure Disk 2 to use Encrypting File System (EFS).
D. Configure Disk 2 as a basic volume and format the volume as FAT32.

查看答案

不定项选择题

You have stored confidential financial data in a shared folder named AccSecured on your Windows 2000 Professional computer. Your company hires an intern named Richard. You create a subfolder named intern, which Richard needs to access. You want to allow Richard access to the intern subfolder only. You create a user account named intern. You want to allow the intern user account the ability to update, create, and delete files within the intern folder. You need to prevent Richard from accessing any other files or folders within the AccSecured folder. What should you do？ (Choose all that apply)

A. Map a network drive to the AccSecured\intern folder from Richard's computer.
B. Map a network drive to the AccSecured shared folder from Richard's computer.
C. Allow the intern user account modify permissions on the intern subfolder.
D. Allow the intern user account traverse folder/execute file permission on the AccSecured folder.
E. Allow the intern user account list folder content permission on the AccSecured folder. Remove read extended attributes and read permissions.

查看答案

不定项选择题

You are a network administrator for Ezonexam.com's Windows 2000 network. Your network has 200 Windows 2000 Professional computers and 15 Windows 2000 Server computers. Users on the network save their work files in home folders on a network server. The NTFS partition that contains the home folders has Encrypting File System (EFS) enabled. A user named Jack Bauer leaves the company. You grant her manager the Full Control NTFS permission to Jack's home folder. When the manager attempts to open any of the files, she receives the following error message: "Access is denied." What should you do？

A. Use System File Checker (SFC) to decrypt the file.
B. Log on the network as the Recovery Agent. Decrypt the files for the manager.
C. Log on the network as the administrator. Use the cipher command to decrypt the files.
D. Log on the network as a member of the Backup Operators group. Decrypt the files for the manager.

查看答案

不定项选择题

Your company has two domains cohovineyard.com and westcoastsales.com. The company's intranet site is on a Windows 2000 Advanced Server computer named ServerA. ServerA is in the cohovineyard.com domain and is running Internet Information Services (IIS) and Microsoft Proxy Server 2.0 You want to configure the Windows 2000 Professional computers in the westcoastsales.com domain to access the intranet site. You want users to be able to connect to the intranet site by using the URL http://serverA rather than its fully qualified domain name. What should you do？

Add cohovineyard.com to the Domain Suffix Search Order on the computers.
B. Add westcoastsales.com to the Domain Suffix Search Order on the computers.
C. Add westcoastsales.com to the exceptions list in the proxy server settings on the computers.
D. Configure the proxy server settings on the computers to bypass the proxy server for intranet addresses.

查看答案

不定项选择题

What should you do before you continue the installation？

A. Remove the virus checker in Windows 98.
B. Disable the BIOS virus checker and restart the computer.
C. Run Fixmbr.Exe from the Windows 2000 Professional CD-ROM.
D. Modify the Boot.ini file to include a signature parameter on the ARC path of the system partition.

查看答案

不定项选择题

You want to move a folder named Sales under a folder named Corp on your computer. You want the files in the Sales folder to remain compressed after moving the folder. You want the files in the Corp folder to remain uncompressed. You want to ensure that the files are recoverable in case of any disk problems. You also want to move the files with the least amount of administrative effort. What should you do？

A. Copy the Sales folder to the Corp folder. Do nothing further.
Backup the Sales folder. Move the Sales folder to the Corp folder.
Compress the Corp folder. Then copy the Sales folder to the Corp folder.
D. Move the Sales folder to a second computer. Then move the Sales folder to the Corp folder.

查看答案

不定项选择题

You are the administrator of a SQL Server 2000 computer. One of the databases on the server contains a table named complaints. This table is used to store information about customer complaints. The customer service representatives in your company add and edit the information in the complaints table. They work with this table by using a number of client applications, including a web-based application and a Microsoft Windows 32-bit application. The customer service manager discovers that some customer complaints are marked as closed before they are resolved to the customer’s satisfaction. You need to notify the customer service manager whenever a complaint is marked as closed. You do not want to make any changes to the client applications. What should you do？

A. Create an UPDATE trigger that sends an e-mail message.
B. Create a stored procedure that sends an e-mail message. Use the stored procedures to make changes to the data.
Create a user-defined function that sends an e-mail message. Use the function to make changes to the data.
D. Create a rule that validates data entry. Bind the rule to the CompliantClosed column.

查看答案