|
发信人: reynolds(雷龙.DBA中) 整理人: reynolds(2002-02-21 11:25:28), 站内信件 |
| 51. You are the administrator of a SQL Server 2000 computer. You want to set up snapshot replication on the server. The server will serve as Publisher and Distributor for a minimum of 40 Subscribers. Currently, you want to publish 3GB of data, but the data is expected to grow over time. Subscribers will receive a new snapshot each month. You want to minimize the workload on the Publisher/Distributor. Which two actions should you take to configure snapshot replication? (Each correct answer presents part of the solution. Choose two)
A. Store the snapshot in the default folder on the Publisher / Distributor. B. Store the snapshot in an alternative folder on the Publisher / Distributor. C. Store the snapshot in a shared folder on a file server. D. Create pull subscriptions. E. Create push subscriptions. Answer: C D Reason: 分发不能采用默认的文件夹，因为默认的文件夹都是本地文件夹。大规模的分发应该采用拉模式，推模式适用于小规模的。 52. You are the administrator of a SQL Server 2000 computer named SQL1. You want to perform adhoc distribution queries against a database that is stored on a SQL Server 2000 computer named SQL2. SQL2 contains several databases, and each of these databases uses a different collation. You want to ensure that comparisons in distributed queries are evaluated correctly. You also want to minimize administrative overhead. How should you configure SQL1? A. Use the ALTER DATABASE statement to change the collation of the databases on SQL1. B. Add SQL2 as remote server. C. Add SQL2 as a linked server. Select the Use Remote Collation check box, and do not specify a collation name. D. Add SQL2 as a linked server. Select the Use Remote Collation check box, and specify a collation name. Repeat this process once for each database on SQL2. Answer: C Reason: 53. You are the administrator of a SQL Server 2000 computer in your company's HR department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit (exhibit not available). You want to create a text file that lists these data columns: FirstName, LastName, WorkPhone, PositionName, DepartmentName. You want to create the text file as quickly as possible. You do not expect to recreate 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. Answer: D Reason: 由于没有了Exhibit，不好判断，但是估计数据来自3各不同的表。 54. You are the administrator of several SQL Server 2000 computers. A data Transformation Services (DTS) package uses native OLE DB providers to transfer data between the servers. Connection details for the servers are specified in .udl files. The .udl files are frequently updated as connection details change. You want to distribute the DTS package as a file to developers in your company. You want to make sure connection details are available to developers who receive the DTS package. Which two tasks should you perform? (Each correct answer presents part of the solution. Choose two) A. Enable the ‘Always read properties from UDL file option’ in the Connection Properties dialog box. B. Disable the ‘Always read properties from UDL file option’ in the Connection Properties dialog box. C. Delete the .udl files and store connection details in the registry by using system data source names. D. Delete the .udl files, and store connection details in the registry by using user data source names. E. Make the .udl files available on a network share. Answer: A E Reason: ====================================================================== 总是从 UDL 文件读取属性 指定在运行时数据链接 (.udl) 文件中的包解析信息。如果不选择此复选框，则将连接字符串从 .udl 文件复制到包中，而不再引用该文件。以后只有通过直接编辑数据转换服务 (DTS) 包才能修改连接更改。 ====================================================================== 55. You are the administrator of a SQL Server 2000 computer named DataSvr. The server is a member of a Microsoft Windows NT domain named RESEARCH. Several users need access to the database stored on the server. These users all belong to a domain user group named domain scientists. They also belong to a local user group named Local Techs on the DataSvr computer. Your company will be hiring 30 new employees who will be added to the domain scientists group by domain administrators. These employees will also need access to DataSvr. You need to allow all of the appropriate users to access DataSvr. You also want to minimize the amount of time you have spend maintaining security on DataSvr. Which Transact-SQL statement would you execute? A. EXEC sp_grant login BUILTIN\Local Techs B. EXEC sp_grant login ‘Local Techs’ C. EXEC sp_grant login [Datasvr\Domain Scientists] D. EXEC sp_grant login [Research\Domain scientists] Answer: D Reason: 不要被C迷惑就好办了。 ---- / <>< o /| / <>< (o / |/| ) ) <@ < ( O )( \ |\| <>< ) <>< () \| \ \ 每天在网易游水的鱼 |
|
[关闭][返回] |