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

Which of them is/are not Time Series Function?

1. Ago()
2. Todate()
3. Period()
4. PeriodRolling()

✅ Correct Answer: 3

What cannot be done in presentation layer of Repository?

1. Nesting of folders
2. Set implicit fact column
3. Permission grant to groups/users for security
4. Performing calculations of measures

✅ Correct Answer: 4

We can set Bridge table from

1. Properties of Physical Tables
2. Properties of Logical Table
3. Properties of LTS
4. Properties of Presentation Table

✅ Correct Answer: 2

For moving your shared dashboard and reports from dev to QA or Production you should:

1. paste dev catalog to qa / prod environment
2. paste only updated atr files to qa/prod
3. merge catalog changes through catalog manager
4. paste files and associated atr files to qa/prod

✅ Correct Answer: 4

You can apply restriction/ filtration to data in metadata repository in:

1. Physical Layer Alias Table
2. Logical Table
3. Logical Table Source
4. Presentation Table

✅ Correct Answer: 3

Which of these is not Hierarchy type?

1. Skipped Hierarchy
2. Composite Hierarchy
3. Parent Child Hierarchy
4. Ragged Hierarchy

✅ Correct Answer: 2

Repository can be uploaded/ updated 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: 4

You can start all BI services from fusion middleware 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: 3

A lookup transformation is used to look up data in

1. flat file
2. Relational table (wrong)
3. view
4. All of the above

✅ Correct Answer: 4

Which one support heterogeneous join?

1. source qualifier
2. joiner
3. look up
4. None of the mentioned

✅ Correct Answer: 2

Which output file is not created during session running?

1. Session log
2. workflow log
3. Error log
4. cache files

✅ Correct Answer: 4

Which is both connected and unconnected?

1. External Store Procedure
2. Store Procedure
3. Lookup
4. Advanced External Procedure Transformation

✅ Correct Answer: 1

Can we generate alpha-numeric value in sequence generator?

1. yes
2. no
3. all of the above
4. None of the mentioned

✅ Correct Answer: 2

What is meaning of tracing level?

1. Data store in cache (wrong)
2. Data store in database
3. Data store in log file
4. Data store in buffer

✅ Correct Answer: 3

Which one contains input and output transformations?

1. maplet
2. reusable transformation
3. reusable mapping
4. None of the mentioned

✅ Correct Answer: 1

Which dimension is collection of random transactional codes, flags and/or text attributes?

1. degenerated
2. scd
3. junk
4. confirmed

✅ Correct Answer: 3

Which one is not a target Option for file on the Servers?

1. FTP
2. Loader
3. MQ
4. ERP

✅ Correct Answer: 4

Which one is not a designer tool creating transformations?

1. Transformation developer
2. Mapping designer
3. Mapplet designer.
4. target designer

✅ Correct Answer: 4

What are the processes to do join the tables if the tables have no primary and foreign key relation and no matching port to join?

1. Add one dummy port in two sources.
2. Use Joiner transformation to join the sources using dummy port
3. Use Union
4. In expression trans assign '1' to each port

✅ Correct Answer: 2

What is the default source option for update strategy?

1. Update or Delete
2. Update or Insert
3. Insert or Update
4. Date Driven

✅ Correct Answer: 4

What is default join of joiner?

1. Full Outer
2. Detail Outer
3. Normal
4. Master Outer

✅ Correct Answer: 3

What is the default join of Source Qualifier?

1. Left Outer join
2. Equi Join
3. Inner-equi join
4. Outer join

✅ Correct Answer: 3

What are the types of groups in Router transformation?

1. User defined group
2. Multiple Group
3. Default Group
4. Single Group

✅ Correct Answer: 1

Dimension tables are denormalized in nature ? True or False.

1. true
2. False
3. all of the above
4. None of the mentioned

✅ Correct Answer: 1

How can we load time dimension?

1. through Sql transformation
2. through Dimensional Loader (wrong)
3. Through Lookup
4. Through Store Procedure

✅ Correct Answer: 4

Which are the load types in Informatica session?

1. Bulk
2. Terse
3. Normal
4. All of these

✅ Correct Answer: 3

Which load type we should use in case of less amount of data and recover session?

1. verbose
2. normal
3. bulk
4. All of these

✅ Correct Answer: 2

What is a mapplet?

