C_HANASUP_1 Exam Questions

You are working with a multimode SAP HANA database. How can you identify the master indexserver? (Choose two)

On which of the following operating systems is installation of the SAP HANA client supported? Note: There are 3 correct answers

How can you identify often-used SQL statements? Note: 2 correct answers

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...

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

In a scaled-out, high-availability environment for an SAP HANA database, how can you monitor the status of the hosts in the cluster? (Choose three)

You are supporting an SAP Netweaver BW Powered by HANA system that is in productive operation. Inadvertently, a table was deleted. The last data backup was three days ago. You need...

Your client tells you that the SAP HANA database backup is not working. In the SAP HANA studio, where could you start to investigate the issue? (Choose three)

In an expensive statement trace configuration, you want to identify queries that run longer than two minutes. Which value do you enter? Please choose the correct answer.

You have selected SAP HANA as product in SAP Solution Manager and checked the prerequisites. What are the next steps to configure SAP HANA as a managed system in SAP Solution Manag...

What are the purposes of executing a delta merge operation in an SAP HANA database? (Choose three)

An ABAP program in SAP ECC is being optimized for the SAP HANA database. You have been asked to identify expensive SQL statements of this program that run for longer than one secon...

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

Which of the following columns are displayed in the Merge Statistics system report? (Choose three)

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

In the SAP HANA studio, which of the following SQL thread details can you monitor by using the Threads subtab of the Performance tab of the Administration editor? (Choose three)

Which parameters can you configure for an expensive statement trace? (Choose two)

In SAP HANA, the automatic backup is disabled. The log area has grown and now the file system is full. The database has frozen. After you stop the database , what do you have to do...

In the SAP HANA studio, in which subtab of the Landscape tab of the Administration editor can you check the statuses of all hosts in a high-availability scenario?

In the SAP HANA studio Administration Editor, for the following purposes can you use the Sessions subtab of the Performance tab? (Choose two)

How can you resolve a Disk Full event?

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?

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

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

You granted a user the system privileges INIFILE ADMIN and DATA ADMIN. What does this allow the user to do?

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

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

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.

How can you restore a default parameter configuration setting in the SAP HANA studio? (Choose two)

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

In the Administration Editor of the SAP HANA studio, how can you identify SQL statements with lock contention?

You want to enable a new database user to view and delete trace files. Which of the following standard roles must you assign to the user?

An SAP HANA administrator has asked you to retrieve size information for one table How can you retrieve this information? Note: There are 2 correct answers to this question.

Your SAP HANA database performs slowly. Which of the following might be reasons for the performance decrease? (Choose two).

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 trace do you have to configure to identify only long-running queries in the SAP HANA database?