SAP HANA placement test question papers - Set 3

SAP HANA placement test question papers - Set 3


1) In which of the following situations a recovery of a HANA DB is applicable?

A) disk crash of log area
B) disk crash of data area
C) reset of the system to a specific point time
D) All of the above
View Answer / Hide Answer

ANSWER: D) All of the above




2) Which of the following component enables SAP HANA high availability?

A) Master Index server
B) Statistics server
C) Name server
D) None of the above
View Answer / Hide Answer

ANSWER: C) Name server




3) By which OS command can you check SAP HANA process?

A) HDB proc
B) HDB version
C) HDB admin
D) None of the above
View Answer / Hide Answer

ANSWER: A) HDB proc




4) If you want to create a custom attribute in addition to your data model, how can you achieve this?

A) Create the attribute as a calculated attribute within the analytic view.
B) Create the attribute and add it to the appropriate system table manually.
C) Create the attribute as a calculated measure within the attribute view.
D) Create the attribute as a restricted attribute within the calculation view.
View Answer / Hide Answer

ANSWER: A) Create the attribute as a calculated attribute within the analytic view.




5) What is the connection type for communication between the SAP LT Replication Server and the non-SAP source system?

A) QRFC
B) Database
C) TRFC
D) Web service
View Answer / Hide Answer

ANSWER: B) Database




6) Which process should be running to view SAP HANA Diagnosis Files if the SAP HANA database is offline?

A) disp+work
B) r3trans
C) SMD Agent
D) sapstartsrv
View Answer / Hide Answer

ANSWER: D) sapstartsrv




7) Which of the following is nota replication method for data replication from a source system to SAP HANA?

A) ETL based
B) Trigger based
C) Time based
D) Log based
View Answer / Hide Answer

ANSWER: C) Time based




8) Which component of the Execution Control module breaks the query into executable parts?

A) SQL script
B) Calculation engine
C) MDX
D) SQL parser
View Answer / Hide Answer

ANSWER: D) SQL parser




9) If you modify an existing view, how can you determine which models are affected by this change?

A) Use the audit trail.
B) Use the History feature for the changed model.
C) Use the "Where-Used List" feature for the changed model.
D) Use the "Auto Documentation" to compare the object version of the changed model.
View Answer / Hide Answer

ANSWER: C) Use the "Where-Used List" feature for the changed model.




10) Is it possible to join row-based tables with column-based tables?

A) Yes
B) No
View Answer / Hide Answer

ANSWER: A) Yes


Post your comment