Chapter 5

Defining the Technical Architecture for a Solution

Review Questions

1. What are the elements of the Data Warehousing Framework?

OLAP Services, DTS, English Query, and Microsoft Repository

2. What is the difference between remote and linked servers?

Linked servers can perform distributed queries as well as remote stored procedures.

3. What are the three new kinds of join methods employed by SQL Server 7.0?

Merge, hash match, and hash match team

4. What role does the middle-tier server component play?

Creation of cubed data and providing data for multidimensional analysis

5. How does the English Query engine know how to process queries with nouns and verbs specific to your database?

You create a domain with a domain editor, and that information is used with the English Query.

6. True or false: Foreign key constraints create indexes automatically.

False. You must create them to support joins.