It is impossible to pass Oracle 1Z0-591 exam without any help in the short term. Come to Actualtests soon and find the most advanced, correct and guaranteed Oracle 1Z0-591 practice questions. You will get a surprising result by our Latest Oracle Business Intelligence Foundation Suite 11g Essentials practice guides.
This Testaimer.com web site will certainly provide you with credible info concerning 1Z0-591 exam dumps.
Q51. When designing a Star Schema, which option does not apply?
A. The facts are quantifiable.
B. The fact has several foreign keys that are primary keys in the dimensional table
C. Fact table is joined to the related dimensional tables.
D. Dimensional tables are normalized.
E. Dimensional tables have one attribute primary key as Product_ID for products.
Q52. Which three techniques are applied to support Failover?
A. WebLogic Clustering
B. Universal Installer > Scale Out BI System option
C. OBIEE Clustering
D. Vertical Scaleout
Q53. 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. Build Aggregate Queries
C. Create SummaryTables
D. Manage user logins
Q54. One of the most common uses of Dynamic Repository Variables is to setup filters for use in reporting. Which variable below is a valid example of a Dynamic Repository Variable?
Q55. When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard, which two statements are true?
A. The analyst mustfirstwrite DML (Data Manipulation Language) scriptstocreate the aggregate table.
B. TheAggregate Persistence Wizard enables youto automate the creation of physical aggregate tables and theircorresponding objects in the repository.
C. Job Managercanbe used to run the Aggregate Persistence script.
D. TheExtractionTransformation and Loading process creates the aggregate tables.
Q56. 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 aggregationin the Content tab
C. By creatingfour new logical table sources and using the Fragmentation content to specify theaggregation levels
D. By creating four new logical table sources and using the "where" section of the Content tab to specify the aggregation levels
Q57. 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 relationshipin 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 alogical table source (LTS) thatjoins the Employees and Jobs tables
Q58. How do you get the BI plug-in for MS Office?
A. By contacting the administrator
B. By downloading it from the BI Server
C. By downloading it from the Database Server
D. By downloading it from Microsoft Server
Q59. 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
Q60. 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 include best practice naming conventions for physical table names.
C. Alias tables are set up to create another physical copy of the data.
D. Alias tables are set up to create a copy of the data with a filter applied to it.