Q1. DSNs are set up for access to which data sources?
A. ODBC Data Sources
B. Oracle Data Sources
C. IBM Data Sources
D. Teradata Data Sources
Answer: A
Q2. What are the two ways to use the administration tool?
A. It can be used to manage user password.
B. The administration tool uses a set of wizards that support the design of calculations, expressions, dimensions, and so on.
C. It can be used for versioning of the rpd.
D. Administrator can use repository and session variables in a repository to streamline administrative tasks and dynamically modify metadata content to adjust to a changing data environment.
Answer: CD
Q3. Which two options are included in Oracle BI Server cache management techniques?
A. Using NQSConfig.ini to manually edit the parameters
B. Scheduling Server password
C. Maximum Number of Rows to Download to Excel
D. Inspecting the cache reports
E. Manage access to Subject Areas
Answer: AD
Q4. In the Oracle Data Warehouse Reference Architecture, which term is not a layer in the data warehouse?
A. Access and Performance Layer
B. Master Data Layer
C. Staging Data Layer
D. Presentation DataLayer
Answer: D
Q5. If you have a database with four aggregate tables, how should the repository be configured to take advantage of the aggregates?
A. By creating four new logical tables sources
B. By creating four new logical table sources and choosing each dimension's level of aggregationin the Content tab
C. By creatingfour new logical table sources and using the Fragmentation content to specify theaggregation levels
D. By creating four new logical table sources and using the "where" section of the Content tab to specify the aggregation levels
Answer: B
Q6. 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
Answer: D
Q7. 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.
Answer: AD
Q8. 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
Answer: BC
Q9. What is the first step when creating an Aggregate table in the OBI repository?
A. Test the Aggregate table by using Analysis
B. Specify the Fact table that you want to aggregate
C. Use Job Manager to run the Aggregate script
D. Create a dedicated Connection Pool
Answer: B
Q10. 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 calledTime and then two subsequent folders called-> Fiscal Calendar and-> Julian Calendar
B. By creating aPresentationFolder called ->Timecalledthen two subsequent folders calledFiscal Calendar and Julian Calendar
C. By creatingaPresentation Foldercalled -Time and then two subsequent folders called + FiscalCalendar and+Julian Calendar
D. Bycreating a Presentation Foldercalled Time<parent> and thentwo subsequent folders called Fiscal Calendar<child> and Julian Calendar<child>
Answer: A