MCQ with Answers: OBIEE, Informatica, DAC, ODI, Dataware house concepts

Section A(Informatica)

1. A lookup transformation is used to look up data in
      A.flat file

      B. Relational table (wrong)

      C. view

      D. synonyms

      E. All of the above

  Answer: E

2. Which one support heterogeneous join?
      A. source qualifier

      B. joiner

      C. look up

  Answer: B

3. Which output file is not created during session running?
      A. Session log

      B. workflow log 

      C. Error log

      D. Bad files

      E. cache files

   Answer: E

4.Which is both connected and unconnected?

      A. External Store Procedure

      B. Store Procedure

      C. Lookup

      D. Advanced External Procedure Transformation

   Answer: A, B, C

5. Can we generate alpha-numeric value in sequence generator?

       A. yes

       B.no

      Answer: B

6. What is meaning of tracing level?

     A. Data store in cache (wrong)

    B. Data store in database

    C. Data store in log file

    D. Data store in buffer

    Answer: C

7.Which one contains input and output transformations? 

    A. maplet

    B. reusable transformation

    C. reusable mapping

    Answer: A

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

    A. degenerated

    B. scd

    C. junk

    D. confirmed

    Answer: C

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

     A.FTP

    B. Loader

    C.MQ

    D.ERP
  Answer: D

10. Which one is not a designer tool creating transformations?
     A. Transformation developer

     B. Mapping designer

     C. Mapplet designer.

     D. target designer

    Answer: D

11. 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?

    A. Add one dummy port in two sources. 

    B. Use Joiner transformation to join the sources using dummy port 

    C. Use Union

    D. In expression trans assign '1' to each port
  Answer: A, B, D

12. What is the default source option for update strategy?

    A. Update or Delete

   B. Update or Insert

   C. Insert or Update

   D. Date Driven
  Answer: D

13. What is default join of joiner?

    A. Full Outer

    B. Detail Outer

    C. Normal

    D. Master Outer

    Answer: C

14.What is the default join of Source Qualifier?

     A. Left Outer join

     B. Equi Join

     C. Inner-equi join

     D. Outer join

     Answer: C

15. What are the types of groups in Router transformation?

     A. User defined group

    B. Multiple Group

    C. Default Group

   D. Single Group

Answer: A,C

16. Dimension tables are denormalized in nature ? True or False.

    A. true

    B. false

  Answer: A

17.How can we load time dimension?

     A. through Sql transformation

    B. through Dimensional Loader (wrong)

    C. Through Lookup

    D. Through Store Procedure

   Answer: D

18. Which are the load types in Informatica session?

    A. Bulk 

   B. Terse 

   C. Normal 

   D. All of these 

Answer: A, C

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

    A. verbose

    B. normal

    C. bulk

    D. All of these

   Answer: B

20. Which one is not correct about filter transformation?

    A. Act as a 'where' condition

    B. Can't passes multiple conditions

    C. Act like 'Case' in pl/sql

    D. If one record does not match condition, the record is blocked
    Answer: B

21. What is a mapplet?

    A. Combination of reusable transformation.

    B. Combination of reusable mapping

    C. Set of transformations and it allows us to reuse

    D. None of these
    Answer: C

22. Which one is not an option in update strategy?

    A. dd_reject

     B.4

     C.2

     D. dd_delete

     Answer: B

23. Which transformation acts like CASE.. WHEN in Sql?

      A. filter

      B. router

      C. aggregator

     D. look up

    Answer: B

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

      A. Work flow will fail

      B. Automatically it will created

      C. Give a message to user to put it

      D. none of these

      Answer: A

25. 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?

      A. yes

      B.no

    Answer: B

Section B(DAC)

1. Can we run multiple execution plan at the same time in DAC?
     A. Yes. 

     B. No

    Answer: A

2. What are the components of DAC

    A. DAC Server

    B. DAC Client

   C. W ebLogic Server

   D. Informatica Server

  Answer: A,B

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

   A. Yes

   B. No

   Answer: A

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

    A. Indexes

    B. Tasks

    C. Schemas

   D. Workflows

