• Author / Uploaded
• Bhujangam Naidu

• Categories
• Base de datos Oracle
• Bases de datos
• Almacén de datos
• Caché (Computación)
• Inteligencia de negocios

Citation preview

Page |1 Oracle Business Intelligence Enterprise Edition Plus Implementation Boot Camp (Answer all questions in this section)

1. Which file is edited in order to change the repository loaded in the server memory? 1. NQQuery.ini 2. rpd_config.ini 3. DBFeatures.ini 4. NQSConfig.ini (*) Correct. The NQSConfig.ini file is edited in order to change the repository loaded in the server memory. 2. Data source specific features can be configured in: (Choose all correct answers) 1. Connection Pool Properties 2. ODBC or Native connection properties 3. A static file on the server (*) 4. Repository (*) Incorrect. Data source specific features can be configured in: the repository and a static file on the server. 3. Steps for creating requests in Oracle Answers include: (Choose all correct answers) 1. Adding filters to request (*) 2. Creating/Modifying request criteria (*) 3. Changing column order (*) 4. Changing metadata Correct. The steps for creating requests in Oracle Answers include: creating/modifying request criteria, changing column order, adding filters to request. 4. Requests are cached in OBI at the following levels (Select all that applies): (Choose all correct answers) 1. Browser (*) 2. Scheduler Server

Page 1 of 23

Page |2 3. Database Server (*) 4. Web Server (*) 5. Dashboards Incorrect. Requests are cached in OBI at the following levels: browser, web server and database server. 5. Aliases are used in the physical layer of OBI RPD to: 1. Hide original objects 2. Avoid circular joins (*) 3. Remove complexity Correct. Aliases are used in the physical layer of OBI RPD to avoid circular joins. 6. How is the Oracle BI Office client made available for a user to install? 1. It is available as a link on the dashboard (*) 2. It is automatically installed by the dashboard 3. Via a file distributed by the OBI Administrator 4. It is provided by the MS office installer Incorrect. The Oracle BI Office client is made available for a user to install as a link on the dashboard. 7. Which prompt can be created at report level? (Select all that applies) (Choose all correct answers) 1. Image Prompt (*) 2. Column level prompt (*) 3. Dashboard prompt Incorrect. The following prompts can be created at report level: Image Prompt and Column level prompt. 8. Write Back option can be enabled at column level? 1. True (*) 2. False Correct. Write Back option can be enabled at column level. 9. Values of non-system session variables are initialized by: 1. Initialization box (*)

Page 2 of 23

Page |3 2. Variable dialogue box 3. Security Manager 4. Variable manager Incorrect. Values of non-system session variables are initialized by the Initialization box. 10. Two fact tables can be joined directly in the BMM layer? Note: BMM layer always contains a perfect star, containing one logical Fact only 1. True 2. False (*) Incorrect. Two fact tables can not be joined directly in the BMM layer. 11.

Which type of variable can be used to store a value derived from the user? 1. Repository 2. Non-system Session 3. Presentation (*) 4. Static Correct. The Presentation variable can be used to store a value derived from the user.

12.

Calculated measures can be created in which of the following places? 1. All answers are correct. (*) 2. Physical column mappings 3. Request column function 4. Logical column expression Incorrect. Calculated measures can be created in: physical column mappings, logical column expression and request column function.

13.

Which default driver is created in system DSN during installation of OBIEE? 1. Analytics 2. AnalyticsWeb (*) 3. WebAnalytics 4. BIAnalytics

Correct. During installation of OBIEE AnalyticsWeb is the default driver created in system DSN. 14.

Complex joins can be create in the logical layer and physical layer.

Page 3 of 23

Page |4 1. True (*) 2. False Incorrect. Complex joins can be create in the logical layer and physical layer. 15. Values of the static repository variables are initialized in the variable dialog box. 1. True (*) 2. False Correct. Values of the static repository variables are initialized in the variable dialog box. 16. Presentation Variables derive their values when a user logs into the application. 1. True (*) 2. False Correct. Presentation Variables derive their values when a user logs into the application.

