"When a customer wants to get sales numbers by day, how is data stored in the Star Schema, if the data is loaded nightly? A. The lowest level of aggregation B. The highest level of aggregation C. Multiple levels of aggregation D. Independently from aggregation level"	"Answer: A"
"The highest sales amount for this year is $10,000. If you create a rank measure for sales this year and display it on a report, the value will be________. A. $10,000 B. 0 C. 1 D. Year"	"Answer: C Explanation: The rank measure is numbered from 1. The highest sales amount will be ranked 1."
"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: B,E Explanation: B: Before you can run Oracle Business Intelligence 11g Installer, you must first create required Oracle Business Intelligence schemas in an unhardened database. You use a tool called the Repository Creation Utility (RCU) to create these schemas with the appropriate permissions and data. E: The database 11gR2 is required if you want to run the Oracle Business Intelligence Enterprise Edition Plus Samples One Oracle Database Preinstalled and not hardened to host the schemas"
"The administration tool is the developer's interface to the repository file. It allows the development of and changes to the metadata repository file. Which statement is true? A. Changes to the repository can only be carried out in offline mode. B. Multiple developers can work on one repository at the same time. Results can be merged later on. C. All aspects of security are being held in the repository file. D. Opening the rpd.file in online mode results in performance Issues for the application user."	"Answer: B Explanation: The Oracle BI repository development process adheres to the classic Software Configuration Management (SCM)process, which utilizes a three–way merge to manage concurrent development. The merge process involves three repositories: In a multiuser environment (MUDE), Developers check out the file and make changes locally. Then, these changes are automatically reconciled and merged into the master repository."
"Which installation option is used to install into an existing Fusion Middleware Home? A. Software Only Install B. Simple Install C. Enterprise Install D. Cannot install into an existing Fusion Middleware Home"	"Answer: A Explanation: The Software Only Install type installs the Oracle Business Intelligence software binary files in an Oracle home for later configuration as part of a Fusion Middleware deployment."
"What are the two methodologies that are followed within an OBIEE implementation? A. Do not use prototypes B. Use an iterative approach C. Start with a small model and then enhance the repository D. Start with a big repository and trim it down with the requirements"	"Answer: B,C Explanation:"
"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. OBIEE integrates with Planning directly through relational database access."	"Answer: A,B Explanation: A: * Combining Relational and OLAP Data Sources: Oracle’s Common Enterprise Information Model allows users to combine data from a relational system and an OLAP source in a single calculation. For example, a user can compare sales forecasts from an Oracle CRM System with budget data from an Oracle Essbase planning application. To clients of the Common Enterprise Information Model, the forecast and budget data appear to be from the same logical source. * The Essbase server provides advanced multi–user read and write capabilities, including data update and multi–user recalculation. Business users with front–end tools can write data back to a server and recalculate the data on a server using calculation scripts—key functionality to support sophisticated modeling and planning applications. * Using aggregate storage, Essbase serves a wide range of analytic needs—financial analysis, planning, budgeting, sales analysis, marketing analysis, supply–chain analysis, and pr"
"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 Explanation: Note 1: There are four types of variables that you can use: Session Repository Presentation Request Note 2: Session Variables A session variable is a variable that is initialized at login time for each user. When a user begins a session, the Oracle BI Server creates a new instance of a session variable and initializes it. There are as many instances of a session variable as there are active sessions on theOracle BI Server. Each instance of a session variable could be initialized to a different value. There are two types of session variables: System — A session variable that the Oracle BI Server and Oracle BI Presentation Services use for specific purposes. System session variables have reserved names that cannot be used for other kinds of variables (such as static or dynamic repository variables and non–system session variables). Non–system — A system variable that the administrator creates and names. For example, the administrator might create a SalesRegion non–"
"Which option is used to enter the rank function when creating a new rank measure? A. Initialization Block B. Expression Builder C. Connection Pool D. Web Catalog"	"Answer: B Explanation: Example (see step 4 and 5 below): Getting Top–N Sales Reps for Year and Year–1 1. Under the “Business Model and Mapping” Layer, right click the “F1 Revenue” and select “New Object” –> “Logical Column…” 2. In the “Logical Column” Window give for Name: Year Ago Revenue as seen below: 3. Goto the “Column Source” Tab and select “Derived from existing columns using an expression” radio button then click on the “Edit Expression” icon. 4. Enter the following expression in the “Expression Builder” Window by selecting “Functions” in the “Category:” list, “Time Series Functions” in the “Functions:” list then “Ago” “Time Series Functions:” section. 5. Select the “<<Measure>>” in the “Ago( )” function, then select “Logical Tables” in the “Category:” list, “F1 Revenue” in the “Logical Tables:” list, then double click the “Revenue” in the “Columns:” list. Etc."
"Query limits tab can be accessed through________. A. Security Manager, Query tab, Application role dialog box, Permissions B. Security Manager, Application Roles tab, Query dialog box, Permissions C. Security Manager, Application Roles tab, Application role dialog box, Permissions D. Security Manager, Application Roles tab, Application role dialog box, Query Properties"	"Answer: C Explanation: Query environment can be managed by setting query limits (governors) in the Repository (RPD) for particular Application Roles. You should always set query limits for particular application roles rather than for individual users. Steps: 1. Login to Repository using OBIEE Admin Tool 2. Navigate to Manage > Identity 3. Go to Application Role tab, choose the role and double click on it to open."
"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 Explanation: CurrentMonth can be calculated by a sql statement. Note: REPOSITORY VARIABLE(DYNAMIC) · Initialized when BI server is started · Assigned value dynamically based on the result of a query · Value is dependent of the sql provided in Initialization Block Create a dynamic variable and provide a Name and Default Initializer.Create a new initialization block by clicking on the New button in the above screen."
"12. WLS Embedded LDAP Server is managed by the Admin Server Console and supports which three options? A. Creating and Maintaining Users B. Authentication and Authorization C. Basic Directory for storing user details D. Subject area and row–level security, connection pool passwords E. Application of Session Variables as Data Filters"	"Answer: A,B,C"
"Point–and–click generation of case statement logic can be accessed via which option? A. Column Formula –> Bins tab B. Compound Layout C. Column Properties –> Conditional Format tab D. Advanced Tab E. Subject Area metrics"	"Answer: A Explanation: The “Edit Column Formula” dialog box has a second, Question No : 12 Question No : 13 14 very tiny tab called, “Bins.” You can use this tab to have OBIEE build a CASE statement for you in a formula (you can also create a CASE statement yourself by using one of the functions that appears under “Expressions” if you want). A CASE statement is a lot like an IF–THEN–ELSE statement, except that it’s a little easier to read when you have multiple options. Basically, it puts values in different buckets that you define."
"Which task can be performed after the Administrator link has been reached through logging into OBIEE? A. Associate map layers to columns B. Manage access to Subject Areas C. SSO enablement D. Start or Stop BI Managed Servers"	"Answer: A"
"Which three techniques are applied to support Failover? A. WebLogic Clustering B. Universal Installer > Scale Out BI System option C. OBIEE Clustering D. Vertical Scaleout"	"Answer: A,B,C Explanation: A: OBIEE 11g is centred on WebLogic Server as the underlying application server architecture. B: If you want to scale out this infrastructure, you would typically run the OBIEE 11g installer on a second server, and instead of choosing to do a new install, you’d choose to instead scale out the existing BI domain."
"The Oracle BI office plug–in allows you to import the results of an OBI request into which two MS applications? A. MS Visio B. MS Excel C. MS Project D. MS Word"	"Answer: B,D Explanation: Oracle Business Intelligence Office Plug–In is a Windows application that is Question No : 16< 17<br /> an optional feature under the Oracle Business Intelligence Presentation Services. The<br /> Plug–In provides a way to browse the Analytics catalog, select a report, and then drop that<br /> report into Microsoft Word or Excel.<br /> Reference: Oracle Business Intelligence Infrastructure Installation and Configuration Guide<br /> > Installing Individual Oracle BI Components >Installing Oracle BI Office Plug–In"
"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: A,B,C Explanation: See BI Home Page screenshot below: Note: The BI Home page contains the BI content catalog. Fusion Apps will use OBIEE web catalog to store all shipped reporting and analytics content. From the BI home page users can browse and view the entire BI content. The BI catalog folder structure will match the Fusion Apps main menu structure. Folder structure would be content driven not technology driven which would enable ease of navigation for fusion Apps users. Following content will be available under the BI catalog structure: BI Publisher Reports (regardless of data source) OTBI reports & dashboards OBIA dashboards & scorecards Financial Reporting Also, users can do some additional actions from the BI Home page like: Access personal and shared reports, View/ edit BI publisher report schedules, Launch BI tools for advanced actions and create new reports with report wizard. New reports created can be saved in BI catalog and added as embedded content within Fusion ap"
"A customer needs to have a calculation done prior to aggregating the data. How would you accomplish this? A. By creating a derived measure by using the Logical Columns available B. By creating a derived measure in the Column Mapping dialog box by using the physical table columns. C. By creating a derived measure by using Logic Columns available and changing the aggregation type D. By creating a derived metric by using the Expression Builder E. By creating a derived metric by using the Calculation Wizard"	"Answer: B Explanation: Question No : 18 19 Note 1: OBIEE offers two calculation types for measure in the repository: logical physical You can define calculations in either of the following ways: * Before the aggregation, in the logical table source. * After the aggregation, in a logical column derived from two other logical columns. For example: sum(col A) * sum(col B) Note 2: A measure column is a column unlike the baseline column that has a default aggregation rule defined in the Aggregation tab of the Logical Column dialog in the repository. Measure columns always calculate the aggregation with which they are defined. Measures need to be defined in a logical fact. Any column with an aggregation rule is a measure."
"Which resource identifies the OBIEE Web Catalog (webcat)? A. instanceconfig.xml B. RCU Schema C. Identity Store D. nqsconfig.ini E. Admin Server"	"Answer: A"
"The ODBC DSN is never used for _______. A. Initial import of the physical layer metadata on a Windows server B. Query execution and data access on a Windows server C. Initial import of the physical layer metadata, query execution, and data access on a Windows Server D. Changing passwords E. Comparing RPDs"	"Answer: E Explanation: You do not use ODBC DSN to compare repositories. Note: When an ODBC based application connects to a database, it connects to a logical name, the Data Source Name (DSN), which identifies the datasource to which it wants to connect. Some external repository of configuration information holds the various DSN values that are available, together with the necessary configuration and control information needed by the ODBC driver to establish a connection and manage usage of the data source. Question No : 19 Question No : 20 21 The DSN (data source name) is a data structure that contains the information about a specific data source (database, …), typically used by an ODBC driver to be able to connect to it. The DSN contains information about the data source such as: the name, the directory, and the driver. On Windows, the DSN also specifies the ODBC driver to be used to access the database."
"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."	"Answer: D Explanation: All metadata for cubes and dimensions is stored in the Oracle database and revealed in the data dictionary views, so that you can query the entire business model in SQL. Reference: Oracle OLAP User's Guide, What's New in Oracle OLAP?"
"When Exporting an Analysis from a Dashboard, which of the following is NOT an option? A. MS Excel B. MS Word C. PDF D. CSV"	"Answer: B Explanation:"
"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 database table."	"Answer: B Explanation: Ragged Hierarchies are hierarchies where some routes down the hierarchy are longer than others; for example, you may have an organizational hierarchy for salespeople where the overall boss has two assistant managers, one of them works on their own and another has three sales managers under them; some of those sales manager may have sales staff under them, and some sales staff may have trainees under them."
"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 Explanation: Denormalization is the process of intentionally backing away from normalization to improve performance by suppressing join and permitting the use of star transformation technique. Denormalization should not be the first choice for improving performance and should only be used for fine tuning of a database for a particular application."
"An organization has re–implemented one of its systems but has not moved history. One database has data for all years up to 2010 and the other has data for years from 2011 to the present. The organization needs data from the years 2010 and 2011 on a single report. How can you model this in the RPD? A. By creating two Logical Fact Tables for each database. B. By creating joins in the physical model so it looks like a single table. C. By creating two logical table sources, that specify in Content tab using the Fragmentation content areas to specify the years for each source. D. By creating two logical table sources and checking the “This Source should be combined with other sources at this level” box leaving the Fragmentation content area blank. E. By creating one logical table sources and checking the “This Source should be combined with other sources at this level” box."	"Answer: C Explanation: Note: This source should be combined with other sources at this level (check box) Description: Check this box when data sources at the same level of aggregation do not contain overlapping information. In this situation, all sources must be combined to get a complete picture of information at this level of aggregation. Note 2: To use a source correctly, the Analytics Server has to know what each source contains in terms of the business model. Therefore, you need to define aggregation content for each logical table source of a fact table. The aggregation content rule defines at what level of granularity the data is stored in this fact table. Question No : 25 24 Use the Content tab of the Logical Table Source dialog box to define any aggregate table content definitions, fragmented table definitions for the source, and Where clauses (if you want to limit the number of rows returned). Reference: Siebel Business Analytics Server Administration Guide > Creating and Admi"
"What are the two leading design solutions recommended by Oracle that you would use for performance? A. Design requests that use Complex Queries B. Avoid returning big data sets within the Dashboard C. Use Cache D. Avoid using Guided Navigation unless the data set is large"	"Answer: B,C Explanation: C: OBIEE Caching and Cache Seeding Cache is a component that improves performance by transparently storing data such that future requests for the same criteria can be served much faster. Like other application cache is not virtual memory in OBIEE. In OBIEE cache will be stored as files on the Hard Disk of the OBIEE Server in the form of files. By Default caching is enabled in the OBIEE server configuration. For time–consuming Dashboard Pages, we can use the concept of cache seeding in OBIEE, this can be configured as a scheduled job that will ensure that the data is cached and readily available as and when the user runs the dashboard."
"The WebLogic Repository Schema generated via RCU can be deployed to which three DBMS? A. Oracle RDBMS B. Microsoft SQL Server C. IBM DB2 D. Teradata"	"Answer: A,B,C Explanation: BIEE 11g Install High level Steps : Software Required 1. Database (Oracle, IBM DB2 or MS–SQL) 2. Repository Creation Utility (RCU) 3. OBIEE 11g (11.1.1.3 is latest OBIEE as of 30 April 2011) 4. WebLogic 10.3.3 (Optional – Only required for 64 bit machine or IBM AIX) 5. JDK 1.6 64 bit (Optional – Only required for 64 bit machine)"
"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 column Item number and using the count Function B. By creating a derived measure on the logical column item number and using the count distinct function C. By creating a derived measure based on the physical column item number and changing the aggregation method to count D. By creating a derived metric by using the Expression Builder"	"Answer: B"
"Which language is used by OBIEE to query Essbase? A. SQL B. LINQ C. MDX D. DMX"	"Answer: C Explanation: The Essbase cube looks just like any other relational star schema in my Presentation Layer, however when it is queried Oracle BI Server will issue MDX queries against a multi–dimensional data source, rather than an SQL query against a relational star schema."
"Which are the three types of tables available to physical tables in the physical layer? A. Physical Table B. Stored Proc C. Select D. View E. Table"	"Answer: A,B,C Explanation: Pull the table and column definition into the physical layer Use the OBIEE “import metadata” wizard to pull the table and column definition into the physical layer. The wizard is used so that all of the column definitions do not need to be manually added into the physical layer."
"Which option describes how OBIEE natively integrates with HFM? A. Through EPM Analytic Data Model (ADM) connectivity B. Direct relational database access C. Through Essbase connectivity D. OBIEE does not support HFM integration"	"Answer: A Explanation: BI EE uses the ADM driver to extract the data from HFM. Note: HFM (Hyperion Financial Management) Example: I EE connects to HFM through JavaHost. So, the setup for configuring the connectivity is to basically make the EPM environment variables available for access to BI EE. Before making the changes, there are a couple of things to be aware of 1. Ensure that DCOM is enabled on the BI Server machine. This is needed for HFM client to work/connect properly with HFM Server. 2. Ensure that HFM Client is installed. The above assumes EPM 11.1.2.x version. If you are on Hyperion 9.3.3, then you need to have the ADM drivers installed manually. All of this is documented clearly. So, rather than re–iterating that i will just point to the link here. Ensure that you follow all the steps mentioned in the docs else you will have issues in the connectivity. Once all the prerequisite steps are done, we start off with the metadata import process."
"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 Explanation: BSO is preferred to ASO in the following scenarios: * Top–down planning and allocation (Sales Forecasting) * Cost Allocations across products and customers (Profitability Analysis) * Currency conversion, inter–company eliminations(Financial consolidations)"
"What would you use to customize the text elements that appear on BI Analysis, Delivers and Dashboard pages? A. Cascading Style Sheets B. DHML Message files C. XML Message Files D. BI Presentation services web template"	"Answer: A Explanation: You can control the way that the interface for Oracle BI EE is displayed to users by creating skins and styles. While skins and styles are typically used to customize the look and feel of analyses and dashboards by providing logos, color schemes, fonts, table borders, and other elements, they can also be used to control the position and justification of various elements by including specialized style tags in the relevant style sheet (.css) file. You can check the directory skin location with a right click on a OBIEE dashboard page, select show source code and search “custom.css”."
"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 Data Layer"	"Answer: D Explanation:"
"Which two options are valid Repository Variable names? A. USER B. CurrentDay C. CurrentMonth D. Date"	"Answer: B,C Explanation: CurrentDay and CurrentMonth can be calculated by a sql statement. Note: REPOSITORY VARIABLE(DYNAMIC) · Initialized when BI server is started · Assigned value dynamically based on the result of a query · Value is dependent of the sql provided in Initialization Block Create a dynamic variable and provide a Name and Default Initializer.Create a new initialization block by clicking on the New button in the above screen."
"One benefit of adding a second table source that is joined to the first table source in the Physical Layer by a foreign key relationship is that______. A. Multiple SQL queries are performed B. Two SQL queries are performed to get data from both tables C. A single SQL query is performed to get data from both tables D. No SQL queries are performed against the source tables"	"Answer: C Explanation: A single query can be performed accessing data from both tables through a join on the columns in the foreign key relation."
"When creating a Security Realm in the WebLogic Console, which object is created? A. Groups B. Row Level Filters C. Server Password D. Single Sign On"	"Answer: A Explanation: Security Realms are an Oracle Platform Security Services concept and bring together sets of users, groups, providers and so on for a WebLogic domain."
"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. Cache can 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."	"Answer: C Explanation: In a standard OBIEE implementation, we generally want to purge and rebuild the cache after every ETL (extract, transform, and load) run."
"A customer has a requirement for rolling period calculations. What two additional steps will need to be done to enable this in the repository? A. Clicking the "Time" option in the Logical Dimension Dialog B. Designating a chronological key for every level of every dimension hierarchy C. Clicking the "Time" option in the Logical Table Source Dialog D. Designating a chronological key for every logical column in the Logical Table Source E. Specifying a sort order in the Logical Table dialog"	"Answer: A,B Explanation: Creating Logical Time Dimensions Compared to modeling an ordinary dimension, the time dimension requires just two additional steps: selecting the Time option in the Logical Dimension dialog, and designating a chronological key for every level of every dimension hierarchy. Note: Time dimensions and chronological keys. You can identify a dimension as a time dimension. At least one level of a time dimension must have a chronological key. The following is a list of some guidelines you should use when setting up and using time dimensions: * At least one level of a time dimension must have a chronological key. * All time series measures using the AGO, TODATE, and PERIODROLLING functions must be on time levels. AGO, TODATE, and PERIODROLLING aggregates are created as derived logical columns. Reference: Oracle Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition. Working with Logical Dimensions"
"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 Explanation: Users in Oracle BI Answers can create queries that span multiple subject areas, as long as the subject areas correspond to the same business model."
"Pre Deployment sign–off is a milestone for a OBIEE implementation and is based on successful completion of certain tasks. Which option is not one of them? A. Test Environment B. System Testing C. Performance Tuning D. Project initiation and resourcing E. Data Validation / Verification"	"Answer: D Explanation:"
"How will you model a Type II Slowly–Changing Dimension? A. Add an additional column to the dimension table to capture a version of change B. Overwrite an existing dimension table record with the changed record C. Add a new row to the dimension table with a new key for the changed record D. Do Nothing"	"Answer: C Explanation: Dimensional Modeling – Slowly Changing Dimensions * Type 1 – Overwrite Original Value A change does not require tracking * Type 2 – Add a new record With Type II SCD, a new version of the dimension record (row) is created, and the existing version is marked as history. Each row does not correspond to a different instance of an entity but a different “state”, a “snapshot” of the instance at a point in time. Note: Tracking changes in dimension is referred in datawarehousing as slowly changing dimensions. In the source system a lot of changes are daily made : new customers are added, addresses are modified, new regional hierarchies are implemented, or simply the product descriptions and packaging change. These sorts of changes need to be reflected in the dimension tables and in several cases, the history of the changes also needs to be tracked. By remembering history, we are then able to look at historical data and compare it to their current situation."
"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: A,B Explanation: Decrease query response time which will improve performance for Dashboards and Analysis."
"A customer frequently queries multiple dimension tables without a measure. What needs to be defined in the presentation layer? A. Logical Key B. Implicit Fact Column C. Alias D. Logical Column Name E. Custom Display Name"	"Answer: B"
"A customer needs to do a cross database join between two tables where, one of the tables has a small number of values and the other has a large number of values. How can you optimize the way the BI Server processes the query? A. By specifying a one–to–many join between the tables with the small and large numbers of values B. By specifying a driving table C. By specifying a many to one join between the tables with the small and large numbers of values D. By creating your logical join by using the Joins Manager E. By creating your joins by using the Business Model Diagram"	"Answer: B Explanation: You can specify a Driving table parameter in a complex join. Driving tables are for use in optimizing the manner in which the Oracle BI Server processes cross–database joins when one table is very small and the other table is very large. The BI Server will query the driving table (the small one) and will get a list of values. The BI Server will then generate a second SQL using a parameterized IN list with the values from the first query. Specifying driving tables leads to query optimization only when the number of rows being selected from the driving table is much smaller than the number of rows in the table to which it is being joined."
"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: B Explanation: Denormalized data in the transactional system could be divided into different tables to increase performance."
"Query Limits are used to manage Query environment in the repository for users and roles and can________. A. Control runaway queries B. Limit Queries by maximum run time C. Control aggregation D. Control User Authentication E. Control Write Back Capabilities"	"Answer: B Explanation: Query Limits. You can limit queries by the number of rows received, by maximum run time, and by restricting to particular time periods. You can also allow or disallow direct database requests or the Populate privilege."
"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 Explanation:"
"What are the two types of Session Variables? A. System B. Non System C. Static D. Dynamic"	"Answer: A,B Explanation: There are two types of session variables: System — A session variable that the Oracle BI Server and Oracle BI Presentation Services use for specific purposes. System session variables have reserved names that cannot be used for other kinds of variables (such as static or dynamic repository variables and non–system session variables). Non–system — A system variable that the administrator creates and names. For example, the administrator might create a SalesRegion non–system variable that initializes the name of a user's sales region. The administrator creates non–system session variables using the Oracle BI Administration Tool. Note: Session Variables A session variable is a variable that is initialized at login time for each user. When a user begins a session, the Oracle BI Server creates a new instance of a session variable and initializes it. There are as many instances of a session variable as there are active sessions on the Oracle BI Server. Each instance"
"Content that is saved in personal and shared folders can be browsed by using which view? A. Catalog B. Dashboard C. New –> Analysis D. Home E. Favorites"	"Answer: A Explanation: The Catalog Manager workspace enables you to view and work with catalog objects. It displays the following folders for an open catalog: The shared folder— Contains content that is shared among catalog users. This includes the preconfigured dashboards and analyses that are distributed with prebuilt applications, and other objects such as shared filters. The system folder — Contains administrative elements of Presentation Services. Some of these elements are distributed with the product, and others are configured by you as the administrator, such as privileges. Avoid modifying any files in this folder. Presentation Services uses these files internally and modifying them might cause unexpected results. The users folder — Contains content that catalog users with the appropriate permissions have saved to their personal folders, such as individual analyses. Reference: Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edit"
"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"	"Answer: B,C Explanation: The Oracle Business Intelligence (BI) Administration Tool can be used to build, modify, enhance, and manage an Oracle BI repository. C: To add a new user to a repository 1 Open a repository in the Administration Tool. 2 Display the security manager by selecting Manage > Security. 3 Select Action > New > User to open the User dialog box. 4 Type a name and password for the user. 5 If you want to log queries for this user in the query log, change the query logging level to 1 or 2. 6 Click OK. This creates a new user with default rights granted to it. Note: What is Oracle BI Admin Tool/Oracle Business Intelligence Administration Tool? Oracle Business Intelligence Administration Tool is Used to manage OBIEE server Available only for Windows operating systems. A Windows application that allows the BI Server administrator to create & edit repositories. Can edit repositories in either online or offline mode. Having a session manager and a cache manager in online mode."
"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"	"Answer: B,C"
"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"	"Answer: B Explanation:"
"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."	"Answer: A,B Explanation: It is a best practice to create aliases for all tables. Aliases are created in The Physical Layer of the repository. Some of the benefits of using aliases are given below: (A) * An alias is used to avoid circular joins and to configure self joins. * You can create a join relationship which is different than the actual foreign key relationship in the database. This helps in defining relationships to meet business model criteria. * Aliases can function in numerous ways to define business model e.g. a table can act both as a dimension and a fact using aliases. (B) * You can rename aliases to make physical and business model easier to understand."
"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 Explanation: The principal connection to an OBI Server inside the Oracle BI System is Made through an Odbc Connection. OBI Server can handle multiple repository but you can connect to only one at the same time by DSN Odbc Connection. Therefore, you must set up an ODBC connection for each repository."
"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."	"Answer: A,D Explanation: Modeling Time Series Function in OBIEE Modeling Time Series Data Time series functions provide the ability to compare business performance with previous Time periods, allowing you to analyze data that spans multiple time periods. For example, time series functions enable comparisons between current sales and sales a year ago, a month ago, and soon. Because SQL does not provide a direct way to make time comparisons, you must model time series data in the Oracle BI repository. First, set up time dimensions based on the period table in your data warehouse. Then, you can define measures that take advantage of this time dimension to use the AGO, TODATE, and PERIODROLLING functions."
"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"	"Answer: A,C,D"
"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 SummaryTables D. Manage user logins"	"Answer: A"
"The Time Dimension hierarchy is a good example of a__________. A. Level–basedTime Dimension hierarchy B. Ragged Hierarchy C. Skip Level Hierarchy D. Value–based Hierarchy"	"Answer: A"
"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."	"Answer: D"
"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 aggregationin the Content tab C. By creatingfour 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"	"Answer: B"
"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"	"Answer: C"
"A customer would like to create a change and a % Change for Revenue at the same time. How would they accomplish this? A. Using theExpression Builder B. Using the Calculation Wizard C. Defining them in the physical data model D. Defining them in the Presentation Layer"	"Answer: B"
"When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard, which two statements are true? A. The analyst mustfirstwrite DML (Data Manipulation Language) scriptstocreate the Aggregate table. B. TheAggregate Persistence Wizard enables youto automate the creation of physical Aggregate tables and theircorresponding objects in the repository. C. Job Managercanbe used to run the Aggregate Persistence script. D. TheExtractionTransformation and Loading process creates the aggregate tables."	"Answer: B,C"
"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"	"Answer: A,B,C"
"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"
"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"
"Which Oracle Partner is the supplier of map–based content to provide background maps,<br /> Boundary information, and points of interest?<br /> <br /> A. Navteq<br /> B. TeleAtlas<br /> C. Google<br /> D. ESRI"	"Answer: A"
"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"
"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"	"Answer: D"
"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"	"Answer: A"
"Where is Cache in OBIEE located? A. In relational database B. It is local disk–based. C. In dynamic aggregate D. In memory cache"	"Answer: B"
"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 AggregateTable 1 the first table in the list ofLogical TableSources. B. Do not map the logical levelin the Content tab. C. Set the Priority Group to 0. D. Setthe Priority Croup to5"	"Answer: C"
"Which OBIEE capability enables developers to build Aggregate tables? A. Aggregate Persistence Wizard B. Expression Builder C. Table Builder D. Query Analyzer"	"Answer: A"
"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"
"What are the two types of Repository Variables? A. System B. Non System C. Static D. Dynamic"	"Answer: C,D"
"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"
"What are the two capabilities that users can apply to an Analysis when working within Plug–In for MS Office? A. Edit Analysis B. Refresh All C. Edit Prompts and Levels D. Publish"	"Answer: B,C"
"Which three components are part of a cluster server? A. Master Server B. Repository Publishing Directory C. Primary Cluster Controller D. Web Server E. Server request Controller"	"Answer: A, C, D"
"If Security attributes conflict, what happens? A. The user or application role is granted the minimum security attribute B. The user or application role is granted the maximum security attribute C. The user or application role is granted No security attribute D. The user or application role is granted the Fully Restrictive security attribute"	"Answer: A"
"How do Dynamic Repository Variables differ from Static Repository Variables? A. Dynamic Repository Variables are not initialized by the Initialization Block. B. Dynamic Repository Variables cannot be used in the Expression Builder. C. Dynamic Repository Variables can be changed by data that is returned from queries. D. Dynamic Repository Variables cannot be used in a CASE statement."	"Answer: C"
"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."	"Answer: D"
"Which two options are included in Oracle BI Server cache management techniques? A. Using NQSConfig.ini to manually edit the parameters B. Scheduling Server password C. Maximum Number of Rows to Download to Excel D. Inspecting the cache reports E. Manage access to Subject Areas"	"Answer: A,D"
"To add multiple sources to on existing logical table dimension in the Business Model and Mapping layer, the source of the data must first exist in which option? A. Presentation Layer B. Business Aggregate Layer C. PhysicalLayer D. WebCatalog"	"Answer: C"
"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"
"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"
"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"
"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"
"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: D"
"What are the two disadvantages of implementing Query Caching? A. Reduction in BI server processing time B. Cache results being old C. Storage space for cache D. Increased network traffic E. Needs a lot of administrators’ time"	"Answer: B,C"
"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"
"Derived metrics are_____. A. Derived from other logical columns B. Derived from other physical columns C. Used to apply pre–aggregation calculations to measures D. Used to rename measures to user–friendly names"	"Answer: A"
"Which variable does not use initialization blocks to initialize its values? A. Static Repository Variable B. Dynamic Repository Variable C. System Variable D. Non System Variable"	"Answer: A"
"An organization has its employees’ names in an Employees table, and information about their jobs in a Jobs table. However, an organization’s employees can have multiple jobs, and the same job can be performed by multiple employees. This situation would result in a many to–many relationship between the Employees and Jobs tables. How can the many to–many relationship issue be resolved? A. By modeling the many to many relationshipin the business model B. By creating a bridge table that represents one employee doing one job, with several rows for an employee who has several jobs C. By creating the many to many join in the physical model D. By creating a logical table source (LTS) that joins the Employees and Jobs tables"	"Answer: B"
"Oracle BI Server at a company is connected to Data Warehouse that is refreshed on a daily basis, the majority of users at the company log in to Oracle BI every Monday to generate the previous week’s sales report. The BI Administrator schedules cache purge and cache seeding to improve report response times. How is this accomplished? A. Everyday before Data Warehouse refresh B. Every day after Data Warehouse refresh C. Every Monday early morning D. Every Monday late night"	"Answer: C"
"Oracle BI Server cache setup information is configured by using Enterprise Manager Fusion Middleware control. Which component stores the configuration Information? A. NQSConfig.ini B. Cache table in OBIEE repository C. WebCatalogue D. Instanceconfig.xml"	"Answer: A"
"What must be done before you can run the Oracle Business Intelligence 11g Installer? A. Obtain BI installation media B. Create required Oracle Business Intelligence schemas in a database C. Ensure system meets installation requirements for Fusing Middleware, Oracle Business Intelligence, AND Repository Creation Utility D. Install the WLS Admin Server E. Select installation components OBIEE, BIP, RTD"	"Answer: A,B,C"
"Which option does not describe Aggregate tables? A. Aggregate tables increase query performance by pre–calculating frequently accessed Measure aggregations. B. Aggregate tables relieve bottlenecks and pre–calculate and store the data for better Query response. 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 the BIServer."	"Answer: D"
"Security Manager is used for______. A. Setting permissions for particular users or application roles B. Setting permissions for individual objects in the Presentation Layer C. Setting up new Roles and Groups D. Setting up new Application Roles"	"Answer: A"
"Which configuration can be changed through Enterprise Manager? A. Minimum Number of Rows to Download to Excel B. The default BI Server Repository C. Start and Stop BI Services D. Manages user login"	"Answer: B"
"Which two Oracle BI Components contain security information regarding permissions And privileges? A. The Web Catalog B. The Repository C. NQSConfig.ini File D. NQServer.ini File E. InstanceConfig.xml File"	"Answer: A,B"
"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: A,C"
"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: A,B"
"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"
"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"
"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."	"Answer: A"
"Initialization Blocks are never used to initialize which option? A. Dynamic Repository Variables B. System Session Variables C. Non System Session Variables D. rpd file"	"Answer: D"
"What must be purchased when integrating Oracle map with Oracle BI? A. Oracle Mapviewer B. Oracle Business Intelligence Enterprise Edition C. Spatial Option with Database D. OLAP option"	"Answer: A"
"The customer is questioning the necessity to have a data warehouse in place. They want to run OBIEE against various transactional systems. Identify the two limitations. A. Operational system might be overburdened with analytical requests resulting in had performance for transactional processes. B. TheBIserver cannot integrate various sourcesin one metadata model. C. Dataquality issues might emerge, due to missing data cleansing. D. Business issues are depending on real–time data."	"Answer: A,C"
"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"
"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"	"Answer: A"
"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"	"Answer: D"
"Selecting the Manage Map Data link allows one to do which three of the following? A. Associate map layers to columns defined in the OBIEE metadata B. Create a new map layer C. Set the zoom level of an imported map D. Import images for use on maps"	"Answer: A,C,D"
"Which option is not an example of a level–based measure? A. Regional Revenue B. Sales C. Brand Cost D. Employee Salary"	"Answer:B"
"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: A,B,C"
"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: C,D"
"An integrated BI tools business case can be built around which three options? A. Scalability B. Fault tolerance C. Cost Savings D. Development efficiency"	"Answer: A,C,D"
"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"
"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: A,D"
"When creating an initialization Block, which BI Administration function is used? A. Variable Manager B. Job Manager C. Identity Manager D. Projects Manager"	"Answer: A"

Descubre

Crear Tarjetas

Acerca de Nosotros

Explore Tarjetas

Comparta este Set de Tarjetas de Aprendizaje

Tarjetas de Aprendizaje relacionadas

120

Cómo estudiar sus tarjetas

Rango de Cartas a estudiar

120 Cartas en este set