计算机类 - 微软认证

不定项选择题

You are the administrator of Ezonexam's network. You want to deploy a Windows 2000 Professional service pack to 10 computers in the Development organizational unit. You create a Windows 2000 installer package file for the service pack. You use the package file to successfully install the service pack to other computers in the domain. You assign the package file to the Development organizational unit. After the installation, you notice that the service pack was not installed on any of the 10 computers. You want to ensure that the service pack is successfully installed on the computers in the Development organizational unit. What should you do？

A. Use Computer Management to start the Windows installer service on all the computers in the Development organizational unit
B. Use the local administrator account to log on to the computers in the Development organizational unit. Then redeploy the service pack to the computers in the Development organizational unit.
C. Run Windows Installer to repair the package file. Then redeploy the service pack to the computers in the Development organizational unit.
D. Add the user accounts from the Development organizational unit to a DACL. Grant the user accounts read permission to the service pack deployment directory.

查看答案

不定项选择题

Mark has a local user account on a Windows 2000 Professional computer. Mark has rights to multiple files and folders on the computer. You want Eric to have the same rights and permissions that Mark has. You want to ensure that Mark will no longer have access to the files and folders. You want to accomplish this with least administrative effort. What should you do？

A. Rename Mark's user account to Eric and change the account password.
B. Create Eric's account by copying Mark's profile to Eric's account. Delete Mark's account.
Create Eric's account by copying Marks account. Delete Mark's account.
Delete Mark's account. Add Eric's account. Add Eric to the same groups to which Mark belonged. Grant Eric to all the individual user rights and permissions that Mark had.

查看答案

不定项选择题

You are the administrator of a Windows 2000 network. You need to store secured files for your company's accounting and legal departments on a Windows 2000 Professional computer. You want to accomplish the following goals: 1. Enable users in both departments to access their own files from the network 2. Enable users in the accounting department to view the legal accounting department's documents 3. Prevent users in the legal department from being able to view the accounting department's documents 4. Enable managers within the company to access and modify both the accounting and the legal department's files You take the following actions: 1. Create two shared folders named Accounting and Legal 2. Create three groups named Accounting, Legal, and Management 3. Allow the Accounting group modify permission on the Accounting folder 4. Allow the Legal group modify permission on the Legal folders. 5. Allow the Management group modify permission on both the Accounting and Legal folders. Which result or results do these actions produce？ (Choose all that apply)

A. Users in both departments can access to their own files from the network.
B. Users in the accounting department can view the legal department's documents.
C. Users in the legal department cannot view the accounting department's documents.
D. Company managers can access and modify both departments' files.

查看答案

不定项选择题

You are the desktop administrator for Ezonexam, Inc. The company's network contains an intranet Web farm, which consists of three Web servers. The Web servers are named Ezonexam1, Ezonexam2, and Ezonexam3. Users access the Web farm by using the URL http://team.Ezonexam.com. The relevant portion of the network is configured as shown in the exhibit. Jack is a user in the company operations department. Jack uses Internet Explorer on this Windows 2000 Professional computer to access files that are located on the Web farm. Jack reports that when he attempts to access a file named Schedule.xls by using the URL http://team.Ezonexam.com/ops/schedule.xls, Internet Explorer displays the following error message: "DNS error or server not found". The network administrator informs you that the company DNS server is unavailable. However, Jack needs to access the Schedule.xls file immediately. You need to ensure that King can access the file by using Internet Explorer on his computer. Which URL should you instruct King to use？

A. http://Ezonexam1/ops/schedule.xls
B. file://Ezonexam1/ops/schedule.xls
C. http://team.Ezonexam.com/ops$/schedule.xls
D. file://team.Ezonexam.com/ops/schedule.xls

查看答案

不定项选择题

First, you create a network distribution folder named InstallFiles. You copy the i386 folder from the Windows 2000 Professional CD to the InstallFiles folder. What should you do？

