Olete.in – MCQs, Mock Tests & Government Job Prep | OBIEE 12C OBIEE 12C Mcq Question Set 1

Which of the following would be true when creating filters whose values automatically change with time?

1. You can meet the requirements by creating dynamic filters
2. You can meet the requirement by using parenthetical filtering
3. Filters cannot be combined with other column filters from the same subject area to further constrain the results of a request
4. The variables have to be constructed and saved in the repository to be used in Siebel

✅ Correct Answer: 1

Which of the following tasks can you perform in the Catalog Manager?

1. Set permissions for Web Catalog items
2. Manage privileges and rights given to groups and users
3. Set authentication options
4. Manage Web groups and users

✅ Correct Answer: 1

What type of access can view content, but not make changes?

1. No Access
2. Traverse Folder
3. Change/Delete
4. Read

✅ Correct Answer: 4

Where do you set the Logging level for a user?

1. BI Administration Tool
2. Answers
3. BI Publisher
4. None

✅ Correct Answer: 1

Which of the following charts would best suit your needs?

1. Bar charts
2. Area charts
3. Pareto charts
4. Scatter charts

✅ Correct Answer: 4

If you wish to drill down on a column heading, where would you add this functionality?

1. Select Column Properties and choose the Column Format tab
2. Modify the Physical Layer of the rpd
3. Edit the Column formula
4. Select Column Properties and choose the Conditional Format tab

✅ Correct Answer: 1

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?

1. Everyone Group
2. Authenticated Users Group
3. Web Administrators Group
4. Administrators Group

✅ Correct Answer: 3

The name of the symbolic URL has to be exactly the same as which of the following?

1. The name of the business component
2. The name of the calculated value of the field of the business component
3. The name of the Web template item of the business component
4. The name of the business object component

✅ Correct Answer: 2

The 12c version of the OBIEE was released in

1. 2010
2. 2001
3. 2000
4. 2015

✅ Correct Answer: 4

The Siebel IQY feature allows you to integrate data with:

1. Text Files
2. SQL
3. Access
4. Excel

✅ Correct Answer: 4

The measures in fact table are usually

1. 6
2. 4
3. 3
4. 5

✅ Correct Answer: 3

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?

1. Cascading Style Sheets
2. DHML Message files
3. XML Message files
4. Siebel Web Template items

✅ Correct Answer: 3

Log messages can be verified from?

1. Capacity Management Tab of Fusion MiddleWare
2. Diagnostics Tab of Fusion MiddleWare
3. Overview Tab of Fusion MiddleWare
4. Deployment Tab of Fusion MiddleWare

✅ Correct Answer: 2

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?

1. Column Selector
2. Row Selector
3. None of the Above
4. All the above

✅ Correct Answer: 1

Which of the following files specifies the current .rpd to the BI Server?

1. Nqsconfig.ini
2. Instanceconfig.XML
3. None
4. All of these

✅ Correct Answer: 1

Which statement is true?

1. If presentation column is renamed, a logical column will get auto-renamed
2. If presentation column is renamed, physical column will get auto renamed
3. If a Logical column is renamed, presentation column will get auto-renamed
4. If Logical column is renamed, physical column will get auto renamed

✅ Correct Answer: 3

Best option for cache management is?

1. Cache Seeding
2. Setting Event Pooling Table
3. Programmatic cache management
4. Cache Pruning

✅ Correct Answer: 2

Which of the following can be used for performance optimization when table size is too large?

1. Logical Joins
2. Sub Query
3. Derived Table
4. Complex Joins

✅ Correct Answer: 3

Which of the following is NOT true of the Intelligence Dashboards?

1. They can provide personalized views and preconfigured views
2. They can be created base on a user's permission
3. Users with common responsibilities or job functions can share a dashboard
4. Dashboard objects are saved in the repository

✅ Correct Answer: 4

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?

1. Row BBB
2. Row AAA and row CCC
3. Row AAA, row BBB, and row CCCD.
4. Row AAA, row BBB, row BBB, and row CCC

✅ Correct Answer: 1

Which of the Statement is/are incorrect:

1. Repository Import to be activated from utilities
2. Query Repository available in tools
3. Projects to be allotted for MultiUser Development
4. All are correct

✅ Correct Answer: 1

The latest release of the OBIEE was in

1. April 2014
2. April 2013
3. June 2013
4. March 2013

✅ Correct Answer: 2

Cache can be disabled from?

1. Capacity Management Tab of Fusion MiddleWare
2. Diagnostics Tab of Fusion MiddleWare
3. Overview Tab of Fusion MiddleWare
4. Deployment Tab of Fusion MiddleWare

✅ Correct Answer: 1

This is/are a dimension where data changes rapidly

1. Rapidly Changing Dimension
2. Slowly Changing Dimension
3. Junk Dimension
4. Degenerate Dimension

✅ Correct Answer: 1

Which of the following is NOT true of the Exhibit?

1. The query was filtered by the sales reps’ first names
2. The results’ layout includes Title, Chart, and Table views.
3. The query was sorted by the Dollars (ascending)
4. None of the above

✅ Correct Answer: 3

What can be used to customize the user interface in Siebel Analytics Web?

1. Dashboard Editor
2. Styles and skins
3. Scripts in installation folders
4. JavaScript

✅ Correct Answer: 2

Which of the statements is true of a view selector view?

