SAP HANA Mock Test

This section presents you various set of Mock Tests related to SAP HANA. You can download these sample mock tests at your local machine and solve offline at your convenience. Every mock test is supplied with a mock test key to let you verify the final score and grade yourself.

SAP HANA Mock Test III

Q 1 - To recover SAP HANA database to the specific point, which of the below recovery type should be used?

A - Most Recent State option

B - Point In Time option

C - Specific Log backup option

D - None of the above

Answer : B

Explanation

Point in Time.

Q 2 - 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 3^rd 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 3 - To perform Analytical reporting in SAP Business Objects on the top of HANA views, which of the below BI reporting tools can be directly connected to HANA system?

Answer : B

Q 4 - You have create a Universe on the top of HANA database to create reports in Web Intelligence. Which of the connection type can be used to publish Universe in Repository?

Answer : B

Explanation

.cns- connection type represents secured Repository connection that should be used to create Data foundation.

.cnx-represents local unsecured connection and if you use this connection while creating a Universe and while publishing Universe it will not allow you to publish that to repository.

Q 5 - In SAP HANA security, which of the below can be used to limit the data access based on the attributes and for a specific time period in Modeling Views?

A - Roles Management

B - Object Privilege

C - Analytic Privilege

D - System Privilege

E - Package Privilege

Answer : C

Explanation

Analytic Privileges are used to limit access on HANA Information views. You can assign different types of right to different users on different component of a View in Analytic Privileges.

Q 6 - Which of the below privilege type is used for Backup/Restore, User Administration, Instance start and stop, etc.?

A - Object Privileges

B - System Privileges

C - Package Privileges

D - Analytic Privileges

Answer : B

Explanation

System privileges are used for Backup/Restore, User Administration, Instance start and stop, etc.

Q 7 - To manage remote objects from Teradata, Sybase IQ and Hadoop in HANA database, which of the below option can be used?

A - SAP Smart data access

B - HANA XS Engine

C - HANA Application Perspective

D - HANA Sybase Replication

Answer : A

Explanation

SAP Smart data access

Q 8 - Which of the below migration method in SAP HANA allows you to export multiple packages to remote HANA server?

A - SAP Developer Mode

B - SAP Support mode

C - Local File

D - Delivery Unit

Answer : D

Explanation

Delivery unit is a single Unit which can be mapped to multiple packages and can be exported as single entity so that all the packages assigned to Delivery Unit can be treated as single unit.

Users can use this option to export all the packages that make a delivery unit and the relevant objects contained in it to a HANA Server or to local Client location.

Q 9 - To provide unfiltered read only access to all system views, which of the below system privilege type should be added to user profile?

Answer : B

Explanation

It authorizes users to have unfiltered read-only access to all system views.

Normally, the content of these views is filtered based on the privileges of the accessing user.

Q 10 - 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 11 - In SAP HANA Calculation view, which of the below default node type is not available to use in Scenario pane?

Answer : C

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

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 13 - Consider a SAP HANA system with a permanent license which is about to expire. How many days an administrator has to get it renew after the permanent license is expired.

Answer : A

Explanation

Permanent License keys are valid till the predefine expiration date. License keys specify amount of memory licensed to target HANA installation. They can installed from SAP Market place under Keys and Requests tab. When a permanent License key is expired, a temporary license key is issued which is valid for only 28 days. During this period you have to install a permanent License key again.

Answer Sheet

Question Number	Answer Key
1	B
2	C
3	B
4	B
5	C
6	B
7	A
8	D
9	B
10	C
11	C
12	D
13	A

Download

sap_hana_questions_answers.htm