SAP HANA: Certification Questions 351 through 360

QUESTION: 351

Which system privilege do you need to modify the global_allocation_limit parameter?

A. SERVICE_ADMIN

B. MONITOR_ADMIN

C. SESSION_ADMIN

D. INIFILE_ADMIN

Answer: D

QUESTION: 352

Which of the following are prerequisites for the integration of SAP Solution Manager and SAP HANA?
Note: There are multiple correct answers to the question

A. Register SAP HANA in the System Landscape Directory

B. Create a connection to SAP HANA in the managed system configuration

C. Configure SAP NetWeaver Landscape Virtualization Management

D. Configure SAP Early Watch Alerts for SAP HANA

Answer: A, B

QUESTION: 353

A customer has started stress testing their SAP HANA solution. The actual performance of a calculation view is 100 times slower than the customer requires. The main table accessed contains billions of rows. Join logic in the calculation view is implemented using SQL. The customer explains that this was needed because a required join type is not supported in analytic views or CE functions.  
Which of the following do you recommend to overcome the performance issue?  
Note: There are multiple correct answers to the question

A. Force query parallelization of the SQL 

B. Re-design the data model to use an analytic view 

C. Re-design the SQL 

D. Persist the result set of the calculation view 

Answer: B, D

QUESTION: 354

To support high availability, which of the following are valid index server actual roles for a 5 node scale-out SAP HANA system? 

A. Two masters, two slaves, one standby 

B. One master, four slaves 

C. One master, three slaves, one standby 

D. Four masters, one standby 

Answer: C

QUESTION: 355

Which of the following reduces the amount of data transferred from the OLAP engine to the Calculation Engine? 

A. Unions 

B. Projections 

C. Calculated attributes in an attribute view 

D. Calculated attributes in an analytic view 

Answer: B

QUESTION: 356

The values for budget and actuals are in the same fact table identified by value type. You want to move budget and actual to the same row to be able to calculate the variance (Key Figure Model). How could you fulfill the requirement?  

A. Add two instances of the fact table to the data foundation. Implement a constant union in the analytic view. 

B. Add two instances of the fact table to the data foundation. Join them via inner join and design a star schema on the logical view. 

C. Implement a constant union by designing two analytic views and build a graphical calculation view with a union. 

D. Implement a union by designing two analytic views and build a calculation view using CE_UNION_ALL. 

Answer: C

QUESTION: 357

What are the advantages of SAP BW on HANA compared to SAP BW with BWA?
Note: There are multiple correct answers to the question

A. Reduced data latency 

B. Modeling flexibility 

C. Decreased data load frequency

D. Usage of Near Line Storage (NLS) 

Answer: A, B

QUESTION: 358
Which of the following can you use to perform ranking in an SAP HANA data model?
Note: There are multiple correct answers to the question

A. A CE function

B. A Calculated Attribute

C. An SQL query

D. A Calculated Measure

Answer: A, C

QUESTION: 359
A customer is implementing an SAP HANA solution. The major requirements for data sourcing are: 

• Extract data from the customer's ECC system using all Business Content extractor types and custom extractors. 
• Provide job scheduling and monitoring. 

Which of the following supports all requirements?

A. SAP BusinessObjects Data Services

B.  BW on SAP HANA

C. DXC using embedded BW

D. SAP Landscape Transformation

Answer: B

QUESTION: 360
You are asked to develop a concept for transporting SAP HANA content from development to production. 
Which of the following are prerequisites to use CTS+ transports? 

A. SAP HANA content has been copied using „Mass Copy…“ in SAP HANA Studio

B. SAP HANA content has been placed in a built-in package

C. SAP HANA content is bundled in a delivery unit

D. SAP HANA content has been exported

Answer: D