I85PREP
⌘ K
OBI study materials
OBI study resources

OBI practice questions

One question at a time. Build your OBI understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Oracle BI Architecture and Components

In Oracle BI Enterprise Edition, which server component is primarily responsible for generating and formatting the final presentation of a dashboard or report for the user?

  1. Oracle BI Server
  2. Oracle BI Presentation Services Correct answer.
  3. Oracle BI Cluster Controller
  4. Oracle BI Scheduler

Explanation

Presentation Services renders dashboards and reports, manages the catalog, and handles user interaction in the web interface. It requests logical SQL from the BI Server and formats the returned results for display.

Question 2Oracle BI Architecture and Components

Which Oracle BI component translates a logical SQL request into one or more physical SQL statements against underlying data sources?

  1. Oracle BI Server Correct answer.
  2. Oracle BI JavaHost
  3. Oracle BI Web Catalog Service
  4. Oracle BI Presentation Services

Explanation

The BI Server is the analytical engine that parses logical SQL, builds an execution plan, and generates optimized physical queries for each source. It then aggregates and combines the results before returning them to clients.

Question 3Oracle BI Architecture and Components

In the Oracle BI repository, which layer exposes business-friendly columns and measures to users and tools?

  1. Connection Pool layer
  2. Business Model and Mapping layer
  3. Physical layer
  4. Presentation layer Correct answer.

Explanation

The Presentation layer defines the columns and hierarchies that users see in Answers and dashboards. It sits above the Business Model and Mapping layer and simplifies the model for a business audience.

Question 4Oracle BI Architecture and Components

Which three layers make up the core structure of an Oracle BI repository?

  1. Metadata, Cache, Security
  2. Source, Staging, Target
  3. Ingest, Transform, Publish
  4. Physical, Business Model and Mapping, Presentation Correct answer.

Explanation

The repository is organized into Physical, Business Model and Mapping, and Presentation layers. Each layer serves a distinct purpose, from describing sources to exposing business views.

Question 5Oracle BI Architecture and Components

What is the primary function of the Oracle BI Scheduler?

  1. Caching physical query results
  2. Executing scheduled agents and delivering results to users Correct answer.
  3. Authenticating users against an LDAP directory
  4. Storing dashboard definitions in the catalog

Explanation

The Scheduler runs jobs at defined times, such as agents that evaluate conditions and deliver content. It works with the BI Server and delivery services to produce and distribute results.

Question 6Oracle BI Architecture and Components

Which Oracle BI component handles Java-based functions such as graphing and some map rendering?

  1. Oracle BI Presentation Services
  2. Oracle BI JavaHost Correct answer.
  3. Oracle BI Server
  4. Oracle BI Cluster Controller

Explanation

JavaHost provides a Java runtime for services that require Java, including graph generation. Presentation Services communicates with it when such features are requested.

Question 7Oracle BI Architecture and Components

What is the purpose of the Oracle BI Cluster Controller?

  1. To store repository metadata on disk
  2. To manage scheduled agent deliveries
  3. To coordinate multiple BI Server nodes in a clustered deployment Correct answer.
  4. To render dashboard pages for browsers

Explanation

The Cluster Controller tracks BI Server nodes, monitors their availability, and routes requests to active members. This provides scalability and failover for the analytical engine.

Question 8Oracle BI Architecture and Components

Which statement best describes the role of the Oracle BI web catalog?

  1. It records user authentication credentials for external providers
  2. It holds the in-memory cache of aggregated query results
  3. It stores the physical schema definitions used for query generation
  4. It stores objects such as dashboards, analyses, and folders that users create and share Correct answer.

Explanation

The web catalog is a file-based repository of presentation objects, including dashboards, analyses, and permissions. It preserves user-created content and folder structure across sessions.

Question 9Oracle BI Architecture and Components

An administrator wants the BI Server to reuse results of an identical logical query issued repeatedly within a short window. Which feature should be configured?

  1. Usage tracking
  2. Multiuser authentication
  3. Query result cache Correct answer.
  4. Session variable initialization block

Explanation

The query result cache stores results of previously executed queries so identical requests can be served without re-querying sources. Administrators tune cache settings and purging policies.

Question 10Oracle BI Architecture and Components

