Home / CSE MCQs / SAP BW ::

CSE MCQs :: SAP BW

  1. Which of the following is correct about Profile Generator?
  2. A.
    It is a tool to automatically generate Authorization Profile
    B.
    It is a tool existing in OLTP systems only
    C.
    Complete the Administrator work with extra tasks to set up authorization
    D.
    A tool that can be used by end users to modify their authorizations

  3. Where can data transformation cannot take place in BW?
  4. A.
    Update rules
    B.
    Transfer rules
    C.
    Transfer routine
    D.
    Extract routine

  5. Which of the following is correct about SAP BW Statistics?
  6. A.
    Data volume of the SAP BW Statistics cannot be anticipated
    B.
    SAP BW Statistics are delivered as a part of the technical content
    C.
    All SAP BW Statistics query objects start with OSAP
    D.
    All SAP BW Statistics InfoObject catalogues start with OSAP

  7. The following statements are true for an info cube.
  8. A.
    Each characteristic of info cube should be assigned to at least one dimension
    B.
    One characteristic can be assigned to more than one dimensions
    C.
    One dimension can have more than one characteristic
    D.
    More than one characteristic can be assigned to one line item dimension

  9. The following statements are not true about navigational attributes
  10. A.
    An attribute of an info object cannot be made navigational if the attribute-only flag on the attribute info object has been checked
    B.
    Navigational attributes can be used to create aggregates
    C.
    It is possible to make a display attribute to navigational in an info cube data without deleting all the data from the info cube
    D.
    Once an attribute is made navigational in an info cube, it is possible to change it back to a display attribute if the data has been deleted from the info cube

  11. In SAP BW/BI what are the main areas and activities?
  12. A.
    Data Warehouse: Integrating, collecting and managing entire company's data
    B.
    Analyzing and Planning: Using the data stored in data warehouse
    C.
    Reporting: BI provides the tools for reporting in web-browser, Excel etc
    D.
    All of these

  13. Using BI accelerator the query performance can be boosted by
  14. A.
    10-100
    B.
    10-1000
    C.
    1-10
    D.
    None

  15. A setup table is basically a....
  16. A.
    Transparent Table
    B.
    Pooled table
    C.
    Cluster Table
    D.
    Structure

  17. Select the correct statements about ODS settings.
  18. A.
    Performance of the ODS activation improves when the BEx reporting flag is switched to off
    B.
    Overwriting a data record is not allowed if the 'unique' data record flag is set
    C.
    Data targets are updated from the ODS regardless of the ODS activation status
    D.
    All of the above

  19. What should you do after an InfoCube is converted to be in-memory optimized?
  20. A.
    Review customer-specific programs that access tables belonging to the InfoCube
    B.
    Delete obsolete process types from process chains containing the InfoCube
    C.
    Activate all MultiProviders that include the InfoCube
    D.
    Reload data into the InfoCube