QUESTION NO: 51 Identify the two Object level security functions that are done on the repository by using the BI Admin tool.
A. Assign users to a web catalog group
B. Create a new repository group
C. Create a new user in the repository
D. Create a web catalog group
E. Define permissions for Dashboard
QUESTION NO: 52 OBIEE 11g authentication of users is performed by which two components listed below?
A. Repository file (rpd)
B. Embedded WebLogic LDAP server
C. External directories such as Active Directory using WebLogic and Fusion Middleware's Oracle Platform Security Services framework
D. BI Presentation Services
QUESTION NO: 53 One of the initial phases in OBIEE implementation is the Discovery phase where the project team focuses on a few activities. Which option is not one of them?
A. Business Requirements Definition
B. Technical Requirements Definition
C. Data Quality Assessment
D. Dashboard Testing
QUESTION NO: 54 Identify the two true statements about alias tables.
A. Alias tables are set up to avoid triangular or circular joins.
B. Alias tables are set up to include best practice naming conventions for physical table names.
C. Alias tables are set up to create another physical copy of the data.
D. Alias tables are set up to create a copy of the data with a filter applied to it.
QUESTION NO: 55 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
QUESTION NO: 56 You do not have a physical time table in your database but would like to use the time series functions that OBIEE offers. What two options do you have?
A. Create a physical time table in your database.
B. Create a Logical Table that is sourced from the time key in the fact table.
C. Create an "Opaque View" in the physical layer that contains the time columns from the fact and map it into your physical model.
D. Create a Logical Table that is sourced from a time field in one of your dimension tables.
E. Create a time table that is joined through a intervening Table so there is no foreign key relationship.
QUESTION NO: 57 Identity the three advantages of the BI Server metadata repository.
A. Mapping of federated data sources to one logical object
B. Ability to change physical sources without losing reports
C. Little changes in the physical layer to shift from development to production environment
D. Three layers support the highest level of security
QUESTION NO: 58 The WebLogic Console will allow you to perform which of the following functions in the BI Managed Server?
A. Start and Stop BI Services
B. Build Aggregate Queries
C. Create Summary Tables
D. Manage user logins
QUESTION NO: 59 The Time Dimension hierarchy is a good example of a__________.
A. Level-based Time Dimension hierarchy
B. Ragged Hierarchy
C. Skip Level Hierarchy
D. Value-based Hierarchy
QUESTION NO: 60 When designing a Star Schema, which option does not apply?
A. The facts are quantifiable
B. The fact has several foreign keys that are primary keys in the dimensional table
C. Fact table is joined to the related dimensional tables.
D. Dimensional tables are normalized.
E. Dimensional tables have one attribute primary key as Product_ID for products.
QUESTION NO: 61 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 aggregation in the Content tab
C. By creating four new logical table sources and using the Fragmentation content to specify the aggregation levels
D. By creating four new logical table sources and using the "where" section of the Content tab to specify the aggregation levels
QUESTION NO: 62 Which of the following native features of Essbase are not supported in OBIEE 11g?
A. Member Alias
B. Alternate Hierarchies
C. Dynamic Time Series
D. Parent/Child-based Hierarchies
QUESTION NO: 63 A customer would like to create a change and a % Change for Revenue at the same time. How would they accomplish this?
A. Using the Expression Builder
B. Using the Calculation Wizard
C. Defining them in the physical data model
D. Defining them in the Presentation Layer
QUESTION NO: 64 When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard, which two statements are true?
A. The analyst must first write DML (Data Manipulation Language) scripts to create the aggregate table.
B. The Aggregate Persistence Wizard enables you to automate the creation of physical aggregate tables and their corresponding objects in the repository.
C. Job Manager can be used to run the Aggregate Persistence script.
D. The Extraction Transformation and Loading process creates the aggregate tables.
QUESTION NO: 65 Which three options apply to FMW Application Roles?
A. Provide an indirection between LDAP groups and BI roles
B. Can be exported / moved between FMW11g environments
C. Are created and managed by using the WLS Admin Console and FMW Control
D. Can be created by using BI Administrator Client and "pushed" to WLS Admin Console
E. Secures RPD permissions but NOT Web Catalog (webcat) permissions
QUESTION NO: 66 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
QUESTION NO: 67 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 A and B
D. By creating one new Logical Table Source
QUESTION NO: 68 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
QUESTION NO: 69 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
QUESTION NO: 70 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
QUESTION NO: 71 Identify the two types of storage for Essbase.
A. Aggregate Storage Option and Block Storage Option
B. Aggregate Storage and Cell Storage
C. OLAP Storage and Cell Storage
D. Aggregate Storage and Hybrid Columnar Compression
QUESTION NO: 72 Where is Cache in OBIEE located?
A. In relational database
B. It is local disk-based.
C. In dynamic aggregate
D. In memory cache
QUESTION NO: 73 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 Aggregate Table 1 the first table in the list of Logical Table Sources.
B. Do not map the logical level in the Content tab.
C. Set the Priority Group to 0.
D. Set the Priority Croup to 5.
QUESTION NO: 74 Which OBIEE capability enables developers to build Aggregate tables?
A. Aggregate Persistence Wizard
B. Expression Builder
C. Table Builder
D. Query Analyzer
QUESTION NO: 75 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. Parent Level
C. Child Level
D. Dynamic Key
