Free Oracle 1Z1-591 Exam Dumps Questions & Answers

When adding a new dimension to an existing logical table, what is the significance of the Logical Level setting in the Logical Table Source properties?

• A.  It creates a new session variable.
• B.  It creates a foreign key relationship.
• C.  It determines the actual value of the dimension.
• D.  It defines the granularity of the dimension.

Identify the two true statements about alias tables.

• A.  Alias tables are set up to create a copy of the data with a filter applied to it.
• B.  Alias tables are set up to include best practice naming conventions for physical table names.
• C.  Alias tables are set up to avoid triangular or circular joins.
• D.  Alias tables are set up to create another physical copy of the data.

When designing a Star Schema, which option does not apply?

• A.  Dimensional tables have one attribute primary key as Product_ID for products.
• B.  The fact has several foreign keys that are primary keys in the dimensional table
• C.  The facts are quantifiable.
• D.  Fact table is joined to the related dimensional tables.
• E.  Dimensional tables are normalized.

The customer is questioning the necessity to have a data warehouse in place. They want to run OBIEE against various transactional systems. Identify the two limitations.

• A.  Operational system might be overburdened with analytical requests resulting in had performance for transactional processes.
• B.  Business issues are depending on real-time data.
• C.  The BI server cannot integrate various sources in one metadata model.
• D.  Data quality issues might emerge, due to missing data cleansing.

Which option does not describe Aggregate tables?

• A.  Aggregate tables are created and stored on the BI Server.
• B.  Aggregate tables relieve bottlenecks and pre-calculate and store the data for better query response.
• C.  Aggregate tables increase query performance by pre-calculating frequently accessed measure aggregations.
• D.  Aggregate tables typically have fewer rows than the non aggregate tables and, therefore, processing should be quicker.