上学吧考试云平台
题库首页计算机类微软认证网络工程师考试辅导微软认证70-228模拟试卷8

微软认证70-228模拟试卷8

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

试卷简介

题型:

  • 1.单选题
  • 2.多选题
会员专享

考点练习

快速练习

历年真题

试卷预览
1

You are the administrator of a SQL Server 2000 computer. The server contains a database named sales. Your company uses the database to store the sales department’s responses to requests for price quotations. The database is configured as shown in the exhibit.

Developers in your company create an application used for saving quotations. The application executes the following transact-SQL statement:

UPDATE QuotationSummary

SET CustomerName = ‘Jean-Paul Deloria’

WHERE QuotationID = 12

When the application executes the statement, the developers receive the following error:

Server: Mrh4403, Level 16, Stats 1, Line 1

View or function ‘QuotationSummary’ is not updateable because it contains aggregates:

You want developers to be able to use this UPDATE statement without generating errors. What should you do?

A.Create an INSTEAD OF trigger on the view to update the composite tables.

B.Grant the developers UPDATE permissions on each base table.

C.Add a cascading update trigger on each base table.

D.Create a QuotationSummary table and populate the table with data from the base tables.

2

You are the administrator of SQL Server 2000 computer. The server contains a database named Inventory. The database has a set of tables that track the location of parts. The tables are configured as shown in the Database Schema exhibit.

You examine the indexes in the PartsLocations table. The indexes are configured as shown in the Indexes exhibit.

You also examine the contiguity of the PK_partsLocations index and receive the following results:

DBCC SHOWCONTIG scanning 'PartsLocations' table...

Table: 'PartsLocations' (1); index ID: 1, database ID: 6

TABLE level scan performed.

- Pages Scanned................................: 3000

- Extents Scanned..............................: 750

- Extent Switches..............................: 502

- Avg. Pages per Extent........................: 4.0

- Scan Density [Best Count:Actual Count].......: 33.33% [1:3]

- Logical Scan Fragmentation...................: 33.33%

- Extent Scan Fragmentation....................: 33.33%

- Avg. Bytes Free per Page.....................: 1166.0

- Avg. Page Density (full).....................: 85.77%

You need to improve the performance of the queries that join this table to the Parts table and the Locations table. What should you do?

A.Re-create the PK_PartsLocations index as a clustered index.

B.Re-create the IX_PartsLocations_PartsID as a clustered index.

C.Re-create the IX_PartsLocations_LocationId as a clustered index.

D.Re-create the PK_PartsLocations index as a nonclustered index.

3

You are the administrator of a SQL Server 2000 computer. The server contains a database that is heavily indexed and that company users query extensively. The database has grown and query response time has slowed. The database is stored in a single data file.

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

A.On a new hard disk, create a new filegroup. Drop the existing nonclustered indexes, and then re-create them on the new filegroup.

B.On a new hard disk, add a new file to the PRIMARY filegroup. Drop the existing nonclustered indexes, and then re-create them on the PRIMARY filegroup.

C.On the existing hard disk, create a new filegroup. Drop the existing nonclustered indexes, and then re-create them on the new filegroup.

D.On the existing hard disk, add a new file to the primary filegroup. Drop the existing nonclustered indexes, and then re-create them on the PRIMARY filegroup.

4

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.

5

You are the administrator of a 12 SQL Server 2000 computers. These servers are located in company offices throughout the world.

You configure a multiserver job on the server in your company's New York City office. You configure this server as a master server, and designate the remaining 11 servers as target servers.

After the job completes successfully, you decide to set up a new SQL Server 2000 computer as the master server. The new server will be named JobMaster and the other 12 servers will be target servers.

You need to make the New York City server a target server instead of a master server. What should you do?

A.On the New York City server, defect all 11 target servers. On the JobMaster server, enlist the 12 servers as target servers.

B.On the JobMaster server, enlist all other servers as target servers.

C.On the New York City server enlist the JobMaster server as a target server. Transfer the multiserver jobs from the New York City server to the JobMaster server.

D.On the JobMaster server, enlist the New York City server as a target server. On the JobMaster server, enlist the other 11 servers as target servers. On the JobMaster server, defect the New York City server.

6

You are the administrator of a new Microsoft Windows 2000 Server computer named CPSRV1.

CPSRV1 is a member server in your company's Windows NT 4.0 domain, which is named CPDOMAIN. A separate Windows NT domain named CPUSERS contains all of your company's user accounts. A trust relationship exists between the CPDOMAIN domain and the CPUSERS domain.

You are installing SQL Server 2000 on CPSRV1.

You specify a service account for each SQL Server service as shown in the following table:

After the installation is complete, the MSSQLServer service and the SQLServerAgent service do not start. You need to configure the services to start without changing any security settings in either domain.

What should you do?

A.Configure the services to run under the local system account

B.Add CPSRV1 to the CPUSERS domain

C.Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the local administrators group on CPSRV1

D.Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the CPUSERS\Domain Admins groups.

E.Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the CPUSERS\Domain users groups.

7

Exhibit:

BULK INSERT Ezonexam.dbo.employees

FROM ‘tk\africe\fubar512.txt’

WITH DATAFILETYPE = ‘char’,

FIELD/TERMINATOR = ‘\t’,

ROWTERMINATOR = ‘\n,’

TABLOCK

You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer.

How should you improve the performance of the query in the exhibit above?

A. Extend the BULK INSERT statement with the BATCHSIZE option set it to equal to 5 percent of the number of rows to be loaded.

B. Extend the BULK INSERT statement with the BATCHSIZE option set it to equal to 10 percent of the number of rows to be loaded.

C. Extend the BULK INSERT statement with the ROWS_PER_BATCH option set it to equal to 5 percent of the number of rows to be loaded.

D. Extend the BULK INSERT statement with the ROWS_PER_BATCH option set it to equal to 10 percent of the number of rows to be loaded.

E. Insert a line before the BULK INSERT statement that drops the indexes for the customers table. Insert a line after the BULK INSERT statement that recreates the indexes for the customers table.

F. The TABLOCK option should be removed.

G. The ROWTERMINATOR line should be removed.

8

You are the administrator of Microsoft Windows 2000 computer. You are preparing to install SQL Server 2000 on the computer.

Your company contains a variety of client computers that will connect to the SQL server 2000 computer by using a specific Net-Library, as shown in the following table.

You need to allow the client computers to connect to the SQL Server 2000 computer. You also want to minimize the number of configuration changes required on the client computers.

Which three actions should you take? (Each correct answer presents part of the solution. Choose three)

A. Install SQL Server 2000 as a named instance.

B. Install SQL Server 2000 as the default instance.

C. Configure the new instance for Mixed Mode Authentication.

D. Configure the new instance for Windows Authentication.

E. Configure the server to use the Named Pipes, IPX/SPX, and TCP/IP Net-Libraries.

F. Configure the server to use the Multiprotocol Net-Library.

试卷评价(5条)

00****80   2013-07-12 22:31:02
考试内容好多都知道,但就是选不对,不知道为什么??
00****88   2013-04-04 04:43:14
我觉得试题质量不错,想知道试题怎么打印??
00****52   2012-12-26 09:55:26
没白来一趟
00****97   2012-12-09 06:47:19
好用,接近真题!选择题比较全面。
00****40   2012-11-19 11:01:31
还没考试,考完以后看命中率怎样才知道是否花得值。

其他考生还关注了这些

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

下载试卷

收藏试题

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

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