SAP HANA Studio

40 Questions | Attempts: 2576
Share

SettingsSettingsSettings
SAP HANA Studio - Quiz

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. 
    What is SAP HANA Appliance?
    • 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

Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.