Summary Handbook Statistics Final Exam (CIS) Questions and Answers 2023

OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items. (T/F) - -True -One way an operational data store differs from a data warehouse is the recency of their data. (T/F) - -True -Type 1 slowly changing dimensions are the type of changes that organizations will want to track. (T/F) - -False -You can simply overwrite existing data for type 1 slowly changing dimensions. (T/F) - -True -For this type of DW architecture, the data acquisition software (back-end) is separate from the data warehouse (or data mart) that contains the data & software. - -Three-tier architecture (dependent data marts) -_____________ describes the level of detail in a fact table determined by the intersection of all the components of the primary key, including all foreign keys and any other primary key element. - -grain -Data warehouses are subsets of data marts. (T/F) - -False -A _____________ is a numerical property that describes a quantitative aspect of a business event relevant to analysis. - -measure -A large storage location that can hold vast quantities of data (mostly unstructured) in its native/raw format for future/potential analytics consumption is referred to as a(n) - -data lake