What are the two leading design solutions recommended by Oracle that you would use for performance?
Correct Answer: B,C
C: OBIEE Caching and Cache Seeding Cache is a component that improves performance by transparently storing data such that future requests for the same criteria can be served much faster. Like other application cache is not virtual memory in OBIEE. In OBIEE cache will be stored as files on the Hard Disk of the OBIEE Server in the form of files. By Default caching is enabled in the OBIEE server configuration. For time-consuming Dashboard Pages, we can use the concept of cache seeding in OBIEE, this can be configured as a scheduled job that will ensure that the data is cached and readily available as and when the user runs the dashboard.
Question 122
Derived metrics are_____.
Correct Answer: A
Question 123
A customer frequently queries multiple dimension tables without a measure. What needs to be defined in the presentation layer?
Correct Answer: B
Metadata Repository Builder's Guide http://download.oracle.com/docs/cd/E21764_01/bi.1111/e10540/toc.htm http://download.oracle.com/docs/cd/E21764_01/bi.1111/e10540.pdf Setting an Implicit Fact Column in the Subject Area For each subject area in the Presentation layer, you can set an implicit fact column. The implicit fact column is added to a query when it contains columns from two or more dimension tables and no measures. The column is not visible in the results. It is used to specify a default join path between dimension tables when there are several possible alternatives or contexts.
Question 124
Identify the correct mode to use when opening the web catalog while performing security settings modifications and migrations.
Correct Answer: A
Explanation/Reference: In online mode, you connect to a catalog on a running web server. In this mode your permissions are applied, you can select a locale, and you can see the effects of any localization on the catalog. You can see only those objects for which you have the appropriate permissions. Both Presentation Services and the web server must be running for you to open catalogs in online mode. Use online mode when you want to make minor incremental changes or additions to the catalog, such as changes to permissions, updates to a single object, or migration of new objects to a production environment. Note: * You can open a catalog in one of two modes - online or offline. Both modes can operate against an actual production catalog, with no need for any downtime. * Repository changes can be done in either online or offline mode. Online mode is when BI Server is actively reading the repository file (when a user is logged in). Offline is when BI Server is idle. Best practice is to develop in Offline mode. Minor changes can be made when in online mode. Incorrect answers: B: Use offline mode when you want to make catalog-wide changes, such as globally renaming objects or moving multiple objects for reorganization. In a clustered environment, use the following procedure to make systemwide changes to the catalog. C, D: No such modes.
Question 125
What is the process in which there is redundancy of data to improve performance?
Correct Answer: C
Explanation Denormalization is the process of intentionally backing away from normalization to improve performance by suppressing join and permitting the use of star transformation technique. Denormalization should not be the first choice for improving performance and should only be used for fine tuning of a database for a particular application.