Answer: A, B

5. What is the default location where parameter files are created by DAC?

    A. $DAC_HOME\Informatica\server\parameters

    B. $DAC_HOME\Informatica\parameters

    C. $DAC_HOME\ parameters

    D. $DAC_HOME\ server\infa_shared\BWParam

  Answer: B

Section C(OBIEE)

1. In a dimensional model, if you want to capture history for a slowly changing dimension, what

Methodology would you use?

          A. Type I Slowly Changing Dimension

         B. Type II Slowly Changing Dimension

         C. Type III Slowly Changing Dimension

         D. Type IV slowly Changing Dimension

Answer:B

2. 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 ?

        A. Oracle BI Presentation services is running

        B. Sales.rpd file can be opened only in the Online mode

        C. Oracle BI Server is running and Sales.rpd is the default repository

        D. None of the above

Answer: C

3. What do you use to Model a schema where the dimension table and the fact table have a many t

o many relationship ?

    A. Complex Join

    B. Aggregate Table

   C. Helper Table

   D. Split Table

   E. Bridge Table

   Answer: E

4. Which layer within the Oracle BI Repository provides customized, role based views to users who

build analyses and other client applications ?

   A. Physical Layer

   B. ETL Layer

   C. Business Model and Mapping Layer

   D. Presentation Layer

   Answer: D

5. What is the name of the object that is used to initialize dynamic repository variable and system

session variables for OBIEE Sessions ?

    A. Tokens

    B. Variables

    C. Initialization Blocks

    D. Meta Tags

   Answer: C

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

    A. Manage Sessions

     B. Manage Interactive Dashboard

     C. Manage Privilege

     D. Manage Presentation catalog group or users

Answer: C

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

   A. Union

   B. Intersect

   C. Minus

   D. SubSet

   Answer: D

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

    A. Restart Java Host Services (Weblogic / oc4j)

    B. Reload EPT

    C. Reload Server Metadata

    D. Refresh Display

  Answer: C

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

     A. Use Filter option

     B. Use Function Option

     C. Use Column Format Option

    D. Use Sorting Option

   Answer: A

10. Bins created in function are similar to:

       A. Case Statement of Expression Function

       B. Cast Statement of Conversion Function

       C. Count Statement of Aggregate Function

       D. RCount of Running Aggregate Function

Answer:A

Section D(Data warehouse)

1. The full form of OLAP is
    A) Online Analytical Processing
    B) Online Advanced Processing
    C) Online Advanced Preparation
   D) Online Analytical Performance

   Answer: A

2. ......................... is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisions.
     A) Data Mining
     B) Data Warehousing
     C) Document Mining
     D) Text Mining

    Answer: B

3. The data is stored, retrieved and updated in....................
     A) OLAP
     B) OLTP
     C) SMTP
     D) FTP
    Answer: B

4. An .................. system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts.
    A)  OLAP
   B) OLTP
   C) Both of the above
   D) None of the above
   Answer: A

5. Which of the following is not a kind of data warehouse application?
    A) Information processing
    B) Analytical processing
    C) Data mining
    D) Transaction processing
   Answer: D

Section E(ODI)

1. If you want to populate several targets, you need to insert several data stores in the target area?

    A. True

    B. False

  Answer: B

2. In ODI, references can be represented by

    A. Simple equalities between columns in tables

    B. Complex relationships between columns in tables

    C. Expressions that must evaluate to true or false

    D. All of the above

    Answer: A, B

3. You manually add and edit some elements of a model by using the ODI designer. After the model is saved in ODI, these changes update the underlying model in the database

    A. True

     B. False

     Answer: B

4. In a given context, how many physical resources can a logical resource be mapped to at the most

     A. None

     B. One

     C. Two

      D. Any Number

     Answer:  B

5. The following steps are preformed to set up an ODI repository environment:

      1. Create repository storage space

     2. Create the master repository

    3. Create one or more work repositories

      A. True

      B. False

     Answer: A