- 1) Mention what is SAP HANA?
- 2) Mention the two types of Relational Data stored in HANA?
- 3) Mention what is the role of the persistence layer in SAP HANA?
- 4) Mention what is modeling studio?
- 5) Mention what are the different compression techniques?
Looking to crack SAP S/4HANA Job interview? Want to know about commonly asked SAP S/4HANA Job questions along with answers? Then wisdom jobs is the best place to get started. SAP S/4HANA is the future generation business suite created to run simply in a digital economy. It mainly redefines how project software creates value across industries with the instant approach. SAP S/4HANA customizes the client knowledge on any machine and locally connects to the Internet of things, Big Data, social and business networks. Many SAP S/4HANA jobs are available across cities including Bangalore, Pune, Chennai, and Hyderabad, in various positions. Go through our SAP S/4HANA job interview questions and answers page to prepare well for the best job in reputed organizations.
SAP Security Interview Tips- HANA Security
FAQ: SAP HANA Security
Listed below are the SAP HANA alerts that indicate problems in the security area:
|
Alert |
Name |
Description |
|
57 |
Secure store file system (SSFS) consistency |
Regarding the database if there is consistency with the secure storage file system (SSFS) is determined by this. |
|
62 |
Expiration of database user passwords |
The database users are identified whose password in line with the configured password policy is due to expire. The user will get locked if the password expires. The application availability can be impacted if the technical user is in question. In case of technical users it is recommended that the password lifetime check is disabled to prevent the password from getting expired (ALTER USER DISABLE PASSWORD LIFETIME). |
|
63 |
Granting of SAP_INTERNAL_HANA_SUPPORT role |
To any database users if the internal support role (SAP_INTERNAL_HANA_SUPPORT) is granted currently is determined. |
|
64 |
Total memory usage of table-based audit log |
The database table used for table-based audit logging consumes the percentage of the effective allocation limit is determined. |
SQL: “HANA_Configuration_MiniChecks” returns a potentially critical issue (C = X) for one of the following individual checks:
|
Check ID |
Details |
|
1310 |
Secure store (SSFS) status |
|
1330 |
Number of users with expiration date |
|
1335 |
Number of SAP users with password expiration |
|
1340 |
CATALOG READ privilege granted to current user |
|
1360 |
Size of audit log table (GB) |
SQL: “HANA_Security_MiniChecks” returns potentially critical issues (C = X).
To analyze security topics which tools are there?
In SAP 1969700 the following analysis commands are available:
|
SQL statement |
Details |
|
SQL: “HANA_Security_CopyPrivilegesAndRoles_CommandGenerator” |
From one grantee to another to copy privileges and roles GRANT commands are generated |
|
SQL: “HANA_Security_GrantedRolesAndPrivileges” |
Roles and privileges granted to roles and users are displayed(via roles either directly or indirectly) |
|
SQL: “HANA_Security_MiniChecks” |
In the SAP HANA Security Check List a subset of provided checks and from the expectation the deviations are marked as potentially critical is executed by this command(C = X). |
|
SQL: “HANA_Security_Roles” |
Overview of defined SAP HANA roles |
|
SQL: “HANA_Security_Users” |
Overview of SAP HANA users and schemas |
Information about security related topics is provided by the following monitoring views and dictionary tables:
Explain the CATALOG READ privilege effect
In SAP HANA dictionary tables (e.g. TABLE_COLUMNS or INDEXES) to what extent a user can access data is controlled by CATALOG READ. All information is visible if CATALOG READ is granted. The information for own objects only is shown if CATALOG READ is not granted. Due to the required security checks at the same time the performance can be worse for these dictionary queries.
A missing CATALOG READ right does not result in an error unlike on other databases; the result set of dictionary queries is just restricted.
Looking to crack SAP S/4HANA Job interview? Want to know about commonly asked SAP S/4HANA Job questions along with answers? Then wisdom jobs is the best place to get started. SAP S/4HANA is the future generation business suite created to run simply in a digital economy. It mainly redefines how project software creates value across industries with the instant approach. SAP S/4HANA customizes the client knowledge on any machine and locally connects to the Internet of things, Big Data, social and business networks. Many SAP S/4HANA jobs are available across cities including Bangalore, Pune, Chennai, and Hyderabad, in various positions. Go through our SAP S/4HANA job interview questions and answers page to prepare well for the best job in reputed organizations.
Intermediate SAP HANA Interview questions
Ans: The main function of the replication server is to manage the table data replication as well as table metadata from the multiple data sources.
Ans: The SAP HANA architecture consists of different components that make the system architecture.
Ans: The following are the important components of the index server;
2. Connection and session manager
Ans: Sizing in SAP HANA defines the hardware requirements for a specific SAP HANA installation process. Hardware components are considered as important for sizing parts of System CPU memory or RAM and hard disk requirements. The very tough task here is that estimate the size of the SAP HANA server that will be best suited for the user’s requirements.
Sizing in SAP HANA can be performed in three ways;
1. Using the quick sizer tool
2. Using the DB script
3. Using the ABAP report.
Ans:
Row storage: Row storage is a data storage method that horizontally stores the datastores the data in a horizontal way. Users can store the data sets as similar to disk databases. Row storage in SAP HANA can be stored in the main memory whereas the traditional storage can be used to store the data in the disk databases.
Ans: Users can avoid storing the unnecessary data being stored in SAP HANA just by pausing the replication to stop the scheme-related jobs.
Ans: In the SAP HANA database, each SQL statement can be implemented with the references to the transaction. Frequently the new session can be allotted to the new SQL transaction.
Ans: The following are the some commonly used perspectives as follows;
Ans: The SAP HANA monitor in the studio can be used to perform tasks like administering and monitor the system’s performance and availability of SAP HANA architectural components. Also, users can access the SAP HANA system’s details, configurations, and the services offered by different SAP HANA components. SAP HANA system monitor can also be used to monitor several database aspects like alerts, trace disk, log disks, data disk, memory, data volume, and disk space, etc.
Ans: The following are the three types of information views such as;
FAQ
What is S4 Hana interview questions?
What is SAP HANA security role cycle?
- What is SAP S/4HANA? …
- Can you explain inventory management in SAP S/4? …
- Can you define Lean Manufacturing? …
- What are the SAP S/4 HANA current versions? …
- Can you define Rebate processing? …
- Can you define the master data in SAP?
