Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Oracle8I Building Efficient Databases

Authors: Jonathan Lewis

1st Edition

0201715848, 978-0201715842

More Books

Students also viewed these Databases questions

Question

How do Data Types perform data validation?

Answered: 1 week ago

Question

How does Referential Integrity work?

Answered: 1 week ago