上学吧考试云平台
题库首页计算机类微软认证网络工程师考试辅导2017年微软认证网络工程师模拟试题及答案2

2017年微软认证网络工程师模拟试题及答案2

推荐等级:
  • 卷面总分:100分
  • 试卷类型:模拟试题
  • 测试费用:免费
  • 答案解析:有
  • 练习次数:17次
  • 作答时间:150分钟
  • 进入考试
  • 下载试卷
  • APP做题
  • 关注人数:1987

试卷简介

2017年微软认证网络工程师模拟试题及答案2,是针对微软认证考试中网络工程师的模拟试题。

题型:

  • 单选题
  • 多选题
会员专享

考点练习

快速练习

历年真题

试卷预览
1

You are the administrator of a SQL Server 2000 database. Using the default options configures the database. You drop indexes to facilitate a large import of data, and rebuild them after the import is complete.

Users report that response times from a stored procedure have become slower. In the stored procedure, you examine the following code.

CREATE PROCEDURE GetCustomer

( @CustomerID Int )

AS

SELECT FirstName, LastName, Address1, Address2, City,

State, Zip, MAX(PurchaseDate) AS LastPurchase

FROM Customers C

JOIN Addresses A ON A.AddressID = C.AddressID

JOIN Purchases P ON P.CustomerID = C.CustomerID

WHERE C.CustomerID = @CustomerID

GROUP BY FirstName, LastName, Address1, Address2, City, State, Zip

You want to improve the performance of the procedure by using the least amount of administrative effort. What should you do?

A.Recompile the stored procedure.

B.Update the database statistics.

C.Check the consistency of the database and repair errors.

D.Create a view and modify the stored procedure to use the view.

2

You are the administrator of your company's network. A user named Lilly prints dozens of documents daily from her Windows 2000 Professional computer. Lilly reports that she receives a dialog box announcing that each print job she sends has printed successfully.

Lilly's default printer is a shared printer that is connected to Windows 2000 Server computer. She wants to have this notification turned off because she prints so many documents.

What should you do?

A.In the server properties of the printer system folder, clear the Notify when remote documents are printed option.

B.In the server properties of the printers system folder, clear the Notify computer, not user, when remote documents are printed option.

C.In the default printer properties, select the Portstab, and clear the Enable bidirectional support option.

D.In the default printer properties, select the Advancedtab, and clear the Advanced printing features option.

3

Ezonexam.com's network consists of Windows 2000 Professional and UNIX client computers. You install a Windows 2000 Server computer on the network. All computers that are connected to the network use TCP/IP as their only network protocol.

Several laser print devices are attached to the UNIX computers. You want to enable the Windows 2000 Professional computers to print to these printers. You want to make the minimum number of configuration changes necessary to achieve this goal.

What should you do?

A.Install Simple TCP/IP services on the Windows 2000 Server computer. Configure printers on the Windows 2000 Server computer to print to the print device attached to the UNIX computers.

B.Install Print Services for UNIX on the Windows 2000 Server computer. Configure shared printers on the Windows 2000 Server computer. Configure the UNIX computers to print to these shared printers.

C.Disconnect the print devices from the UNIX computers and connect them to the Windows 2000 Server computer. Share the printers, and configure the Windows 2000 Professional computers and the UNIX computers to print to the shared printers.

D.On the Windows 2000 Server computer, configure shared printers that connect to the print devices attached to the UNIX computers. Configure the Windows 2000 Professional computers to print to the shared printers on the Windows 2000 Server computer.

4

You want to install Windows 2000 Professional on 30 PXE-compliant computers and 35 non-PXE-compliant computers. All 65 computers are included on the current hardware compatibility list (HCL). You create a RIS image. You load the image on the RIS server. You then start the 65 computers.

You find that the 30 PXE-Compliant computers can connect to the RIS server.

However, the 35 non-PXE-compliant computers fail to connect to the RIS server. What should you do?

A.Run Rbfg.exe to create a Non-PXE-compliant startup disk.

B.Run Riprep.exe to create a Non-PXE complaint startup disk.

C.Grant the Everyone group NTFS Read permission for the RIS image.

D.Grant the Administrators group NTFS Read permission for the RIS image.

5

