Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Which of the following can be a definition of Data Warehouse? A. A huge Database of On-Line Transactions B. A read only database of recent
Which of the following can be a definition of Data Warehouse? A. A huge Database of On-Line Transactions B. A read only database of recent transactions C. A huge database of consolidated information (with historic data) that is stored separately from the Database that stores the companys business transaction. It is used for analysis (OLAP, Data Mining, e.g.). D. A read only historic database stored together with the OLTP database If we Have the following Fact Table: Sales [SalesID, Date, Time, ProductID, Quantity, SaleAmount] we can do which of the following queries? A. Queries involving individual sales B. Queries involving total daily sales per product C. Queries involving monthly sales per product D. All the queries above With the following fact table, which of the queries can be done ? Sales [Date, pid, WeeklySalesAmount,did] A. Tracking individual sales B. Tracking Weekly Sales C. Tracking Monthly Sales D. All of the above A periodic fact table and there is no business transaction is called? A. Centipede Fact Table B. Outrigger Dimension C. Stateless Fact Table D. All of the Above
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started