SAP HANA: Certification Questions 41 through 50

QUESTION: 41 

Which versions of your information models are visible on the History tab of the Modeler perspective in the SAP HANA studio?  
A. Only the last active version  
B. All active and inactive versions  
C. All active versions  
D. The last active and inactive version  

Answer: C 

QUESTION: 42 

Which types of calendar are available for time attribute views in SAP HANA?  
Note:  There are multiple correct answers to the question
A. Fiscal  
B. Factory 
C. Gregorian  
D. Julian  

Answer: A, C 

QUESTION: 43 

Union can be performed only at...  
A. Analytic  
B. Attribute  
C. Calculation  
D. Analytic / Calculation  

Answer: C 

QUESTION: 44 

What does the following SQL statement do?  

SELECT SCORE() as SCORE, PRODUCT_NAME, *  

FROM  

PRODUCT_ITEMS  

WHERE CONTAINS(*,'Paper', FUZZY(0.8))  

ORDER BY PRODUCT_NAME 

A. It performs a fuzzy search on all columns in the PRODUCT_NAME table for the term 'Paper'.  
B. It performs a fuzzy search count on the number of columns in the PRODUCT_NAME table that contain the term 'Paper'.  
C. It performs a fuzzy search on the PRODUCT_NAME column in the PRODUCT_ITEMS table for the term 'Paper'.  
D. It performs a fuzzy search of all columns in the PRODUCT_ITEMS table for the term 'Paper'.  

Answer: D 

QUESTION: 45 

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: 46 

You want to model customer master data. Which of the following must you select?  
Note:  There are multiple correct answers to the question
A. Filter 
B. Table  
C. Hierarchy  
D. Key attribute  

Answer: B, D 

QUESTION: 47 

User A has to setup tables and views in a database schema that is owned by user B. Which of the following privilege must you grant?  
A. CREATE ANY to user A  
B. REFERENCES to user A  
C. CREATE ANY to user B  
D. REFERENCES to user B  

Answer: A 

QUESTION: 48 

What is the functionality of an aggregation node in a calculation view?
Note:  There are multiple correct answers to the question
A. It calculates the sum, minimum, or maximum values for selected columns 
B. It provides grouping of filter criteria  
C. It provides deeper control over which columns are totaled  
D. It determines the output structure of the calculation view  

Answer: A, C 

QUESTION: 49 

Which of the following is included in a rapid deployment solution (RDS) implemented on SAP HANA? 
Note:  There are multiple correct answers to the question
A. Conversion of all BEx queries to analytic views  
B. Guides and educational material  
C. A mix of onsite and offsite consulting 
D. The SAP HANA database license E. SAP best practices and templates  

Answer: B, C, E 

QUESTION: 50 

You want to enable the end user to decide at runtime how to restrict the data in an information model. Which of the following objects do you use?  
A. Input parameter  
B. Filter  
C. Restricted measure  
D. Variable  

Answer: D