1Z0-515 · Question #19
Your BI tool (for example, Oracle Business Intelligence Enterprise Edition Plus, Business Objects and Cognos) will be used to query an Oracle database that includes the Oracle OLAP Option. What does…
The correct answer is A. SQL. BI tool can use data from different data sources (Ms SQLS,ORACLE,DB2 and etc.) and should use more common approach to extract the data. Just SQL is more suitable in this case, moreover database optimizer automatically aware of cube if it has already been exists.
Question
Your BI tool (for example, Oracle Business Intelligence Enterprise Edition Plus, Business Objects and Cognos) will be used to query an Oracle database that includes the Oracle OLAP Option. What does tool generate in submitting queries that might include data stored in relational tables and OLAP cubes?
Options
- ASQL
- BPL/SQL
- CProprietary API code
- DSQL for relational and proprietary API code for OLAP
How the community answered
(37 responses)- A84% (31)
- B5% (2)
- C3% (1)
- D8% (3)
Explanation
BI tool can use data from different data sources (Ms SQLS,ORACLE,DB2 and etc.) and should use more common approach to extract the data. Just SQL is more suitable in this case, moreover database optimizer automatically aware of cube if it has already been exists.
Topics
Community Discussion
No community discussion yet for this question.