1. It is used to show SQL generated for a request
2. It is used to show filters in effect for a request.
3. It is used to display results as a marquee (moving results that scroll across a page).
4. It is used to select a specific view of results from saved views.

✅ Correct Answer: 4

Which of the following would NOT be the best candidate for business intelligence tools such as Siebel Analytics?

1. Analyzing data that reside in many systems
2. Analyzing data that require accessing millions of records
3. Interactive and dynamic reporting
4. Merging two Excel files for operational processing

✅ Correct Answer: 4

Why would you set default values for global filters?

1. Because setting a default value creates a larger data set
2. Because not setting the value will return all the data and thus negatively impact performance
3. Because the user may want it to default to a certain value
4. Because Siebel 7.7 requires a default value be set

✅ Correct Answer: 2

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?

1. In Siebel Webcat
2. From the browser’s URL address window
3. In Siebel Intelligence Dashboard > Edit Dashboard
4. In Siebel Intelligence Dashboard > Admin > Manage Catalog

✅ Correct Answer: 3

Which of the following Dashboard contents can contain ActiveX objects, Java scripts, sound bites, or animation?

1. Links and images
2. Embedded content
3. HTML object
4. Folders

✅ Correct Answer: 3

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?

1. PortalBanner.css
2. Views.css
3. PortalContent.css
4. DashboardBanner.css

✅ Correct Answer: 3

Which of the following is NOT a correct step of how Siebel Analytics applications handle Answers requests?

1. 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
2. The Siebel Analytics Server, using the RPD, optimizes functions to request the data from the data sources
3. The Siebel Analytics Server receives the data from the data sources and processes as necessary
4. The Siebel Analytics Server passes the data to the Siebel Analytics Web Server

✅ Correct Answer: 1

Which of the following is NOT true of the Chart view?

1. You can change the axis scaling
2. You can change the chart legend
3. You can add titles to the axis
4. All columns have to be graphed

✅ Correct Answer: 4

Which of the following are true of iBots?

1. They are driven by events
2. They can execute scripts
3. They can trigger Siebel Workflow
4. They cannot be subscribed

✅ Correct Answer: 1

What is the term for the item used to align content on a dashboard?

1. Page
2. Results (reports)
3. Column
4. Builder

✅ Correct Answer: 3

Which of the statements are TRUE of Bulb gauges?

1. They show data with one or more indicator needles.
2. Their needles change position to indicate where data falls within predefined limits.
3. They are useful for scorecard-type output.
4. They show data using a circle.

✅ Correct Answer: 4

The Saved Selections options within Intelligence Dashboards allow you to ……

1. Switch between saved selections
2. Import saved selections from an Excel spreadsheet
3. Write saved selections to an Excel spreadsheet for import into other applications
4. none of the above

✅ Correct Answer: 1

Which of the following are some of the necessary steps when using iBots to trigger Siebel Workflow?

1. Workflow tasks such as policies and processes must be already set up in the Siebel eBusiness applications
2. Workflow policies named iBots must be set up in Siebel Tools
3. A workflow Policy Object named iBots has to be created in Siebel Tools
4. none of the above

✅ Correct Answer: 1

What is the default alignment for objects in sections of a dashboard?

1. Horizontal
2. horizontal or vertical (you set the default)
3. vertical
4. none of the above

✅ Correct Answer: 3

Which CSS (cascading style sheet) influences the overall appearance a of dashboard’s top section, including dashboard names and links?

1. Views.css
2. PortalBanner.css
3. DashboardBanner.css
4. PortalContent.css

✅ Correct Answer: 2

Which of the following is NOT true of the Siebel Analytics Repository?

1. Repository subject areas have a one-to-one correspondence to prebuilt Intelligence Dashboards
2. Prebuilt repository subject areas are exposed in Siebel Answers according to the user’s privileges
3. The prebuilt Siebel Analytics Repository has industry-specific stars that map to the SRMW and Siebel OLTP database
4. Business models cannot map to more than one database

✅ Correct Answer: 4

Where in the Siebel Analytics would you create Web groups and users?

1. Siebel Answers
2. Siebel Delivers
3. Siebel Intelligence Dashboards
4. Siebel Analytics Administration

✅ Correct Answer: 4

Which of them is/are not OBIEE Services to be started?

1. Java Host
2. Server
3. Presentation
4. Cache

✅ Correct Answer: 4

Which of them is/are not managed in Repository?

1. Jobs
2. Joins
3. Catalog
4. Variables

✅ Correct Answer: 3

Which of the Tools Utilities is not valid?

1. LTS Column / Table Replacement
2. Externalize String
3. Updating Row Count
4. Repository Documentation

✅ Correct Answer: 3

Type of Isolation Level including default are :

1. 4
2. 5
3. 6
4. 7

✅ Correct Answer: 2

What is/are not type of measure column?

1. Additive
2. Semi-additive
3. Count-additive
4. Non-additive

✅ Correct Answer: 3

Dimension that is/are derived from fact table and does not have its own dimension table

1. Rapidly Changing Dimension
2. Slowly Changing Dimension
3. Junk Dimension
4. Degenerate Dimension

✅ Correct Answer: 4

To overcome changing dimensions performance issue, we must create?

1. Mini Dimension
2. Segregate Dimension
3. Incident Dimension
4. Snapshot Dimension

✅ Correct Answer: 1