SAP HANA Certification Exam Prep Test

80 Questions | Total Attempts: 639

SettingsSettingsSettings
SAP Quizzes & Trivia

HANA


Questions and Answers
  • 1. 
    Which tool do you use to investigate an SAP HANA system that is started but can't be reached using SQL? Note: There are 2 correct answers to this questions:
    • A. 

      Hdbcons 

    • B. 

      HANASitter 

    • C. 

      HDBAdmin 

    • D. 

      Sapcontrol 

  • 2. 
    Which privileges are assigned automatically when you create a technical user during the register resource procedure in SAP HANA cockpit? Note: There are 2 correct answers to this question. 
    • A. 

      SELECT on the _SYS_STATISTICS scheme

    • B. 

      CATALOG READ

    • C. 

      SELECT on the _SYS_TELEMETRY schema

    • D. 

      RESOURCE ADMIN 

  • 3. 
    Which prerequisites must you consider to add hosts to an SAP HANA scale-out system? Note:There are 2 correct answers to this question. 
    • A. 

      The SAP HANA system installation should be on a shared file system. 

    • B. 

      The SAP HANA database server is shut down. 

    • C. 

      The host has access to the installation directories. 

    • D. 

      The additional host is placed in a different data center 

  • 4. 
    In an SAP HANA database system running in log mode "normal", in which situation does the system automatically execute a regular log backup? Note: There are 2 correct answers to this question. 
    • A. 

      When the time threshold is exceeded. 

    • B. 

      When a commit occurs. 

    • C. 

      When the log segment is full. 

    • D. 

      When the log buffer is full. 

  • 5. 
    Which SAP HANA features are secured by certificates saved in the SAP HANA certificate store? Note:There are 2 correct answers to this question.
    • A. 

      A. Internal communication channels with the system PKI 

    • B. 

      Client-server communication over JDBC 

    • C. 

       SAP HANA tenant database replication 

    • D. 

       HTTPS client access using the SAP HANA Web Dispatcher 

  • 6. 
    Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting? 
    • A. 

      The R3LDCTL 

    • B. 

      The Process Bucket monitor 

    • C. 

      The Observer Monitor 

    • D. 

      The Log viewer

  • 7. 
    Which database objects can you manipulate if you have the ALL PRIVILEGES activity? Note: There are 2 correct answers to this question
    • A. 

      Views

    • B. 

      Tables

    • C. 

      Procedures

    • D. 

      Sequences

  • 8. 
    What is a characteristic of the Delta Data Shipping operation mode in SAP HANA system replication?
    • A. 

      Delta data shipping takes place in addition to continuous log replay.

    • B. 

      Delta data shipping takes place with continuous read-only access to the secondary system.

    • C. 

      Delta data shipping takes place every 5 minutes.

    • D. 

      Delta data shipping takes place in addition to continuous log shipping.

  • 9. 
     Which parameters do you need to change before you can analyse the memory usage of running SOL statements? Note: There are 2 correct answers to this question. Which one do you like?
    • A. 

      Enable_tracking

    • B. 

      Use_in_memory_tracing

    • C. 

      Statement_memory_limit

    • D. 

      Memory_tracking 

  • 10. 
    Your customer has purchased a 1.5 TB SAP HANA license. To which value do you set the GLOBAL_ALLOCATION_LIMIT parameter when you have four 1TB nodes in an SAP HANA scale-out system with three worker and one standby nodes?
    • A. 

      1.0 TB 

    • B. 

      1.5 TB 

    • C. 

      375 GB 

    • D. 

      512 GB

  • 11. 
    Which prerequisites are necessary for using the SAP HANA database lifecycle manager (HDBLCM) Web user interface? Note:There are 2 correct answers to this question.
    • A. 

      Communication port 1129 is open.

    • B. 

      SAP HANA database system in any version. 

    • C. 

      Installed SAP Host Agent on the SAP HANA host. 

    • D. 

      SAP HANA Client software locally installed. 

  • 12. 
    What can you directly assign to a user with the Manage Users app in SAP HANA cockpit? Note:There are 2 correct answers to this question.
    • A. 

      Scopes 

    • B. 

      Privileges 

    • C. 

      Role collections

    • D. 

      Roles 

  • 13. 
    Where are the R3load processes located when performing the Database Migration Option (DMO) procedure using the in-place migration?
    • A. 

      On the Primary Application Server (PAS) host 

    • B. 

      On the remote target database host 

    • C. 

      On the Additional Application Server (AAS) host 

    • D. 

      On the source and target host

  • 14. 
    Which SAP HANA database system usage types are automatically assigned to tiles in the SAP HANA cockpit? Note:There are 3 correct answers to this question. 
    • A. 

      Sandbox 

    • B. 

      Test 

    • C. 

       Development 

    • D. 

      Production 

  • 15. 
    What are the two features of the storage engine in the SAP HANA index server that enable data consistency and maintain durable changes? 
    • A. 

      Page Management and logger 

    • B. 

      Column Store and Row Store

    • C. 

      Metadata Manager and Transaction Manager 

    • D. 

      Session Management and log Volumes

  • 16. 
    Which system schema provides performance data and system alerts details to review in SAP HANA MiniChecks ? 
    • A. 

      _SYS_TELEMETRY 

    • B. 

       _SYS_WORKLOAD_REPLAY

    • C. 

      _SYS_SQL_ANALYZER

    • D. 

      _SYS_STATISTICS 

  • 17. 
    What is the correct minimum requirement for log volume and/hana/shared/ file system for an SAP HANA database system? 
    • A. 

      For 512 GB system, Log volume = 512 GB,/hana/shared/ = 256 GB 

    • B. 

      For 2 TB system, Log volume = 1 TB,/hana/shared/ = 1TB

    • C. 

      For 1 TB system, Log volume = 1 TB,/hana/shared/ = 1TB

    • D. 

       For 256 GB system, Log volume = 128 GB,/hana/shared/ = 256 GB 

  • 18. 
    Which preparation steps do you need to perform before replaying a captured workload using the SAP HA NA capture and replay tool? Note:There are 3 correct answers to this question. 
    • A. 

      Restore the source system tenant backup to the target tenant. 

    • B. 

      Store the logon credentials of the replayer user in the secure store. 

    • C. 

      Create a replayer user account on the target operating system. 

    • D. 

      Create a replayer user account in the target database system. 

    • E. 

      Preprocess the captured workload on the source system. 

  • 19. 
    Which user credentials are requested during the initial run of the configuration phase when performing the Database Migration Option (DMO) procedure to an SAP HANA 2.0 database tenant? Note:There are 3 correct answers to this question.
    • A. 

      The DBACOCKPIT user of the tenant database 

    • B. 

      The SYSTEM user of the system database

    • C. 

      The SAP• user in client 000 of the ABAP system

    • D. 

      The S-user for the SAP Support Portal connection 

    • E. 

      The DDIC user in client 000 of the A BAP system 

  • 20. 
    Which types of backups can you use to copy an SAP HANA tenant? Note:There are 2 correct answers to this question. 
    • A. 

      Delta database backup

    • B. 

      Fallback snapshot 

    • C. 

      Data snapshot 

    • D. 

      Full database backup 

  • 21. 
    Which file systems are supported for the SAP HANA database system? Note:There are 2 correct answers to this question. 
    • A. 

      EXT3 

    • B. 

      XFS 

    • C. 

      GPFS 

    • D. 

      MPFS 

  • 22. 
    You are checking and monitoring SAP HANA system replication.Which status indicates a temporary connection loss of the secondary system? 
    • A. 

      Unknown 

    • B. 

      Syncing 

    • C. 

      Error 

    • D. 

      Initializing 

  • 23. 
    Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA system replication with secondary time travel? Note:There are 2 correct answers to this question. 
    • A. 

      An explicit read-only connect on between both systems must be available.

    • B. 

      Both must have the same SAP HANA version. 

    • C. 

      The CPU architecture must be identical. 

    • D. 

      Both systems are located in the same data center. 

  • 24. 
    What do you have to consider when you perform a Tailored Data Center Integration (TDI) installation for a productive SAP HANA database system? Note:There are 2 correct answers to this question. 
    • A. 

      Obtaining the hardware certification from SAP for the existing hardware you are going to use. 

    • B. 

      Having 10 GBit/s for storage zone and 1 GBit/s for internal zone for network connect vity. 

    • C. 

      Obtaining C_HANATEC_XX Certification. 

    • D. 

      Having the data and log volumes on the different disks

  • 25. 
    How are hosts assigned to the shared storage in an SAP HANA scale-out system? Note:There are 2 correct answers to this question.
    • A. 

      The standby server is assigned to the master data volume

    • B. 

      The master name server is assigned to its master data volume. 

    • C. 

      The master server is assigned to all data volumes. 

    • D. 

      The slave servers are assigned to their own data volumes. 

Related Topics
Back to Top Back to top