A repository developer needs to combine two source tables from different databases into one logical business model. Which capability of the BI Server enables this?

  1. Session variable substitution
  2. Presentation-layer column aliasing
  3. Federated query processing across multiple sources Correct answer.
  4. Static table replication into a single database

Explanation

The BI Server can generate physical queries against multiple sources and combine their results in a single logical request. This federation is a core architectural strength of the server.

Question 11Oracle BI Architecture and Components

Which repository layer contains logical dimension hierarchies and measures that are independent of physical source structures?

  1. Physical layer
  2. Business Model and Mapping layer Correct answer.
  3. Connection pool layer
  4. Presentation layer

Explanation

The Business Model and Mapping layer defines logical tables, dimensions, hierarchies, and measures mapped from physical sources. It abstracts source complexity so presentation objects can be built on logical structures.

Question 12Oracle BI Architecture and Components

A user reports that a dashboard shows stale numbers even though the source data was refreshed. Which architectural mechanism is the most likely cause?

  1. The web catalog losing folder permissions
  2. The Cluster Controller routing to an offline node
  3. Cached query results being served before the cache is purged Correct answer.
  4. The Scheduler failing to deliver an agent

Explanation

The BI Server cache can return earlier results until entries expire or are purged. Refreshing source data does not automatically invalidate cached results.

Question 13Oracle BI Architecture and Components

Which component issues logical SQL requests to the BI Server on behalf of a dashboard?

  1. Oracle BI JavaHost
  2. Oracle BI Scheduler
  3. Oracle BI Cluster Controller
  4. Oracle BI Presentation Services Correct answer.

Explanation

Presentation Services converts user actions into logical SQL and sends those requests to the BI Server. It then formats the returned result sets for dashboards and analyses.

Question 14Oracle BI Architecture and Components

A company wants to authenticate BI users against an external directory service while still managing BI-specific roles. Which architectural area governs this?

  1. The query cache settings
  2. The Cluster Controller configuration
  3. Security configuration in the BI Server and Presentation Services Correct answer.
  4. The Physical layer join definitions

Explanation

Security is configured across the BI Server and Presentation Services, including authentication providers and role-based permissions. External directory integration supplies authentication while BI roles control access.

Question 15Oracle BI Architecture and Components

What does an initialization block do in the Oracle BI architecture?

  1. Stores dashboard definitions in the catalog
  2. Renders graphs on dashboards
  3. Populates session or repository variables at runtime through a query or other source Correct answer.
  4. Defines the physical joins between source tables

Explanation

Initialization blocks run queries or other logic to assign values to session and repository variables. Those variables can then drive row-level security and dynamic content.

Question 16Oracle BI Architecture and Components

In a clustered Oracle BI deployment, what is the main benefit of the Cluster Controller?

  1. It distributes requests across BI Server nodes and supports failover Correct answer.
  2. It stores the repository file for all nodes
  3. It caches presentation objects for faster rendering
  4. It schedules agents across time zones

Explanation

The Cluster Controller monitors node health and routes client requests to available BI Server instances. This improves scalability and provides continuity if a node fails.

Question 17Oracle BI Architecture and Components

Which statement accurately distinguishes usage tracking from the query cache?

  1. Both store query results but differ only in retention
  2. Usage tracking logs query activity for later analysis, while the cache stores results for reuse Correct answer.
  3. Usage tracking stores results, while the cache logs activity
  4. Both log activity but differ only in file format

Explanation

Usage tracking records details about issued queries so administrators can analyze patterns and performance. The cache, by contrast, holds result sets to avoid repeated source queries.

Question 18Oracle BI Architecture and Components

A developer adds a new source table and wants it available to business users. In which order should the repository layers typically be built?

  1. Presentation, then Physical, then Business Model and Mapping
  2. Business Model and Mapping, then Presentation, then Physical
  3. Physical, then Presentation, then Business Model and Mapping
  4. Physical, then Business Model and Mapping, then Presentation Correct answer.

Explanation

Sources are imported into the Physical layer first, then mapped into logical business models, and finally exposed as presentation columns. This bottom-up flow keeps each layer consistent with the one beneath it.

Question 19Oracle BI Architecture and Components

