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

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

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

试卷简介

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

题型:

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

考点练习

快速练习

历年真题

试卷预览
1

You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers.

You are also the administrator of Oracle relational database management system (RDBMS) server.

This server is used to store your company’s financial information. The financial information is updated frequently throughout the day.

You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.

You want to create reports on the SQL Server computer by using the minimum amount of disk space.

What should you do?

A.Set up SQL server replication to replicate the data from the oracle server to the SQL server computer.

B.Set up the oracle server as a linked server. Create a view that joins the service contract information and the financial information.

C.Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS package throughout the day as needed.

D.Set up Microsoft ActiveX script. that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.

2

You need to install Windows 2000 Professional on 35 new computers on the company LAN.

First, you create a distribution folder on the network server. Then you create a network boot disk to install Windows 2000 Professional from the distribution folder.

Now you need to create a batch file, which the network boot disk will execute to start the installation. You must specify a source path and temporary drive for the installation files.

You also need to install the accessibility options within the batch file. The batch file must execute a hardware-specific application to run after the GUI-mode Setup has completed.

Which command must you specify in the batch file?

A.Z:\i386\winnt /s:z:\i386 /t:d: /a /e:z:\hardware\setup.exe

B.Z:\i386\winnt /s:z:\i386 /rwinnt.tmp /a /e:z:\hardware\setup.exe

C.Z:\i386\winnt32 /s:z:\i386 /tempdrive:d /cmd:z\hardware\setup.exe

D.Z:\i386\winnt32 /s:z:\i386 /cmdcons:z:\hardware\setup /makelocalsource

3

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?

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

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

4

You are the administrator of a SQL Server 2000 computer. You are creating a data transformation services package. As the first step in this process, you need to load data from text files into a database table. These text files contain data on new stores that join your franchise. The text files list the data columns in the following format StoreID, StoreName, Address, City, State, PostalCode, ManagerID, StoreTypeID, FacilityID.

The destination table is configured as shown in the exhibit.

You want to load the data into the table as quickly as possible. What should you do?

A.Use a Bulk Insert Task to read the data into a temporary table. Use an Execute SQL task to import the appropriate data into the destination table.

B.Create and edit a format file to select the columns you want to import. Use a Bulk Insert Task, and then specify the format file to import the appropriate data into the destination table.

C.Use a transform. data task to import the data. Use Microsoft ActiveX transformation scripts to write the appropriate data to the appropriate columns in the destination table.

D.Create and edit a format file to select the columns you want to import. Use a transform. data task, and then specify the format file to import the appropriate data into the destination table.

5

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?

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

6

You are the administrator of a Windows 2000 Network for Ezonexam Inc. The network includes four Web servers named WWW1, WWW2, WWW3, and WWW4. Your network also includes a Windows 2000 Server computer that uses DNS.

Each Web server contains exactly the same content, and users accessing www.Ezonexam.com can be directed to any one of them.

You add records to your DNS server, as shown in the following table.

Record type Name IP address

CNAME www 192.168.10.5

CNAME www 192.168.10.6

CNAME www 192.168.10.7

CNAME www 192.168.10.8

When you examine the logs for the Web servers, you discover that all incoming traffic is being directed to 192.168.10.5, which is the IP address for WWW1.

You want the incoming traffic to be balanced across the four Web servers. What should you do?

A.Select the Disable recursion check box in the properties of the DNS server.

B.Enable round-robin in the properties of the DNS server.

C.Enable W3C logging in the properties of the Web servers.

D.Install and configure Network Load Balancing on WWW1.

7

You are the administrator of SQL Server 2000 computer named FABSQL2K01. You create a Data Transformation Services package that contains definition for two transform. data tasks.

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.

8

You need to create a web share on your Windows 2000 Professional computer named Admin01. You create a folder named reports. Then you configure web sharing on Reports. You name the share WebReports and allow Read permissions on the share.

You test the web share by pointing to http://admin01/WebReports from another computer. You receive the following error message, 'You are not authorized to view this page.'

You need to be able to access the folder. What must you do?

A.Allow write permission on WebReports.

B.Allow directory browsing permissions on WebReports.

C.In the IIS console, enable anonymous access to WebReports.

D.In the IIS console, set the execute permissions option to script. and executables on WebReports.

9

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.

10

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.

试卷评价(0条)

其他考生还关注了这些

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

下载试卷

收藏试题

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

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