C_HANATEC141 Online Practice Questions and Answers

Which of the following would you use to upgrade an SAP HANA system and keep the downtime to a minimum?

A. High availability

B. Storage replication

C. Partitioning

D. System replication

Which Linux kernel parameters need to be adapted during SAP HANA installation depending on the SAP HANA system size?

A. net.ipv4.tcp_slow_start_after_idle and kernel.shmmni

B. kernel.shmall and fs.file-max

C. fs.file-max and net.core.wmem_max

D. net.core_rmem_max and kernel.sysrq

A user is locked due to too many failed logon attempts. Which SQL command can solve this problem?

A. ALTER USER DROP CONNECT ATTEMPTS

B. ALTER USER ACCOUNT UNLOCK

C. ALTER USER RESET CONNECT ATTEMPTS

D. ALTER USER FORCE PASSWORD CHANGE AFTER ATTEMPTS

Diagram: Which component in the attached diagram is used when you query an SAP HANA information model to populate a pivot table in Microsoft Excel?

A. The Log Volumes

B. The Calculation Engine

C. The Transaction Manager

D. The SQL Interface

You are using continuous system replication between SAP HANA systems in two separate data centers. What are the advantages of this scenario? (Choose two)

A. The take-over happens in less than 3 minutes.

B. Database changes are continuously updated to the secondary site.

C. The take-over only requires a roll forward since the last synchronization point.

D. Memory and CPU are used on the secondary site for shadow processes.

Which of the following can you do in the SAP HANA studio and also in the DBA Cockpit? (Choose three)

A. Execute system recovery.

B. Implement backup scheduling.

C. Monitor an SQLDBC trace.

D. Display the statuses of database resources.

E. View the tables in the _SYS_STATISTICS schema.

Which of the following must you implement for high availability in an SAP HANA production system? (Choose three)

A. A name server on one active node

B. Index server processes on all nodes

C. Shared file system for all nodes

D. Data replication to the standby nodes

E. A statistics server on one active node

You set up a data transfer architecture that replicates data to SAP HANA from an SAP source system using SAP Landscape Transformation (SLT).

Which of the following SLT configuration parameter changes can improve the replication performance? (Choose three)

A. Set data class of tablespace

B. Change initial load mode

C. Select Allow Multiple Usage in Connection to Source System

D. Increase the number of calculation jobs

E. Increase the number of data transfer jobs

In the SAP HANA studio, to which of the following does the loading status "partially" refer?

A. To a row store table that is loaded in delta storage

B. To a column store table that is loaded in delta storage

C. To a row store table of which only some rows are loaded

D. To a column store table of which only some columns are loaded

You have to transport data models from one SAP HANA system to another using the Change and

Transport System (CTS).

Where do you install the CTS plug in?

A. In the SAP HANA studio

B. In SAP Solution Manager

C. In the XS engine

D. In the source system