SAP HANA Certification Exam Prep Test
HANA
- 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.
Recent Quizzes
Back to top