Which of the following columns are displayed in the Merge Statistics system report? (Choose three)
A. TYPE
B. PART_ID
C. STATEMENT_STRING
D. MOTIVATION
E. CONNECTION_ID
How can you improve performance of SAP HANA information models? (Choose two)
A. Use filters at table level instead of analytic views.
B. Use the JOIN operator instead of the UNION operator in calculation views.
C. Use CE_FUNCTIONS instead of SQL statements in calculation views.
D. Use calculated columns in calculation views instead of calculated measures in attribute views.
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 second.
What do you have to do to identify these expensive SQL statements? (Choose two)
A. Filter expensive SQL statements by DB user.
B. Enable expensive SQL statements tracing.
C. Set the trace level.
D. Set the threshold duration.
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
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 Manager?
A. 1. Assign diagnosis agents.
2.
Create logical components.
3.
Enter system parameters
4.
Enter landscape parameters.
5.
Check configuration.
B. 1. Check configuration.
2.
Create logical components.
3.
Assign diagnosis agents.
4.
Enter system parameters.
5.
Enter landscape parameters.
C. 1. Assign diagnosis agents.
2.
Enter system parameters.
3.
Enter landscape parameters.
4.
Create logical components.
5.
Check configuration.
D. 1. Assign diagnosis agents.
2.
Check configuration.
3.
Create logical components.
4.
Enter system parameters.
5.
Enter landscape parameters.
What are the purposes of executing a delta merge operation in an SAP HANA database? (Choose three)
A. To move updated records from delta storage to column store
B. To move new records from SAP ECC tables to delta storage
C. To move merge data from row tables to column store
D. To move inserted records from delta storage to column store
E. To move deleted records from delta storage to column store
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)
A. _SYS_BI schema
B. SYS schema
C. Administration editor - System Information
D. Administration editor - Performance overview
E. Administration editor ?Alerts
In an expensive statement trace configuration, you want to identify queries that run longer than two minutes.
Which value do you enter?
A. 12 000
B. 120
C. 120000000
D. 20000
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 to recover the system to the point before the table deletion.
What do you have to do accomplish this?
A. Restore the SAP HANA database from backup and apply the logs to recover to a point in time.
B. Reinstall the SAP HANA database and recover the database from the last known backup.
C. Recover the database from the last known backup and reload the deleted table.
D. Drop the table in the SAP HANA database and import the table from another system.
You have executed a kernel trace where can you view the trace results?
A. In the HDBAdmintool
B. In a third-party tool such as KCachegrind
C. In the SAP HANA studio diagnosis files
D. In the SAP HANA studio system information
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only SAP exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C_HANASUP_1 exam preparations and SAP certification application, do not hesitate to visit our Vcedump.com to find your solutions here.