SAP HANA: Certification Questions 11 through 20

QUESTION: 11  

Which of the following can be grouped inside a single schema in an SAP HANA database?  
A. Information models  
B. Packages  
C. Users  
D. Database tables 

Answer: D   

QUESTION: 12 

How can you import information models into SAP HANA using the Quick Launch view? 
A. Choose the Redeploy button.  
B. Choose Import -> SAP HANA Content -> Delivery Unit. 
C. Choose Data Provisioning -> Load.  
D. Choose Import -> SAP HANA Content -> Import Data From Local File.  

Answer: B 

QUESTION: 13 

When you try to delete an attribute view you receive the error message, "One or more objects are dependent upon this object".  

Which of the following functions can you use to find out which objects depend on this view?  

Note: There are 2 correct answers to this question.  
A. History function 
B. Where-used function  
C. Auto Documentation function  
D. Display XML function  

Answer: B, C 

QUESTION: 14 

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. The last active and inactive versions 
C. All active and inactive versions  
D. All active versions  

Answer:  D 

QUESTION: 15 

You modified an active analytic view in the SAP HANA studio and saved it without activating it. What is the consequence?  
A. The inactive view is available for reporting.  
B. The active view is in "read-only" mode.  
C. The inactive view is in "read-only" mode.  
D. The active view is not available for reporting.  

Answer: B 

QUESTION: 16 

Which of the following steps do you have to execute to import models from one SAP HANA system (system1) to another SAP HANA system (system2)?  

Note:  There are multiple correct answers to the question

A. Export the models from system1. 
B. Create a delivery unit on system1.  
C. Create a delivery unit on system2.  
D. Import the models into system2.  
E. Create a schema on system2.  

Answer: A, B, D 

QUESTION: 17 

Which of the following SAP HANA schemas contains the runtime objects of activated views? 
 A. _SYS_STATISTICS  
B. _SYS_REPO  
C. _SYS_BI  
D. _SYS_BIC  

Answer: D 

QUESTION: 18 

Which of the following actions must you perform in an SAP HANA system to transport content to another SAP HANA system?  

Note:  There are multiple correct answers to the question

A. Generate and save an export file.  
B. Mass copy the content repository into the other SAP HANA system.  
C. Assign the package to a delivery unit.  
D. Assign the content repository to a transport request.  

Answer: A, C 

QUESTION: 19 

Which of the following can you use to implement currency conversion in an information model?  

Note:  There are multiple correct answers to the question

A. A calculated column in a calculation view  
B. A calculated column in an attribute view  
C. A calculated column in an analytic view  
D. A restricted column in an analytic view  

Answer: A, C 

QUESTION: 20 

In a fuzzy search, when would you perform a freestyle search?  
A. When you want to search with a high fuzziness threshold  
B. When you want to search in multiple columns  
C. When you want to search in only one column 
 D. When you want to search with a low fuzziness threshold  

Answer: B