计算机类 - 微软认证

不定项选择题

For the testing of each service pack, you plan to deploy the service pack to the support.IS.contoso.com domain and the support.IS.litware.com domain, but to no other domains. You plan to use a Group Policy to configure and administer the service pack package. You need to minimize the complexity and administration of the service pack package, and to minimize network traffic between the domains. You create a Microsoft Windows Installer package for the service pack. What should you do to configure the Group Policy？

A. Configure the Windows Installer package in a Group Policy for the litware.com and contoso.com domains
B. Configure the Windows Installer package in a Group Policy for the support.IS.litware.com and support.IS.contoso.com domains.
Configure two sites, with one tree in each site. Configure the Windows Installer package in a Group Policy for each site.
D. Configure one site that contains both trees. Configure the Windows Installer package in a Group Policy for the site.

查看答案

不定项选择题

The Windows 2000 Professional installation files reside on a server named Ezonexamsrv in a shared folder named W2Ksource. You place the installation files for the spreadsheet application in \\Ezonexamsrv\W2Ksource\i386\$OEMS$. You create an answer file named Acctanswer.txt and place it in \\Ezonexamsrv\W2Ksource. You map drive letter H: to \\Ezonexamsrv\W2Ksource and begin the installation on a test computer by running the winnt32 /s:H:\i386 /u:H:\acctanswer.text command. Windows 2000 Professional is installed successfully. However, the spreadsheet application is not installed. You want to ensure that the spreadsheet application is installed during the unattended installation. What should you do？

A. Run thewinnt /s:H:\i386 /u:H:\acctanswer.txtcommand instead of thewinnt32 /s:H:\i386 /u:H:\acctanswer.textcommand.
B. Move the spreadsheet application installation files to \\Ezonexamsrv\W2Ksource\i386, and then run thewinnt/s:H:\i386 /u:H:\acctanswer.txtcommand.
C. Edit the[Unattended]section of the answer file to contain the parameterOemPreinstall = Yes, and then run thewinnt32 /s:H:\i386/u:H:\acctanswer.txtcommand.
D. Rename Acctanswer.txt to Unattend.txt, and then run thewinnt32 /s:H:\i386 /u:H:\unattend.txtcommand.

查看答案

不定项选择题

You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. The database will store sales transactions. Retail locations must be able to add transactions to the database 24 hours a day every day. The server is configured as shown in the exhibit. You need to configure the data files and transaction log for the Sales database. What should you do？

A. Place the transaction log on physical disk 0 and the data file on the RAID-5 disk array.
B. Place the transaction log on the RAID-5 disk array and the data file on physical disk 0.
C. Place the transaction log and the data file on physical disk 0.
D. Place the transaction log and the data file on the RAID-5 disk array.

查看答案

不定项选择题

What should you do？

A. Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.
B. Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.
C. Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.
D. Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.

查看答案

不定项选择题

You are the administrator of a SQL server 2000 computer. The server contains a database named Inventory. Developers at your company upgrade an inventory tracking application. Users report that when they insert new information in the Locations table, the upgrade application returns the following error message ‘string or binary data would be truncated. The statement has been terminated.’ When you use SQL profiler to trace the activity of the application, you receive the results as shown in the trace exhibit. You examine the design of the locations table as shown in the table design exhibit. Table Schema You need to configure the database to support both versions of the application without affecting server performance. What should you do？

Alter the data type of the description field to varchar(50).
B. Alter the data type of the Special field to varchar(50).
C. Alter the data type of the CubicFeet field to float.
D. In the locations table, create an INSTEAD OF trigger that truncates the description field at 10 characters when the record is updated.
E. In the locations table, create an INSTEAD OF trigger that truncates the Special field at 10 characters when the record is updated.

查看答案

不定项选择题

You want to configure the deployment of the most recent Windows 2000 Service pack so that users of the Windows 2000 Professional Computers receive the service pack automatically when they log on to the domain. What should you do？

A. Create a Microsoft Windows installer package for the service pack. Configure RIS to use the package.
B. Create a Microsoft Windows installer package for the service pack. Configure the package in a group policy.
Create a Microsoft Windows installer package for the service pack. Configure the package in the local computer policy.
D. Place the service pack in a distributed file system (Dfs).