1. Combination of reusable transformation.
2. Combination of reusable mapping
3. Set of transformations and it allows us to reuse
4. None of these

✅ Correct Answer: 3

Which one is not an option in update strategy?

1. dd_reject
2. 4
3. 2
4. dd_delete

✅ Correct Answer: 2

Which transformation acts like CASE.. WHEN in Sql?

1. filter
2. router
3. aggregator
4. look up

✅ Correct Answer: 2

What will happen if informatica server doesn't find session parameter and variable?

1. Work flow will fail
2. Automatically it will created
3. Give a message to user to put it
4. None of these

✅ Correct Answer: 1

If two tables emp_detail and emp_payroll contain EMP_ID1 and EMP_ID2 with a row with a null value, can joiner will match that null value?

1. yes
2. no
3. all of the above
4. None of the mentioned

✅ Correct Answer: 2

Can we run multiple execution plan at the same time in DAC?

1. Yes.
2. no
3. all of the above
4. None of the mentioned

✅ Correct Answer: 1

What are the components of DAC

1. DAC Server
2. DAC Client
3. W ebLogic Server
4. Informatica Server

✅ Correct Answer: 1

Can DAC send an email just in case of any failures?

1. Yes
2. no
3. all of the above
4. None of the mentioned

✅ Correct Answer: 1

What kind of DAC Repository Objects Held in Source System Containers?

1. Indexes
2. Tasks
3. Schemas
4. Workflows

✅ Correct Answer: 1

When you open a sales.rpd file in the BI Server repository directory, it displays a message “The repository sales.rpd can only be opened as Read-Only. Do you want to open it ?”. What is the correct statement ?

1. Oracle BI Presentation services is running
2. Sales.rpd file can be opened only in the Online mode
3. Oracle BI Server is running and Sales.rpd is the default repository
4. none of the above

✅ Correct Answer: 3

What do you use to Model a schema where the dimension table and the fact table have a many to many relationship ?

1. Complex Join
2. Aggregate Table
3. Helper Table
4. Bridge Table

✅ Correct Answer: 4

Which layer within the Oracle BI Repository provides customized, role based views to users who build analyses and other client applications ?

1. Physical Layer
2. ETL Layer
3. Business Model and Mapping Layer
4. Presentation Layer

✅ Correct Answer: 4

What is the name of the object that is used to initialize dynamic repository variable and system session variables for OBIEE Sessions ?

1. Tokens
2. Variables
3. Initialization Blocks
4. Meta Tags

✅ Correct Answer: 3

You can assign Administration & management rights to users / groups for answers/ dashboards or more products from?

1. Manage Sessions
2. Manage Interactive Dashboard
3. Manage Privilege
4. Manage Presentation catalog group or users

✅ Correct Answer: 3

Which is not valid type of set operation for combine with similar request?

1. Union
2. Intersect
3. Minus
4. SubSet

✅ Correct Answer: 4

How can you show updated changes made to online rpd, without restarting BI Services?

1. Restart Java Host Services (Weblogic / oc4j)
2. Reload EPT
3. Reload Server Metadata
4. Refresh Display

✅ Correct Answer: 3

If you want to limit / restrict data based on some dimension attribute, you should:

1. Use Filter option
2. Use Function Option
3. Use Column Format Option
4. Use Sorting Option

✅ Correct Answer: 1

Bins created in function are similar to:

1. Case Statement of Expression Function
2. Cast Statement of Conversion Function
3. Count Statement of Aggregate Function
4. RCount of Running Aggregate Function

✅ Correct Answer: 1

.............. is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisions.

1. Data Mining
2. Data Warehousing
3. Document Mining
4. Text Mining

✅ Correct Answer: 2

The data is stored, retrieved and updated in........

1. OLAP
2. OLTP
3. SMTP
4. FTP

✅ Correct Answer: 2

An ......... system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts.

1. OLAP
2. OLTP
3. Both of the above
4. None of the above

✅ Correct Answer: 1

Which of the following is not a kind of data warehouse application?

1. Information processing
2. Analytical processing
3. Data mining
4. Transaction processing

✅ Correct Answer: 4

In ODI, references can be represented by

1. Simple equalities between columns in tables
2. Complex relationships between columns in tables
3. Expressions that must evaluate to true or false
4. All of the above

✅ Correct Answer: 1