1.
For which of the following is a data warehouse optimized?
- A.Backup and recovery
- B.Transactions
- C.Security
- D.Queries
- Answer
- Report
Answer : [D]
2.
Which of the following describes the age of the data in an OLTP system?
- A.Current
- B.Projected
- C.Historical
- D.Current and projected
- Answer
- Report
Answer : [A]
3.
Which of the following is a typical data warehouse query?
- A.What is this customers address?
- B.Does this customer have any unpaid bills?
- C.What is the balance in this customers account?
- D.What are the total sales for each of the last 6 months?
- Answer
- Report
Answer : [D]
4.
Which of the following is the main feature of an OLTP application?
- A.Summarized queries
- B.Granular transactions
- C.Voluminous historical data
- D.Heterogeneous data sources
- Answer
- Report
Answer : [B]
5.
Which of the following tools is used to view historical information about tasks, database changes, messages, and notifications?
- A.Journal
- B.Task Center
- C.Control Center
- D.Activity Monitor
- Answer
- Report
Answer : [A]
|
|
||||||||||||||||||||||||||||
