How Well Do You Know About SAP HANA?

75 Questions | Total Attempts: 251

SettingsSettingsSettings
How Well Do You Know About SAP HANA? - Quiz

SAP HANA is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE. Its primary function as the software running a database server is to store and retrieve data as requested by the applications. How well do you know about SAP HANA?


Questions and Answers
  • 1. 
    Which recent technology advances have made SAP HANA possible?
    • A. 

      Faster internet speeds

    • B. 

      Large and cheaper memory

    • C. 

      Multi-core processors

    • D. 

      Faster disk speeds

  • 2. 
    What are the key features of SAP HANA?
    • A. 

      In-memory database

    • B. 

      Automatic compression of data

    • C. 

      Removes the need for security screening

    • D. 

      Combines database (OLTP) and data processing (OLAP) in one platform

  • 3. 
    What is SAP HANA Live?
    • A. 

      Consumption ready views of operational data that is sourced from SAP systems

    • B. 

      Out of the box ready applications and systems

    • C. 

      Supplied tools to explore and extend the SAP HANA Live content

    • D. 

      A twice yearly check up and update of the system

  • 4. 
    SAP HANA can be used in which scenarios?
    • A. 

      To power Enterprise Suites

    • B. 

      To replace ABAP 

    • C. 

      As a general purpose database

    • D. 

      For OEM partners to embed their SAP HANA into their applications

    • E. 

      As a data warehouse

  • 5. 
    SAP HANA security services include which of the following?
    • A. 

      Audit logging

    • B. 

      Authentication

    • C. 

      Encryption

    • D. 

      Antivirus protection

    • E. 

      Authorisation

  • 6. 
    What is the Business Function Library?
    • A. 

      SAP defined re-useable building blocks for SAP HANA based applications

    • B. 

      An interface to allow fine tuning of business logic

    • C. 

      A list of published BAPIs that can be called from SAP HANA

    • D. 

      A dedicated SAP HANA engine optimized for business functions

  • 7. 
    Which open source language do you use to create custom predictive algorithms?
    • A. 

      R

    • B. 

      L

    • C. 

      C++

    • D. 

      ABAP

  • 8. 
    With fuzzy search, when I enter ', what does SAP HANA return?
    • A. 

      Words that are closely matched in spelling

    • B. 

      Words that are closely matched in meaning

  • 9. 
    How would you most likely represent the location of an ATM in a visual application that uses SAP HANA spatial processing?
    • A. 

      Multi-polygon

    • B. 

      Polygon

    • C. 

      Line

    • D. 

      Point

  • 10. 
    Which are valid SAP HANA Live views?
    • A. 

      Private

    • B. 

      Re-use

    • C. 

      Shared

    • D. 

      Secured

  • 11. 
    SAP recommends to use which of these types of view?
    • A. 

      Calculation

    • B. 

      Attribute

    • C. 

      Database

    • D. 

      Analytical

  • 12. 
    What are the two storage components used to restore the database in case of power failure?
    • A. 

      Log area

    • B. 

      Data volume

    • C. 

      Memory

    • D. 

      Delta store

  • 13. 
    What are advantages of column store tables?
    • A. 

      Data footprint is automatically reduced through compression

    • B. 

      Only the columns required are actually loaded to memory

    • C. 

      Columns can be partitioned

    • D. 

      Aggregates can be created

  • 14. 
    TRUE or FALSE? SAP Web Development Workbench is installed on Windows.
    • A. 

      True

    • B. 

      False

  • 15. 
    What would you find in a package?
    • A. 

      Information/Calculation Views

    • B. 

      Analytic Privileges

    • C. 

      Procedures

    • D. 

      Security Protocols

    • E. 

      Tables

  • 16. 
    When creating a system connection in SAP HANA Studio, which of these is essential information?
    • A. 

      A valid user and password

    • B. 

      Host

    • C. 

      URL

    • D. 

      Instance

  • 17. 
    What is XS?
    • A. 

      A native, lightweight application server

    • B. 

      An optional engine to handle excessive data loads

    • C. 

      A data cleansing engine

    • D. 

      A user interface

  • 18. 
    What is the SAP HANA Application Function Library (AFL)?
    • A. 

      Repository of ready made business functions

    • B. 

      Repository of connections that can be used by business functions

    • C. 

      Repository of ready made predictive algorithms

    • D. 

      Repository of ready to run applications that are powered by SAP HANA

  • 19. 
    What is the main benefit for using DXC?
    • A. 

      Connectivity to a large number of data sources

    • B. 

      Powerful data transformation

    • C. 

      Re-use built in extraction technology in SAP source systems

    • D. 

      Real time data loading

  • 20. 
    What are the key strengths of SAP Data Service?
    • A. 

      Real time replication

    • B. 

      Data cleansing

    • C. 

      Data integration

    • D. 

      Managing change data capture

    • E. 

      Data streaming

  • 21. 
    Which standard data streaming language does SAP HANA support?
    • A. 

      Computational Continuous Language

    • B. 

      Dynamic SQL

    • C. 

      Python

    • D. 

      Pearl

  • 22. 
    SAP HANA EIM jobs are created using which of the following?
    • A. 

      SAP HANA procedure

    • B. 

      Graphical calculation view

    • C. 

      SQLScript

    • D. 

      Flowgraph

  • 23. 
    SAP HANA EIM includes which components?
    • A. 

      SDI

    • B. 

      SDA

    • C. 

      SDS

    • D. 

      SDQ

  • 24. 
    TRUE or FALSE? SAP SLT can be used for real-time replication from SAP and also non SAP sources.
    • A. 

      True

    • B. 

      False

  • 25. 
    What are typical characteristics of replication?
    • A. 

      Virtualisation

    • B. 

      Transformation

    • C. 

      Real-time

    • D. 

      Batch

    • E. 

      Synchronisation/Data Duplication

Back to Top Back to top