Sail E0 Webinar

MCQs

Total Questions : 30 | Page 3 of 3 pages
Question 21. Joining is the process of partitioning data according to predefined criteria.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 22. Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 23. Periodic data are data that are physically altered once added to the store.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 24. Data in the data warehouse are loaded and refreshed from operational systems.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 25. The role of the ETL process is to identify erroneous data and to fix them.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 26. Both status data and event data can be stored in a database.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 27. Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 28. Static extract is used for ongoing warehouse maintenance.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 29. Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 30. Every key used to join the fact table with a dimensional table should be a surrogate key.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True

Latest Videos

Latest Test Papers