SAP HANA Certification Exam Prep Test

80 Questions | By Themes | Last updated: Dec 18, 2020 | Total Attempts: 639

Questions

Settings

or Create Online Exam

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.