17.

Dashboard security can be enforced at all the following levels except: 1. Dashboard 2. Request 3. Request Column (*) 4. Page 5. Section Correct. Dashboard security can be enforced at all levels except Request Column.

18. Which of the following is not a Windows service associated with Oracle BI components? 1. OBI Presentation Server 2. OBI Office Engine (*) 3. OBI Server 4. OBI Java host 5. OBI Scheduler

Page 4 of 23

Page |5 Correct. OBI Office Engine is not a Windows service associated with Oracle BI components. 19.

Which of the following is a reserve system session variable? 1. USER (*) 2. RPDNAME 3. CONNECTIONPOOL 4. CURRENTDATE

Incorrect. "USER" is a reserve system session variable. 20. You can create single request using columns from various subject areas using following option: 1. Combine with similar request (*) 2. Narrative view 3. Java script 4. Compound layout view Correct. You can create single request using columns from various subject areas using following option: combine with similar request.

21. Objects are checked out for editing and check in for loading in the server memory in which of the following mode: 1. Both 2. Online (*) 3. Offline 4. All answers are correct. Incorrect. Objects are checked out for editing and check in for loading in the server memory in the online mode. 22.

Row wise initialization is enabled: 1. to initialize multiple users 2. to initialize multiple variables 3. to initialize multiple sessions 4. to initialize multiple values (*) Incorrect. Row wise initialization is enabled to initialize multiple values.

23.

Which default table is used for event polling ? Page 5 of 23

Page |6 1. Fact table 2. EPT table 3. Aggregate table 4. UET Table (*) Incorrect. UET Table is used for event polling.

24.

Consistency check can be performed for the following in the OBI repository: 1. Dimension Hierarchy 2. All answers are correct. (*) 3. OBI Repository 4. Specific Business Model

Correct. Consistency check in the OBI repository can be performed for the following: OBI Repository, Specific Business Model, and Dimension Hierarchy. 25. Which of the following is a correct expression to extract the value of a session variable? 1. value(nq_session.variable name) 2. valueof(variable name ) (*) 3. value(variable name) 4. valueof(session.variable name) Incorrect. "valueof(variable name )" is a correct expression to extract the value of a session variable. 26.

Which of the following is not a repository validation step? 1. Perform a consistency check in the admin tool 2. Run queries in OBI ODBC client 3. Execute Answers requests 4. Run SQL queries in Toad (*) Correct. Run SQL queries in Toad is not a repository validation step.

27. Which of the following files contains the name of the web catalog to be used by the OBI presentation server? Page 6 of 23

Page |7 1. instanceconfig.xml (*) 2. NQSConfig.ini 3. webconfig.xml 4. catalogconfig.xml Correct. instanceconfig.xml file contains the name of the web catalog to be used by the OBI presentation server. 28.

A common dimension joined to more than one fact tables is known as: 1. Mini dimension 2. Junk dimension 3. Degenerated dimension 4. Confirmed dimension (*)

Incorrect. A common dimension joined to more than one fact tables is known as "confirmed dimension". 29.

Which authentication methods are supported by OBI?

(Choose all correct answers) 1. LDAP Authentication (*) 2. Oracle Authentication 3. External Database Authentication (*) 4. OBI Repository Authentication (*) Correct. External Database Authentication, LDAP Authentication, OBI Repository Authentication are the authentication methods supported by OBI. 30.

Web Catalog can be opened in Catalog manager with following mode: 1. No answer is correct. 2. Both (*) 3. Online 4. Offline Correct. Web Catalog can be opened in Catalog manager with both: online or offline mode.

Page 7 of 23

Page |8

31.

OBIEE server is not supported on which of the following operating systems? 1. Solaris 2. Mac (*) 3. Linux 4. AIX Incorrect. OBIEE server is not supported on Mac operating system.

32. The Oracle BI office plug-in allows you to import the results of an OBI request into the following MS office applications (Select all that applies): (Choose all correct answers) 1. MS Visio 2. MS Project 3. MS Excel (*) 4. MS Word 5. MS PowerPoint (*) Incorrect. The Oracle BI office plug-in allows you to import the results of an OBI request into the following MS office applications: MS PowerPoint and MS Excel. 33.