A. Copy the service pack files to the InstallFiles\Misc folder.
B. Copy the service pack files to the InstallFiles\$OEM$ folder.
C. From an existing client computer, run theUpdate -ucommand from the service pack to the InstallFiles folder.
D. From an existing client computer, run theUpdate -s:InstallFilescommand from the service pack to the InstallFiles folder.

查看答案

不定项选择题

You are the administrator of a SQL Server 2000 computer. The server contains a database named Customers, which is used by a custom client/server application. The database contains more than 1 million rows. Users report that the database responds slowly when they search for customers by using the application. Users search for customers by scrolling through an alphabetical list of customer names. You use SQL profiles to capture information about how the application uses the database. You receive results as shown in the following screen shot. You need to improve the application’s performance. What should you do？

A. Create additional nonclustered indexes on the CustomerInformation table.
B. Rewrite the application so that it uses a user-defined function to return the customer list.
C. Rewrite the application so that it uses a query with a WHERE clause to search for customer names.
D. Rewrite the application so that is uses a stored procedure to return the customer list.

查看答案

不定项选择题

You are the administrator of a SQL Server 2000 computer. The server contains a database named Contracts. The server is configured as shown in the server configuration exhibit. The database files are configured as shown in the database properties exhibit. The database developers have been creating new tables and indexes without specifying a filegroup. The primary filegroup is reaching its maximum capacity. You want the developers to continue adding new objects, but you do not want then to change the way they create objects. You do not want to run out of disk space. You also want to minimize the time it takes to administer the database. What should you do？

A. Back up the existing objects on the PRIMARY filegroup. Drop them from the database. Re-create them on the SECONDARY filegroup.
B. Set the file growth on the PRIMARY filegroup to UNLIMITED.
C. Set the PRIMARY filegroup so that it is read-only.
D. Set the SECONDARY filegroup as the default filegroup.

查看答案

不定项选择题

You are the administrator of a SQL Server 2000 computer. The server contains a database named sales. You need to change the way customer Ids appear in the Customers table. The database schema is shown in the exhibit. You need to automate the process of updating the primary key tools. You also want to minimize records locks and administration within the database during the update process. What should you do？

Add an ON UPDATE CASCADE constraint to the CustomerID field in the Customers table. Modify the values in the CustomerID field in the Customers table.
B. Create a duplicate record that has a new CustomerID value. Update the foreign key fields in the invoices, contacts, and quotes tables with the new value.
C. Disable the FOREIGN KEY constraints. Within a transaction, modify the values in the CustomerID field in the Customers table and all related foreign key values in the invoices, contacts, and quotes tables. Re-enable the FOREIGN KEY constraints after the keys are changed.
D. Create a Data Transformation Services package. Use the package to transform. the CustomerID value and the values of the related foreign keys in the invoices, contacts, and quotes tables.

查看答案

不定项选择题

You are the administrator of several SQL Server 2000 computers. A data Transformation Services (DTS) package uses native OLE DB providers to transfer data between the servers. Connection details for the servers are specified in .udl files. The .udl files are frequently updated as connection details change. You want to distribute the DTS package as a file to developers in your company. You want to make sure connection details are available to developers who receive the DTS package. Which two tasks should you perform？ (Each correct answer presents part of the solution. Choose two)

A. Enable the Always read properties from UDL file option in the Connection Properties dialog box.
B. Disable the Always read properties from UDL file option in the Connection Properties dialog box.
C. Delete the .udl files and store connection details in the registry by using system data source names.
Delete the .udl files, and store connection details in the registry by using user data source names.
E. Make the .udl files available on a network share.

查看答案

不定项选择题

BULK INSERT finance.dbo.customers FROM ‘di\bulk\accts143_10141000.txt’ WITH DATAFILETYPE = ‘char’, FIELD/TERMINATOR = ‘\t’, ROWTERMINATOR = ‘\n,’ TABLOCK You 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.

查看答案

First, you create a network distribution folder named InstallFiles. You copy the i386 folder from the Windows 2000 Professional CD to the InstallFiles folder.<br>What should you do？