C_HANASUP_1 by SAP Actual Free Exam Q&As

Question 1

DRAG DROP

Which of the following descriptions on the lift match the terms in the dropdown list on the right?

Discussion 0

Correct Answer:

Question 2

How can you improve performance of SAP HANA information models? (Choose two)

A. Use CE_FUNCTIONS instead of SQL statements in calculation views. B. Use filters at table level instead of analytic views. C. Use the JOIN operator instead of the UNION operator in calculation views. D. Use calculated columns in calculation views instead of calculated measures in attribute views.

Discussion 0

Correct Answer: A,B Vote an answer

Question 3

In the Administration editor in the SAP HANA studio, which reports can you use to first investigate
(1)
And then release (2) deadlocks?

A. The Diagnosis Files tab The Job Progress tab B. The System information tab The Threads subtab of the Performance tab C. The System information tab The Sessions subtab of the Performance tab D. The Diagnosis Files tab The Sessions subtab of the Performance tab

Discussion 0

Correct Answer: D Vote an answer

Question 4

You have executed a kernel trace where can you view the trace results?

A. In the HDBAdmintool B. In the SAP HANA studio system information C. In the SAP HANA studio diagnosis files D. In a third-party tool such as KCachegrind

Discussion 0

Correct Answer: C Vote an answer

Question 5

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_TABLES C. Load subtab of the Performance tab of the Administration editor D. SYS.M_CS_TABLES

Discussion 0

Correct Answer: C Vote an answer

Question 6

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 STATUS column of the view M_SYSTEM_OVERVIEW B. In the Host Status column of the Configuration subtab of the Landscape tab in the Administration editor C. In the REPLICATION_STATUS colum of the view M_SERVICE_REPLICATION D. In the Host column of the Services subtab of the Landscape tab in the Administration editor

Discussion 0

Correct Answer: B Vote an answer

Question 7

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. Modify configuration files. C. Reset the log.txt file D. Reset the backup.log file.

Discussion 0

Correct Answer: B Vote an answer

Question 8

How can you find default values for SAP HANA configuration settings?

A. Go to the Configuration tab in the Administration editor and inspect the Default column. B. Double-click the Database Information row in the System information tab in the Administration editor. C. Go to the Configuration tab in the Administration editor and inspect the System column. D. Right-click on a configuration setting in the Configuration tab in the Administration editor.

Discussion 0

Correct Answer: A Vote an answer

Question 9

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?

A. Mutilevel round robin. B. Mutilevel hash hash. C. Single-level round robin. D. Single-level hash.

Discussion 0

Correct Answer: A Vote an answer

SAP Certified Support Associate - SAP HANA 1.0 - C_HANASUP_1 Exam Practice Test