SAP SAP Certifications C_HANASUP_1 Questions & Answers

• Question 71:

  You cancelled a running backup. Where in the SAP HANA studio can you verify that the cancellation was successful?

  A. In the Backup folder of the Navigator pane

  B. In the vies M_BACKUP_CATALOG_FILE in the SYS schema

  C. In the System Information tab of the Administration editor

  D. In the Session subtab of the Performance tab of the Administration edit

  Correct Answer: D

• Question 72:

  For which purposes can you use the Table locks system report?

  A. To investigate locked table names

  B. To unlock tables

  C. To investigate table lock transaction owners

  D. To kill locking transactions

  Correct Answer: A

• Question 73:

  How can you set configurations at the system level using the SAP HANA studio?

  A. Enter values in the System column in the Configuration tab in the Administration editor.

  B. Right-click on a system in the Navigator pane and select Open Security from the context menu.

  C. Right-click on a setting in the Configuration tab in the Administration editor, select Change, and enter values for all hosts.

  D. Enter values in the Properties view when you use the Overview tab of the Administration editor.

  Correct Answer: C

• Question 74:

  Which of the following can you transport using CTS/CTS+? (Choose two)

  A. Analytic privilege

  B. Calculation view

  C. Index

  D. Table

  Correct Answer: AB

• Question 75:

  Which part of an expensive statement trace would you investigate to identify possible performance improvements?

  A. Statement string

  B. Statement length

  C. TOTAL_LOCK_WAIT_TIME

  D. ALLOC_MEM_SIZE_COLSTORE

  Correct Answer: A

• Question 76:

  What do you have to consider when you want to unpartition an SAP HANA table? (Choose three)

  Unpartitioning blocks concurrent read access to the table during the process.

  A. An exclusive lock on the table is required.

  B. Unpartitioning can table a long time to complete.

  C. Only read access is allowed during the unpartitioning process.

  D. Only tables of more than 2 billion rows can be unpartitioned.

  Correct Answer: ACD

• Question 77:

  An SAP HANA developer receives an error when running an SAP HANA Predictive Analysis Library procedure.

  In which of the following files can you find more information?

  A. Script server log

  B. Index server log

  C. Name server log

  D. Statistics server log

  Correct Answer: D

• Question 78:

  Which of the following are held in SAP HANA used memory? (Choose two)

  A. Free memory pool

  B. Temporary computations

  C. Heap memory

  D. Column and row tables

  Correct Answer: BD

• Question 79:

  Which of the following events can trigger a delta merge? (Choose two)

  A. Memory consumption of delta storage drops below a specified limit.

  B. The delta log for a columnar table drops below a defined limit.

  C. The delta log for a columnar table exceeds a defined limit.

  D. Memory consumption of delta storage exceeds a specified limit.

  Correct Answer: CD

• Question 80:

  You granted a user the system privileges INIFILE ADMIN and DATA ADMIN.

  What does this allow the user to do?

  A. Modify the nameserver_history.trc files.

  B. Reset the backup.log file.

  C. Modify configuration files.

  D. Reset the log.txt file

  Correct Answer: C