SAP Bi Quiz (tbw42 Part 2)

26 Questions

Settings
SAP Quizzes & Trivia

Quiz for TBW42 Part 2 unit 4


Questions and Answers
  • 1. 
    On activation of an Info Cube the how many technical tables are generated for the fact table
    • A. 

      1

    • B. 

      2

    • C. 

      3

    • D. 

      4

    • E. 

      None

  • 2. 
    Regarding Info Cubes : The F Table is optimized for loading data and the E table is optimized for data Requests
    • A. 

      True

    • B. 

      False

  • 3. 
    On activation of info Cubes the "D" table (/BIC/D...) is generated for each Dimension 
    • A. 

      True

    • B. 

      False

  • 4. 
    The dimension tables contains the data for each Characteristic with a DIM ID as the primary key of the Table
    • A. 

      True

    • B. 

      False

  • 5. 
    In a ________ all descriptive attributes are located in other dimensions
    • A. 

      Degenerated Dimension

    • B. 

      Optimized Dimension

    • C. 

      Line item Dimension

    • D. 

      Non-Attribute Dimension

  • 6. 
    The setting _________ is used to change the method for dimention indexing in Oracle DB Only
    • A. 

      Optimized Indexing

    • B. 

      Low Indexing

    • C. 

      High Cardinality

  • 7. 
    Characteristics with an N:M relationship can be combined in the same dimension if the Maximum number of records are clearly defined and the Cartesian product of the Characteristic results only in a small dimension table 
    • A. 

      True

    • B. 

      False

  • 8. 
    The MultiProvider does not contain any data itself. Its data comes exclusively from the InfoProviders on which it is based, which are grouped together in a join operation.
    • A. 

      True

    • B. 

      False

  • 9. 
    A MultiProvider can be made up of various combinations of the following InfoProviders: InfoCube, DataStore object, InfoObject, InfoSet, VirtualProvider, and aggregation level.
    • A. 

      True

    • B. 

      False

  • 10. 
    Since MultiProviders do not save any data, performance aspects do not affect the way dimensions of the MultiProvider are modeled.
    • A. 

      True

    • B. 

      False

  • 11. 
    The MultiProvider also optimizes read access since _________ subqueries are executed on every InfoProvider involved in the MultiProvider.
    • A. 

      Optimized

    • B. 

      Parallel

    • C. 

      Smaller

  • 12. 
    You can include the __________ characteristic in the query selection criteria and specify the basic InfoProvider against which the query is executed.
    • A. 

      0SOURCE

    • B. 

      0INFOPROVIDER

    • C. 

      0INFOPROV

    • D. 

      0SUBSET

  • 13. 
    Do not use more than one InfoCube with non-cumulative key figures in a MultiProvider, otherwise the numbers in the query may be incorrect.
    • A. 

      True

    • B. 

      False

  • 14. 
    The tools of the OLAP for performance optimization (such as caching and aggregation) can be used for a MultiProvider even if the InfoProviders involved does not support these tools.
    • A. 

      True

    • B. 

      False

  • 15. 
    Parallel processing is not possible with InfoSets.
    • A. 

      True

    • B. 

      False

  • 16. 
    Infosets can be based on which of the following Info providers.
    • A. 

      Data Store Object

    • B. 

      Master data Charateristics

    • C. 

      Multiprovidors

    • D. 

      Infosource

    • E. 

      Infocubes

  • 17. 
    Wich of the following are joins supported by InfoSets
    • A. 

      Temporal Join

    • B. 

      Union

    • C. 

      Inner join

    • D. 

      Outer join

    • E. 

      Key join

  • 18. 
    When creating an InfoSet from several characteristics, you can map transitive attributes and use these to report on master data
    • A. 

      True

    • B. 

      False

  • 19. 
    A dimension for the valid time interval (VALIDTIMEINTERVAL) exists for each InfoSet that represents a temporal join. This is only visible in the Query Designer and only used for the time selection.
    • A. 

      True

    • B. 

      False

  • 20. 
    The term qualok refers to
    • A. 

      Quantity correct

    • B. 

      Quantity Unit conversion ok

    • C. 

      Qualitatively correct

    • D. 

      Quality of data model is correct/ok

  • 21. 
    Within an InfoSet, it is possible to access BI accelerator indexes.
    • A. 

      True

    • B. 

      False

  • 22. 
    For InfoSets it is possible to define an InfoCube as a right operand of a left outer join.
    • A. 

      True

    • B. 

      False

  • 23. 
    What is the Maximum amount of infocubes permitted in an Infoset?
    • A. 

      1

    • B. 

      2

    • C. 

      3

    • D. 

      4

  • 24. 
    Which of the following is not yet possible to remodel
    • A. 

      InfoCubes

    • B. 

      InfoObjects

    • C. 

      DataStore objects

  • 25. 
    In remodeling, you can use a customer exit to fill added or replaced characteristics and key figures with initial values. The interface _______ Should be used in such a case.
    • A. 

      IF_RSCNV_EXIT

    • B. 

      IF_RSCUST_EXIT

    • C. 

      IF_REMOD_CUST_EXIT

    • D. 

      IF_REMODEL

  • 26. 
    You cannot use the remodeling toolbox if:
    • A. 

      You want to use more than one characteristic in line item dimensions.

    • B. 

      You want to completely remove an existing dimension from an InfoCube or create a new dimension.

    • C. 

      Replace exsisting charateristics

    • D. 

      Delete key figures

    • E. 

      You want to change the granularity of the fact table for your InfoCube by adding or deleting characteristics.