Online Access Free 1Z1-591 Exam Questions

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

How do you get the BI plug-in for MS Office?

• A.By downloading it from the BI Server
• B.By contacting the administrator
• C.By downloading it from the Database Server
• D.By downloading it from Microsoft Server

What are the two leading design solutions recommended by Oracle that you would use for performance?

• A.Avoid returning big data sets within the Dashboard
• B.Avoid using Guided Navigation unless the data set is large
• C.Use Cache
• D.Design requests that use Complex Queries

A user's BI Home page provides one-click access to which three options?

• A.Business model metadata
• B.Dashboard layout editor
• C.Create new content
• D.Catalog search functionality
• E.Oracle BI online documentation

The WebLogic Repository Schema generated via RCU can be deployed to which three DBMS?

• A.Microsoft SQL Server
• B.IBM DB2
• C.Oracle RDBMS
• D.Teradata