| 1: | You are the chief database administrator for a large manufacturing company. You need to install Microsoft SQL Server 2000 Enterprise for test purposes and have moderate storage capabilities. Which of the following systems suits your needs without requiring you to perform any alterations? A. Pentium 133, 256MB RAM, IE 5 B. Pentium 200, 64MB RAM, IE 4 C. Pentium 400, 128MB RAM, IE 3 D. Pentium 400, 32MB RAM, IE 5
|
| A1: | Answer: B. To install SQL Server, you need a minimum of a Pentium 166, 64MB of RAM (though more is recommended), and Internet Explorer 4 or above. See the section "Installation Requirements" within SQL Server Books Online for more information. |
| 2: | You are the database administrator for a small private educational institution. You would like to use SQL Server 2000 as a gateway to various data sources that have been used for several applications. As a primary goal, you would like to get a copy of all data stored on the SQL Server 2000. What technologies could be used to solve this problem? (Select all that apply.) A. OLE-DB B. ANSI C. ISO D. ODBC E. Analysis Services F. SQL Profiler
|
| A2: | Answer: A, D. OLE-DB and ODBC are industry-standard technologies. They provide the standards for drivers that are supplied to allow data to be read from an underlying data source. ODBC (open database connectivity) is a mature interface supported by almost all database engines. OLE-DB is a set of driver APIs that has growing usage and allows for access to data in a generic form as well. See the section "Direct Execution" in SQL Server Books Online for more information. |
| 3: | A large shipping company uses a dual processor SQL Server to track load information for a fleet of transport vehicles that handle shipments throughout North America. The data being collected is shared with other vendors. This company requires a technology that will provide a data structure and formatting rules, and that will be easily transferable between applications. Which technology is best suited for this structure? A. HTML B. IIS C. XML D. Replication E. Triggers
|
| A3: | Answer: C. XML, now supported through a number of new features, provides a mechanism in which the data can be transmitted from one application to the other while maintaining the data structure and other formatting provided by XML schemas and style sheets. For more information, refer to the section "XML Support," earlier in this chapter. |
| 4: | You are working on a database implementation in a production environment. You would like to perform analysis on the server hosting the database. You need to get detailed information on the types of queries being performed and the locking effects of all operations. Which tool should you use? A. Query Analyzer B. SQL Profiler C. Books Online D. Analysis Manager E. Enterprise Manager
|
| A4: | Answer: B. To perform analysis of this type, you would use the Profiler to gather detailed server-wide information. The Query Analyzer is more appropriate to analyze and improve on the performance of singular queries, and the Analysis Manager is used to configure data warehousing. For more information see the section "Features of SQL Server 2000" within SQL Server Books Online. |