Where is the instanceconfig.xml file located? 1. \OracleBIData\web\config (*) 2. \OracleBI\server\Repository 3. \OracleBIData\web\catalog 4. \OracleBI\server\Config Correct. The instanceconfig.xml file is located here: \OracleBIData\web\config .

34.

A user may belong to one or more user groups. 1. True (*) 2. False Correct. A user may belong to one or more user groups.

35. NQServer.log records information about query requests. Note: NQS Serverlog contains log of server activities (Startup, shut down etc.)

Page 8 of 23

Page |9 1. True 2. False (*) Incorrect. NQServer.log doesn't record information about query requests. 36. A logical column can be mapped to two separate physical columns from two separate databases. 1. True (*) 2. False Correct. A logical column can be mapped to two separate physical columns from two separate databases. 37. Conditional formatting can be applied on the following views (Select all that applies): (Choose all correct answers) 1. Table View (*) 2. Filter view 3. Pivot table view (*) 4. Pie chart view (*) Incorrect. Conditional formatting can be applied on the following views: Table View, Pivot table view, and Pie chart view. 38.

Fragmentation of physical tables provides better query performance. 1. True (*) 2. False Incorrect. Fragmentation of physical tables provides better query performance.

39. Multiple physical sources for a logical table can be used to configure the following scenarios: 1. Fragmentations 2. Aggregates 3. All answers are correct. (*) 4. Extension Tables Incorrect. Multiple physical sources for a logical table can be used to configure the following scenarios: aggregates; fragmentations; extension tables.

Page 9 of 23

P a g e | 10 40. What are different types of schemas used in dimensional modelling? (Select all that applies) (Choose all correct answers) 1. Normalized Schemas 2. Distributed Schemas 3. Star schemas (*) 4. Snowflake Schemas (*) Correct. Star schemas and Snowflake Schemas are used in dimensional modelling. 41. Oracle Application Server is required in order to run OBIEE. Note: An IIS server can be used in place of Oracle Application server 1. True 2. False (*) Correct. The Oracle Application Server is not required in order to run OBIEE. 42.

What types of graphs are available in OBIEE? (Select all that applies) 1. Radar 2. Pie 3. Pareto 4. Scatter 5. All answers are correct. (*)

Correct. The following types of graphs are available in OBIEE: Pie, Scatter, Radar, and Parreto. 43.

Conditional Formatting can be implemented on dashboards. 1. True (*) 2. False Incorrect. Conditional Formatting can be implemented on dashboards.

44.

Which of the following are the stages of OBI Implementation Methodology? 1. No answer is correct. 2. Formal review processes 3. Analysis, Design (*) 4. Activities, Inputs, Outputs

Page 10 of 23

P a g e | 11 5. Formal sign off Correct. The two stages of OBI Implementation Methodology are: analysis and design. 45. The analytics scheduler supports which two of the following scripting languages? (Choose all correct answers) 1. VBScript 2. Unix Shell Script (*) 3. JavaScript (*) 4. Python Incorrect. The analytics scheduler supports as scripting languages: JavaScripts and Unix Shell Scripts. 46.

Default look and feel of dashboards can be modified. 1. True (*) 2. False Correct. Default look and feel of dashboards can be modified.

47.

LDAP Stands for: 1. Lightweight distributed authentication protocol 2. Lightweight database authentication protocol 3. Lightweight database access protocol 4. Lightweight directory access protocol (*)

Correct. LDAP Stands for Lightweight Directory Access Protocol. 48.

Self joins can be created in the physical layer using: 1. Alias table (*) 2. Join manager 3. View 4. Not possible Correct. Self joins can be created in the physical layer using "Alias table".

49. What filter condition will be used for a column which is prompted on the dashboard?

Page 11 of 23

