1Z0-591 | Leading Oracle 1Z0-591 dumps


Q1. A company's Database Administrator has divided the region table into two tables so that the region "West" is in one table and all the other regions are in another single table. What kind of partition is being used? 

A. Fact-based 

B. Time-based 

C. Mixed 

D. Complex 

Answer:

Q2. 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 

Answer: A

Q3. Oracle BI Server at a company is connected to Data Warehouse that is refreshed on a daily basis, the majority of users at the company log in to Oracle BI every Monday to generate the previous week's sales report. The BI Administrator schedules cache purge and cache seeding to improve report response times. How is this accomplished? 

A. Everyday before Data Warehouse refresh 

B. Every day after Data Warehouse refresh 

C. Every Monday early morning 

D. Every Monday late night 

Answer: D

Q4. 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 

Answer: B

Q5. Which option is used to enter the rank function when creating a new rank measure? 

A. Initialization Block 

B. Expression Builder 

C. Connection Pool 

D. Web Catalog 

Answer: B

Q6. What must be purchased when integrating Oracle map with Oracle BI? 

A. Oracle Mapviewer 

B. Oracle Business Intelligence Enterprise Edition 

C. Spatial Option with Database 

D. OLAP option 

Answer: A

Q7. A customer always wants Aggregate Table l to be looked at first to see if it can answer the query. What should be done to make sure this happens? 

A. Make AggregateTable 1 the first table in the list ofLogical TableSources. 

B. Do not map the logical levelin the Content tab. 

C. Set the Priority Group to 0. 

D. Setthe Priority Croup to5. 

Answer: C

Q8. Initialization Blocks are never used to initialize which option? 

A. Dynamic Repository Variables 

B. System Session Variables 

C. Non System Session Variables 

D. rpd file 

Answer: D

Q9. 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. 

Answer: BC

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

A. Design requests that use Complex Queries 

B. Avoid returning big data sets within the Dashboard 

C. Use Cache 

D. Avoid using GuidedNavigation unless the data set is large 

Answer: BC