SAP HANA: Certification Questions 121 through 130

QUESTION: 121 
You want to perform a multiple linear regression on your data. Which of the following do you use?
A. SAPUI5 runtime library  
B. RODBC library  
C. SAP HANA Predictive Analysis Library  
D. SAP HANA Business Function Library 

Answer: C 

QUESTION: 122 
In SAP HANA, which join type yields the same results as a referential join when fields from both tables are selected?
A. Left outer join  
B. Temporal join  
C. Inner join  
D. Full outer join 

Answer: C 

QUESTION: 123 
Which of the following must you do when you create an analytic view?
Note:  There are multiple correct answers to the question 
A. Define a column as an attribute.  
B. Define a column as a measure.  
C. Select a data foundation table.  
D. Define a join.  
E. Select an attribute view. 

Answer: A, B, C 

QUESTION: 124 
Which of the following are phases of an SAP rapid-deployment solution (RDS)?
Note:  There are multiple correct answers to the question
A. Start  
B. Run  
C. Deploy  
D. Blueprint  
E. Realization  

Answer: A, B, C 

QUESTION: 125 
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. 

Answer: A 

QUESTION: 126 
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?
Note:  There are multiple correct answers to the question 
A. _SYS_BI schema  
B. SYS schema  
C. Administration editor - System Information  
D. Administration editor - Performance overview  
E. Administration editor - Alerts  

Answer: B, C, E 

QUESTION: 127 
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.  
A. 12 000  
B. 120  
C. 120 000 000  
D. 120 000  

Answer: C 

QUESTION: 128 
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? Please choose the correct answer.  
A.  
  1. Assign diagnosis agents.  
  1. Create logical components.  
  1. Enter system parameters  
  1. Enter landscape parameters.  
  1. Check configuration.  
B.  
  1. Check configuration.  
  1. Create logical components.  
  1. Assign diagnosis agents.  
  1. Enter system parameters.  
  1. Enter landscape parameters.  
C.  
  1. Assign diagnosis agents.  
  1. Enter system parameters.  
  1. Enter landscape parameters.  
  1. Create logical components.  
  1. Check configuration.  
D.  
  1. Assign diagnosis agents. 
  1. Check configuration.  
  1. Create logical components.  
  1. Enter system parameters.  
  1. Enter landscape parameters. 

Answer: C 

QUESTION: 129 
What are the purposes of executing a delta merge operation in an SAP HANA database?
Note:  There are multiple correct answers to the question
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 

Answer: A, D, E 

QUESTION: 130 
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?
Note:  There are multiple correct answers to the question
A. Filter expensive SQL statements by DB user.  
B. Enable expensive SQL statements tracing.  
C. Set the trace level.  
D. Set the threshold duration. 

Answer: B, D
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)