Which component would you examine first if graph images on dashboards fail to render while tabular results display correctly?

  1. The query cache
  2. Oracle BI Scheduler
  3. The Cluster Controller
  4. Oracle BI JavaHost Correct answer.

Explanation

Graphs rely on Java-based services provided by JavaHost. If tables work but graphs fail, the Java rendering path is the most likely fault domain.

Question 20Oracle BI Architecture and Components

What is the primary role of connection pools in the Oracle BI repository?

  1. Storing dashboard permissions
  2. Scheduling agent executions
  3. Managing and reusing connections from the BI Server to a physical data source Correct answer.
  4. Defining logical dimension hierarchies

Explanation

Connection pools hold connection settings and manage how the BI Server connects to a source. They control parameters such as maximum connections and connection sharing.

Question 21Oracle BI Architecture and Components

A logical query joins a large fact table with a small dimension. The BI Server decides to push the join to the source database rather than joining in memory. What does this illustrate?

  1. Role resolution by Presentation Services
  2. Cache invalidation by the Scheduler
  3. Cost-based query planning and source pushdown by the BI Server Correct answer.
  4. Rendering delegation to JavaHost

Explanation

The BI Server evaluates execution strategies and can push operations to sources when that is more efficient. This planning reduces data movement and leverages source capabilities.

Question 22Oracle BI Architecture and Components

An administrator observes that a session variable used for row-level security is empty for some users, causing them to see no rows. Which architectural element is the most probable source of the problem?

  1. An expired query cache entry
  2. A misconfigured Cluster Controller port
  3. A missing presentation layer column
  4. An initialization block that fails to populate the variable for those users Correct answer.

Explanation

Session variables used in security filters are populated by initialization blocks. If the block does not return values for certain users, filters evaluate against empty values and suppress rows.

Question 23Oracle BI Architecture and Components

Which combination best explains why the BI Server can present a single logical model over heterogeneous sources?

  1. Logical-to-physical mappings plus federated query execution Correct answer.
  2. Presentation aliases plus catalog folder permissions
  3. Connection pooling plus usage tracking
  4. Scheduler jobs plus JavaHost rendering

Explanation

Mappings in the Business Model and Mapping layer define how logical objects derive from physical tables. The BI Server then federates execution across sources to satisfy one logical request.

Question 24Oracle BI Architecture and Components

A dashboard's data appears correct for one user but wrong for another who should see the same values. Both use the same analysis. Which architectural factor most directly explains differing results?

  1. JavaHost rendering different graphs per user
  2. Session-variable-driven security filters applied per user Correct answer.
  3. The web catalog storing separate copies of the analysis per user
  4. The Scheduler running separate jobs per user

Explanation

Row-level security filters often depend on session variables that differ by user, so the same analysis can return different rows. The underlying query is modified by those filters at execution time.

Question 25Oracle BI Architecture and Components

Why might enabling the query cache actually degrade perceived freshness in a reporting environment with frequent source updates?

  1. The cache rewrites logical SQL into invalid physical SQL
  2. The cache forces all queries through JavaHost
  3. Cached entries may be served until they expire or are purged, ignoring newer source data Correct answer.
  4. The cache disables initialization blocks at runtime

Explanation

Cached results represent a snapshot from when the query last ran. Until expiration or purging occurs, the BI Server can return that snapshot even after source data changes.

Question 26Oracle BI Architecture and Components

Which Oracle BI component is responsible for generating the HTML and interactive elements that users see in a dashboard page?

  1. Oracle BI Presentation Services Correct answer.
  2. Oracle BI Cluster Controller
  3. Oracle BI Server
  4. Oracle BI Scheduler

Explanation

Presentation Services renders the user interface, including dashboard pages, prompts, and views, and it communicates with the BI Server by sending logical SQL requests. It acts as the web-facing layer that formats results for the browser.

Question 27Oracle BI Architecture and Components

In the Oracle BI repository, which layer exposes business-friendly subject areas, dimensions, and measures to users while hiding physical source details?

  1. The Physical layer
  2. The Business Model and Mapping layer
  3. The Presentation layer Correct answer.
  4. The Connection Pool layer

Explanation

