SAP Certified Support Associate - SAP HANA 1.0 Set 1

Which column do you use to identify long-running SQL statements within the SQL Plan Cache view?

Which is the dominant statement (see attached table)?

Which system privilege do you need to modify the global_allocation_limit parameter?

You have an application that runs on the SAP HANA database. The application loads relatively large volumes of data for hint to the database. Which mergedog configuration parameter in the indexserver.ini file must you set to accomplish this?

How do you Configure an end-to-end trace in the SAP HANA studio Administration console?

How can you avoid filling up the space of the log backup file area?

You want to partition a large table in an SAP HANA database. One of the columns on which you want to base the partition is non-primary key column YEAR. Which partitioning method can you use?

Which role must you grant to an SAP HANA user to enable this user for replication tasks only?

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?

How do you display the available disk space (in %) for data from the Volumes tab of the SAP HANA editor?