Oracle Business Intelligence Foundation Suite 11g Essentials (1Z1-591) Free Practice Test

Question 1

DSNs are set up for access to which data sources?

A. Teradata Data Sources

B. IBM Data Sources

C. ODBC Data Sources

D. Oracle Data Sources

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

The Consistency Checker checks______.

A. Mappings to the physical objects

B. Syntax errors in derived logical columns

C. The validity of objects outside the metadata using the connection

D. For objects deleted from the database

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

The WebLogic Console will allow you to perform which of the following functions in the BI Managed Server?

A. Start and Stop BI Services

B. Create Summary Tables

C. Build Aggregate Queries

D. Manage user logins

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

Identify the two true statements about alias tables.

A. Alias tables are set up to avoid triangular or circular joins.

B. Alias tables are set up to create a copy of the data with a filter applied to it.

C. Alias tables are set up to include best practice naming conventions for physical table names.

D. Alias tables are set up to create another physical copy of the data.

Correct Answer: A,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

An organization has its employees' names in an Employees table, and information about their jobs in a Jobs table.
However, an organization's employees can have multiple jobs, and the same job can be performed by multiple employees. This situation would result in a many to-many relationship between the Employees and Jobs tables. How can the many to-many relationship issue be resolved?

A. By creating a logical table source (LTS) that joins the Employees and Jobs tables

B. By creating the many to many join in the physical model

C. By modeling the many to many relationship in the business model

D. By creating a bridge table that represents one employee doing one job, with several rows for an employee who has several jobs

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

You do not have a physical time table in your database but would like to use the time series functions that OBIEE offers. What two options do you have?

A. Create a Logical Table that is sourced from a time field in one of your dimension tables.

B. Create a time table that is joined through a intervening Table so there is no foreign key relationship.

C. Create an "Opaque View" in the physical layer that contains the time columns from the fact and map it into your physical model.

D. Create a physical time table in your database.

E. Create a Logical Table that is sourced from the time key in the fact table.

Correct Answer: A,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Oracle Business Intelligence Foundation Suite 11g Essentials (1Z1-591) Free Practice Test