DBW 301 Final Exam | Verified with 100% Correct Answers
14 views 0 purchase
Course
DBW 301
Institution
DBW 301
DBW 301 Final Exam | Verified with 100% Correct Answers ..... table contains the values we want to analyze. A. Fact B. Dimension C. Aggregate D. Center ........ focus is on how managers view the business. A. Data warehouse B. OLTP C. Business system D. OLAP ......... reveals business trends. A. D...
..... table contains the values we want to analyze.
A. Fact
B. Dimension
C. Aggregate
D. Center
........ focus is on how managers view the business.
A. Data warehouse
B. OLTP
C. Business system
D. OLAP
......... reveals business trends.
A. Data warehouse
B. OLTP
C. Business system
D. OLAP
........... acts as the glue that connects all parts of the data warehouse.
A. Metadata
B. ETL
C. Operational Metadata
Extraction and Transformation Metadata
............ may answer questions on overall process.
A. OLTP
B. OLAP
C. Business Intelligence
D. Data warehouse
............ systems capture details of events or transactions.
A. OLTP
B. Data warehouse
C. OLAP
D. Business Intelligence
,............. indicator of high-quality data ensures that there are no missing values for a
given attribute in the system.
A. Accuracy
B. Domain Integrity
C. Data Type
D. Completeness
............. indicator of high-quality data ensures the data value of an attribute falls in the
range of allowable, defined values.
A. Accuracy
B. Domain Integrity
C. Data Type
D. Consistency
............. indicator of high-quality data ensures the form and content of a data field is the
same across multiple source systems.
A. Accuracy
B. Domain Integrity
C. Data Type
D. Consistency
............. indicator of high-quality data ensures the value stored in the system for a data
element is the right value for that occurrence of the data element.
A. Accuracy
B. Domain Integrity
C. Data Type
D. Consistency
............. indicator of high-quality data ensures value for a data attribute is actually
stored as the data type defined for that attribute.
A. Accuracy
B. Domain Integrity
C. Data Type
D. Consistency
............... signifies that the data warehouse stores the information around a particular
subject such as product, customer, sales etc.
A. Subject oriented
B. Integrated
, C. Time-Variant
D. Nonvolatile
................. means populating all the data warehouse tables for the very first time.
A. Initial load
B. Incremental load
C. Load all
D. Load
............................. are designed to overcome any limitations placed on the warehouse
by the nature of the relational data model.
A. Operational database
B. Relational database
C. Multidimensional database
D. Data repository
...............represents the level of detail in the fact table.
A. Data granularity
B. Aggregation
C. Data level
D. Data size
............systems focus on individual events.
A. Data warehouse
B. OLTP
C. Business system
D. OLAP
...........means applying ongoing changes as necessary in a periodic manner.
A. Incremental load
B. Updating load
C. Full refresh
D. Immediate load
A fact is a measure taken at the .............of all the dimensions.
A. intersection
B. union
C. combination
D. cross
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Jumuja. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $21.99. You're not tied to anything after your purchase.