P a g e | 12 1. filter should be - is prompted (*) 2. filter should be - is in top 3. Is not null 4. Is equal to / Is in Correct. For a column which is prompted on the dashboard the filter condition to be used should be "is prompted". 50. A presentation catalog may contain logical tables from more than one business models. Note: One presentation catalog can be mapped to only one business model 1. True 2. False (*) Correct. A presentation catalog may not contain logical tables from more than one business models. ****************************************************************************************** **** 51. Which file is used by the Presentation Server to read the information related to a request format? 1. Dbfeatures.ini 2. NQSconfig.ini 3. No answer is correct. (*) 4. Instanceconfig.xml Incorrect. Nor NQSconfig.ini, or Dbfeatures.ini, or Instanceconfig.xml is used by the Presentation Server to read the information related to a request format. 52.

Which function does not belong to display functions group? 1. Truncate() (*) 2. Rank() 3. Msum() 4. TopN() Correct. The Truncate () function does not belong to display functions group.

53. Cache entries can be purged using the following methods (Select all that applies): 1. All answers are correct. (*)

Page 12 of 23

P a g e | 13 2. Manually from the cache directory 3. Using event polling tables 4. Automatically when the allocated space is filled up 5. From cache manager Incorrect. Cache entries can be purged using the following methods: from cache manager, manually from the cache directory, automatically when the allocated space is filled up, or using event polling tables.

54.

Which of the following is not true about Analytical Systems? 1. The data model is optimized for Query performance 2. They contain highly aggregated data 3. They are read Intensive 4. They contain normalized data (*) Correct. Analytical Systems do not contain normalized data.

55. Consistency Check will fail if logical column is not mapped to any physical column. Note: A logical column can be calculated from two other logical columns, hence need not be mapped to any physical table column 1. True 2. False (*) Correct. Consistency Check will not fail if logical column is not mapped to any physical column. 56. Import feature of the OBI repository allows you to import objects into the repository from: 1. From the database 2. From another multi dimensional source 3. From another repository 4. All answers are correct. (*) Correct. Import feature of the OBI repository allows you to import objects into the repository from: the database; another multi dimensional source; another repository.

Page 13 of 23

P a g e | 14 57. The dimension hierarchy defines the attributes of a dimension in what order of aggregation? (Choose all correct answers) 1. Highest level to lowest level (*) 2. Lowest level to highest level 3. Depends on the client (*) Incorrect. The order of aggregation in which the dimension hierarchy defines the attributes of a dimension is from highest level to lowest level and it depends on the client. 58.

Which of the following is an example of the Session variable? •

OLAP DSN

•

ETL Load Date

•

Top Customer by Revenue

•

User Organization (*)

Incorrect. User Organization is an example of the Session variable. 59.

Multiple repositories can be loaded on a single instance of Oracle BI server. 1. True (*) 2. False Incorrect. Multiple repositories can be loaded on a single instance of Oracle BI server.

60. When data is duplicated in more than one physical tables, one logical table source is mapped to multiple physical tables. Note: In this scenario, two separate logical sources mapped to two physical sources are created 1. True 2. False (*) Incorrect. When data is duplicated in more than one physical tables, two separate logical sources mapped to two physical sources are created.

Page 14 of 23

P a g e | 15

61.

Which type(s) of variables can be found in the Oracle BI administration tool?

(Choose all correct answers) 1. Session variables (*) 2. Dynamic variables (*) 3. Repository variables (*) 4. Static variables (*) 5. Global variables Correct. The static variables, dynamic variables, repository variables and session variables can be found in the Oracle BI administration tool. 62. Which of the following represents the correct directory path to the Oracle BI repository? 1. OracleBI\Server\Repository (*) 2. OracleBI\Config\Repository 3. OracleBI\rpd\Repository 4. OracleBI\metadata\Repository Correct. The correct directory path to the Oracle BI repository is OracleBI\Server\Repository. 63. Presentation tables in the RPD can be made cachable. Note: Only physical tables can be cached 1. True 2. False (*) Correct. Presentation tables in the RPD can not be made cachable. 64. NQSConfig.ini is a configuration file that stores critical information used by OBI server at startup. 1. True (*) 2. False Correct. NQSConfig.ini is a configuration file that stores critical information used by OBI server at start-up. 65.

