Bluekey Hana Technical Test

40 Questions | Total Attempts: 38

SettingsSettingsSettings
Please wait...
Computing Quizzes & Trivia

BLUEKEY HANA TECHNICAL TEST


Questions and Answers
  • 1. 
    Which entry must the client maintain in SAP Service Marketplace in order to provide access to SAP Support to access SAP HANA studio remotely?
    • A. 

      Name server

    • B. 

      Preprocessor server

    • C. 

      Statistics server

    • D. 

      Master Index server

  • 2. 
    Which of the following are recovery types in SAP HANA database?
    • A. 

      Recovery with incremental backup and Recovery until cancel

    • B. 

      Full recovery and Point in time recovery

    • C. 

      Full recovery Recovery with incremental backup

    • D. 

      None of the above

  • 3. 
    Select the correct statement?
    • A. 

      During data and log backup ,the system is available as usual

    • B. 

      Backup only supports files as backup media

    • C. 

      Only the database payload is backed up

    • D. 

      All of the above

  • 4. 
    Size of the backup can be estimated from which system table?
    • A. 

      M_CONVERTER_STATISTICS

    • B. 

      M_BACKUP

    • C. 

      M_BACKUP_STATISTICS

    • D. 

      None of the above

  • 5. 
    Select the correct statement with respect to “LOG WRITING”
    • A. 

      Log is written to log Buffers in memory

    • B. 

      If a Log-Buffer becomes full OR a commit entry is written , the log buffer will be written to assigned Log Volume

    • C. 

      The log is finally written into Log segments where multiple log buffers can be combined into .

    • D. 

      All of the above

  • 6. 
    Which privilege types are included in the SAP HANA authorization concept?
    • A. 

      Analytic privileges

    • B. 

      System privileges

    • C. 

      SQL privileges

    • D. 

      All of the above

  • 7. 
    From the HANA studio in which tab can you see HANA services?
    • A. 

      Landscape

    • B. 

      Overview

    • C. 

      System information

    • D. 

      Configuration

  • 8. 
    What is the benefit of implementing SAP HANA with SAP ERP?
    • A. 

      Reduction of Business Suite process steps

    • B. 

      Provision of BI Content

    • C. 

      Performance optimization for operational reporting

    • D. 

      All of the above

  • 9. 
    Which component of the Execution Control module breaks the query into executable parts ?
    • A. 

      SQL parser

    • B. 

      MDX

    • C. 

      Calculation engine

    • D. 

      SQL script

  • 10. 
    What are the components of SAP IMCE Clients 1.0?
    • A. 

      IMCE SQLDBC 1.0

    • B. 

      IMCE JDBC 1.0

    • C. 

      IMCE ODBC 1.0

    • D. 

      All of the above

  • 11. 
    Semantic layer is available for reporting by which of the following reporting tools?
    • A. 

      MS-Excel

    • B. 

      Explorer, Dashboards

    • C. 

      Crystal Reports, Dashboards n& Webl

    • D. 

      BI BO Analysis v 1.1

  • 12. 
    Calculation view can contain the following.
    • A. 

      Calculation views

    • B. 

      Analytic views

    • C. 

      Database tables

    • D. 

      All of the above

  • 13. 
    What is an example of a selective data load using SAP Landscape Transformation?
    • A. 

      Selected data field values are randomized and loaded into SAP HANA.

    • B. 

      Selected units or currencies are converted into recalculated amounts or values and loaded into SAP HANA.

    • C. 

      Selected data for transformation is split into portions.

    • D. 

      Selected data for a range of years is loaded into SAP HANA.

  • 14. 
    Relational Universe is used for Semantic Business Layer?
    • A. 

      True

    • B. 

      False

  • 15. 
    You installed SAP HANA Database using 31 as your system number, which port is used for standard SQL communication for client access?
    • A. 

      33115

    • B. 

      31531

    • C. 

      33113

    • D. 

      None of the above

  • 16. 
    Which view in SAP HANA studio do you use to add additional users?
    • A. 

      Navigator view

    • B. 

      Modeler perspective

    • C. 

      Analytic view

    • D. 

      None of the above

  • 17. 
    What are the recommended ways to perform a database backup?
    • A. 

      DB14

    • B. 

      HANA studio

    • C. 

      SQL commands

    • D. 

      B and C

  • 18. 
    Which command stops the HANA database?
    • A. 

      HDB stop

    • B. 

      HANA stop

    • C. 

      HDB stop

    • D. 

      None of the above

  • 19. 
    In which table would you can get the current system limits?
    • A. 

      M_SYSTEM_LIMITS

    • B. 

      M_LIMITS_SYSTEM

    • C. 

      M_SYSTEM

    • D. 

      None of the above None of the above None of the above

  • 20. 
    What is the maximum number of jobs for which you can view the information in the Current tab of Job log?
    • A. 

      3

    • B. 

      4

    • C. 

      5

    • D. 

      6

  • 21. 
    Which tab in SAP HANA studio displays CPU load history data?
    • A. 

      Overview

    • B. 

      Volumes

    • C. 

      Landscape

    • D. 

      Performance

  • 22. 
    By executing “HDB info” command, can we check SAP HANA process?
    • A. 

      Yes

    • B. 

      No

  • 23. 
    Which of the following sequence of steps is used to implement SAP HANA with SAP ERP?
    • A. 

      SAP HANA system setup Data Provisioning Modeling Consumption

    • B. 

      SAP HANA system setup Modeling Data Provisioning Consumption

    • C. 

      SAP HANA system setup Data Provisioning Consumption Modeling

    • D. 

      Data Provisioning Modeling Consumption SAP HANA system setup

  • 24. 
    The SAP LT trigger-based approach uses a log table to record all relevant changes, where is this log table stored?
    • A. 

      In the source system

    • B. 

      In SAP HANA

    • C. 

      In SAP Solution Manager

    • D. 

      In SAP LT

  • 25. 
    Which delivered role is mandatory for a system administrator in SAP HANA?
    • A. 

      sys_admin

    • B. 

      Ic modeler

    • C. 

      sap_all

    • D. 

      Content_admin