🧪 OBIEE 12C MCQ Quiz Hub

1. Which of the following would be true when creating filters whose values automatically change with time?
You can meet the requirements by creating dynamic filters
You can meet the requirement by using parenthetical filtering
Filters cannot be combined with other column filters from the same subject area to further constrain the results of a request
The variables have to be constructed and saved in the repository to be used in Siebel

2. Which of the following tasks can you perform in the Catalog Manager?
Set permissions for Web Catalog items
Manage privileges and rights given to groups and users
Set authentication options
Manage Web groups and users

3. What type of access can view content, but not make changes?
No Access
Traverse Folder
Change/Delete
Read

4. Where do you set the Logging level for a user?
BI Administration Tool
Answers
BI Publisher
None

5. Which of the following charts would best suit your needs?
Bar charts
Area charts
Pareto charts
Scatter charts

6. If you wish to drill down on a column heading, where would you add this functionality?
Select Column Properties and choose the Column Format tab
Modify the Physical Layer of the rpd
Edit the Column formula
Select Column Properties and choose the Conditional Format tab

7. The members of which of the following groups can grant rights to users, set privileges to restrain access to any piece of information, and filter data so that the users have access to the data that are related to their role?
Everyone Group
Authenticated Users Group
Web Administrators Group
Administrators Group

8. The name of the symbolic URL has to be exactly the same as which of the following?
The name of the business component
The name of the calculated value of the field of the business component
The name of the Web template item of the business component
The name of the business object component

9. The 12c version of the OBIEE was released in
2010
2001
2000
2015

10. The Siebel IQY feature allows you to integrate data with:
Text Files
SQL
Access
Excel

11. The measures in fact table are usually
6
4
3
5

12. You would like to customize the text elements that appear in Siebel Answers, Siebel Delivers, and on dashboard pages. Which of the following would you use?
Cascading Style Sheets
DHML Message files
XML Message files
Siebel Web Template items

13. Log messages can be verified from?
Capacity Management Tab of Fusion MiddleWare
Diagnostics Tab of Fusion MiddleWare
Overview Tab of Fusion MiddleWare
Deployment Tab of Fusion MiddleWare

14. Which view allows you to see results by being able to substitute one or more of the columns at runtime with other columns chosen beforehand?
Column Selector
Row Selector
None of the Above
All the above

15. Which of the following files specifies the current .rpd to the BI Server?
Nqsconfig.ini
Instanceconfig.XML
None
All of these

16. Which statement is true?
If presentation column is renamed, a logical column will get auto-renamed
If presentation column is renamed, physical column will get auto renamed
If a Logical column is renamed, presentation column will get auto-renamed
If Logical column is renamed, physical column will get auto renamed

17. Best option for cache management is?
Cache Seeding
Setting Event Pooling Table
Programmatic cache management
Cache Pruning

18. Which of the following can be used for performance optimization when table size is too large?
Logical Joins
Sub Query
Derived Table
Complex Joins

19. Which of the following is NOT true of the Intelligence Dashboards?
They can provide personalized views and preconfigured views
They can be created base on a user's permission
Users with common responsibilities or job functions can share a dashboard
Dashboard objects are saved in the repository

20. Request 1 returns row AAA and row BBB. Request 2 returns row BBB and row CCC. An intersection of these two requests should produce which set of results?
Row BBB
Row AAA and row CCC
Row AAA, row BBB, and row CCCD.
Row AAA, row BBB, row BBB, and row CCC

21. Which of the Statement is/are incorrect:
Repository Import to be activated from utilities
Query Repository available in tools
Projects to be allotted for MultiUser Development
All are correct

22. The latest release of the OBIEE was in
April 2014
April 2013
June 2013
March 2013

23. Cache can be disabled from?
Capacity Management Tab of Fusion MiddleWare
Diagnostics Tab of Fusion MiddleWare
Overview Tab of Fusion MiddleWare
Deployment Tab of Fusion MiddleWare

24. This is/are a dimension where data changes rapidly
Rapidly Changing Dimension
Slowly Changing Dimension
Junk Dimension
Degenerate Dimension

25. Which of the following is NOT true of the Exhibit?
The query was filtered by the sales reps’ first names
The results’ layout includes Title, Chart, and Table views.
The query was sorted by the Dollars (ascending)
None of the above

26. What can be used to customize the user interface in Siebel Analytics Web?
Dashboard Editor
Styles and skins
Scripts in installation folders
JavaScript

