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

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

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

试卷简介

题型:

  • 1.单选题
会员专享

考点练习

快速练习

历年真题

试卷预览
1

You are the administrator of a SQL Server 2000 computer. Each evening after business hours, you perform. database maintenance tasks. You create a Data Transformation Services package to populate the data warehouse. MAPI is not installed on the server.

You want to schedule the DTS package to run each night. You want to attend to other duties while the DTS package is executing. You also want to be notified if the DTS package fails.

What should you do?

A.Select the DTS packages log package execution to SQL server check box. Create a SQL server event alert to notify you if the package fails.

B.Select the DTS packages write completion status to event log check box. Create a SQL server event alert to notify you if the package fails.

C.Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the send mail task to notify you if the package fails.

D.Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the execute process task to execute a not send command that will notify you if the package fails.

2

server’s msdb database in an e-mail message to the administrator of another SQL Server computer.

You create a job that contains the following steps:

--Detach the msdb database

--Send the database to the administrator in an e-mail message

--Reattach the msdb database

You test the job, and it fails on the first step. You need to ensure that the msdb database is mailed to the administrator every night.

What should you do?

A.Ensure that the SQLServerAgent service is running under a user account that has database owner access to the msdb database

B.Delete the first and last steps in the job

C.Configure the job to back up the msdb database to a temporary file. Send the file to the administrator in an e-mail message

D.Insert a new job step before the first step. Configure the new step to terminate all processes that use the msdb database

3

You are the database administrator for an accounting company. You are installing SQL Server 2000 on a new Microsoft Windows 2000 Server computer. The computer will run two client/server database applications that your company has purchased. Each application uses a separate database.

During the installation, you specify SQL_Latin1_General_CP1_CI_AI as the default collation for the SQL server computer. After completing the installation, you discover that one of the new applications, named Financials, is sorting information incorrectly.

You contact the application vendor and discover that the Financials application requires the SQL_Latin1_CP437_BIN collation. You need to configure the correct collation for the applications without diminishing the performance of the SQL Server computer.

What should you do?

A.Rerun the SQL Server Setup and specify the SQL_Latin1_General_CP437_BIN collation.

B.Run the rebuildm utility and specify the SQL_Latin1_General_CP437_BIN collation.

C.Use the ALTER DATABASE statement to specify the SQL_Latin1_General_CP437_BIN collation for the Financials database.

D.Use the ALTER TABLE statement to specify the SQL_Latin1_General_CP437_BIN collation for each table in the Financials database.

4

You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.

Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.

What should you do?

A.Enable the torn page detection database option for each database.

B.Disable write caching on all disk controllers.

C.Ensure that write caching disk controllers have battery backups.

D.Create a database maintenance plan to check database integrity and make repairs each night.

5

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

Users frequently need details about parts. Users search for data by using the following query.

SELECT   Parts.SKU, Locations.Description, Manufacturer.Name,

       PartsLocations.Qty, PartsLocations.LastInventoried

FROM    Parts

INNER JOIN Manufacturer ON Parts.ManufacturerID=

       Manufacturer.ManufacturerID

INNER JOIN  PartsLocation ON Parts.PartID = Parts.Location.PartsID

INNER JOIN  Locations ON Parts.LocationID= Locations.LocationID

WHERE SKU?

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

A.Create a parameterised stored procedure to retrieve the data.

B.Create a denormalized table that is maintained by triggers.

C.Use ad hoc queries to retrieve the data.

D.Create a nonclustered index on the primary key of each table.

6

You are the administrator of a SQL Server 2000 computer. The server contains a database that stores inventory data. Another database administrator has created a number of scheduled jobs to maintain the inventory database. Each weeknight the following jobs occur.

-- A BULK INSERT job imports data at 10:00 P.M.

-- Indexes are rebuilt at 10:15 P.M.

-- Data integrity checks are performed at 10:30 P.M.

-- A differential backup is performed at 10:45 P.M.

-- A DBCC SHRINKDATABASE job runs at 11:00 P.M.

You notice that the final job often fails and returns the following error message: "Server Msg 3140, Level 16, State 3. Could not adjust the space allocation for file 'inventory_data'."

You need to ensure that the final job runs without errors. What should you do?

A.Create a new DBCC SHRINKFILE job to shrink the inventory_data file. Schedule the new job to run at the same time as the DBCC SHRINKDATABASE job.

B.Modify the DBCC SHRINKDATABASE job so that it uses DBCC SHRINKFILE statement to shrink each file individually.

C.Increase the time between the data integrity checks and the differential backup.

D.Increase the time between the differential backup and the DBCC SHRINKDATABASE job.

7

You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.

You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.

You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.

What should you do?

A.Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.

B.Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.

C.Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.

D.Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.

试卷评价(4条)

00****14   2014-01-15 14:08:38
慢慢做了,希望题目准啦!
00****14   2013-04-23 03:40:12
感觉不错,能指导我复习的方向
00****28   2013-01-14 08:52:24
大家做的情况怎么样啊?题是不是太难啦,分享一下啊
00****26   2012-12-29 09:54:26
没白来一趟

其他考生还关注了这些

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

下载试卷

收藏试题

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

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