SAP HANA Online Quiz


Advertisements


Following quiz provides Multiple Choice Questions (MCQs) related to SAP HANA. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.

Questions and Answers

Answer : A

Explanation

In Star schema, you have one fact table and multiple dim tables.

Q 2 - A SAP HANA developer wants to create HTML application and to host it on web server in HANA. Which of the below component in HANA architecture can be used by Web applications to access HANA database?

A - Index Server

B - Name Server

C - XS Engine

D - SAP Host Agent

Answer : C

Explanation

XS Engine allows external applications to access the SAP HANA system via the XS Engine clients. It allows UI5 based applications to use SAP HANA via http/https or other protocols.

Q 3 - A SAP HANA developer has two tables and while joining the tables he is getting output as number of rows in table A multiplied by table B. Which of the below Join type is used?

A - Cross Join

B - Outer Join

C - Inner Join

D - Self Join

Answer : A

Explanation

CROSS JOIN produces a result set which is the number of rows in the first table multiplied by the number of rows in the second table, if no WHERE clause is used along with CROSS JOIN. This kind of result is called as Cartesian Product.

Q 4 - A SAP HANA Modeler is trying to activate an Analytical view and getting the error message- insufficient privilege. Which of the below user should get access on Schema and tables used in HANA view to activate the view?

A - SYS_REPO

B - SYS_READ

C - DATA ADMIN

D - REPO READ

Answer : A

Explanation

GRANT SELECT ON SCHEMA "B11SALES" TO _SYS_REPO WITH GRANT OPTION

Q 5 - In SAP HANA Job based replication, which of the below can be used to add a schedule, to trace, monitor and error check a replication job?

A - Data Service Designer

B - Data Service Repository Manager

C - Data Service Management Console

D - Data Services Server Manager

Answer : C

Explanation

Data Service Management Console – You can trace, monitor, error check replication jobs in repository.

Q 6 - In SAP HANA database, an administrator can see that log area is filling continuously and causing database to hang. What can be done to fix this issue?

A - Limit File Size

B - Use backint destination type

C - Enable Automatic log backup

D - Use 3rd party backup tool

Answer : C

Explanation

Enable Automatic log backup option: It helps you to keep log area vacant. If you disable this log area will continue to fill and that can result database to hang.

Q 7 - While creating a SAP HANA Modeling view, which user parameter allows you to add a new field in the Data Preview that doesn’t exist in database or view level?

A - Hierarchies

B - Another View at Star Join level

C - Calculated Column

D - Distinct Value

E - Primary Key

Answer : C

Explanation

Calculated column allows you to add a column at report level that doesn’t exist in database or view level.

Q 8 - Which of the below is not an audit trial type while configuring an audit policy in HANA system?

A - Syslog

B - CSV Text file

C - Database table

D - Backing

Answer : D

Explanation

Syslog(default) − Logging system of Linux Operating System.

Database Table − Internal database table, user who has Audit admin or Audit operator system privilege he can only run select operation on this table.

CSV text − This type of audit trail is only used for test purpose in a non-production environment.

Q 9 - SAP HANA Modeling can only be performed on column base tables?

A - True

B - False

Answer : A

Q 10 - To get multiple measures from different tables, which of the below is most suitable view type to be used in HANA Modeling?

A - Attribute

B - Analytic

C - Calculation

D - Analytic Privilege

Answer : C

Explanation

Calculation Views are used to consume other Analytic, Attribute and other Calculation views and base column tables. These are used to perform complex calculations which are not possible with other type of Views including implementing Galaxy schema.


sap_hana_questions_answers.htm

Advertisements
E-Books Store