Free SAP C-HANASUP-1 Exam Dumps Questions & Answers

You are asked to configure the SAP HANA database to recompile every query prior execution. What do you have to disable to accomplish this?

• A.The SQL trace
• B.The SQL plan cache
• C.The SQL result cache
• D.The expensive statements trace

In the SAP HANA studio, which of the following enables you to identify the memory consumption of loaded tables?

• A.System Information tab of the Administration editor
• B.SYS.M_CS_TABLES
• C.SYS.M_TABLES
• D.Load subtab of the Performance tab of the Administration editor

Your SAP HANA project has gone live. The client requires to build a new sandbox environment, using a copy of the production data, for prototyping and technical upgrades What is the SAP recommended approach to meet the requirement?

• A.Install a new SAP HANA instance with help from the hardware vendor Restore the production database from a data backup
• B.Install a new SAP HANA instance on your own Restore the production database from a data backup
• C.Make a copy of the file system of the production appliance with 'tar' Create a clone in the sandbx appliance from this tar file.
• D.Install a new SAP HANA instance on you own Deploy SAP HANA packages to this new sandbox instance

You have to set the alert levels for CPU utilization:
Low alert-75%
Medium alert-85%
High alert-95%
You have opened the ConfigureCheck threshold tab in the Administration editor of the SAP HANA studio To which values do you set the alert levels in the Check Host CPU Utilization row?

• A.25,15,5
• B.0.75, 0.85, 0.95
• C.0.25, 0.15, 0.05
• D.75, 85, 95

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

• A.The time and data of the last backup of the table
• B.The columns that are loaded into memory
• C.The compression rate of columns
• D.The source system that populates the table