SAP HANA: Certification Questions 131 through 140

QUESTION: 131 
In the SAP HANA studio, which of the following enables you to identify the memory consumption of loaded tables? Please choose the correct answer.  
A. System Information tab of the Administration editor  
B. SYS.M_TABLES  
C. Load subtab of the Performance tab of the Administration editor  
D. O SYS.M_CS_TABLES  

Answer: D 

QUESTION: 132 
Which of the following columns are displayed in the Merge Statistics system report? 
Note:  There are multiple correct answers to the question
A. TYPE  
B. PART_ID  
C. STATEMENT_STRING  
D. MOTIVATION  
E. CONNECTION_ID 

Answer: A, B, D 

QUESTION: 133 
How can you improve performance of SAP HANA information models?
Note:  There are multiple correct answers to the question
A. Use filters at table level instead of analytic views.  
B. Use the JOIN operator instead of the UNION operator in calculation views.  
C. Use CE_FUNCTIONS instead of SQL statements in calculation views.  
D. Use calculated columns in calculation views instead of calculated measures in attribute views. 

Answer: A, C 

QUESTION: 134 
In a scaled-out, high-availability environment for an SAP HANA database, how can you monitor the status of the hosts in the cluster? 
Note:  There are multiple correct answers to the question 
A. 
  1. In the SAP HANA studio, right-click to add a new system.  
  1. Create an entry for each of the hosts in this environment.  
  1. Log into each of the hosts.  
B.  
  1. In the SAP HANA studio, create an entry for a standby host.  
  1. Verify that all SAP HANA database processes are running.  
C. 
  1. Log into the Linux operating system of the SAP HANA appliance.  
  1. Run command ifconfig.  
D. 
  1. In the SAP HANA studio, navigate to the Landscape tab.  
  1. Select the Services subtab.  
  1. Check the Detail column.  
E. 
  1. Log into the Linux operating system of the SAP HANA appliance.  
  1. Launch the SAP HDB Admin console.  
  1. Navigate to the Management Console tab.  
  1. Verify that all SAP HANA database processes are running.  

Answer: A, D, E 

QUESTION: 135 
Which type of objects can you view using the SAP HANA Live Browser?
Note:  There are multiple correct answers to the question
A. Calculation views  
B. Query views  
C. SAP HANA analytic privileges  
D. Extended views  
E. Private views  

Answer: A, B, E 

QUESTION: 136 
What is the result when the Trigger Delta Merge process chain step is executed for a given data target? 
A. The delta between the new data and the already loaded data is calculated in the data target.   
B. Data is transferred from the delta store to the main store of the data target. 
C. The before and after images of the delta queue are merged and sent to the data target.  
D. Only data from the delta queue is extracted and merged into the data target. 

Answer: C 

QUESTION: 137 
You generate an advanced DataStore object out of an Open ODS view based on an SAP HANA table with the Generate DataFlow function. Which data load technique is used?
A. InfoPackage without a persistent staging area (PSA)  
B. InfoPackage with a persistent staging area (PSA)  
C. SAP Landscape Transformation (SLT)  
D. Data transfer process (DTP) with direct access  

Answer: D 

QUESTION: 138 
Which objects can you use to go from a persistent to a logical data warehouse based on new layered scalable architecture (LSA++) for SAP Business Warehouse 7.4? 
Note:  There are multiple correct answers to the question
A. Open ODS view  
B. Virtual key figures  
C. New Eclipse-based CompositeProvider  
D. VirtualProvider 

Answer: A, C 

QUESTION: 139 
What should you do after an InfoCube is converted to be in-memory optimized?  
A. Review customer-specific programs that access tables belonging to the InfoCube.  
B. Delete obsolete process types from process chains containing the InfoCube.  
C. Activate all MultiProviders that include the InfoCube.  
D. Reload data into the InfoCube. 

Answer: A 

QUESTION: 140 
Your customer runs SAP Business Warehouse (SAP BW) 7.4 on SAP HANA and would like to build a BEx Query on top of an existing native SAP HANA calculation view. The query should make use of a master data hierarchy that is already available in SAP BW. What is the recommended approach for this scenario? 
A. Create a SAP BusinessObjects BI Universe and copy the hierarchy from SAP BW to the field of the SAP HANA calculation view.  
B. Create a VirtualProvider and associate all fields of the SAP HANA view with SAP BW InfoObjects.  
C. Create a CompositeProvider in Eclipse and associate the relevant field of the SAP HANA calculation view with the corresponding SAP BW InfoObject.  
D. Create a TransientProvider and associate only the relevant field of the SAP HANA calculation view with the corresponding SAP BW InfoObject.  

Answer: C
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)