Oracle 1Z0-591 Online Practice Questions and Exam Preparation

Oracle 1Z0-591 Online Questions & Answers

• Question 91:

  If Security attributes conflict, what happens?

  A. The user or application role is granted the minimum security attribute
  B. The user or application role is granted the maximum security attribute
  C. The user or application role is granted No security attribute
  D. The user or application role is granted the Fully Restrictive security attribute
  A. The user or application role is granted the minimum security attribute

  ---

  If security attributes conflict, a user or group is granted the least restrictive security attribute.

• Question 92:

  OBIEE default security model stores security Information such as user names and password combinations for accessing an external system such as Active Directory. It is stored in the____________.

  A. Policy Store
  B. Credential Store
  C. Identity Store
  D. Person Store
  C. Identity Store

  ---

  Identity Store: It is directory server to perform the authentication. It contains user name , password and groups membership information .When a user name and password combination is entered at log in, the authentication provider searches

  the identity store to verify the credentials provided.

  See figure below.

  

• Question 93:

  The customer is questioning the necessity to have a data warehouse in place. They want to run OBIEE against various transactional systems. Identify the two limitations.

  A. Operational system might be overburdened with analytical requests resulting in had performance for transactional processes.
  B. The BI server cannot integrate various sources in one metadata model.
  C. Data quality issues might emerge, due to missing data cleansing.
  D. Business issues are depending on real-time data.
  A. Operational system might be overburdened with analytical requests resulting in had performance for transactional processes.
  C. Data quality issues might emerge, due to missing data cleansing.

• Question 94:

  DSNs are set up for access to which data sources?

  A. ODBC Data Sources
  B. Oracle Data Sources
  C. IBM Data Sources
  D. Teradata Data Sources
  A. ODBC Data Sources

  ---

  The principal connection to an OBI Server inside the Oracle BI System is made through an Odbc Connection.

  OBI Server can handle multiple repository but you can connect to only one at the same time by DSN Odbc Connection. Therefore, you must set up an ODBC connection for each repository.

• Question 95:

  What must be done before you can run the Oracle Business Intelligence 11g Installer?

  A. Obtain BI installation media
  B. Create required Oracle Business Intelligence schemas in a database
  C. Ensure system meets installation requirements for Fusing Middleware, Oracle Business Intelligence, AND Repository Creation Utility
  D. Install the WLS Admin Server
  E. Select installation components ?OBIEE, BIP, RTD
  B. Create required Oracle Business Intelligence schemas in a database

  ---

  Before you can run Oracle Business Intelligence 11g Installer, you must first create

  required Oracle Business Intelligence schemas in an unhardened database. You use a tool called the Repository Creation Utility (RCU) to create these schemas with the appropriate permissions and data.

  Reference: Installation Guide for Oracle Business Intelligence, Additional Oracle Business Intelligence 11g Installer Requirements

• Question 96:

  A customer frequently queries multiple dimension tables without a measure. What needs to be defined in the presentation layer?

  A. Logical Key
  B. Implicit Fact Column
  C. Alias
  D. Logical Column Name
  E. Custom Display Name
  D. Logical Column Name

  ---

  You can define calculations in either of the following ways:?Before the aggregation, in the logical table source. For example:sum(col_A *( col_B))?After the aggregation, in a logical column derived from two other logicalcolumns. For example:sum(col A) * sum(col B)

• Question 97:

  If you have a database with four aggregate tables, how should the repository be configured to take advantage of the aggregates?

  A. By creating four new logical tables sources
  B. By creating four new logical table sources and choosing each dimension's level of aggregation in the Content tab
  C. By creating four new logical table sources and using the Fragmentation content to specify the aggregation levels
  D. By creating four new logical table sources and using the "where" section of the Content tab to specify the aggregation levels
  B. By creating four new logical table sources and choosing each dimension's level of aggregation in the Content tab

  ---

  Content Tab Aggregation Content You can define the aggregation (ie the group by) of: by hierarchy level

  by logical column It helps you to define an aggregate navigation

  

  Note: logical table source

  Logical table sources define the mappings from a single logical table to one or more physical tables. A logicaltable contains one or more logical table source. The mapping between physical columns and logical columns are done in this

  element. The definition of the logical table source is used:

  The Content tab of the Logical Table Source is used to define :

• Question 98:

  How do Dynamic Repository Variables differ from Static Repository Variables?

  A. Dynamic Repository Variables are not initialized by the Initialization Block.
  B. Dynamic Repository Variables cannot be used in the Expression Builder.
  C. Dynamic Repository Variables can be changed by data that is returned from queries.
  D. Dynamic Repository Variables cannot be used in a CASE statement.
  C. Dynamic Repository Variables can be changed by data that is returned from queries.

  ---

  Dynamic Repository Variables:

  You initialize dynamic repository variables in the same way as static variables, but the values are refreshed by data returned from queries. When defining a dynamic repository variable, you will create an initialization block or use a pre-existing

  one that contains a SQL query. You will also set up a schedule that the Oracle BI Server will follow to execute the query and periodically refresh the value of the variable.

  Note: The value of a static repository value is initialized in the Variable dialog box. This value persists, and does not change until an Oracle BI Administrator decides to change it.

• Question 99:

  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
  A. Whether the logical table source for this column has been disabled

  ---

  This warning indicates that the given column is only mapped to logical table sources that are disabled. The warning brings this issue to the repository developer's attention in case the default behavior is not desired.

  Reference: Oracle Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition, Common Consistency Check Messages

• Question 100:

  A customer needs to do a cross database join between two tables where, one of the tables has a small number of values and the other has a large number of values. How can you optimize the way the BI Server processes the query?

  A. By specifying a one-to-many join between the tables with the small and large numbers of values
  B. By specifying a driving table
  C. By specifying a many to one join between the tables with the small and large numbers of values
  D. By creating your logical join by using the Joins Manager
  E. By creating your joins by using the Business Model Diagram
  B. By specifying a driving table

  ---

  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.