27. Which of the statements is true of a view selector view?
It is used to show SQL generated for a request
It is used to show filters in effect for a request.
It is used to display results as a marquee (moving results that scroll across a page).
It is used to select a specific view of results from saved views.

28. Which of the following would NOT be the best candidate for business intelligence tools such as Siebel Analytics?
Analyzing data that reside in many systems
Analyzing data that require accessing millions of records
Interactive and dynamic reporting
Merging two Excel files for operational processing

29. Why would you set default values for global filters?
Because setting a default value creates a larger data set
Because not setting the value will return all the data and thus negatively impact performance
Because the user may want it to default to a certain value
Because Siebel 7.7 requires a default value be set

30. Which of the following is NOT where you can find the path to the request that you want to add to the new Analytics Dashboard view that you just created?
In Siebel Webcat
From the browser’s URL address window
In Siebel Intelligence Dashboard > Edit Dashboard
In Siebel Intelligence Dashboard > Admin > Manage Catalog

31. Which of the following Dashboard contents can contain ActiveX objects, Java scripts, sound bites, or animation?
Links and images
Embedded content
HTML object
Folders

32. Which CSS (cascading style sheet) influences the overall appearance of a dashboard’s main content area, including background color of dashboard page and page tab color?
PortalBanner.css
Views.css
PortalContent.css
DashboardBanner.css

33. Which of the following is NOT a correct step of how Siebel Analytics applications handle Answers requests?
The Siebel Analytics Server makes a request to the Siebel Analytics Web Server to retrieve the data request from a user through an Answers UI
The Siebel Analytics Server, using the RPD, optimizes functions to request the data from the data sources
The Siebel Analytics Server receives the data from the data sources and processes as necessary
The Siebel Analytics Server passes the data to the Siebel Analytics Web Server

34. Which of the following is NOT true of the Chart view?
You can change the axis scaling
You can change the chart legend
You can add titles to the axis
All columns have to be graphed

35. Which of the following are true of iBots?
They are driven by events
They can execute scripts
They can trigger Siebel Workflow
They cannot be subscribed

36. What is the term for the item used to align content on a dashboard?
Page
Results (reports)
Column
Builder

37. Which of the statements are TRUE of Bulb gauges?
They show data with one or more indicator needles.
Their needles change position to indicate where data falls within predefined limits.
They are useful for scorecard-type output.
They show data using a circle.

38. The Saved Selections options within Intelligence Dashboards allow you to ……
Switch between saved selections
Import saved selections from an Excel spreadsheet
Write saved selections to an Excel spreadsheet for import into other applications
none of the above

39. Which of the following are some of the necessary steps when using iBots to trigger Siebel Workflow?
Workflow tasks such as policies and processes must be already set up in the Siebel eBusiness applications
Workflow policies named iBots must be set up in Siebel Tools
A workflow Policy Object named iBots has to be created in Siebel Tools
none of the above

40. What is the default alignment for objects in sections of a dashboard?
Horizontal
horizontal or vertical (you set the default)
vertical
none of the above

41. Which CSS (cascading style sheet) influences the overall appearance a of dashboard’s top section, including dashboard names and links?
Views.css
PortalBanner.css
DashboardBanner.css
PortalContent.css

42. Which of the following is NOT true of the Siebel Analytics Repository?
Repository subject areas have a one-to-one correspondence to prebuilt Intelligence Dashboards
Prebuilt repository subject areas are exposed in Siebel Answers according to the user’s privileges
The prebuilt Siebel Analytics Repository has industry-specific stars that map to the SRMW and Siebel OLTP database
Business models cannot map to more than one database

43. Where in the Siebel Analytics would you create Web groups and users?
Siebel Answers
Siebel Delivers
Siebel Intelligence Dashboards
Siebel Analytics Administration

44. Which of them is/are not OBIEE Services to be started?
Java Host
Server
Presentation
Cache

45. Which of them is/are not managed in Repository?
Jobs
Joins
Catalog
Variables

46. Which of the Tools Utilities is not valid?
LTS Column / Table Replacement
Externalize String
Updating Row Count
Repository Documentation

47. Type of Isolation Level including default are :
4
5
6
7

48. What is/are not type of measure column?
Additive
Semi-additive
Count-additive
Non-additive

49. Dimension that is/are derived from fact table and does not have its own dimension table
Rapidly Changing Dimension
Slowly Changing Dimension
Junk Dimension
Degenerate Dimension

50. To overcome changing dimensions performance issue, we must create?
Mini Dimension
Segregate Dimension
Incident Dimension
Snapshot Dimension