[计算机类试卷]微软认证70-228模拟试卷5及答案与解析.doc
《[计算机类试卷]微软认证70-228模拟试卷5及答案与解析.doc》由会员分享,可在线阅读,更多相关《[计算机类试卷]微软认证70-228模拟试卷5及答案与解析.doc(12页珍藏版)》请在麦多课文档分享上搜索。
1、微软认证 70-228模拟试卷 5及答案与解析 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 th
2、e 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
3、 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
4、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 servers msdb database in an e-mail message to the adminis
5、trator 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
6、 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 tempo
7、rary 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 ne
8、w 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.
9、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 colla
10、tion 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 ALT
11、ER 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 compu
12、ter. The server contains your companys 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
13、) 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
14、 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,
15、PartsLocations.Qty, PartsLocations.LastInventoriedFROM PartsINNER JOIN Manufacturer ON Parts.ManufacturerID= Manufacturer.ManufacturerIDINNER JOIN PartsLocation ON Parts.PartID = Parts.Location.PartsIDINNER JOIN Locations ON Parts.LocationID= Locations.LocationIDWHERE SKU?You need to accelerate quer
16、y 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 admi
17、nistrator 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. - Inde
18、xes 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.
19、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) Mo
20、dify 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 adm
21、inistrator of a SQL Server 2000 computer in your companys 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, Last
22、Name, 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 t
23、ext 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) Crea
24、te 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 appropr
- 1.请仔细阅读文档,确保文档完整性,对于不预览、不比对内容而直接下载带来的问题本站不予受理。
- 2.下载的文档,不会出现我们的网址水印。
- 3、该文档所得收入(下载+内容+预览)归上传者、原创作者;如果您是本文档原作者,请点此认领!既往收益都归您。
下载文档到电脑,查找使用更方便
2000 积分 0人已下载
下载 | 加入VIP,交流精品资源 |
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 计算机 试卷 微软 认证 70228 模拟 答案 解析 DOC
