Top

Data Warehousing

21.

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

22.

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

Answer: B

No answer description available for this question.

Enter details here

24.

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

25.

Most operational systems are based on the use of transient data.

Answer: A

No answer description available for this question. 

Enter details here

26.

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

Answer: D

No answer description available for this question. 

Enter details here

28.

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

29.

Data in operational systems are typically fragmented and inconsistent.

Answer: A

No answer description available for this question.

Enter details here

30.

Static extract is used for ongoing warehouse maintenance.

Answer: B

No answer description available for this question.

Enter details here

Loading…
Tags: Data Warehousing Questions and Answers || Data Warehousing MCQ Questions and Answers || Data Warehousing GK Questions and Answers || Data Warehousing GK MCQ Questions || Data Warehousing Multiple Choice Questions and Answers || Data Warehousing GK || GK on Data Warehousing || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database