Question: Considering business intelligence environments to retain historical data for a very long time, select an answer that is a design prototcol. A table containing operational

Considering business intelligence environments to retain historical data for a very long time, select an answer that is a design prototcol.

A table containing operational data activity that has become historical, is designed with attributes/columns that can be totaled for display on reported outcomes and ways to describe those facts.

Large databases have capability to retain millions of completed transactions imported from the operational databases for business applications, so, an OLAP tools can drill down to find detail to support a summary graphic.

A reasonable limit on number of dimension table to describe the transactions that have been imported is to have only five tables because a star has five points.

A star schema design is highly dependent on having a tool like MS Excel for generating graphical displays of financial data.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!