The Presentation layer is the topmost layer that users see; it contains the subject areas and columns exposed in Answers and dashboards. It sits above the Business Model and Mapping layer, which handles logical business modeling, and the Physical layer, which models source tables.

Question 28Oracle BI Architecture and Components

A dashboard query aggregates sales by region and year. The BI Server determines that the source database can compute the aggregation and sends a GROUP BY query to that database. Which architectural capability does this demonstrate?

  1. Query pushdown to the underlying data source Correct answer.
  2. Query federation across multiple sources
  3. Query persistence through the query cache
  4. Aggregate navigation using prebuilt summary tables

Explanation

The BI Server can push operations such as joins, filters, and aggregations down to the source database when the source supports them, reducing data movement and leveraging source processing power. This is a core function of the physical query generation process.

Question 29Oracle BI Architecture and Components

An administrator needs to give a group of users the ability to see only their own department's data in every dashboard. Which Oracle BI feature is designed to enforce this kind of row-level filtering centrally?

  1. Dashboard prompts that users can set to select a department
  2. Session variables populated by initialization blocks and referenced in logical SQL filters Correct answer.
  3. Presentation Services catalog permissions on dashboard pages
  4. The query cache's cache persistence table

Explanation

Row-level security is typically implemented by initializing session variables per user and referencing those variables in logical table filters or in the business model. This centralizes filtering in the BI Server so that all queries for a user are constrained consistently.

Question 30Oracle BI Architecture and Components

A dashboard is slow even though the BI Server's logical query is efficient and the source database responds quickly. Which architectural analysis best identifies where to investigate next?

  1. Compare the time spent in Presentation Services versus the BI Server by examining timings in the query log and the presentation log. Correct answer.
  2. Verify that the Cluster Controller has assigned the request to the primary instance.
  3. Confirm that the query cache is disabled so that every request is fresh.
  4. Check whether the Physical layer contains unnecessary outer joins that force full scans.

Explanation

When the logical query and source response are fast, the bottleneck may lie in Presentation Services rendering or in the communication between Presentation Services and the BI Server. Comparing timings recorded in the respective logs isolates which tier consumes the elapsed time.

Question 31Data Modeling and the BI Server Repository

In an Oracle BI Server repository, which object type physically groups columns from one or more tables and represents the level at which detail data is stored?

  1. A presentation column
  2. A business model
  3. A physical table Correct answer.
  4. A logical table source

Explanation

Physical tables are the repository objects that map to actual tables, views, or stored procedures in a data source. Their columns carry the physical data types and are joined through physical foreign keys. Logical objects sit above them and are built on top of these physical definitions.

Question 32Data Modeling and the BI Server Repository

Which layer of the Oracle BI Server repository is exposed directly to users and query tools through the Presentation Services catalog?

  1. The business model and mapping layer
  2. The connection pool layer
  3. The presentation layer Correct answer.
  4. The physical layer

Explanation

The presentation layer defines the columns and hierarchies that users see in Answers, dashboards, and other clients. It is built from business model objects but is renamed and reorganized for user friendliness. Physical and business model objects remain hidden from end users.

Question 33Data Modeling and the BI Server Repository

What is the primary purpose of a logical table source in the repository?

  1. To schedule cache refresh events
  2. To set the default formatting of presentation columns
  3. To define which physical tables supply data for a logical table and under what aggregation rules Correct answer.
  4. To store the database password for a connection pool

Explanation

A logical table source maps a logical table to one or more physical tables and specifies column mappings plus content levels such as aggregation and fragmentation. Multiple sources let the server choose the cheapest source for a query. This mapping is central to how the BI Server generates physical SQL.

Question 34Data Modeling and the BI Server Repository

A repository developer needs two logical tables in the same business model to be combined so that queries can drill across them. Which object must be created to relate them?

  1. A physical foreign key in the physical layer
  2. A complex join in the business model and mapping layer Correct answer.
  3. An initialization block
  4. A presentation hierarchy

Explanation

Logical relationships between tables in the business model are expressed as complex joins, which define the join condition using logical columns. They enable drill-across and multi-fact queries. Physical foreign keys only describe source relationships and do not by themselves create logical navigation paths.

Question 35Data Modeling and the BI Server Repository

