SAP HANA: Certification Questions 111 through 120

QUESTION: 111 
You add an existing analytic view to a new calculation view. You get the warning message “This model is deprecated”. What should you do?  
A. Reactivate the deprecated view.  
B. Remove the deprecate flag in the view properties of the analytic view.  
C. Replace the analytic view with a newer version.  
D. Change all existing models that use the deprecated view. 

Answer: C 

QUESTION: 112 
You created a calculation view with a variable. The value help is displayed hierarchically. Where is the hierarchy linked to the variable? 
A. In the variable property dialog  
B. In the Manage Mappings dialog 
C. In the hierarchy property dialog  
D. In the value help dialog  

Answer: A 

QUESTION: 113 
Where in the SAP HANA web-based development environment can you maintain table data?
Note:  There are multiple correct answers to the question
A. In the data preview  
B. In the SQL console  
C. In the table content 
D. In the debug browser  

Answer: A, B 

QUESTION: 114 
Which capabilities does the ESRI Feature Services provide?  
A. Read and write for ESRI spatial data from SAP HANA  
B. Additional nodes in Smart Data Quality to handle cleaning of ESRI spatial data 
C. Library of advanced visualizations for the ESRI spatial data  
D. Ability to synchronize offline ESRI spatial data with online ESRI spatial data  

Answer: A 

QUESTION: 115 
You want to repeatedly load data from a flat file into SAP HANA with SAP Data Services. The target table is not available in SAP HANA and must be recreated with every scheduled data load. The structure of the target table is identical to the structure of the source table. Which of the following steps must you perform?
Note:  There are multiple correct answers to the question
A. Map the source structure to the template table.  
B. Create a table in the SAP HANA studio.  
C. Import metadata of the target table from the SAP HANA datastore.  
D. Drop a template table into the data flow.  
E. Enter the table name and schema name.  

Answer: A, D, E 

QUESTION: 116 
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: 117 
How can you generate documentation of your information models?
Note:  There are multiple correct answers to the question
A. Right-click on your information model and select the Auto Documentation function.  
B. Use the Export SQL button in the column view of your information model.  
C. Right-click on the column view of your information model and select the export function.  
D. Use the Auto Documentation button in your information model.  

Answer: A, D 

QUESTION: 118 
Which connection type is required from the SAP ERP system to SAP HANA to enable a CO-PA side-by-side scenario?
A. HTTP connection  
B. JDBC  
C. Secondary database connection  
D. Remote Function Call  

Answer: C 

QUESTION: 119 
Where can you consume the column view of a decision table?
Note:  There are multiple correct answers to the question
A. In SAP Visual Intelligence  
B. In analytic views  
C. In calculation views  
D. In Microsoft Excel  

Answer: A, C 

QUESTION: 120 
You have created an information space in SAP BusinessObjects Explorer, but the information space is not available on the Home page. How can you make the information space available on the Home page?
Note:  There are multiple correct answers to the question
A. Index the information space again.  
B. Drag the information space to the Home page.  
C. Refresh the list of information spaces on the Home page.  
D. Select the Show on Home page checkbox in the information space properties.  

Answer: C, D

No comments:

Post a Comment