SAP HANA: Certification Questions 21 through 30

QUESTION: 21 
Which of the following criteria indicate that you should store data in row tables?  
Note:  There are multiple correct answers to the question
A. The tables have a large number of columns  
B. The information models search the table based on the values of a few columns.  
C. The information models frequently need to access all columns.  
D. The tables require frequent write access.  

Answer: C, D 

QUESTION: 22 
Which SAP HANA model is recommended for reporting purposes where read operations on mass data are required?  
A. Analytic view  
B. Calculation view using SQL  
C. Calculation view using SQL Script 
D. Attribute view  

Answer: A 

QUESTION: 23 
You want to aggregate the grand total sales amount into one currency. In which of the following cases would you perform the calculation before aggregation? 
Note:  There are multiple correct answers to the question
A. When a line item table contains sales values of two different currencies.  
B. When an aggregate table by country contains sales values in one currency. 
C. When a line item table contains sales values in one currency.  
D. When an aggregate table by country contains sales values in three different currencies.  

Answer: A, D 

QUESTION: 24 
You have imported models from the development system. What is the recommended way toactivate dependent models in SAP HANA?  
A. Use the Activate with History function.  
B. Use the Where-Used List function.  
C. Use the Cascade Activate function.  
D. Activate each view manually.  

Answer: C 

QUESTION: 25 
Which SAP BusinessObjects tool do you use to visualize real-time key performance indicators with simulations?  
A. Explorer  
B. Analysis, edition for OLAP  
C. Web Intelligence  
D. Dashboards  

Answer: D 

QUESTION: 26 
Which type of connection does Direct Extractor Connection (DXC) use to transfer data to SAP HANA? 
A. RFC connection 
B. Secondary database connection  
C. http connection 
D. ODBC connection  

Answer: C 

QUESTION: 27 
Which tool do you use for real-time data provisioning into SAP HANA? 
A. SAP Landscape Transformation (SLT)  
B. SAP BusinessObjects Data Federation Administration  
C. SAP BusinessObjects Data Services  
D. SAP Direct Extractor Connection (DXC)  

Answer: A 

QUESTION: 28 
In SAP ERP there are more than 50,000 application tables. How do you determine the relevant SAP ERP tables to replicate in SAP HANA and their dependencies?  
A. Use SAP ERP Data Modeler (transaction SD11).  
B. Use SAP ERP ABAP Dictionary Maintenance (transaction SE11).  
C. Use the SAP ERP Tables and Indexes Monitor(transaction DB02).  
D. Use SAP ERP Data Browser (transaction SE16).  

Answer: A 

QUESTION: 29 
Which of the following CE functions can you use to query an analytic view directly?  
A. CE_CALC  
B. CE_AGGREGATION  
C. CE_OLAP_VIEW  
D. CE_JOIN_VIEW  

Answer: C 

QUESTION: 30 
Which package privileges are required to extend an SAP HANA Live view?  
Note:  There are multiple correct answers to the question
A. REPO.ACTIVATE_NATIVE_OBJECTS 
B. REPO.EDIT_IMPORTED_OBJECTS  
C. REPO.READ  
D. REPO.EDIT_NATIVE_OBJECTS 
E. REPO.MAINTAIN_NATIVE_PACKAGES  

Answer: A, C, D

No comments:

Post a Comment