Statistics > EXAM > Summary Handbook Statistics Final Exam (CIS) Questions and Answers 2023 (All)
Summary Handbook Statistics Final Exam (CIS) Questions and Answers 2023
Document Content and Description Below
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 -A fact (in a fact table) corresponds to a physical observable event, and not to the demands of a particular report. (T/F) - -True -A _____________ provides the "who, what, where, when, why, and how" context surrounding a business process event. - -dimension -Data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure. (t/f) - -false -_____________ help to provide levels of aggregation for users wanting summary information in a data warehouse. - -Dimensional hierarchies -Which kind of data warehouse is [Show More]
Last updated: 2 years ago
Preview 1 out of 8 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$2.50
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Mar 31, 2023
Number of pages
8
Written in
Additional information
This document has been written for:
Uploaded
Mar 31, 2023
Downloads
0
Views
42
 – CHAMBERLAIN COLLEGE OF NURSING.png)
.png)
