SAP SAP Certifications C_HANASUP_1 Questions & Answers

• Question 21:

  How can you perform a manual backup of the Sap HANA database? (Choose two)

  A. Select Backup in the SAP HANA studio

  B. Run the stored procedure SYS UPDATE_LANDSCAPE_CONFIGURATION

  C. Execute SQL statements in the SQL Console

  D. Run a backup via the Administration Console in the SAP HANA database

  Correct Answer: AC

• Question 22:

  What does peak used memory represent?

  A. The point when an automatic delta merge will be triggered

  B. The point when SAP HANA switches to virtual memory

  C. The maximum used memory authorized by the SAP HANA license

  D. The maximum values of used memory over time

  Correct Answer: D

• Question 23:

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

  A. Update settings in the_SYS_REPO.CHANGES table

  B. Enter values in the Host column in the Configuration tab in the Administration editor

  C. Update settings in the _SYS_REPO.CHANGE_ENTRIES table

  D. Right-click on a row in the Host column of the Configuration tab in the Administration editor. Select Configure Table and change settings

  Correct Answer: D

• Question 24:

  What does a data snapshot do?

  A. It creates a backup of the database

  B. It generates a frozen point-in-time set of data

  C. It writes data from memory to the persistence layer

  D. It clones the database to an exportable file

  Correct Answer: A

• Question 25:

  Which steps are required to identify dominant SQL statements? (Choose two)

  A. Go to the SQL Plan Cache tab on the Performance tab

  B. Go to the Expensive Statements Trace tab on the Performance tab

  C. Sort expensive statements by total execution time; from largest to smallest

  D. Sort SQL plan cache by total execution time, from largest to smallest

  Correct Answer: AD

• Question 26:

  Which of the following are minimum requirements for the installation of an SAP HANA server? (Choose two)

  A. contains sapprofile.ini

  B. is empty before the start of the installation

  C. has 200MB or more of free disk space

  D. has 100MB or more of free disk space

  Correct Answer: BC

• Question 27:

  Which of the following can you use to delete an index in SAP HANA? (Choose two)

  A. 1. Open the SAP HANA studio

  2.

  Expand the Content tree and select the package

  3.

  Expand the Package tree

  4.

  Select a package and delete it

  B. Execute a CE_CONVERSION statement from a stored procedure

  C. Execute a DROP INDEX SQL statement from the SQL console

  D. 1. Open the SAP HANA studio

  2.

  Expand the Catalog tree and select the schema

  3.

  Expand the Table tree

  4.

  Select Open Definition and delete the index

  Correct Answer: CD

• Question 28:

  What information about a column store table can you fine in the Open Definition report? (Choose two).

  A. The columns that are loaded into memory

  B. The source system that populates the table

  C. The compression rate of columns

  D. The time and data of the last backup of the table

  Correct Answer: AC

• Question 29:

  You are operating a secondary instance of an SAP HANA database in a high-availability scenario.

  Where can you check the status of the secondary system replication?

  A. In the Host column of the Services subtab of the Landscape tab in the Administration editor

  B. In the STATUS column of the view M_SYSTEM_OVERVIEW

  C. In the REPLICATION_STATUS colum of the view M_SERVICE_REPLICATION

  D. In the Host Status column of the Configuration subtab of the Landscape tab in the Administration editor

  Correct Answer: D

• Question 30:

  Why do you configure a standby host?

  A. To share storage between several active data centers

  B. To add more capacity disk storage

  C. To ensure high performance during replication and reading processes

  D. To reduce recovery time from an outage

  Correct Answer: D