Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
Q1. 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
Q2. Which language is used by OBIEE to query Essbase?
A. SQL
B. LINQ
C. MDX
D. DMX
Answer: C
Q3. What is the first step when creating an Aggregate table in the OBI repository?
A. Test the Aggregate table by using Analysis
B. Specify the Fact table that you want to aggregate
C. Use Job Manager to run the Aggregate script
D. Create a dedicated Connection Pool
Answer: B
Q4. In the Oracle Data Warehouse Reference Architecture, which term is not a layer in the data warehouse?
A. Access and Performance Layer
B. Master Data Layer
C. Staging Data Layer
D. Presentation DataLayer
Answer: D
Q5. The Consistency Checker checks______.
A. The validity of objects outside the metadata using the connection
B. Mappings to the physical objects
C. For objects deleted from the database
D. Syntax errors in derived logical columns
Answer: B
Q6. 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
Q7. What are the two types of Repository Variables?
A. System
B. Non System
C. Static
D. Dynamic
Answer: CD
Q8. Which component is responsible for determining the device that receives the alerts for a given user account?
A. Dashboard
B. iBot
C. Alerts
D. Delivery Profiles
Answer: B
Q9. Permissions for Presentation layer objects and Business layer objects that restrict users is configured in which software component?
A. OracleEnterpriseManager
B. OracleHTTP Server
C. WebLogicServer Administration Component
D. BIAdministration Tool
Answer: D
Q10. OBIEE default security model stores security Information such as user names and password combinations for accessing an external system such as Active Directory. It is stored in the____________.
A. Policy Store
B. Credential Store
C. Identity Store
D. Person Store
Answer: C
Q11. Which resource identifies the OBIEE Web Catalog (webcat)?
A. instanceconfig.xml
B. RCU Schema
C. Identity Store
D. nqsconfig.ini
E. Admin Server
Answer: CE
Q12. When creating a new dimensional hierarchy in the BI Administration tool, right click the dimension, then select "New Object" What must be selected next?
A. Logical Key
B. ParentLevel
C. ChildLevel
D. Dynamic Key
Answer: B
Q13. An organization would like to see a Time folder with subfolders for its Fiscal and Julian calendars. How would you accomplish this?
A. By creating Presentation Folder calledTime and then two subsequent folders called-> Fiscal Calendar and-> Julian Calendar
B. By creating aPresentationFolder called ->Timecalledthen two subsequent folders calledFiscal Calendar and Julian Calendar
C. By creatingaPresentation Foldercalled -Time and then two subsequent folders called + FiscalCalendar and+Julian Calendar
D. Bycreating a Presentation Foldercalled Time<parent> and thentwo subsequent folders called Fiscal Calendar<child> and Julian Calendar<child>
Answer: A
Q14. Which option does not describe Aggregate tables?
A. Aggregatetables increase query performance by pre-calculating frequently accessed measure aggregations.
B. Aggregate tables relieve bottlenecks and pre-calculate and store the data for better queryresponse.
C. Aggregate tables typically have fewer rows than the non aggregate tables and,therefore,processing should be quicker.
D. Aggregate tables are created and stored on theBIServer.
Answer: C
Q15. A derived measure is never used to_________.
A. Calculate share measures
B. Add two logical columns together
C. Calculate a variance between two measures
D. Calculate the rank dimension values
E. Input data
Answer: E
Q16. 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
Answer: AB
Q17. When adding a new dimension to an existing logical table, what is the significance of the Logical Level setting in the Logical Table Source properties?
A. It defines the granularity of the dimension.
B. It determines the actual value of the dimension.
C. It creates a new session variable.
D. It creates a foreign key relationship.
Answer: A
Q18. 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