Discussion
Home ‣ Database ‣ Data Warehousing Comments
- Question
A snowflake schema is which of the following types of tables?
Options- A. Fact
- B. Dimension
- C. Helper
- D. All of the above
- Correct Answer
- All of the above
- 1. Which of the following items are not necessary for client/server?
Options- A. Assure that tools will connect with middleware.
- B. Understand the requirements.
- C. Determine network bandwidth capabilities.
- D. Include the use of a file server. Discuss
- 2. Which of the following statements is true about symmetric multiprocessing?
Options- A. A single copy of the operating system resides in each processor.
- B. Useful for situations where data must remain in memory to process.
- C. Bottlenecks increase with uniprocessor systems because tasks are not shared.
- D. The problems of memory contention are unlikely. Discuss
- 3. Which of the following is true concerning QBE?
Options- A. An official standard has been defined for QBE.
- B. QBE cannot be used for client/server systems.
- C. QBE does not give the programmer a visual programming environment.
- D. Complete applications can be written using QBE. Discuss
- 4. Which of the following is true concerning the mainframe?
Options- A. It is the same thing as client/server.
- B. Requires someone to decide which code should be on the workstation or the server.
- C. Mission-critical systems have tended to remain there.
- D. All of the above. Discuss
- 5. Three-tier architecture includes which of the following?
Options- A. Three server layers
- B. A client layer and two server layers
- C. Two client layers and one server layer
- D. Three client layers Discuss
- 6. Fact tables are which of the following?
Options- A. Completely denoralized
- B. Partially denoralized
- C. Completely normalized
- D. Partially normalized Discuss
- 7. An operational system is which of the following?
Options- A. A system that is used to run the business in real time and is based on historical data.
- B. A system that is used to run the business in real time and is based on current data.
- C. A system that is used to support decision making and is based on current data.
- D. A system that is used to support decision making and is based on historical data. Discuss
- 8. The @active data warehouse architecture includes which of the following?
Options- A. At least one data mart
- B. Data that can extracted from numerous internal and external sources
- C. Near real-time updates
- D. All of the above. Discuss
- 9. A goal of data mining includes which of the following?
Options- A. To explain some observed event or condition
- B. To confirm that data exists
- C. To analyze data for expected relationships
- D. To create a new data warehouse Discuss
- 10. The extract process is which of the following?
Options- A. Capturing all of the data contained in various operational systems
- B. Capturing a subset of the data contained in various operational systems
- C. Capturing all of the data contained in various decision support systems
- D. Capturing a subset of the data contained in various decision support systems Discuss
Data Warehousing problems
Search Results
Correct Answer: Include the use of a file server.
Correct Answer: Useful for situations where data must remain in memory to process.
Correct Answer: Complete applications can be written using QBE.
Correct Answer: Mission-critical systems have tended to remain there.
Correct Answer: A client layer and two server layers
Correct Answer: Completely normalized
Correct Answer: A system that is used to run the business in real time and is based on current data.
Correct Answer: All of the above.
Correct Answer: To explain some observed event or condition
Correct Answer: Capturing a subset of the data contained in various operational systems
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.