SAP HANA: Certification Questions 181 through 190

QUESTION: 181 

A company uses SAP Landscape Transformation (SLT) to transfer data from a source system to SAP HANA. How does SAP recommend that you check for any data transfer problems within SLT on a regular basis? Please choose the correct answer.  

A. Perform a job status check in SLT manually.  

B. Run the health check functionality in SLT.  

C. Run health check scripts on the SLT server at the operating system level.  

D. Perform a data provisioning status check in SAP HANA manually.  

Answer: B 

QUESTION: 182 

An SAP HANA user wants to incorporate the Diminishing Balance Depreciation function in an SAP HANA data model. How can you implement this request efficiently and without incurring additional hardware or license costs? Please choose the correct answer.  

A. Implement analytical and predictive functions in SAP HANA extended application services for use in the SAP HANA information models.  

B. Install the R desktop version to the users’ computers to enable SAP HANA information models to be accessed via ODBC.  

C. Install the Application Function Library (AFL) into the existing SAP HANA server and implement analytical and predictive models based on the SAP standard algorithms.  

D. Set up an R serve installation and connect it with SAP HANA to enable R scripts to be executed as part of the SAP HANA information models. 

Answer: C 

QUESTION: 183 

You are designing a table partitioning strategy in a scale-out scenario. Detailed information about the data access pattern is not available. Which partitioning options would you choose? Note: There are 2 correct answers to this question.  

A. Round robin  

B. Hash  

C. Multi-level  

D. Range  

Answer: A, B 

QUESTION: 184 

Which of the following SQL statements is equivalent to the following CE function?  

out = CE_OLAP_VIEW("OLAP_view", ["DIM1", SUM("KF")]);  

Please choose the correct answer.  

A. out = select distinct dim1, SUM(kf) FROM “OLAP_view”;  

B. out = select dim1, SUM(kf) FROM “OLAP_view” GROUP BY dim1;  

C. out = select dim1, SUM(kf) FROM “OLAP_view”;  

D. out = select dim1, kf FROM “OLAP_view”; 

Answer: B 

QUESTION: 185 

You are doing currency conversions using input parameters in an information model. You ran the report that uses the model and selected the target currency from the pop-up list of currencies. You notice that the financial figures in the report are not correct but no error is shown. What could be the reason for this? Please choose the correct answer.  

A. The “Measure Type” of the currency column is not set to “Amount with Currency”.  

B. The TCUR* currency conversion tables are in the wrong schema.  

C. The “Enable for Conversion” option is not selected.  

D. The “Set Upon Conversion Failure” option is set to “Ignore”.  

Answer: D 

QUESTION: 186 

You want to create a user that can do the following: Create test users.Create roles for developers.Assign role-based authorizations to analytic views. Which combination of authorizations is required for this user? Please choose the correct answer.  

A. USER ADMIN, SERVICE ADMIN, DATA ADMIN  

B. USER ADMIN, CREATE STRUCTURED PRIVILEGE, RESOURCE ADMIN  

C. USER ADMIN, CREATE STRUCTURED PRIVILEGE, ROLE ADMIN  

D. USER ADMIN, SERVICE ADMIN, ROLE ADMIN 

Answer: D 

QUESTION: 187 

You need to recover an SAP HANA database. What is a prerequisite? Please choose the correct answer.  

A. Use the SAP DBA Cockpit to perform a database recovery.  

B. An offline SAP HANA database  

C. Use the SAP HANA cockpit to perform a database recovery.  

D. An online SAP HANA database  

Answer: B 

QUESTION: 188 

What can you do on the Configure Alerts tile in the SAP HANA cockpit? Note: There are 2 correct answers to this question.  

A. Run the checks regardless of their status.  

B. Schedule the execution of the checks.  

C. Set a threshold value which triggers the check run.  

D. Cancel a running check from the list. 

Answer: A, B 

QUESTION: 189 

You plan to install an SAP HANA database in an SAP HANA Tailored Datacenter Integration (TDI) scenario. Which SAP HANA installation tools are required? Note: There are 2 correct answers to this question.  

A. hdbinst  

B. hdbsetup  

C. hdblcmgui  

D. hdblcm  

Answer: C, D 

QUESTION: 190 

You execute an authorization trace in the SAP HANA studio. Where can you review the outcome? Please choose the correct answer.  

A. In the result screen of the trace configuration.  

B. In the indexserver trace diagnosis file.  

C. In the authorization dependency viewer.  

D. In the monitoring view M_SERVICE_TRACES.  

Answer: C