Permissions can be assigned for which of the following objects? 1. Connection pools

Page 15 of 23

P a g e | 16 2. Reports 3. Subject Areas 4. All answers are correct. (*) 5. Dashboards Correct. Permissions can be assigned for the following objects: Dashboards, Reports, Subject Areas, Connection pools. 66.

In the "value based partition" which condition should be satisfied? 1. Tables have same columns and grain, but different values. (*) 2. Tables have different columns and store different information. 3. Tables have different columns and grain, but same values. 4. Tables have a different grain and often have different columns.

Correct. In the "value based partition" the following condition should be satisfied: the tables have to have the same columns and grain, but different values. 67. Which repository utility allows you to control the display of three layers of the repository. 1. Tools > Options > Tile when Resizing (*) 2. Tools > Options > Repository 3. Tools > Utilities > Repository Documentation 4. All answers are correct. Incorrect. The "Tools > Options > Tile when Resizing" repository utility allows you to control the display of three layers of the repository.

68. In a star schema, one fact is joined with one dimension. Note: Multiple dimensions are joined with one fact in a Star Schema 1. True 2. False (*) Incorrect. In a star schema, one fact is not joined with one dimension. 69.

Query limits can be enforced for: 1. Groups (*)

Page 16 of 23

P a g e | 17 2. Neither 3. Users 4. Both Incorrect. Query limits can be enforced for Groups. 70.

Which of the following is not a data partition method? 1. Value Based 2. No answer is correct. (*) 3. Fact Based 4. Level Based Incorrect. The following are data partitioning methods: fact based; level based; value based.

71. Native SQL queries can be executed in the OBI ODBC client. Note: Only logical queries can be executed in OBI ODBC client 1. True 2. False (*) Incorrect. Native SQL queries can not be executed in the OBI ODBC client. 72.

A dimension hierarchy is required for (Select all that applies):

(Choose all correct answers) 1. Aggregate navigation (*) 2. Drill down to detail level (*) 3. derived measures 4. Level based measures (*) Correct. A dimension hierarchy is required for level based measures, as well as to drill down to detail level and to aggregate navigation. 73.

Dimension tables contain characteristics that qualify facts. 1. True (*) 2. False

Correct. Dimension tables contain characteristics that qualify facts. 74.

ETL is used for: 1. De-normalizing a database schema 2. Creating Aggregate tables Page 17 of 23

P a g e | 18 3. All answers are correct. (*) 4. Building the Data Warehouse Correct. ETL is used for: building the Data Warehouse, creating Aggregate tables and denormalizing a database schema. 75.

Oracle BI Server uses all these configuration files, except: 1. DBFeatures.ini 2. NQSConfig.ini 3. DBStats.ini (*) 4. NQQuery.log

Incorrect. Oracle BI Server uses all these configuration files, except DBStats.ini .

76.

Which of the following is not an Oracle BI product offering? 1. Enterprise Edition 2. SMB Edition (*) 3. BI Applications 4. Standard Edition

Correct. SMB Edition it is not an Oracle BI product offering. 77. Which OBI component contains security information regarding permissions and privileges? 1. None 2. Repository 3. Oracle BI Web Catalog 4. Both (*) Correct. Both OBI components: Oracle BI Web Catalog and Repository contain security information regarding permissions and privileges. 78.

Which of the following is not a valid use of iBots. 1. Deliver requests to user's dashboards 2. Populate cache in the BI server 3. Kick off the ETL process (*)

Page 18 of 23

P a g e | 19 4. Deliver requests to user's devices 5. Clear cache from the server Correct. Kick off the ETL process is not a valid use of iBots. 79.

The data is stored in fact and dimension sources at: 1. Doesn't matter 2. Highest level of aggregation 3. Mixed levels of aggregation 4. Lowest level of aggregation (*)

