SAP Certified Support Associate - SAP HANA 1.0 - C_HANASUP_1 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which is the dominant statement (see attached table)?

A. Statement4 B. Statement2 C. Statement1 D. Statement3

Discussion 0

Correct Answer: D Vote an answer

Question 2

How can you perform a manual backup of the Sap HANA database? (Choose two)

A. Select Backup in the SAP HANA studio B. Execute SQL statements in the SQL Console C. Run a backup via the Administration Console in the SAP HANA database D. Run the stored procedure SYS UPDATE_LANDSCAPE_CONFIGURATION

Discussion 0

Correct Answer: A,B Vote an answer

Question 3

Which of the following are performance trace options? (Choose three)

A. Trace execution plans B. Performance trace duration C. Optimizer performance D. Start kernel profiler tracing E. Activate function profiler

Discussion 0

Correct Answer: A,B,E Vote an answer

Question 4

Which of the following tasks can you perform only with system privilege TRACE ADMIN? (Choose two)

A. Start a Python B. Delete SYS.P_SQLSCRIPTTRACE_. C. Start SQL traces D. Delete trace files

Discussion 0

Correct Answer: C,D Vote an answer

Question 5

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

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

Discussion 0

Correct Answer: A,C Vote an answer

Question 6

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

A. Index B. Calculation view C. Analytic privilege D. Table

Discussion 0

Correct Answer: B,C Vote an answer

Question 7

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

A. Memory consumption of delta storage exceeds a specified limit. B. The delta log for a columnar table drops below a defined limit. C. Memory consumption of delta storage drops below a specified limit. D. The delta log for a columnar table exceeds a defined limit.

Discussion 0

Correct Answer: A,D Vote an answer

Question 8

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

A. Filter on the DURATION_MICROSEC column in the Expensive Statements Trace tab of the Performance tab. B. Check the Overall Workload report of the System Information tab. C. Check the Record Locks report of the System Information tab. D. Filter on the LOCK_WAIT_COUNT column in the Expensive Statements Trace tab of the Performance tab.

Discussion 0

Correct Answer: D Vote an answer

Question 9

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

A. AVG_EXECUTION_TIME B. TOTAL_EXECUTION_OPEN_TIME C. AVG_EXECUTION_OPEN_TIME D. TOTAL_EXECUTION _TIME

Discussion 0

Correct Answer: A Vote an answer