1Z0-591 | Improve Oracle 1Z0-591 vce
Q21. 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?
A. Year
B. Month
C. Quarter
D. CurrentMonth
Answer: D
Q22. Which Oracle Partner is the supplier of map-based content to provide background maps, boundary information, and points of interest?
A. Navteq
B. TeleAtlas
C. Google
D. ESRI
Answer: C
Q23. 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
Answer: A
Q24. There are two aggregate tables that are available for query. How would they be mapped into the logical data model so queries can use them?
A. By creating two new logical tables sources
B. By opening the two logical Table Source dialog boxes and mapping the appropriate levels in the Content tab
C. Both Aand B
D. By creating one new LogicalTableSource
Answer: B
Q25. Which of the following characteristics pertain to a "ragged" hierarchy?
A. It can only be stored in an XML structure.
B. A branch of the hierarchy may have a different number of levels than other branches.
C. All values can have a maximum of six levels.
D. It creates multiple levels of hierarchy in the databasetable.
Answer: B
Q26. Use of the Enterprise Install option is recommended for which three options?
A. Multiple instances on a single computer
B. Scale out for High Availability and Failover
C. Support for high security requirements
D. Evaluation of end user functionality
E. Single users working on a single computer
Answer: ABC
Q27. Why is it necessary to join multiple source tables to a single dimension?
A. Because transactional source systems are often denormalized
B. Because transactional source systems are often normalized
C. Because a single source table often contains all the dimensions needed
D. Because the dimensions tables are built in the transactional systems
Answer: A
Q28. Identify the correct mode to use when opening the web catalog while performing security settings modifications and migrations.
A. Online
B. Offline
C. Managed
D. UnManaged
Answer: A
Q29. Which option describes how OBIEE Integrates with Planning?
A. OBIEE primarily accesses Planning using standard Essbase integration techniques.
B. OBIEE provides complete access to all Planning data through the Analytic Data Model (ADM) layer.
C. Planning is not a supported OBIEE source.
D. OBIEEintegrates with Planning directly through relational database access.
Answer: AB
Q30. 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 columnItem number and using the count Function
B. By creating a derived measure on the logical column item number and usingthe count distinct function
C. By creating a derived measure based on the physical column item number and changing theaggregation method to count
D. By creatinga derived metric by using the Expression Builder
Answer: C