Incorrect. The data is stored in fact and dimension sources at the lowest level of aggregation. 80. Which of the following objects are present in the logical layer of the repository? (Select all that applies) (Choose all correct answers) 1. Logical Table and Columns (*) 2. Connection Pool 3. Schema Folder 4. Dimension (*) Correct. The objects which are present in the logical layer of the repository are: the "Logical Table and Columns" and the "Dimension". 81. BI?

Which of the following is not a performance improvement technique in Oracle

1. Specifying a valid hierarchy for each dimension (*) 2. Enabling Cache 3. Avoiding Excessive metadata joins 4. Creating Aggregate Tables Incorrect. Specifying a valid hierarchy for each dimension is not a performance improvement technique in Oracle BI. 82.

Which system session variable is required for authentication? 1. LOCALE 2. LOGLEVEL 3. PROXY 4. GROUP Page 19 of 23

P a g e | 20 5. USER (*) Correct. The "User" system session variable is required for authentication.

83.

Execution precedence is specified for (Select all that applies):

(Choose all correct answers) 1. Session variable initialization blocks (*) 2. Repository variables 3. Static variables 4. Repository variable initialization blocks (*) Correct. Execution precedence is specified for: Session variable initialization blocks and Repository variable initialization blocks. 84.

"My Folder" objects can be shared with other users at the user's discretion. 1. True 2. False (*)

Correct. "My Folder" objects can not be shared with other users at the user's discretion. 85. Which approach is best suited for filtering a report based on a criteria not specified in that report? 1. Add SQL Expression 2. Filter based on result of another request (*) 3. Add Presentation variable Correct. The approach best suited for filtering a report based on a criteria not specified in that report is to filter based on result of another request. 86.

Web Groups can be assigned default dashboards. 1. True (*) 2. False

Correct. Web Groups can be assigned default dashboards. 87.

Real-time data access is more expensive than data warehousing. 1. True (*) 2. False

Page 20 of 23

P a g e | 21 Incorrect. Real-time data access is more expensive than data warehousing. 88. Dashboard prompts can be applied on a single page or on the entire dashboard. 1. True (*) 2. False Correct. Dashboard prompts can be applied on a single page or on the entire dashboard. 89.

Only one variable can be populated using one initialization block. 1. True (*) 2. False

Incorrect. Only one variable can be populated using one initialization block. 90. Which of the following components is responsible for determining the device that receives the alerts for a given user account? 1. Alerts 2. Dashboard 3. iBot 4. Delivery Profiles (*) Incorrect. The component Delivery Profiles is responsible for determining the device that receives the alerts for a given user account. 91.

Dashboard layout and default look and feel can be modified using: 1. Custom xml files 2. Custom Style Sheets (CSS) (*) 3. instanceconfig.xml file 4. Customer SQL queries

Incorrect. Dashboard layout and default look and feel can be modified using Custom Style Sheets (CSS).

92. Which of the following is not an effective performance improvement method for OBI? 1. Using Cache 2. Simplifying metadata structure 3. Creating User Groups (*)

Page 21 of 23

P a g e | 22 4. Analyzing database tables Incorrect. Creating User Groups is not an effective performance improvement method for OBI. 93. BI?

Which of the following components is not a pre-requisite for installing Oracle

1. Web Server 2. MS Office (*) 3. JDK Correct. MS Office is not a pre-requisite for installing Oracle BI. 94. Values of the dynamic repository variables are initialized and refreshed using the initialization box. 1. True (*) 2. False Incorrect. Values of the dynamic repository variables are initialized and refreshed using the initialization box. 95.

What are the types of joins used in a physical star schema?

(Choose all correct answers) 1. One to Many (Dimension to Fact) (*) 2. one to Many (Fact to Dimension) 3. Primary key - Foreign Key (*) 4. Many to Many 5. Complex (*) Incorrect. The types of joins used in a physical star schema are: Primary key - Foreign Key; Many to Many; One to Many (Dimension to Fact). 96.

A default initialization string is required for all variables. 1. True (*) 2. False Incorrect. A default initialization string is required for all variables.

97. 98. 99. 100. Page 22 of 23

P a g e | 23

Page 23 of 23