Oracle Essbase Presales Specialist Assessment

Topics: Management, Database, Business process Pages: 28 (4460 words) Published: May 12, 2011
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 database (*)|

| Adding aliases to existing members of the outline|

| | Correct. Creating a dimension based on information that is stored in a relational database - is a scenario where rules files are required for building a dimension. | 7. What is a risk of a BI initiative led solely by the line of business? Mark for Review  (1) Points

| Tends to focus more on product selection rather than business needs.|

| Unlikely to achieve adequate ROI|

| May produce an ill-architected solution whose TCO explodes over time (*)|

| Likely to produce expansive technical solution that does not adequately solve any particular business problem.|

| | Incorrect. A BI initiative led solely by the line of business may produce an ill-architected solution whose TCO explodes over time. | 8. Operational excellence as management strategy focuses on cost, quality and speed. Mark for Review  (1) Points

| True (*)|

| False|

| | Correct. Operational excellence as management strategy focuses on cost, quality and speed. | 9. Essbase Studio features a built-in repository that enables you to store and reuse metadata clients and hierarchies in multiple cubes. Mark for Review  (1) Points

| True (*)|

| False|

| | Correct. Essbase Studio features a built - in repository that enables you to store and reuse metadata clients and hierarchies in multiple cubes. | 10. Select the calculation script command that is used in the default database calculation. Mark for Review  (1) Points

| CALC ALL (*)|

| CALC|

| CALC DIM|

| AGGREGATE|

| | Correct. CALC ALL is the calculation script that is used in the default database calculation. | 11. What is the price per processor for Essbase Visual Explorer? Mark for Review  (1) Points

| 184000|

| 86500 (*)|

| 800|

| | Incorrect. The price per processor for Essbase Visual Explorer is $ 86.500 | 12. BI implementations can hid underlying data quality issues. Customers...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Oracle Specialist Assessment Paper
  • Oracle GoldenGate: Sales Specialist Assessment Essay
  • Business Intelligence Applications Presales Specialist Assessment Essay
  • Essay on Oracle Business Intelligence Foundation 10.3.1 Sales Specialist Assessment
  • Oracle Sparc T4-Based Servers Sales Specialist Assessment Essay
  • Oracle Business Intelligence Foundation Sales Specialization Assessment Research Paper
  • Oracle EBS Essay
  • Oracle Essay

Become a StudyMode Member

Sign Up - It's Free