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

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

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

试卷简介

题型:

  • 1.单选题
会员专享

考点练习

快速练习

历年真题

试卷预览
1

You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.

What should you do?

A.Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.

B.Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.

C.Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.

D.Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.

2

You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. The database has a Parts table that has a field named InStock.

When the parts have shipped, a table named PartsShipped is updated. When the parts are received, a table named PartsReceived is updated. The relationship of these tables is shown in the exhibit.

You want the database to update the InStock field automatically. What should you do?

A.Add triggers to the PartsShipped and the PartsReceived tables that update the InStock field in the Parts table.

B.Create a user-defined function that calculates current inventory by running aggregate queries on the PartsShipped and PartsReceived tables.

C.Use a view that creates an InStock field as part of an aggregate query.

D.Create stored procedures for modifying the PartsShipped and PartsReceived tables that also modify the InStock field in the Parts table. Use these procedures exclusively when modifying data in the PartsShipped and PartsReceived tables.

3

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.

4

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

The database has grown to 7 GB. The server has no more available disk space. You need to make more disk space available in the accounting database without affecting system performance.

What should you do?

A.Compress drive E.

B.Add a new hard disk to the server. Create a new file on the new hard disk as part of the PRIMARY filegroup.

C.Add a new hard disk to the server. Create a new file on the new hard disk as part of a new filegroup.

D.Map a network drive to the server. Create a new data file on the network drive as part of the PRIMARY filegroup.

E.Map a network drive on the server. Create a new data file on the network drive as part of a new filegroup.

5

You are the administrator of SQL server 2000 computer. The server contains a database named MedicalRecords. Users access medical records by using the PatientID field. This field is the clustered primary key for the Patients table. When users try to access medical records, the database responds slowly. You examine the database options as shown in the exhibit.

You want to accelerate query response time and minimize administrative overhead. How should you reconfigure the database?

A.Create a SQL Server Agent job to execute the UPDATE STATISTICS statement, and schedule the job to run weekly.

B.Select the Auto Update Statistics check box.

C.Run the database maintenance plan wizard, and accept the default settings.

D.Rebuild the primary key as a nonclustered primary key.

E.Clear the Auto Create Statistics check box.

6

You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation.

However, the existing SQL server computers in your office are configured to use the

SQL_Latin1_General_CP1_CI_AS collation.

You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort.

What should you do?

A.Use the rebuildm utility to rebuild the system database on an existing SQL server computer. Configure all the databases on that server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the server.

B.Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.

C.Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the named instance.

D.Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the new server.

7

You are the administrator of a SQL Server 2000 computer named SQL1. You want to perform. ad hoc distribution queries against a database that is stored on a SQL Server 2000 computer named SQL2. SQL2 contains several databases, and each of these databases uses a different collation.

You want to ensure that comparisons in distributed queries are evaluated correctly. You also want to minimize administrative overhead.

How should you configure SQL1?

A.Use the ALTER DATABASE statement to change the collation of the databases on SQL1.

B.Add SQL2 as remote server.

C.Add SQL2 as a linked server. Select the Use Remote Collation check box, and do not specify a collation name.

D.Add SQL2 as a linked server. Select the Use Remote Collation check box, and specify a collation name. Repeat this process once for each database on SQL2.

试卷评价(4条)

00****49   2013-06-19 09:54:26
客观题难度适中,还可以
00****16   2013-05-13 02:38:09
试题符合考试要求,还算满意
00****43   2013-03-12 05:46:17
哎,得个六十多分不容易啊
00****26   2013-02-03 07:50:22
谢谢上学吧,给了我这么多做题的机会,如果这次考试没过,下次我一定再来

其他考生还关注了这些

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

下载试卷

收藏试题

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

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