|
发信人: reynolds(雷龙.DBA中) 整理人: reynolds(2002-04-02 12:37:13), 站内信件 |
| 21. 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. Answer: D Reason: 由于没有安装MAPI客户端，因此涉及到发送邮件的选项C被排除。至于AB两个选项，可以参看《联机帮助手册》使用SQL SERVER工具-用户界面参考-DTS设计器帮助-DTS包属性（日志记录选项卡），虽然记录了错误，但是管理员不会直接得到提示。 22. You are the administrator of a SQL Server 2000 computer. Your company purchased an accounting application from a vendor. The application stores its data in a database named Accounting on the server. The tables in this database contain columns that function as primary keys, but PRIMARY KEY and FOREIGN KEY constraints are not used. You need to replicate data from this database to another SQL Server computer. This server will use the replicated data to generate reports. Most reports will run each month, but the accounting department needs to have the ability to run reports at any time. Reports should be accurate through the last full working day. You cannot make any changes to the database, but you need to implement replication. Which two actions should you take? (Each correct answer presents part of the solution. Choose two) A. Implement merge replication. B. Implement snapshot replication. C. Implement transactional replication. D. Schedule replication to run continuously. E. Schedule replication to run during off-peak hours. Answer: B E Reason: 由于需要每天添加当日的工作资料，因此根据需求分析，合并复制是最佳的选择。至于选择低峰时间作业我就不用罗嗦了吧。 23. You are the administrator of a SQL Server 2000 computer named FABSQL2K01. You create a data transformation services package that contains definitions for two transform data tasks. The tasks get data from two text files named customers and sales. The DTS package is configured as shown below: See http://www.cheet-sheets.com/228/image5.jpg 
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 and the ‘Join transaction of present’ check box of both transform data tasks. You them 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. Answer: A Reason: 只有这个选项是存在的。编辑DTS包，选择包-属性-高级，缺省是选择的，确保完整性。 24. You are the administrator of a SQL Server 2000 computer. The server is a member of a Windows NT domain and is configured for Windows authentication. The server contains a database that stores contact information for public officials in your region. These officials need to access the database by means of the Internet by using the guest login. However, some users report that they cannot connect to the server by means of the Internet. You need to allow anyone access to the server by means of the Internet. What should you do? A. Assign the guest login a blank password. B. Delete the guest login and create a new login that is mapped to the guest domain user account. C. Create a database user named Anonymous and assign the user the appropriate database permissions. D. Configure the server for mixed mode authentication. Answer: D Reason: 通过Internet连接属于非Windows验证方式，所以... 25. You are the administrator of a SQL Server 2000 computer named corpsql. The server is a member of a Microsoft Windows NT domain named CORPDOMAIN. Corpsql is configured for Windows authentication and contains three databases named sales, finance, and research. Andrea is an administrative assistant in your company. She uses a suite of client/server applications to access all three databases on corpsql. Andrea transfers to a different department within your company and requires access only to the research database. Her former manager requests that you remove Sophia’s access to the sales and finance databases. You need to configure the appropriate permissions for Andrea. Which batch of transact-SQL statements should you execute? A. USE finance GO EXEC sp_revokedbaccess Andrea USE sales GO EXEC sp_revokedbaccess Andrea B. USE finance GO EXEC sp_revokedbaccess Andrea ‘db_denydatareader’, ‘Andrea’ USE sales GO EXEC sp_revokedbaccess Andrea ‘db_denydatareader’, ‘Andrea’ C. USE Master GO EXEC sp_droplogin ‘Copdomain\Andrea’ GO EXEC sp_droplogin ‘Copdomain\Andrea’ D. USE Finance GO EXEC sp_denylogin ‘Andrea’ USE sales GO EXEC sp_denylogin ‘Andrea’ Answer: A Reason: 纯粹语法问题，没有什么为什么。 ---- / <>< o /| / <>< (o / |/| ) ) <@ < ( O )( \ |\| <>< ) <>< () \| \ \ 每天在网易游水的鱼 |
|
[关闭][返回] |