Which repository feature lets the BI Server combine measures from two fact tables at different levels of granularity in a single query result?

  1. A dimension with a shared level
  2. Fragmentation content
  3. A multi-source logical table with conformed dimensions Correct answer.
  4. Aggregate navigation

Explanation

When two fact tables share conformed dimensions, the BI Server can stitch their measures together into one logical request through multi-fact logic. Conformed dimension levels give the server the common grain needed to align the results. This is the foundation of drill-across reporting.

Question 36Data Modeling and the BI Server Repository

In the physical layer, what does a primary key defined on a physical table primarily communicate to the BI Server?

  1. That the column should be hidden from users
  2. That the column is guaranteed unique and non-null in the source Correct answer.
  3. That the table should be cached in memory
  4. That the column must appear in every presentation layer

Explanation

A physical primary key declares uniqueness and non-null constraints on the source data, which the server can use for integrity assumptions and join reasoning. It does not control visibility, caching, or presentation exposure. Physical keys also help document source relationships alongside foreign keys.

Question 37Data Modeling and the BI Server Repository

A developer wants queries against a logical fact table to automatically use a pre-aggregated summary table when it satisfies the request. What must be configured?

  1. A new connection pool with a higher connection count
  2. A presentation hierarchy on the fact table
  3. A session variable in an initialization block
  4. A second logical table source with its aggregation content set to the summary grain Correct answer.

Explanation

Aggregate navigation relies on logical table sources whose content levels describe the grain of pre-aggregated data. When a source's aggregation content covers the requested level, the server can rewrite the query to that source. The summary must also be mapped to the same logical columns.

Question 38Data Modeling and the BI Server Repository

Which object is used to define a drill path so users can navigate from a higher level such as Region down to City?

  1. A connection pool
  2. A physical foreign key
  3. A logical dimension with levels and a hierarchy Correct answer.
  4. An aggregate persistence script

Explanation

Dimensions contain levels that describe the grain of attributes, and hierarchies order those levels to define drill paths. Presentation hierarchies expose those paths to users. Physical keys and connection settings do not define navigation for end users.

Question 39Data Modeling and the BI Server Repository

What happens when a logical column has no expression and no direct mapping but is derived entirely from other logical columns?

  1. The server computes it from the derived expression at query time Correct answer.
  2. The server ignores the column in all queries
  3. The server requires a physical column with the same name
  4. The server returns an error at query time

Explanation

A logical column can be defined as derived, meaning its value is computed from an expression over other logical columns rather than read from a physical column. The BI Server evaluates that expression and pushes what it can to the source. No physical column of the same name is required.

Question 40Data Modeling and the BI Server Repository

Which statement best describes the role of the business model and mapping layer?

  1. It stores only the physical SQL text issued to each source
  2. It controls which users may log on to the server
  3. It stores dashboard layout definitions
  4. It translates physical structures into business-friendly logical tables, columns, and joins Correct answer.

Explanation

The business model and mapping layer provides the logical abstraction over physical sources, defining logical tables, columns, dimensions, and complex joins. It also holds the mappings that connect logical objects to physical ones. This layer is where business semantics and calculation logic live.

Question 41Data Modeling and the BI Server Repository

A developer needs a logical table source to apply only to data where the source column REGION equals 'EMEA'. Which feature should be used?

  1. A physical foreign key on the region column
  2. A fragmentation content specification on the logical table source Correct answer.
  3. Aggregation content at the country level
  4. A presentation hierarchy with a region level

Explanation

Fragmentation content declares that a logical table source contains only a subset of rows, identified by an expression such as REGION = 'EMEA'. The server then unions or selects among sources as needed to satisfy a query. This is useful for partitioning data across sources.

Question 42Data Modeling and the BI Server Repository

Which object would a developer create to store a value such as the current user's department at session initialization for use in row-level security filters?

  1. A presentation column
  2. A physical table alias
  3. A logical dimension level
  4. A repository variable initialized by an initialization block Correct answer.

Explanation

Initialization blocks run at session start and populate session or repository variables with values such as the user's department. Those variables can then be referenced in security filters and logical expressions. This is the standard mechanism for dynamic, per-user context.

Question 43Data Modeling and the BI Server Repository

