10 Tips For Improved 1Z0-591 vce

Q1. Identify the reason why Oracle OLAP provides a favorable aggregation strategy. 

A. OLAP cubes eliminate the need for a large number of aggregate tables. 

B. OLAP cubes are stored outside of the database in highly optimized file structures. 

C. OLAP cubes can be easily transported from database to database. 

D. OLAP cubes can be queried by using SQL. 

View Answer

Q2. Cache in OBIEE is used to_____. Select the two correct answers. 

A. improve performance of Dashboards and Analysis 

B. decrease query response time 

C. improve Analysis data quality 

D. eliminate Write Back Capabilities 

E. create Aggregate tables 

View Answer

Q3. Under what circumstances would you model within the BI environment to include transactional data directly? 

A. When the customer needs near real-time data to support decision making in a fast changing environment 

B. When the customer is not prepared to spend budget on data-warehousing 

C. When the complexity of operational schema does not allow modeling in the BI repository 

D. When it is not possible to query against a transactional system 

View Answer

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

View Answer

Q5. Select the correct statement. 

A. Cache provides fast and always up-to-date information. 

B. Cache can increase traffic to back end database. 

C. Cache needs to be purged to refresh data. 

D. Cachecan degrade query performance by reading data from the disk instead of the database. 

E. Cache is seeded by manually running PL/SQL at the back end database. 

View Answer

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

A. Oracle RDBMS 

B. Microsoft SQL Server 

C. IBMDB2 

D. Teradata 

View Answer

Q7. The three metadata layers are an important concept of the BI Server. Which statement is incorrect? 

A. The physical layer defines the objects and relationships that the OracleBIServer needs to writenative queries against each physical data source. 

B. Separating the logical of the application from the physical model provides the ability to federate multiple physical sources to the same logical object. 

C. The model and mapping layer define the business or logical model of the data. This layer determines the analytic behavior seen by users. 

D. Thepresentation layer defines the relationship thatis needed to create the DML. 

View Answer

Q8. If a customer is planning on building a data warehouse, how would you describe data warehousing to the customer? 

A. The data in the data warehouse describes events and statuses of business processes, products and services, goals and organizational units, and generally mirrors every aspect of the structure and behavior of the organization. 

B. Data warehouses can only be based on multidimensional data modeling. 

C. Application based data warehouses can be bought off the shelf and used without any tweaking. 

D. Data warehouse projects are usually implemented within two weeks. 

View Answer

Q9. What is an example of a Session Variable? 

A. ETL Load Date 

B. User Organization 

C. OLAP DSN 

D. Top Customers by Revenue 

View Answer

Q10. How do System Session Variables obtain their values? 

A. They are entered by user input on a dashboard 

B. They are obtained from data fields in the Physical Layer 

C. They are obtained from the Presentation Layer 

D. They are obtained from the Initialization Block 

View Answer