SAP Hana Studio

40 Questions

Settings
Please wait...
SAP Hana Quizzes & Trivia

Test your SAP HANA skills. Good Luck !


Questions and Answers
  • 1. 
    SAP HANA database is ____
    • A. 

      A sort of SAP GUI used to access SAP servers.

    • B. 

      A general purpose ANSI compliant in-memory database.

    • C. 

      Used to store mountains of OLAP data.

    • D. 

      A hardware product made by hardware manufacturers.

  • 2. 
    • A. 

      It is a combination of software from SAP and certified hardware from vendors like Dell, IBM, Cisco, Fujitsu.

    • B. 

      It is a piece of hardware from vendors like Dell, IBM, Cisco, Fujitsu.

    • C. 

      Is solely produced by SAP AG only.

    • D. 

      It is a combination of BI, BOBJ and HANA.

  • 3. 
    What BI standards does HANA support? (3 correct answers)
    • A. 

      ODBC

    • B. 

      JDBC

    • C. 

      MDX

    • D. 

      MIME

  • 4. 
    Can SAP HANA database be used by any application, other than SAP?
    • A. 

      Yes

    • B. 

      No

  • 5. 
    SAP HANA server can be accessed by _______
    • A. 

      SAP GUI

    • B. 

      Any web browser

    • C. 

      Only Internet Explorer

    • D. 

      HANA Studio

  • 6. 
    What method is used to extract tables from ECC server in real time?
    • A. 

      SLT based table data provisioning

    • B. 

      Information Design Tool (IDT)

    • C. 

      BI R3 extraction services

    • D. 

      None of the above

  • 7. 
    Which one of the following are components of SAP HANA Studio?
    • A. 

      Navigator

    • B. 

      Job Log

    • C. 

      Where-Used List

    • D. 

      All of the above

  • 8. 
    How many perspectives are available in SAP HANA Studio (SPS03)?
    • A. 

      4

    • B. 

      8

    • C. 

      9

    • D. 

      10

  • 9. 
    Which perspective is used to create joins?
    • A. 

      Administration & Modeling

    • B. 

      Debug & Modelling

    • C. 

      Modeler

    • D. 

      All of the above

  • 10. 
    The SAP HANA system can be created within _____
    • A. 

      Modeler

    • B. 

      Resource

    • C. 

      Navigator

    • D. 

      SAP GUI

  • 11. 
    Can we create multiple connections to the same SAP HANA system?
    • A. 

      Yes

    • B. 

      No

  • 12. 
    The login user who has maximum authorizations in a SAP HANA database is ______
    • A. 

      SYS

    • B. 

      SYSTEM

    • C. 

      Administrator

    • D. 

      Root

  • 13. 
    Can the attribute views be created with 1 table?
    • A. 

      Yes

    • B. 

      No

  • 14. 
    By default, the maximum number of rows displayed from a table is ______
    • A. 

      1000

    • B. 

      5000

    • C. 

      Unlimited

    • D. 

      None of the Above

  • 15. 
    For faster reads, SAP HANA reads the tables column wise.
    • A. 

      True

    • B. 

      False

  • 16. 
    Using SAP HANA Studio, table can be _______, ________, _______ (3 correct answers)
    • A. 

      Created manually

    • B. 

      Created using SQL

    • C. 

      Replicated from other systems

    • D. 

      Just copied from other systems

  • 17. 
    When Administration Console is the perspective selected, which of the following can be viewed under HANA system?
    • A. 

      Catalog

    • B. 

      Content

    • C. 

      Both of them

    • D. 

      None of them

  • 18. 
    Ultimately, SAP HANA database will replace all databases used in BI/BW, ECC and all other SAP Systems.
    • A. 

      True

    • B. 

      False

  • 19. 
    In the SAP HANA Studio the physical tables are stored ______
    • A. 

      Under Catalogs

    • B. 

      Under Content

    • C. 

      In both

    • D. 

      Nowhere

  • 20. 
    When deleting a table, what options can be selected? (2 correct answers)
    • A. 

      Delete Catalog Object

    • B. 

      Delete All Rows

    • C. 

      Drop The Table

    • D. 

      All of the above

  • 21. 
    Users are created under ______
    • A. 

      Catalog

    • B. 

      Content

    • C. 

      Any of them

    • D. 

      None of them

  • 22. 
    Can SAP HANA run on SUSE Linux?
    • A. 

      Yes

    • B. 

      No

  • 23. 
    The option to send a table from Quality Assurance System to Production System is _______
    • A. 

      Use CTS+

    • B. 

      Use Import from Quality Assurance System

    • C. 

      Use Export from Quality Assurance System

    • D. 

      Use Transport Management System

  • 24. 
    To create a user, we have to ________
    • A. 

      Use T-Code SU01

    • B. 

      Use T-Code SU10

    • C. 

      Use Users folder under Authorization in Catalog

    • D. 

      Use Users folder under Authorization in Content

  • 25. 
    Which user has privileges to Root Package?
    • A. 

      SYS

    • B. 

      SYSTEM

    • C. 

      Both of the above

    • D. 

      Administrator

  • 26. 
    Which role is specifically assigned to a user involved in creating views?
    • A. 

      SAPSR3_POWER_USER

    • B. 

      PUBLIC

    • C. 

      MODELING

    • D. 

      None of the above

  • 27. 
    SAP HANA system is memory based and persistent storage is not necessary.
    • A. 

      True

    • B. 

      False

  • 28. 
    SAP HANA contains OLAP data (only) in the memory.
    • A. 

      True

    • B. 

      False

  • 29. 
    When you are creating a SAP HANA system in the SAP HANA Studio, a user should be used as the logon user. SYSTEM can be the only user for this purpose.
    • A. 

      True

    • B. 

      False

  • 30. 
    If you have only one SAP HANA system physically, then you can create only one HANA system icon in the SAP HANA Studio.
    • A. 

      True

    • B. 

      False

  • 31. 
    SAP HANA database is ______
    • A. 

      Oracle based

    • B. 

      Sybase based

    • C. 

      MS SQL based

    • D. 

      Informix based

  • 32. 
    Joins are created under ______
    • A. 

      Content

    • B. 

      Catalog

    • C. 

      Schema

    • D. 

      Authorization

  • 33. 
    In SAP HANA Studio, HANA systems can be created under nested folders identical to the departments in your company.
    • A. 

      True

    • B. 

      False

  • 34. 
    Calculation Views can be created under _______
    • A. 

      Schema

    • B. 

      Content

    • C. 

      Catalog

    • D. 

      HANA System

  • 35. 
    Calculation Views have 2 view types. They are _________, _________ (2 correct answers)
    • A. 

      Graphical

    • B. 

      SQL Script

    • C. 

      Analytic

    • D. 

      Attribute

  • 36. 
    Attribute View types are ________
    • A. 

      Standard

    • B. 

      Time

    • C. 

      Derived

    • D. 

      All of the above

  • 37. 
    Whenever a user is created, then a schema is created for that user.
    • A. 

      True

    • B. 

      False

  • 38. 
    Whenever a user is created, a package is created for that user.
    • A. 

      True

    • B. 

      False

  • 39. 
    Every user created at the OS level will be automatically created in the SAP HANA system as well.
    • A. 

      True

    • B. 

      False

  • 40. 
    Views are stored under the schema _______
    • A. 

      _SYS_BIC

    • B. 

      SYS_BI

    • C. 

      SYS_REPO

    • D. 

      SYS