Oracle 1Z0-591 dumps - 100% Pass Guarantee!

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

When creating a Security Realm in the WebLogic Console, which object is created?

A. Groups

B. Row Level Filters

C. Server Password

D. Single Sign On

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

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 modeling the many to many relationship in the business model

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

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

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

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.