An organization has re-implemented one of its systems but has not moved history. One database has data for all years up to 2010 and the other has data for years from 2011 to the present. The organization needs data from the years 2010
and 2011 on a single report.
How can you model this in the RPD?
A. By creating two Logical Fact Tables for each database
B. By creating joins in the physical model so it looks like a single table
C. By creating two logical table sources, that specify in Content tab using the Fragmentation content areas to specify the years for each source
D. By creating two logical table sources and checking the "This Source should be combined with other sources at this level" box leaving the Fragmentation content area blank.
E. By creating one logical table sources and checking the "This Source should be combined with other sources at this level" box
The WebLogic Repository Schema generated via RCU can be deployed to which three DBMS?
A. Oracle RDBMS
B. Microsoft SQL Server
C. IBM DB2
D. Teradata
How will you model a Type II Slowly-Changing Dimension?
A. Add an additional column to the dimension table to capture a version of change
B. Overwrite an existing dimension table record with the changed record
C. Add a new row to the dimension table with a new key for the changed record
D. Do Nothing
When designing a Star Schema, which option does not apply?
A. The facts are quantifiable.
B. The fact has several foreign keys that are primary keys in the dimensional table
C. Fact table is joined to the related dimensional tables.
D. Dimensional tables are normalized.
E. Dimensional tables have one attribute primary key as Product_ID for products.
How do you get the BI plug-in for MS Office?
A. By contacting the administrator
B. By downloading it from the BI Server
C. By downloading it from the Database Server
D. By downloading it from Microsoft Server
A company's Database Administrator has divided the region table into two tables so that the region "West" is in one table and all the other regions are in another single table. What kind of partition is being used?
A. Fact-based
B. Time-based
C. Mixed
D. Complex
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
Which component is responsible for determining the device that receives the alerts for a given user account?
A. Dashboard
B. iBot
C. Alerts
D. Delivery Profiles
Which analysis features could be applied to provide interactive controls for end users?
A. Column Selector
B. Action Links
C. Conditional Formatting
D. Narrative View
E. Greenbar Styling
Which two steps are needed to set up Failover support for an OBIEE deployment?
A. Use Installer to affect Horizontal scale out of an existing instance B. Employ WebLogic Enterprise Edition, licensed separately
C. Use Installer to set up separate single instances, then apply Horizontal scale out clustering
D. Apply OBIEE Clustering option
E. Leverage spare hardware capacity of single machine by using Vertical scale out option