Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
Q1. DSNs are set up for access to which data sources?
A. ODBC Data Sources
B. Oracle Data Sources
C. IBM Data Sources
D. Teradata Data Sources
Answer: A
Q2. What are the two ways to use the administration tool?
A. It can be used to manage user password.
B. The administration tool uses a set of wizards that support the design of calculations, expressions, dimensions, and so on.
C. It can be used for versioning of the rpd.
D. Administrator can use repository and session variables in a repository to streamline administrative tasks and dynamically modify metadata content to adjust to a changing data environment.
Answer: CD
Q3. What is an example of a Session Variable?
A. ETL Load Date
B. User Organization
C. OLAP DSN
D. Top Customers by Revenue
Answer: B
Q4. A customer needs to create a product share calculation. What are the two ways that they would get the revenue for all products to use in the denominator?
A. Create a derived measure by using the addition function that adds each product value together.
B. Create a derived measure based on Revenue that has the Level Total Product selected on the Level Tab of the Logical Column Dialog.
C. Create a derived measure based on Revenue that has all the levels selected on the Level Tab of the Logical Column Dialog except Total Product.
D. Create a derived metric by using the Expression Builder.
Answer: AC
Q5. Which analysis features could be applied to provide interactive controls for end users?
A. Column Selector
B. Action Links
C. Conditional Formatting
D. Narrative View
E. Greenbar Styling
Answer: B
Q6. Which OBIEE capability enables developers to build Aggregate tables?
A. Aggregate Persistence Wizard
B. Expression Builder
C. Table Builder
D. Query Analyzer
Answer: A
Q7. Where is Oracle Mapviewer installed?
A. In the same domain as OBIEE on the web application server
B. Never on the same domain as OBIEE on the web application server
C. On the Database server
D. On its own application server
Answer: A
Q8. Which two components are required for all OBIEE installations?
A. Admin Server
B. RCU Schema
C. Managed Server
D. Node Manager
E. Oracle 11g
Answer: BE
Q9. A user's BI Home page provides one-click access to which three options?
A. Create new content
B. Oracle BI online documentation
C. Catalog search functionality
D. Dashboard layout editor
E. Business model metadata
Answer: ABC
Q10. Object Security controls access to Subject Areas, Tables, and Columns in OBIEE and can be implemented by using which method?
A. Single Sign-On (SSO)
B. Database Authentication
C. Business Logic Object Security
D. External Table Authentication
E. LDAP Authentication
Answer: C
Q11. Which two steps are needed to set up Failover support for an OBIEE deployment?
A. Use Installer to affect Horizontal scale out of an existing instance
B. Employ WebLogic Enterprise Edition, licensed separately
C. Use Installer to set up separate single instances, then apply Horizontal scale out clustering
D. Apply OBIEE Clustering option
E. Leverage spare hardware capacity of single machine by using Verticalscale out option
Answer: AD
Q12. Select the scenario in which block storage must be used instead of aggregate storage.
A. Incremental data loading
B. Top - down planning
C. Extremely sparse data sets
D. Millions of members in the outline
Answer: B
Q13. A customer wants to analyze the efficiency of his/her order fulfillment process. If the customer has a dimensional model, which option is the fact table?
A. Stores
B. Orders
C. Products
D. Time
Answer: B
Q14. Which two options are valid Repository Variable names?
A. USER
B. CurrentDay
C. CurrentMonth
D. Date
Answer: BC
Q15. 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
Answer: B
Q16. When creating a query. Subject areas can be combined via point and click as long as____.
A. the subject areas share objects of the same name
B. the subject areas both share the same model in the business model and mapping layer
C. the subject areas are both from the same physical source, though they may be in separate business layers
D. two or more subject areas cannot be joined together without manually mapping the contents
Answer: B
Q17. What is the process in which there is redundancy of data to improve performance?
A. Redundancy
B. Normalization
C. Denormalization
D. Granularity
E. Cardinality
Answer: C
Q18. 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
Answer: ABC