What is the effect of marking a logical dimension as a 'degenerate' or snowflaked dimension across separate logical tables?

  1. It forces all dimension attributes into the fact table
  2. It removes the dimension from the presentation layer
  3. It prevents the dimension from being used in drill-across
  4. It allows dimension attributes to be split across related logical tables while remaining one logical dimension Correct answer.

Explanation

A logical dimension can span multiple logical tables that are related through complex joins, letting attributes live in normalized or separate tables while still behaving as one dimension. This supports snowflaked source designs without exposing the complexity to users. It does not remove the dimension or block drill-across.

Question 44Data Modeling and the BI Server Repository

Which physical-layer object is required before the BI Server can connect to a source database?

  1. A business model
  2. A logical table source
  3. A presentation hierarchy
  4. A connection pool assigned to a physical database Correct answer.

Explanation

Connection pools hold the connection information such as driver, data source name, and credentials, and they are assigned to a physical database object. Without a valid connection pool the server cannot issue queries to the source. Logical and presentation objects depend on this physical connectivity.

Question 45Data Modeling and the BI Server Repository

A developer wants the BI Server to push a calculation to the source database when possible rather than computing it after retrieval. What design choice best supports this?

  1. Add a second connection pool for the same database
  2. Create a presentation hierarchy on the column
  3. Mark the column as hidden in the presentation layer
  4. Define the calculation as a derived logical column with an expression the source can evaluate Correct answer.

Explanation

When a logical column's expression uses functions the source database supports, the server can include that expression in the generated physical SQL. This is often called aggregate or function pushdown. Defining the logic at the logical layer lets the optimizer decide whether to push it down.

Question 46Data Modeling and the BI Server Repository

Which statement correctly describes the relationship between a logical table and its logical table sources?

  1. A logical table may have only one logical table source
  2. A logical table may have multiple logical table sources mapped to different physical tables Correct answer.
  3. A logical table source cannot contain column mappings
  4. A logical table source may belong to multiple logical tables at once

Explanation

A logical table can be supported by several logical table sources, each mapping to a different physical table or grain. The server selects among them based on cost and content. Each source belongs to one logical table and defines its own column mappings.

Question 47Data Modeling and the BI Server Repository

What does a physical join in the repository describe?

  1. A user-facing drill path between two dimensions
  2. How two physical tables are related through key columns in the source Correct answer.
  3. The cache expiration policy for a subject area
  4. The order in which presentation columns appear

Explanation

Physical joins record the relationship between physical tables, typically through foreign key columns, and mirror the source schema. They help the server understand source structure and can inform join generation. They are distinct from logical complex joins used in the business model.

Question 48Data Modeling and the BI Server Repository

A measure must be summed across all rows in a logical table regardless of the query grain. Which aggregation setting on the logical column supports this?

  1. Aggregation rule set to Sum Correct answer.
  2. Aggregation rule set to None
  3. Aggregation rule set to Average
  4. Aggregation rule set to Count Distinct

Explanation

The default aggregation rule on a logical column tells the server how to roll up that measure when a query requests a coarser grain. Setting it to Sum means values are added across the rows being aggregated. The rule must match the business meaning of the measure to avoid incorrect totals.

Question 49Data Modeling and the BI Server Repository

Why might a developer set a logical column's aggregation rule to None?

  1. To convert the column into a physical key
  2. To force the server to always aggregate the column
  3. To indicate the column is non-additive and should not be rolled up automatically Correct answer.
  4. To hide the column from all users

Explanation

Some measures, such as ratios or semi-additive balances, cannot be correctly rolled up with a simple rule. Setting aggregation to None tells the server not to aggregate the column automatically and signals that special handling is required. This prevents misleading totals at coarser grains.

Question 50Data Modeling and the BI Server Repository

What is the purpose of the 'content' tab on a logical table source?

  1. To list which users may query the source
  2. To define the color scheme of dashboards
  3. To specify the aggregation grain and any fragmentation expression for that source Correct answer.
  4. To set the maximum number of rows returned

Explanation

The content settings describe what data the source contains, including the level of aggregation and any row-level fragmentation condition. The server uses this metadata to decide which source can satisfy a query. Correct content definitions are essential for aggregate navigation and partitioned sources.