SAP HANA: Certification Questions 71 through 80

QUESTION: 71 

In an analytic view, you need two different logical joins from the data foundation to an attribute view. The analytic view already contains the attribute view but you have to use the attribute view again. To which of the following do you connect the second join?  
Note:  There are multiple correct answers to the question
A. To a shared attribute view  
B. To a derived attribute view  
C. To a new instance of the attribute view  
D. To a copy of the attribute view  

Answer: B, D 

QUESTION: 72 

What must you do to enable currency conversions with a fixed currency in an analytic view?  
A. Set the Enable for Conversion option  
B. Create a measure with the measure type Simple 
C. Base the target currency on a currency column 
D. Create the target currency using an input parameter  

Answer: A 

QUESTION: 73 

You create a graphical calculation view that is based on analytic views. What do you use to combine the data from the analytic views?  
A. Referential join  
B. Projection node  
C. Aggregation node  
D. Union  

Answer: D 

QUESTION: 74 

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

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 not available.  
B. The inactive view is in "Read Only" mode.  
C. The active view is not available.  
D. The active view is in "Read Only" mode.  

Answer: D 

QUESTION: 76 

When you activate a procedure, in which schema is the procedure stored?  
A. SYSTEM 
B. _SYS_BIC  
C. SYS_REPL  
D. _SYS_BI  

Answer: B 

QUESTION: 77 

You want to create a graphical calculation view using the SAP HANA studio. Which steps are mandatory for this task?  
Note:  There are multiple correct answers to the question
A. Define a projection. 
B. Write an SQL script.  
C. Save and activate the view.  
D. Define output fields.  
E. Choose a data source.  

Answer: C, D, E 

QUESTION: 78 

You have a Web Intelligence report that requires data from SAP HANA filtered for a specific year. Where do you apply the filter for optimal performance?  
A. In the universe  
B. In the Web Intelligence report  
C. In the analytic view  
D. In the calculation view using an attribute value variable  

Answer: C 

QUESTION: 79 

What is the lowest level of granularity you can use in an analytic privilege?  
A. An attribute 
B. A view  
C. An attribute value  
D. A column  

Answer: C 

QUESTION: 80 

What must you configure to directly access an SAP HANA analytic view using SAP BusinessObjects Analysis edition for Microsoft Office?  
A. RFC connection  
B. SAP HANA Direct Extractor Connection (DXC)  
C. Pre-delivered MODELING role  
D. System DSN  

Answer: D