1Z0-591 Online Practice Questions and Answers
Which two components are required for all OBIEE installations?
A. Admin Server
B. RCU Schema
C. Managed Server
D. Node Manager
E. Oracle 11g
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
There is a logical fact table that contains Item number, store, time, and revenue. How would you add Number of items sold?
A. By creating a derived measure on the logical column Item number and using the count Function
B. By creating a derived measure on the logical column item number and using the count distinct function
C. By creating a derived measure based on the physical column item number and changing the aggregation method to count
D. By creating a derived metric by using the Expression Builder
One benefit of adding a second table source that is joined to the first table source in the Physical Layer by a foreign key relationship is that______.
A. Multiple SQL queries are performed
B. Two SQL queries are performed to get data from both tables
C. A single SQL query is performed to get data from both tables
D. No SQL queries are performed against the source tables
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
Identify the two Object level security functions that are done on the repository by using the BI Admin tool.
A. Assign users to a web catalog group
B. Create a new repository group
C. Create a new user in the repository
D. Create a web catalog group
E. Define permissions for Dashboard
There are two aggregate tables that are available for query. How would they be mapped into the logical data model so queries can use them?
A. By creating two new logical tables sources
B. By opening the two logical Table Source dialog boxes and mapping the appropriate levels in the Content tab
C. Both A and B
D. By creating one new Logical Table Source
The three metadata layers are an important concept of the BI Server. Which statement is incorrect?
A. The physical layer defines the objects and relationships that the Oracle BI Server needs to write native queries against each physical data source.
B. Separating the logical of the application from the physical model provides the ability to federate multiple physical sources to the same logical object.
C. The model and mapping layer define the business or logical model of the data. This layer determines the analytic behavior seen by users.
D. The presentation layer defines the relationship that is needed to create the DML.
Which option does not describe Aggregate tables?
A. Aggregate tables increase query performance by pre-calculating frequently accessed measure aggregations.
B. Aggregate tables relieve bottlenecks and pre-calculate and store the data for better query response.
C. Aggregate tables typically have fewer rows than the non aggregate tables and, therefore, processing should be quicker.
D. Aggregate tables are created and stored on the BI Server.
You run the Consistency Check and receive the warning: [39003] Missing functional dependency association for column: DIM_Offer_End_Date.CREATE_DT.
What would you check?
A. Whether the logical table source for this column has been disabled
B. Whether the columns creating CREATE_DT have been deleted
C. Whether there is a logical join between the DIM and FACT tables
D. Whether there is a physical join between the DIM and FACT tables
E. Whether there is a physical column mapped to the logical column
F. DIM_Offer_End_Date.CREATE_DT