SAP HANA Administration Questions And Answers

 SAP HANA Administration

Questions And Answers

1. What is SAP HANA?

SAP HANA (High-Performance Analytic Appliance) is a modern, in memory-database and platform that is deployable on premise or in the cloud.
The SAP HANA platform allows you to analyze large volume of data in real time.
SAP HANA platform allows you to store and access data in-memory and column based by using the database services.
SAP HANA allows both online transaction processing (OLTP) and online analytical processing (OLAP) on one system.
SAP HANA allows to develop applications, run your custom applications built on SAP HANA, and manage their lifecycles by using application services.

2. What are the user types required in SAP HANA Database?

Users: These are regular users who uses SAP HANA database regularly. These users are created by the system administrators.
SYSTEM User: These are the user where they will be having system administrator access.
Technical user: SYS, _SYS_STATISTICS and _SYS_REPO. These are internal users within the SAP HANA database and cannot logon from outside.
Application-specific technical users: An application server may log on to the SAP HANA database using a dedicated technical users.

3. What are the privileges in SAP HANA?

a. System Privileges: These are applicable to System and database and assigned mainly to Administrators and developers.
b. Object Privileges: These are applicable to database objects like tables, views and schemas. These privileges are mainly assigned to end users and technical users.
c. Analytic Privileges: These are used to allow read access to data in SAP HANA information models like analytic views. These are assigned to end users.
d. Package Privileges: These are used to allow access to work in packages in the repository of the HANA database. These are assigned to application and content developers.
e. Application Privileges: These are used to allow access to HANA XS classic applications. These are assigned to application end users and technical users.

4. What is system database in SAP HANA?

The system database is created in SAP HANA during the installation. The system database contains the information about the system and its tenant databases. 
The HANA system contains exactly one system database and contains its own data and users for system administration. 
The system database stores all the information related to system landscape, which includes information of the tenant databases also.

5. Column and Row-Based Data Storage in SAP HAHA?

The SAP HANA database supports both column-wise and row-wise storage of tables. But the default storage type in HANA database is column storage.
Column storage is used when user want to execute calculations on individual columns or small number of columns.
Column storage is also used when the table has a large number of columns.
Row storage is used when the application needs to process only one single record at one time. 
Row storage is also used when the table contains small number of rows.

6. What are the audit activities in SAP HANA?

Below are some of the activities performed on the SAP HANA database.
a. Changes to user authorization
b. Creation or deletion of database objects
c. Authentication of users
d. Changes to system configuration
e. Access to or changing of sensitive information


Pls visit my YouTube channel for more SAP content and demo videos. 
https://www.youtube.com/channel/UCirrZvU_y9IBJzkH-AoxvUQ



Location: Chicago, IL, USA

Comments

Post a Comment

Popular posts from this blog

SAP Security: Critical Authorization Objects

SAP Security: Critical Authorization Objects 1. S_TABU_DIS: This authorization object enables authorization check for displaying or modifying the table content. For accessing the table data, users use SE16, SM30 or SM31 transaction codes. This object contains two fields, DICBERCLS (authorization group) and ACTCT. 2. S_RFC: This authorization object enables authorization check for remote function call to access program modules (function modules). This authorization object contains three fields, RFC_TYPE, RFC_NAME and ACTCT. 3. S_DATASET: This authorization object enable file access at operating system level. This gives permission to access files from ABAP programs. This object contains three fields, File name, Program and Activity. 4. S_ADMI_FCD: This authorization objects enable access to various administrator activities like system monitoring, spool administration, client creations, update administration etc. This object contains one field, system administration functions. 5. S_DE
Read more

SAP GRC Security Consultant Roles and Responsibilities

SAP GRC Security Consultant Roles and Responsibilities 1. SAP GRC Consultant should have a knowledge on Governance, Risk and Compliance products. 2. Should have a thorough knowledge as well as experience in relation between ERP and GRC systems. 3. Should have an experience in configuring and supporting of GRC components like ARA, ARM, BRM and EAM. 4. GRC consultant should be having good understanding of GRC architecture. 5. Should be having hands on experience in user provisioning, role management, risk analysis, emergency access management and monitoring. 6. Should have experience in pre installation, post installation, connector settings, rule building and MSMP workflows and BRF+ in the ARM and BRM components. 7. Should have experience in end to end implementation of GRC Access Controls. 8. Should have experience in designing and developing the SAP business process. 9. Should be able to gather business requirements and implement the same in the GRC AC modules like ARA, ARM, BRM and E
Read more

SAP Security: How to set auto Logoff for Inactive users in SAP

Image
How to set auto Logoff for Inactive users in SAP SAP provides an options for logging of inactive users in SAP automatically. Inactive means if there is no activity for a specific period of time. By setting the auto logoff improves the security in the SAP system. The auto logoff options is not active in the system by default. This needs to be activated using the profile parameter called rdisp/gui_auto_logout. The value for this parameter should be set in the form of seconds. The inactive users are logout of the system after the specific time period that is set in the parameter. The SAP system doesn't save the data before auto logoff and it does not popup any prompt before auto logoff. Procedure to set the value in the Profile parameter: Execute transaction code RZ10 Select the DEFAULT profile from the selection menu. Select the Extended maintenance and click on change icon. Click on the create parameter icon as shown below. Enter the new parameter name as rdisp/gui_auto_logout and c
Read more