1Z0-591 Online Practice Questions and Answers

Correct Answer: BC

Explanation: 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.

Correct Answer: C

Explanation: The Essbase cube looks just like any other relational star schema in my Presentation Layer, however when it is queried Oracle BI Server will issue MDX queries against a multi-dimensional data source, rather than an SQL query against a relational star schema.

Correct Answer: D

Correct Answer: B

Explanation: You can specify a Driving table parameter in a complex join.

Driving tables are for use in optimizing the manner in which the Oracle BI Server processes cross-database joins when one table is very small and the other table is very large.

The BI Server will query the driving table (the small one) and will get a list of values. The BI Server will then generate a second SQL using a parameterized IN list with the values from the first query.

Specifying driving tables leads to query optimization only when the number of rows being selected from the driving table is much smaller than the number of rows in the table to which it is being joined.

Correct Answer: ACD

Explanation: A: OBIEE Federated Repository

Instead of moving data in to a single database, OBIEE ?BI Administration can access multiple databases and create a single federated repository.OBIEE BI Answer uses this federated repository and build the ad-hoc reports and dashboards.

D: Repository Metadata Consists of 3 Layers

*

The Physical Layer (Schema)

*

The Business Model and Mapping Layer

*

The Presentation Layer

Note:

Correct Answer: B

1. Configure the new source table to have the 'logical level' under the content set to 'Countries' (the summarized level)

Explanation: B: Example:

b

2. Do the similiar setting for dimension table Now when user query the data at 'Counties' level, the query will be redirected to these summary table instead of the more detail fact table Note: Aggregate tables are Physical tables that store Aggregates of measures across multiple levels of a Hierarchy.

Correct Answer: C

Explanation: Priority group

You can set priority group numbers to determine which logical table source should be used for queries for which there is more than one logical table source that can satisfy the requested set of columns.

For example, you might have user queries that can be fulfilled by both a data warehouse and an OLTP source. Often, access to an operational system is "expensive," while access to a data warehouse is "cheap." In this situation, you can

assign a higher priority to the data warehouse to ensure that all queries are fulfilled by the data warehouse if possible.

Note that the priority group of a given logical table source does not always ensure that a particular query will be fulfilled by that source.

Priority Group Designation

0 the highest-priority source (the default) 1 a lowest-priority source

Correct Answer: A

Explanation: Aggregate Persistence Wizard automates the creation and initial population of aggregates, persists them in a back-end database and configures the BI Server metadata layer so that they're used when appropriate.

Correct Answer: A

Explanation: NQSConfig.ini is the main configuration file of Bi Server and contains a lot of parameters.

The parameters in the Query Result Cache Section provide configuration information for Oracle BI Server caching. The query cache is enabled by default. After deciding on a strategy for flushing outdated entries, you should configure the cache storage parameters in Fusion Middleware Control and in the NQSConfig.INI file.

Correct Answer: A

Explanation: Security Manager ?is used to setup users, groups, synchronize LDAP users and Groups, set access rights for Objects (tables, columns) and to control over when and what data a user can access.

Note: When you open the administration tool, you can reach the security manager by the Menu : Manage > Security