Oracle
1Z0-591 · Question #91
You do not have a physical time table in your database but would like to use the time series functions that OBIEE offers. What two options do you have?
Sign in or unlock 1Z0-591 to reveal the answer and full explanation for question #91. The question stem and answer options stay visible for context.
Modeling Time Series Data
Question
You do not have a physical time table in your database but would like to use the time series functions that OBIEE offers. What two options do you have?
Options
- ACreate a physical time table in your database.
- BCreate a Logical Table that is sourced from the time key in the fact table.
- CCreate an "Opaque View" in the physical layer that contains the time columns from the fact and map
- DCreate a Logical Table that is sourced from a time field in one of your dimension tables.
- ECreate a time table that is joined through a intervening Table so there is no foreign key relationship.
Unlock 1Z0-591 to see the answer
You've previewed enough free 1Z0-591 questions. Unlock 1Z0-591 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#time series#logical table source#time dimension#physical time table