Query to get item on hand by org wise

Friday, November 18, 2022

Oracle Business Intelligence Explorer Test Q&A

 Hello
If you are trying to give the BIP Explorer test,
Below are the questions asked and answers

Explorer Name: Business Intelligence Explorer

Exam Link:
https://mylearn.oracle.com/learning-path/business-intelligence-explorer/80390


---------------------------------------------------------------------------------------------------------------------------------------
1.Which Oracle Transactional Business Intelligence (OTBI) tools can be used to create OTBI analyses? (Choose two)
ANS:
Report Editor
Report Creator
---------------------------------------------------------------------------------------------------------------------------------------
2.Which is the correct order of steps to create a BI Publisher report using the Guide Me wizard?
ANS:
Select Data > Select Layout > Create Chart > Create Table > Save Report
---------------------------------------------------------------------------------------------------------------------------------------
3.Which statement is true about BI Catalog?
ANS:
It is a repository of OTBI, BI Publisher, and Financial Reporting objects.
---------------------------------------------------------------------------------------------------------------------------------------
4.Which are the components of a BI Publisher report? (Choose three)
ANS:
Layout
Template
Data Model
---------------------------------------------------------------------------------------------------------------------------------------
5.What is bursting?
ANS:
The process of generating multiple documents from a report and delivering them to different destinations
---------------------------------------------------------------------------------------------------------------------------------------
6.You can embed an analysis, webpage, or document in a dashboard.
ANS:
True
---------------------------------------------------------------------------------------------------------------------------------------
7.How are the columns in a subject area's folder or subfolder arranged?
ANS:
Alphabetically
---------------------------------------------------------------------------------------------------------------------------------------
8.Which views can you select to display information in Oracle Transactional Business Intelligence? (Choose three)
ANS:
Graphs
Table
Tile
---------------------------------------------------------------------------------------------------------------------------------------
9.Which process options are available while running a report on the Scheduled Processes page? (Choose three)
ANS:
Language
Currency
Number Format
---------------------------------------------------------------------------------------------------------------------------------------
10.What is a data model?
ANS:
It is a report component that contains SQL queries to retrieve data and other elements like parameters and bursting definitions.
---------------------------------------------------------------------------------------------------------------------------------------
11.Which reporting objects can you create using Oracle Transactional Business Intelligence? (Choose three)
ANS:
Analyses
Data Models
Dashboards
---------------------------------------------------------------------------------------------------------------------------------------
12.What is the function of a translation in a BI Publisher report?
ANS:
Allows you to generate a report’s output in multiple languages at run time
---------------------------------------------------------------------------------------------------------------------------------------
13.The BI Answers tool is only used to create Oracle Transactional Business Intelligence analyses for ERP applications like Expenses.
ANS:
False
---------------------------------------------------------------------------------------------------------------------------------------
14.Multiple versions of a report can be created in a single run by selecting different layouts in the Output option of the Schedule Process page.
ANS:
True
---------------------------------------------------------------------------------------------------------------------------------------
15.Which tabs are available in the BI Answers work area? (Choose four)
ANS:
Results
Prompts
Views
Criteria
---------------------------------------------------------------------------------------------------------------------------------------
16.What is a subject area?
ANS:
It’s a collection of columns available to the report writer for creating reports.
---------------------------------------------------------------------------------------------------------------------------------------
17.Which icon in the BI Catalog toolbar do you use to view the owner or the last modified time of an object?
ANS:
Change-List View Type
---------------------------------------------------------------------------------------------------------------------------------------
18.Which tasks can be performed while editing an Oracle Transactional Business Intelligence analysis? (Choose three)
ANS:
Add or remove columns.
Define prompts.
Configure column properties.
---------------------------------------------------------------------------------------------------------------------------------------
19.Where are predefined reporting objects stored?
ANS:
Shared Folders
---------------------------------------------------------------------------------------------------------------------------------------
20.Which options are available in the Create drop-down list of the Reports and Analytics work area? (Choose two)
ANS:
Report
Analysis
---------------------------------------------------------------------------------------------------------------------------------------