OBIEE 12C/OBIEE 12C Mcq Question Set 2 Sample Test,Sample questions

  1. Home

Question: 
.............. 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

Question: 
A lookup transformation is used to look up data in

1.flat file

2.Relational table (wrong)

3.view

4.All of the above

Question: 
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

Question: 
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

Question: 
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

Question: 
Can we generate alpha-numeric value in sequence generator?

1. yes

2.no

3.all of the above

4.None of the mentioned

Question: 
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

Question: 
Dimension tables are denormalized in nature ? True or False.

1.true

2.False

3.all of the above

4.None of the mentioned

Question: 
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

Question: 
How can we load time dimension?

1.through Sql transformation

2.through Dimensional Loader (wrong)

3.Through Lookup

4.Through Store Procedure

Question: 
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

Question: 
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

Question: 
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

Question: 
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

Question: 
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

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

1.OLAP

2.OLTP

3.SMTP

4.FTP

Question: 
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

Question: 
What are the components of DAC

1. DAC Server

2.DAC Client

3.W ebLogic Server

4.Informatica Server

Question: 
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

Question: 
What are the types of groups in Router transformation?

1.User defined group

2.Multiple Group

3.Default Group

4.Single Group

Question: 
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

Question: 
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

Question: 
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

Question: 
What is default join of joiner?

1. Full Outer

2. Detail Outer

3.Normal

4.Master Outer

Question: 
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

Question: 
What is the default join of Source Qualifier?

1.Left Outer join

2.Equi Join

3.Inner-equi join

4.Outer join

Question: 
What is the default source option for update strategy?

1.Update or Delete

2.Update or Insert

3. Insert or Update

4. Date Driven

Question: 
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

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

1.Indexes

2.Tasks

3.Schemas

4.Workflows

Question: 
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

Question: 
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

Question: 
Which are the load types in Informatica session?

1.Bulk

2.Terse

3.Normal

4. All of these

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

1.degenerated

2. scd

3. junk

4. confirmed

Question: 
Which is both connected and unconnected?

1.External Store Procedure

2.Store Procedure

3.Lookup

4.Advanced External Procedure Transformation

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

1.Union

2.Intersect

3.Minus

4.SubSet

Question: 
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

Question: 
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

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

1.Information processing

2.Analytical processing

3.Data mining

4.Transaction processing

Question: 
Which of them is/are not Time Series Function?

1.Ago()

2. Todate()

3.Period()

4.PeriodRolling()

Question: 
Which of these is not Hierarchy type?

1.Skipped Hierarchy

2. Composite Hierarchy

3.Parent Child Hierarchy

4.Ragged Hierarchy

Question: 
Which one contains input and output transformations?

1. maplet

2.reusable transformation

3. reusable mapping

4.None of the mentioned

Question: 
Which one is not a designer tool creating transformations?

1.Transformation developer

2.Mapping designer

3. Mapplet designer.

4.target designer

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

1.FTP

2.Loader

3.MQ

4.ERP

Question: 
Which one is not an option in update strategy?

1. dd_reject

2.4

3.2

4.dd_delete

Question: 
Which one support heterogeneous join?

1.source qualifier

2.joiner

3. look up

4.None of the mentioned

Question: 
Which output file is not created during session running?

1.Session log

2.workflow log

3.Error log

4.cache files

Question: 
Which transformation acts like CASE.. WHEN in Sql?

1.filter

2.router

3.aggregator

4.look up

Question: 
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

Question: 
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

Question: 
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

Posted on by Online Exam TestTeam

More MCQS

  1. OBIEE 12C Mcq Question Set 1
  2. OBIEE 12C Mcq Question Set 2
Search
Olete Team
Online Exam TestTop Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on Online Exam Testwebsite is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!