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

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

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

试卷简介

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

题型:

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

考点练习

快速练习

历年真题

试卷预览
1

One of the file servers in the domain is a Windows 2000 Server computer named Ezonexamfiles.

Ezonexamfiles contains a shared folder named Accounting, which is used to store data for the company's accounts payable department.

The permissions on the Accounting folder are configured as shown in the following table.

Mr. King is an employee in the operations department. He uses a Windows 2000 Professional client computer. His manager requests that King be granted access to the files in the Accounting folder.

You add King's user account to the AcctPay domain local group, but he still cannot access the files in the Accounting folder.

You need to ensure that King can access the files. What should you do?

A.Instruct King to log off his computer and log on again.

B.Move King's user account to the same Active Directory organizational unit (OU) as Ezonexamfiles.

C.Modify the NTFS permissions on the Accounting folder to grant King Full Control permissions.

D.Modify the NTFS permissions on the Accounting folder to grant the AcctPay domain local group Full Control permission.

2

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?

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

3

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.

4

You are the administrator of two Microsoft Windows 2000 advanced server computers. On these servers, you are configuring a database that will store accounting information for your company.

The data must be available at all times. Interruptions in data connectivity should not last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers.

How should you configure the database?

A.Configure the database on the two servers as a SQL Server 2000 cluster.

B.Configure the database on one server, and then configure a standby database on the second server.

C.Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized.

D.Configure the database as a federated database, and then partition half the data on each server.

5

Your Windows 2000 Professional computer contains a single hard disk configured as a single 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.

B.Backup the Sales folder. Move the Sales folder to the Corp folder.

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

6

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.

7

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.

8

You create two shared printers on a Windows 2000 Server computer in Ezonexam.com Ezonexam. One printer is shared as Admin, and the other printer is shared as Executive. Both printers are connected to the same print device. You set the priority of the Admin printer to 90 and the priority of the Executive printer to 50.

You want all users at the Ezonexam network to be able to send print jobs to either printer. However, you do not want the Executive printer to appear in the browse list when employees other than executives and administrative assistants create a new printer connection on their client computers.

What should you do?

A.Change the priority of the Executive printer to 99. Change the priority of the Admin printer to 10.

B.Change the share name of the Executive printer to Executive$. Manually reconfigure client computers that are already connected to the Executive printer.

C.Deny the Everyone group permission to access the Executive printer. Allow access to the users who are allowed to include the printer in their browse lists.

D.Install separate device drivers for the Executive printer. Configure NTFS permissions on the device driver files to allow access only to the System account and to users who are allowed to include the printer in their browse lists.

9

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.

10

You are the administrator of a Windows 2000 Server network. On each server, you format a separate system partition and a separate boot partition as NTFS.

Several months later, you shut down one of the servers for the maintenance. When you try to restart the server, you receive the following error message "NTLDR is missing. Press any key to restart".

You want to install a new NTLDR file on the server, but you do not want to lose any settings you made since the original installation. What should you do?

A.Start the computer by using the Windows 2000 Server CD-ROM and choose to repair the installation. Select the Recovery Console and copy the NTLDR file on the CD-ROM to the root of the system volume.

B.Start the computer by using the Windows 2000 Server CD-ROM and choose to reinstall. When installation is complete, copy the NTLDR file to the root of the boot volume.

C.Start the computer by using a Windows 2000 bootable floppy disk. From the command prompt, run the sfc/scanboot command.

D.Start the computer by using a Windows 2000 bootable floppy disk. Run the File Signature Verification utility.

试卷评价(0条)

其他考生还关注了这些

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

下载试卷

收藏试题

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

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