Figuer: (Oracle) CREATE DIMENSION StoreDim

question 36

Multiple Choice

Figuer: (Oracle)
CREATE DIMENSION StoreDim
LEVEL StoreID IS Store. StoreID
LEVEL City IS Store. StoreCity
LEVEL State IS Store. StoreState
LEVEL Zap IS Store.StoreZip
LEVEL Nation IS Store. StoreNation
LEVEL DivID IS Division. DivID
HIERARCHY CityRollup (
StoreID CHILD OF
City CHILD OF
State CHILD OF
Nation )
HIERARCHY ZipRollup
StoreID CHILD OF
Zip CHILD OF
State CHILD OF
Nation )
HIERARCHY DivisionRollup (
StoreID CHILD OF
DivID
JOIN KEY Store.DivID REFERENCES DivID )
ATTRIBUTE DivID DETERMINES Division. DivName
ATTRIBUTE DivID DETERMINES Division. DivManager;
-The dimension StoreDim gets data from how many columns of the source table Store?

• A) 1
• B) 5
• C) 6
• D) None of the above

---

Definitions:

Cross-Rate

An exchange rate between two currencies derived from their respective exchange rates with a third, common currency.

Exchange Rate

The exchange rate is the value of one currency for the purpose of conversion to another, indicating how much of one currency can be exchanged for another currency.

Forward Exchange Rate

The forward exchange rate is the agreed-upon exchange rate for a currency pair to be traded on a future date, protecting against currency fluctuations.

Exchange Rate

How much one currency is valued when converted into another currency.