|
发信人: reynolds(雷龙.DBA中) 整理人: reynolds(2002-02-25 18:10:11), 站内信件 |
| 66. You are the administrator of a SQL Server 2000 computer. The server contains a database named MedicalRecords. You have recently added a hard disk to the server and configured the database.
The database is configured as shown in the database schema below: See http://www.cheet-sheets.com/228/image10.jpg 
Each primary key is clustered. All foreign keys contain nonclustered indexes. You want to use the new hard disk to make the database respond more quickly to queries. What should you do? A. Re-create the Notes table on the SECONDARY filegroup. B. Re-create the nonclustered indexes on the SEONDARY filegroup. C. Re-create the Patients and Doctors tables and their indexes on the SECONDARY filegroup. D. Re-create the Cases and Notes tables and their indexes on the SECONDARY filegroup. Answer: B Reason: 和前面相同类型所描述的是一样的。 67. You are the administrator of a SQL Server 2000 computer at a bank’s headquarters. Customers can access their accounts from headquarters or from branch offices. The server at headquarters maintains a master copy of all account data for all customers. When a customer deposits or withdraws funds at a branch office, the customer’s new balance must be reflected on the computers at that office and at headquarters. You want to minimize latency between the headquarters and branch offices. You want to copy account data between the server at headquarters and the servers at the branch offices. What should you do? A. Implement merge replication. Use the DATETIME (Later Wins) conflict resolver. Schedule replication for off-peak hours. B. Implement transactional replication. Allow immediate-updating subscribers. Schedule replication to run continuously. C. Create a data transformation services package on the server at headquarters. Configure the DTS package to import new account data from each of the servers at the branch offices and write it to all other servers. Schedule the DTS package to run during off-peak hours. D. Add all branch office servers to the headquarters server as linked servers. Create a job on the headquarters server. Configure the job to query each linked server for new account data and write this data to the other servers. Schedule the job to run every three minutes. E. Configure log shipping between the headquarters server and the branch office servers. Configure the headquarters server as the primary server and the branch office servers as secondary servers. Schedule log backups and log shipping to run every 10 minutes. Answer: B Reason: 在低谷时候传送数据显然无法满足延迟最小的要求，A、C必须排除。D的方式显然不符合编程的逻辑，排除！E的方法并不适用于运行中的数据库，要知道分公司的数据库必须是Active的，而日志传送的方式显然不太适合这种业务模式。 68. You are the administrator of a SQL Server 2000 computer. You are creating a data transformation services package. As the first step in this process, you need to load data from text files into a database table. These text files contain data on new stores that join your franchise. The text files list the data columns in the following format: StoreID, storeName, address, city, state, postalCode, managerID, storeTypeID, facilityID. The destination table is configured as shown in the exhibit (exhibit not available). You want to load the data into the table as quickly as possible. What should you do? A. Use a Bulk Insert Task to read the data into a temporary table. Use an Execute SQL task to import the appropriate data into the destination table. B. Create and edit a format file to select the columns you want to import. Use a bulk insert task, and then specify the format file to import the appropriate data into the destination table. C. Use a transform data task to import the data. Use Microsoft ActiveX transformation scripts to write the appropriate data to the appropriate columns in the destination table. D. Create and edit a format file to select the columns you want to import. Use a transform data task, and then specify the format file to import the appropriate data into the destination table. Answer: B Reason: 没有Exhibit没法分析。 69. You are the administrator of an 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. Answer: B Reason: 6.5和2K是不能同时运行的，必须切换服务方可。 70. You are the administrator of a new Microsoft Windows 2000 Server computer named CPSRV1. CPSRV1 is a member server in your company's Windows NT 4.0 domain, which is named CPDOMAIN. A separate Windows NT domain named CPUSERS contains all of your company's user accounts. A trust relationship exists between the CPDOMAIN domain and the CPUSERS domain. You are installing SQL Server 2000 on CPSRV1. You specify a service account for each SQL Server service as shown in the following table: Service Service Account Account Type MSSQLServer CPUSERS\sqlsvr Domain Administrator SQLServerAgent CPUSERS\sqlagent Domain administrator After the installation is complete, the MSSQLServer service and the SQLServerAgent service do not start. You need to configure the services to start without changing any security settings in either domain. What should you do? A. Configure the services to run under the local system account B. Add CPSRV1 to the CPUSERS domainx C. Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the local administrators group on CPSRV1 D. Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the CPUSERS\Domain Admins groups. E. Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the CPUSERS\Domain users groups. Answer: C Reason: 讲真话搞不清楚为什么要这样设置，默认的设置不是很好吗？ ---- / <>< o /| / <>< (o / |/| ) ) <@ < ( O )( \ |\| <>< ) <>< () \| \ \ 每天在网易游水的鱼 |
|
[关闭][返回] |