A star schema has what type of relationship between a dimension and fact table?
Answer: C
No answer description available for this question.
Enter details here
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
Answer: B
No answer description available for this question.
Enter details here
An operational system is which of the following?
Answer: B
No answer description available for this question.
Enter details here
Periodic data are data that are physically altered once added to the store.
Answer: B
No answer description available for this question.
Enter details here
Most operational systems are based on the use of transient data.
Answer: A
No answer description available for this question.
Enter details here
A data mart is designed to optimize the performance for well-defined and predicable uses.
Answer: A
No answer description available for this question.
Enter details here
The @active data warehouse architecture includes which of the following?
Answer: D
No answer description available for this question.
Enter details here
Independent data marts are often created because an organization focuses on a series of short-term business objectives.
Answer: A
No answer description available for this question.
Enter details here
Data in operational systems are typically fragmented and inconsistent.
Answer: A
No answer description available for this question.
Enter details here
Static extract is used for ongoing warehouse maintenance.
Answer: B
No answer description available for this question.
Enter details here