Q1. Why is it necessary to join multiple source tables to a single dimension? 

A. Because transactional source systems are often denormalized 

B. Because transactional source systems are often normalized 

C. Because a single source table often contains all the dimensions needed 

D. Because the dimensions tables are built in the transactional systems 

View Answer

Q2. A customer frequently queries multiple dimension tables without a measure. What needs to be defined in the presentation layer? 

A. Logical Key 

B. ImplicitFact Column 

C. Alias 

D. Logical Column Name 

E. CustomDisplay Name 

View Answer

Q3. A customer has a requirement for rolling period calculations. What two additional steps will need to be done to enable this in the repository? 

A. Clicking the "Time" option in theLogical Dimension Dialog 

B. Designatingachronological key for every level of every dimension hierarchy 

C. Clicking the "Time" option in the LogicalTable Source Dialog 

D. Designating a chronological keyfor every logical column in the Logical Table Source 

E. Specifying a sort order in theLogicalTable dialog 

View Answer

Q4. When a customer wants to get sales numbers by day, how is data stored in the Star Schema, if the data is loaded nightly? 

A. The lowest level of aggregation 

B. The highest level of aggregation 

C. Multiple levels of aggregation 

D. Independently from aggregation level 

View Answer

Q5. 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 SessionVariables as Data Filters 

View Answer

Q6. A customer always wants Aggregate Table l to be looked at first to see if it can answer the query. What should be done to make sure this happens? 

A. Make AggregateTable 1 the first table in the list ofLogical TableSources. 

B. Do not map the logical levelin the Content tab. 

C. Set the Priority Group to 0. 

D. Setthe Priority Croup to5. 

View Answer

Q7. Where is Cache in OBIEE located? 

A. In relational database 

B. It is local disk-based. 

C. In dynamic aggregate 

D. In memory cache 

View Answer

Q8. You do not have a physical time table in your database but would like to use the time series functions that OBIEE offers. What two options do you have? 

A. Create a physical time table in your database. 

B. Create aLogical Table that is sourced fromthe time keyin the fact table. 

C. Create an "Opaque View" in the physicallayer that contains the time columns from the fact and map itinto your physical model. 

D. Create a LogicalTable that is sourced from a time field in one of your dimension tables. 

E. Createa time table that is joined through a intervening Table so there is no foreign keyrelationship. 

View Answer

Q9. Oracle BI Server cache setup information is configured by using Enterprise Manager Fusion Middleware control. Which component stores the configuration Information? 

A. NQSConfig.ini 

B. Cache table inOBIEErepository 

C. WebCatalogue 

D. Instanceconfig.xml 

View Answer

Q10. The three metadata layers are an important concept of the BI Server. Which statement is incorrect? 

A. The physical layer defines the objects and relationships that the OracleBIServer needs to writenative queries against each physical data source. 

B. Separating the logical of the application from the physical model provides the ability to federate multiple physical sources to the same logical object. 

C. The model and mapping layer define the business or logical model of the data. This layer determines the analytic behavior seen by users. 

D. Thepresentation layer defines the relationship thatis needed to create the DML. 

View Answer