Ags Hana Study Questions

50 Questions | Total Attempts: 205

SettingsSettingsSettings
Please wait...
Study Quizzes & Trivia

Questions and Answers
  • 1. 
    What are the main features of HANA?
    • A. 

      In memory

    • B. 

      Statement level isolation

    • C. 

      Parallelization

    • D. 

      Column Store

    • E. 

      Query processor

  • 2. 
    When to use a column store table and what are the advantages?
    • A. 

      Less distinct values

    • B. 

      Compression,

    • C. 

      Write optimized

    • D. 

      Read optimized

    • E. 

      Many distinct values

    • F. 

      Select * (All columns)

    • G. 

      Aggregation,

    • H. 

      Insert and update

  • 3. 
    When to use a row store table and what are the advantages?
    • A. 

      Read optimized

    • B. 

      Select * (All columns)

    • C. 

      Compression

    • D. 

      Insert and update

    • E. 

      Write optimized

    • F. 

      Less distinct values

    • G. 

      Many distinct values

    • H. 

      Aggregation

  • 4. 
    What is delta merge + basic operating
    • A. 

      Merge changed data from main memory to disk

    • B. 

      Merge at the transaction level

    • C. 

      Merge from delta to main memory only for column store tables

    • D. 

      Merge at the statement level

  • 5. 
    What is savepoint + basic operating?
    • A. 

      A save point is where changed data is pushed from delta memory to main memory for column store tables

    • B. 

      A save point takes place at the statement level

    • C. 

      A save point takes place at the transaction level

    • D. 

      A save point is where changed data is pushed from memory to disk

  • 6. 
    What is true of a transaction level snapshot?
    • A. 

      All statements of a transaction see the same snapshot (Isolation level repeatable read)

    • B. 

      Different statements in a transaction may see different snapshots (Isolation level read committed)

    • C. 

      Each statement sees the changes that were committed when the execution of the statement started.

    • D. 

      Statement level snapshot is the default isolation level (Read Committed)

  • 7. 
    What is true of a statement level snapshot?
    • A. 

      Transaction level snapshot is the default isolation level (Read Committed)

    • B. 

      All statements of a transaction see the same snapshot (Isolation level repeatable read)

    • C. 

      Different statements in a transaction may see different snapshots (Isolation level read committed)

    • D. 

      Each statement sees the changes that were committed when the execution of the statement started.

  • 8. 
    Where can you check the load status of a table?
    • A. 

      Hana Studio (Runtime Tab)

    • B. 

      Solution Manager Table Viewer

    • C. 

      DBACockpit

    • D. 

      M_CS_TABLES view

  • 9. 
    What is a query execution plan?
    • A. 

      An attempt by a Query Optimizer to merge data from delta to main memory.

    • B. 

      An attempt by a Query Optimizer to merge data from memory to disk

    • C. 

      An attempt by a Query Optimizer to compute the most efficient way to fulfill a SQL request.

    • D. 

      An attempt by a Query Optimizer to create a save point.

  • 10. 
    Which of the following things happen when a query is submitted through the Query Optimizer?
    • A. 

      Table statistics are generated for all tables included in the query.

    • B. 

      It is parsed, pre-complied and bound before being processed by the optimizer

    • C. 

      The Plan is passed to the database object containing required information.

    • D. 

      It is processed here (DBI) or native SQL

    • E. 

      A column store table is generated.

    • F. 

      A row store table is generated.

    • G. 

      The index is read.

    • H. 

      An Execution plan with a Timestamp is generated

  • 11. 
    What are the four types of SQL commands?
    • A. 

      RDL – Relational Data Language Mainly for database users

    • B. 

      DDL – Data Definition Language Mainly for developers

    • C. 

      TCL – Transaction Control Language Mainly for developers

    • D. 

      TDL – Transaction Definition Language Mainly for developers

    • E. 

      DML – Data Manipulation Language Mainly for database users

    • F. 

      DCL – Data Control Language Mainly for system Administrators

  • 12. 
    What are the main components of a database system?
    • A. 

      Query processor

    • B. 

      Data files

    • C. 

      Backup Engine

    • D. 

      Config Files

    • E. 

      Application Engine

    • F. 

      Application Engine

  • 13. 
    SQL commands consist of the following:
    • A. 

      Clients

    • B. 

      Additional instructions

    • C. 

      Semicolon

    • D. 

      Data Files

    • E. 

      Object name (Database Table, Field Name)

    • F. 

      Configuration Files

    • G. 

      Command name

    • H. 

      User Store

  • 14. 
    Types of SAP HANA privileges?
    • A. 

      Analytical Privileges

    • B. 

      Power user privileges

    • C. 

      Package Privileges

    • D. 

      Application Privileges

    • E. 

      Privileges on user

    • F. 

      Superuser (sudo) privileges

    • G. 

      System Privileges

    • H. 

      Object/ SQL Privileges

    • I. 

      Restricted privileges

  • 15. 
    Which components are updated by SPS update?
    • A. 

      Database

    • B. 

      Studio

    • C. 

      Clients

    • D. 

      Sapstartsrv

    • E. 

      Agents

    • F. 

      Backup Engine

    • G. 

      AFL

    • H. 

      Application Engine

  • 16. 
    How is a configuration backup initiated?
    • A. 

      Automatically

    • B. 

      Manually

    • C. 

      Through the Solution Manager backup scheduler

    • D. 

      By using DBACockpit

  • 17. 
    Where can you start and stop the HANA database?
    • A. 

      Solution Manager Technical Operations Workcenter

    • B. 

      Via HANA Studio

    • C. 

      HDB start and HDB stop from the OS

    • D. 

      DBACockpit

  • 18. 
    What are the customer specific .ini files?
    • A. 

      Profile.ini

    • B. 

      Daemon.ini

    • C. 

      Config.ini

    • D. 

      Nameserver.ini

    • E. 

      Customer.ini

  • 19. 
    What tools are available for data backup of a HANA database?
    • A. 

      HANA Studio

    • B. 

      DBACockpit

    • C. 

      HDB Console

    • D. 

      Solution Manager Backup Scheduler

  • 20. 
    What is the name of the secure store for user and password data?
    • A. 

      HANA User Store

    • B. 

      Client User Store

    • C. 

      HDB Admin User Store

    • D. 

      HDB User Store

  • 21. 
    What types of data backup are available?
    • A. 

      Full backup

    • B. 

      Delta backup

    • C. 

      Online backup

    • D. 

      Incremental backup

  • 22. 
    What information is displayed in a HANA license?
    • A. 

      Licensed CPU

    • B. 

      Licensed CPU Cores

    • C. 

      Licensed Memory

    • D. 

      Licensed Concurrent Users

  • 23. 
    What service must be running to see HANA diagnostic files?
    • A. 

      SAPSTARTSRV

    • B. 

      DBACockpit

    • C. 

      HANA Studio

    • D. 

      HDB Agent

  • 24. 
    Where can you monitor several HDBs in HANA Studio?
    • A. 

      HDB Monitor

    • B. 

      System Monitor

    • C. 

      Trace Monitor

    • D. 

      HDB Administrative Monitor

  • 25. 
    What steps can you take to identify expensive statements?
    • A. 

      Activate the expensive statements trace which is deactivated by default

    • B. 

      Use the expensive statements trace which is activated by default

Back to Top Back to top