SAP HANA: Certification Questions 31 through 40

QUESTION: 31 

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

Answer: D 

QUESTION: 32 

Which of the following nodes can you use when you create a calculation view with the SAP HANA studio graphical interface? 
Note:  There are multiple correct answers to the question
A. Data Foundation  
B. Aggregation  
C. Join  
D. Analytic Privilege  

Answer: B, C 

QUESTION: 33 

You want to retrieve data from SAP HANA and restrict access to certain data columns for specific user groups. Where can you implement this? 
A. In the analytic privileges 
B. In the data foundation  
C. In the business layer  
D. In the SQL privileges  

Answer: C 

QUESTION: 34 

Which of the following are required to build a SQLScript calculation view?  
Note:  There are multiple correct answers to the question
A. Define a data foundation.  
B. Define a measure. 
C. Set the MultiDimensional Reporting property to false.  
D. Add columns to the var_out output parameter.  

Answer: B, D 

QUESTION: 35 

What is the new feature available in Project Creation Wizard?
A. New option to auto-share an XS Project to the SAP HANA Repository during the project creation wizard  
B. New option to auto-share an XS Server - side Project to the SAP HANA Repository during the project creation wizard  
C. New option to auto-share an XS client - side Project to the SAP HANA Repository during the project creation wizard  
D. New option to auto-share an XS Server - side secure Project to the SAP HANA Repository during the project creation wizard  

Answer: A 

QUESTION: 36 

In which engines is an analytic view executed that contains a calculated column? 
Note:  There are multiple correct answers to the question
A. Calculation engine  
B. Row store engine  
C. OLAP engine  
D. Join engine  

Answer: A, C 

QUESTION: 37 

In a reporting scenario you use an Opening Date attribute in the data foundation that contains information about your stores. You want to determine the number of years each store has been in business. How do you achieve this?  
A. Use calculated measures.  
B. Use time attributes. 
C. Use calculated attributes. 
D. Use private attributes.  

Answer:  C

QUESTION: 38 

Which of the following tools can you use to monitor the query time from SAP HANA?  
A. Central Management Console 
B. Performance tab of the System Monitor 
C. Event Viewer  
D. SQL Trace  

Answer: D 

QUESTION: 39 

In SAP HANA studio, in which of the following can you create users?  
Note:  There are multiple correct answers to the question
A. The Administration console 
B. The Roles node  
C. The Content node  
D. The SQL editor  

Answer: A, D 

QUESTION: 40 

Which security settings can you apply in analytic privileges?  
Note:  There are multiple correct answers to the question
A. Grant access to analytic views.  
B. Restrict access within an analytic view using measure values.  
C. Restrict access within an analytic view using attribute values. 
D. Restrict access to hierarchies.  

Answer: A, C