You are the administrator of a Windows 2000 Server computer. A folder named HR-Data on the system partition of the server is shared on the network as HR-Data. The owner of the HR-Data folder is Administrators.

The shared permissions and NTFS permissions are shown in the following table.

Share permissions:

Everyone: FULL Control

NTFS permissions

Domain Admins: Read

Katrin: Full Control

Katrin creates a file in the HR-Data folder. She sets the NTFS permissions for the file to list only herself on the access control list, with Full Control permission. Katrin then leaves on vacation and cannot be contacted.

Later, you discover that the file contains sensitive information and must be removed from the server as soon as possible. You want to delete the file without modifying any of the permissions for other files in the HR-Data folder. You want your actions to have least possible impact on users who may be using other files in the HR-Data folder. You want to use the minimum amount of authority necessary to delete the file.

What should you do?

A.Grant yourself Full Control permission for only the HR-data folder and not its subobjects. Delete the file. Then remove Full Control permission for HR-Data folder.

B.Take ownership of the HR-Data folder. When prompted, take ownership of the existing files. Grant yourself Full Control permission for the file. Delete the file.

C.Take ownership of the file. Grant yourself Modify permission for the file. Delete the file.

D.Grant yourself Modify permission for the HR-Data folder and its subobjects. Delete the file. Then remove Modify permission for the HR-Data folder.

6

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.

7

Your network includes Windows 2000 Professional client computers, Windows NT Workstation 4.0 client computers, Windows 95 client computers and UNIX client computers. Users of the Windows operating systems send print jobs to shared printers on a Windows 2000 Server computer named PrintServ. The UNIX client computers support the LPR printing protocol.

You want to make the shared printers on PrintServ available to the UNIX computers. What should you do?

A.Configure each of the printers to use an LPR port.

B.Install Microsoft Print Services for UNIX on PrintServ.

C.Configure each of the printers to support TCP/IP printing.

D.Use the SRVANY utility from the Windows NT Resource Kit to run the LPR program as a service.

8

You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. The database is configured as shown in the exhibit.

In the last six months, the database has grown by 4 GB. Users report that query response time has slowed. The options set up on the database are shown in the Database Options exhibit.

You want to accelerate query response time. What should you do?

A.Update the database statistics.

B.Add indexes to the foreign key fields.

C.Truncate the transaction log.

D.Run the database maintenance plan wizard.

E.Drop primary keys from all tables.

9

You are the network administrator for Ezonexam.com. You configure a shared printer on a Windows 2000 Server computer. The printer connects to a Hewlett Packard JetDirect print device that uses DLC. This print device is on the same network segment as the server.

Six months later, you relocate the print device to a different network segment. Users report that they are able to send print jobs to the printer but that their print jobs no longer print.

You need to ensure that the printer and the print device are working properly. What should you do?

A.Configure the JetDirect print device to use DHCP.

B.Uninstall and reinstall the DLC protocol from the server.

C.Configure the printer and the JetDirect print device to use the LPR printing protocol.

D.Delete the printer. Re-create the printer by using DLC to connect to the JetDirect print device.

10

You are the administrator of a database that contains 64 lookup tables. These tables store static data that should not change. However, users report that some of this data is being changed. You need to prevent users from modifying the data.

You want to minimize changes to your security model and to your database applications. How should you modify the database?

A.Create a filegroup named LOOKUP. Move the lookup tables to this filegroup. Select the read only check box for the filegroup.

B.Create a database role named datamodifier. Grant SELECT permissions to the datamodifier role. Add all users to the role.

C.Deny INSERT, UPDATE, and DELETE permissions for all users. Create stored procedures that modify data in all tables except lookup tables. Require users to modify data through these stored procedures.

D.Create a view of the lookup tables. Use the view to allow users access to the lookup tables.

试卷评价(0条)

其他考生还关注了这些

扫码免费做题
联系客服
APP下载
手机验证
温馨提示:输入手机号码获取验证码,验证后即测试该试卷。
图文验证:看不清?点击更换 换一换
手机号码:

下载试卷

收藏试题

此试题已成功加入收藏夹!

关闭窗口查看我的收藏夹
下载试卷
广告
上学吧找答案神器,懒人考试必备神器