查看答案

不定项选择题

You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. The database has a Parts table that has a field named InStock. When the parts have shipped, a table named PartsShipped is updated. When the parts are received, a table named PartsReceived is updated. The relationship of these tables is shown in the exhibit. You want the database to update the InStock field automatically. What should you do？

Add triggers to the PartsShipped and the PartsReceived tables that update the InStock field in the Parts table.
B. Create a user-defined function that calculates current inventory by running aggregate queries on the PartsShipped and PartsReceived tables.
C. Use a view that creates an InStock field as part of an aggregate query.
D. Create stored procedures for modifying the PartsShipped and PartsReceived tables that also modify the InStock field in the Parts table. Use these procedures exclusively when modifying data in the PartsShipped and PartsReceived tables.

查看答案

不定项选择题

You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. The database is configured as shown in the exhibit. Users frequently need details about parts. Users search for data by using the following query. SELECT Parts.SKU, Locations.Description, Manufacturer.Name, PartsLocations.Qty, PartsLocations.LastInventoried FROM Parts INNER JOIN Manufacturer ON Parts.ManufacturerID= Manufacturer.ManufacturerID INNER JOIN PartsLocation ON Parts.PartID = Parts.Location.PartsID INNER JOIN Locations ON Parts.LocationID= Locations.LocationID WHERE SKU？ You need to accelerate query response time. What should you do？

A. Create a parameterised stored procedure to retrieve the data.
B. Create a denormalized table that is maintained by triggers.
C. Use ad hoc queries to retrieve the data.
D. Create a nonclustered index on the primary key of each table.

查看答案

不定项选择题

You are the network administrator for Ezonexam. Your Windows 2000 Server computer named Ezonexam1 contains two 36-GB hard disks. Disk 0 and Disk 1. Each disk is configured as a basic disc and has a single 36-GB NTFS partition. Both partitions are backed up to a tape each night. The partition on Disk 1 stores user data. Most users at Ezonexam encrypt their files. Disk 1 fails. You replace it with a new hard disk and create a single NTFS partition. You need to recover the data as quickly as possible while maintaining the security of the files on Disk 1. What should you do？

A. Restore the contents of Disk 1 from the most recent tape backup to a second file server. Instruct users to copy their files from the second file server to the new partition.
B. Restore the contents of Disk 1 from the most recent tape backup to a second file server. Log on to Ezonexam1 console as a recovery agent. Copy the files from the second file server to the new partition.
C. Restore the contents of Disk 1 from the most recent tape backup to the new partition on Ezonexam1. Instruct the users to verify the integrity of their files.
D. Restore the contents of Disk 1 from the most recent tape backup to the new partition on Ezonexam1. Run the cipher command to decrypt the files.

查看答案

不定项选择题

You configure a Group Policy Object for the Marketing organizational unit (OU) to prevent users from accessing My Network Places and from running System in Control Panel. You want the Managers domain local group to be able to access My Network Places, but you still want to prevent them from running System in Control Panel. What should you do？

Add the managers group to the access control list of the GPO. Disable the permission of the managers group to read and apply the group policy.
B. Add the managers group to the access control list of the GPO. Deny the permission of the managers group to read and apply the group policy.
Create a second GPO in the OU. Add the managers group to the access control list. Allow the managers group to apply the group policy. Deny the authenticated users group permission to read and apply group policy. Configure the new GPO to deny the ability to run System in Control Panel. Give the original GPO a higher priority than the new GPO.
D. Create a second GPO in the OU. Add the managers group to the access control list. Allow the managers group to read and apply the group policy. Disable the permission of the authenticated user group to read and apply the group policy. Configure the new GPO to allow access to My Network Places. Give the new GPO a higher priority than the original GPO.

查看答案

What should you do？

You want to configure the deployment of the most recent Windows 2000 Service pack so that users of the Windows 2000 Professional Computers receive the service pack automatically when they log on to the domain.<br>What should you do？