TESTED 03 Apr
1Z0-591 Online Practice Questions and Answers
The highest sales amount for this year is $10,000. If you create a rank measure for sales this year and display it on a report, the value will be________.
A. $10,000
B. 0
C. 1
D. Year
What are the two methodologies that are followed within an OBIEE implementation?
A. Do not use prototypes
B. Use an iterative approach
C. Start with a small model and then enhance the repository
D. Start with a big repository and trim it down with the requirements
WLS Embedded LDAP Server is managed by the Admin Server Console and supports which three options?
A. Creating and Maintaining Users
B. Authentication and Authorization
C. Basic Directory for storing user details
D. Subject area and row-level security, connection pool passwords
E. Application of Session Variables as Data Filters
Content that is saved in personal and shared folders can be browsed by using which view?
A. Catalog
B. Dashboard
C. New -> Analysis
D. Home
E. Favorites
Identify the two Object level security functions that are done on the repository by using the BI Admin tool.
A. Assign users to a web catalog group
B. Create a new repository group
C. Create a new user in the repository
D. Create a web catalog group
E. Define permissions for Dashboard
When designing a Star Schema, which option does not apply?
A. The facts are quantifiable.
B. The fact has several foreign keys that are primary keys in the dimensional table
C. Fact table is joined to the related dimensional tables.
D. Dimensional tables are normalized.
E. Dimensional tables have one attribute primary key as Product_ID for products.
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.
Oracle BI Server at a company is connected to Data Warehouse that is refreshed on a daily basis, the majority of users at the company log in to Oracle BI every Monday to generate the previous week's sales report. The BI Administrator schedules cache purge and cache seeding to improve report response times. How is this accomplished?
A. Every day before Data Warehouse refresh
B. Every day after Data Warehouse refresh
C. Every Monday early morning
D. Every Monday late night
Which option does not describe Aggregate tables?
A. Aggregate tables increase query performance by pre-calculating frequently accessed measure aggregations.
B. Aggregate tables relieve bottlenecks and pre-calculate and store the data for better query response.
C. Aggregate tables typically have fewer rows than the non aggregate tables and, therefore, processing should be quicker.
D. Aggregate tables are created and stored on the BI Server.
You run the Consistency Check and receive the warning: [39003] Missing functional dependency association for column: DIM_Offer_End_Date.CREATE_DT.
What would you check?
A. Whether the logical table source for this column has been disabled
B. Whether the columns creating CREATE_DT have been deleted
C. Whether there is a logical join between the DIM and FACT tables
D. Whether there is a physical join between the DIM and FACT tables
E. Whether there is a physical column mapped to the logical column
F. DIM_Offer_End_Date.CREATE_DT
Home | Contact Us | About Us | FAQ | Guarantee & Policy | Privacy & Policy | Terms & Conditions | How to buy
Copyright © 2025 pass4itsure.com. All Rights Reserved