C_HANATEC131 Exam Training Practice Tests (SAP Certified Technology Associate (Edition 2013)

Question 1

After you install an SAP HANA database, you want to ensure that it is automatically started when the host is rebooted.
Which of the following parameter settings allows you to do this?

A. Autostart to "TRUE" in the profile file /usr/sap/<SAPSID>/SYS/profile/DEFAULT.PFL B. Autostart to "Enable" in the profile file /usr/sap/<SAPSID>/SYS/profile/<SID>_HDB<Instance_No>_<host_name> C. Autostart to "1" in the profile file /usr/sap/<SAPSID>/SYS/profile/<SID>_HDB<Instance_No>_<host_name> D. Autostart to "Yes" in the profile file /usr/sap/<SAPSID>/SYS/profile/DEFAULT.PFL

Correct Answer: C

Question 2

A backup catalog became unusable.
What can you do to recover existing backups?

A. In SAP HANA studio Backup Editor Display all backups select REFRESH B. Recreate the backup catalog based on the available backup files with the tool hdbbackupdiag. C. Use a third party backup tool to recover the backups. D. Create a new data backup.

Correct Answer: B

Question 3

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

A. kernel.shmall and fs.file-max B. net.core_rmem_max and kernel.sysrq C. fs.file-max and net.core.wmem_max D. net.ipv4.tcp_slow_start_after_idle and kernel.shmmni

Correct Answer: D

Question 4

Which of the following can decrease the startup time of an SAP HANA system after a reboot?

A. Reducing the size of the transactional data records B. Reducing the number of fields in the master data C. Reducing the number of column tables in the database D. Reducing the size of the row-based tables

Correct Answer: D

Question 5

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 source system B. In the SAP HANA studio C. In the XS engine D. In SAP Solution Manager

Correct Answer: D

Question 6

In an analytic view, you want to restrict the access for users according to their geographical reporting region.
What do you have to do to achieve this? (Choose three)

A. Assign a package privilege to the users B. Create an analytic privilege C. Select an attribute and define restricted values for it D. Assign the analytic privilege to the users E. Create a filter on an attribute

Correct Answer: B,C,D

Question 7

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

A. To a row store table of which only some rows are loaded B. To a column store table that is loaded in delta storage C. To a row store table that is loaded in delta storage D. To a column store table of which only some columns are loaded

Correct Answer: D

Question 8

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

A. ALTER USER <username> RESET CONNECT ATTEMPTS B. ALTER USER <user_name> DROP CONNECT ATTEMPTS C. ALTER USER <username> FORCE PASSWORD CHANGE AFTER ATTEMPTS D. ALTER USER <user_name> ACCOUNT UNLOCK

Correct Answer: A

SAP Certified Technology Associate (Edition 2013) - SAP HANA - C_HANATEC131 Exam Practice Test