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

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

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

试卷简介

题型:

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

考点练习

快速练习

历年真题

试卷预览
1

You are the administrator of a SQL Server 2000 computer. You create several jobs on the server and schedule them to run during the evening.

You configure an operator on the server and configure the jobs to send an e-mail to this operator if a job fails for any reason.

While testing the jobs, you discover that e-mail messages are not being sent to the operator when a job fails. You use SQL Server Enterprise Manager to confirm that SQL Mail is started.

You need to ensure that e-mail messages are sent to the operator whenever a job fails. What should you do?

A.Configure SQLAgentMail to use a valid MAPI profile

B.Configure SQL Mail to use a mailbox that delegates permissions to the operator

C.Use the net send notification method to send the operator e-mail messages

D.Create a job that executes the xp_startmail stored procedure Configure the job to run whenever SQL Server 2000 starts

2

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.

3

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.

4

Exhibit:

UPDATE EzonexamConsolidated

SET District = ‘Mexico’

WHERE RtvID = 45

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

When users run the query in the exhibit above the receive the following error message:

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

View or function ‘EzonexamConsolidated’ is not updateable because it

contains aggregates:

How should you enable the query to run?

A.Create a non-normalized EzonexamConsolidated table and populate the table with data from the base tables.

B.The appropriate users should be granted UPDATE permissions on each base table.

C.To enable updates on the composite tables create an INSTEAD OF trigger on the view.

D.On each base table add a cascading update trigger.

5

You are the administrator of a SQL server computer. The server is running SQL Server 6.5 and SQL Server 7.0.

You install a named instance of SQL Server 2000, and then run the SQL server upgrade wizard. On the database selection screen, some of the SQL Server 6.5 databases are not listed.

You cancel the SQL Server upgrade wizard.

You need to ensure that the SQL Server 6.5 databases are listed in the wizard. What should you do?

A.Uninstall SQL Server 7.0, and then rerun the SQL Server upgrade wizard.

B.Run the Microsoft SQL Server-switch application, and then rerun the SQL Server upgrade wizard.

C.Create a data transformation services package that imports the databases from SQL Server 6.5 to SQL Server 2000, and then execute the package.

D.Uninstall SQL Server 2000, and then reinstall SQL Server 2000 as the default instance.

6

You are the administrator of a SQL Server 2000 computer. The server contains a database that has the torn page detection database option enabled. Backups of the database are made daily.

The server loses power for one minute. When power is restored, torn pages are detected. You notice in SQL Server Enterprise Manager that the database is marked suspect.

You need to correct the problem. What should you do?

A.Execute the DBCC CHECKDB statement, and then specify the PHYSICAL_ONLY option.

B.Execute the DBCC CHECKDB statement, and then specify the REPAIR_REBUILD option.

C.Execute the sp_resetstatus stored procedure.

D.Restore the suspect database from backups.

7

You are the administrator of three SQL Server 2000 computers at Five Lakes Publishing. One server, FLPSQL01, stores order data. You want to be able to use the other two servers, FLPSQL02 and FLPSQL03, to answer queries and run report. The planned network configuration is shown in the exhibit.

You want to use the database Maintenance Plan wizard to configure log shipping from FLPSQL01 to FLPSQL02 and FLPSQL03. You do not want users to add any new data on FLPSQL02 and FLPSQL03, but they must be able to run queries and reports.

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

A.Set the database load state for each destination server to No recovery mode.

B.Set the database load state for each destination server to standby mode.

C.Enable the allow database to assume primary role option for both destination servers.

D.Enable the allow database to assume primary role option for one destination server and then disable this option for other destination server.

E.Disable the allow database to assume primary role option for both destination servers.

8

You are the administrator of a SQL Server 2000 computer. The server is configured as shown in the Database Server Configuration exhibit.

You need to create a new database named Inventory. Employees in your company will use the Inventory database to track inventory data. Users will require immediate responses to queries that help them locate where parts are stored. The tables in the database will be configured as shown in the Database Schema exhibit.

The database will consume 14 GB of disk space. You must configure the data files and transaction log to accelerate query response time.

Which two courses of action should you take? (Each correct answer represents part of the solution. Choose two.)

A. On drive C, create a transaction log.

 On drive D, create a data file in the PRIMARY filegroup.

 On drive E, create a data file in the SECONDARY filegroup.

B. On each drive, create a transaction log.

 On each drive, create a data file in the PRIMARY filegroup.

C. On drive D, create a transaction log.

 On drive E, create a data file in the PRIMARY filegroup.

D. On the PRIMARY filegroup, create all tables and all indexes.

E. On the PRIMARY filegroup, create all tables. On the SECONDARY filegroup, create all indexes.

F. On the PRIMARY filegroup, create the Parts table and its indexes.

 On the SECONDARY filegroup, create all other tables and their indexes.

试卷评价(5条)

00****15   2013-12-20 15:11:41
没有想象中的好~~~ 不过还行~~~
00****10   2013-04-18 00:32:03
多少分及格
00****35   2013-03-29 05:43:15
不错,较全面,深度不算深
00****97   2012-12-19 09:55:27
谢谢上学吧给我提供了电子书、试卷和其他资料,真心感谢
00****31   2012-12-03 10:57:29
挺好的,希望考试过关!!!

其他考生还关注了这些

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

下载试卷

收藏试题

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

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