Oracle Essbase Presales Specialist Assessment

Oracle Essbase PreSales Specialist Assessment(Answer all questions in this section)1. Essbase structures data into natural business concepts in a multidimensional database. Mark for Review
(1) Points | True (*) |

| False |

| | Correct. Essbase structures data into natural business concepts in a multidimensional database. |
2. Essbase can support only two different business models. Mark for Review
(1) Points | True (*) |

| False |

| | Correct. Essbase can support many different business models. |
3. Communication between data sources and the metadata catalog with the middle and database tiers is done through which of the following? Mark for Review
(1) Points(Choose all correct answers) | OJBC |

| ODBC (*) |

| JDBC (*) |

| | Incorrect. Communication between data sources and the metadata catalog with the middle and database tiers is done through ODC and JDBC . |
4. According to companies surveyed in 2005 and 2007, BI tool standardization around a single vendor increased from ___ in 2005 to ____ in 2007. Mark for Review
(1) Points | 5% / 16% |

| 11% / 24% |

| 13% / 68% |

| 24% / 42% (*) |

| | Correct. According to companies surveyed in 2005 and 2007, BI tool standardization around a single vendor increased from 24% in 2005 to 42% in 2007. |
5. A Business Intelligence Competency Center (BICC) can be an important part of a BI business case regardless of business case type. Mark for Review
(1) Points | True (*) |

| False |

| | Incorrect. A Business Intelligence Competency Center (BICC) can be an important part of a BI business case regardless of business case type. |
6. Select a scenario where rules files are required for building a dimension. Mark for Review
(1) Points | Adding a single number to an existing hierarchy |

| Creating a simple time dimension with 17 members |

| Creating a dimension based on information that is stored in a relational