We're so confident of our products that we provide no hassle product exchange.
SAP Certified Support Associate - SAP HANA 1.0 Sample Questions:
1. Which part of an expensive statement trace would you investigate to identify possible performance improvements?
A) Statement length
B) TOTAL_LOCK_WAIT_TIME
C) ALLOC_MEM_SIZE_COLSTORE
D) Statement string
2. What does a data snapshot do?
A) It generates a frozen point-in-time set of data
B) It creates a backup of the database
C) It writes data from memory to the persistence layer
D) It clones the database to an exportable file
3. DRAG DROP
Which descriptions on the left match the join types in the dropdown box on the right?
4. You are working with a multimode SAP HANA database. How can you verify that the indexserver hosts are online?
A) Select the Landscape tab of the SAP HANA Administration Console
Navigate to the Configuration subtab.
In the Active column, identify the rows with the value "YES"
B) Select the Landscape tab of the SAP HANA Administration Console Navigate to the Services subtab In the Service column, identify the rows with the value "indexserver", and in the Active column, identify the rows with
C) Select the Landscape tab of the SAP HANA Administration Console
Navigate to the Configuration subtab.
In the Host Status column, identify the rows with the value "OK"
D) Select the Landscape tab of the SAP HANA Administration Console In the Show dropdown list, select Service In the Service column/identify the rows with the value" indexserver"
5. You have enabled an SQL trace. The resulting trace file is rather large. You have downloaded the trace file to your local computer and want to remove it from this system.
Which steps must you perform to accomplish this?
A) 1.
Delete the SQL trace file from the Diagnosis Files tab.
2.Deactive SQL trace in the Trace Configuration tab.
B) 1.
Deactive SQL trace in the Trace Configuration tab,
2.Delete the SQL trace file from the Diagnosis Files tab.
C) 1.
Open the SQL trace file and delete the contents.
2.Deactive SQL trace in the Trace Configuration tab.
D) 1.
Deactive SQL trace in the Trace Configuration tab.
2.Open the SQL trace file and delete the contents.
Solutions:
| Question # 1 Answer: D | Question # 2 Answer: B | Question # 3 Answer: Only visible for members | Question # 4 Answer: C | Question # 5 Answer: B |
By Vanessa
