SAP HANA: Certification Questions 61 through 70

QUESTION: 61 

In a graphical calculation view, you specify the default client to be dynamic. How is the client value determined when the view is used?  

A. By checking the session client of the user accessing the view.  

B. By executing a procedure in the user's own schema.  

C. By applying the filtering conditions on the client field.  

D. By reading the client of the tables in the view.  

Answer: A 

QUESTION: 62 

You have created an input parameter in an information model. In which of the following can you use the input parameter?  

A. The creation of an SAP BEx query reading from the information model  

B. The creation of an SAP BusinessObjects Web Intelligence report directly on the information model  
C. The definition of objects in an SAP BusinessObjects universe  

D. The definition of an information space that reads from the information model  

Answer: C 

QUESTION: 63 

Which of the following should you try to implement as best practices for data modeling?
Note:  There are multiple correct answers to the question

A. Perform aggregation in an attribute view.  

B. Use filters to restrict the number of rows on the tables that make up the analytic views. 
C. Execute calculated columns before any aggregation is performed.  

D. Use a UNION when combining analytic views in a calculation view.  

Answer: B, D 

QUESTION: 64 

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

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

What are characteristics of a constraint filter?  
Note:  There are multiple correct answers to the question
A. It is defined during the design time on a table.  
B. It is applied on a table before the query execution.  
C. It is applied on the result set of an SQL query.  
D. It is defined during the runtime in the SQL query.  

Answer: A, B 

QUESTION: 67 

Which of the following are direct outputs of an analytic view?  
Note:  There are multiple correct answers to the question
A. Hierarchies  
B. Private attributes 
C. Restricted attributes  
D. Measures 
E. Attribute views  

Answer: B, D, E 

QUESTION: 68 

When you activate an analytic view, a column view is created. In which schema is this column view stored? 
A. _SYS_BIC  
B. _SYS_BI  
C. _SYS_REPO 
D. _SYS  

Answer: A 

QUESTION: 69 

Which of the following SAP data provisioning methods provide complex transformations?  
Note:  There are multiple correct answers to the question
A. SAP Data Services  
B. SAP HANA smart data access  
C. SAP Replication Server 
D. SAP HANA smart data quality  

Answer: A, D 

QUESTION: 70 

Which of the following are restrictions of the SAP HANA flat file upload?  
Note:  There are multiple correct answers to the question
A. A table must have the same column order as the flat file when you append data.  
B. The upload does not allow to change the column names of new tables. 
C. A new table must have a 1:1 mapping between the flat file columns and the table columns.  
D. The upload prevents data type changes when appending data.  

Answer: C, D