Want to pass your Oracle Business Intelligence Foundation Suite 11g Essentials 1Z0-591 exam in the very first attempt? Try Pass2lead! It is equally effective for both starters and IT professionals.
VCE
Identify the reason why Oracle OLAP provides a favorable aggregation strategy.
A. OLAP cubes eliminate the need for a large number of aggregate tables.
B. OLAP cubes are stored outside of the database in highly optimized file structures.
C. OLAP cubes can be easily transported from database to database.
D. OLAP cubes can be queried by using SQL.
When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard, which two statements are true?
A. The analyst must first write DML (Data Manipulation Language) scripts to create the aggregate table.
B. The Aggregate Persistence Wizard enables you to automate the creation of physical aggregate tables and their corresponding objects in the repository.
C. Job Manager can be used to run the Aggregate Persistence script.
D. The Extraction Transformation and Loading process creates the aggregate tables.
An organization would like to see a Time folder with subfolders for its Fiscal and Julian calendars. How would you accomplish this?
A. By creating Presentation Folder called Time and then two subsequent folders called -> Fiscal Calendar and -> Julian Calendar
B. By creating a Presentation Folder called ->Time called then two subsequent folders called Fiscal Calendar and Julian Calendar
C. By creating a Presentation Folder called -Time and then two subsequent folders called + Fiscal Calendar and + Julian Calendar
D. By creating a Presentation Folder called Time