SAP HANA Interview Questions And Answers
Are you finding the best sources for your SAP HANA Interview? Then, you’re at the right place. Mindmajix experts compiled Top SAP HANA Interview Questions with their descriptive answers. These Question and answers are best suitable for freshers as well as for the SAP HANA certification exam.
1Q) What do you understand about SAP HANA?
Ans: Ans: SAP HANA means High-Performance Analytical Application which is the best tool for database management. It is an in-memory computing engine that encompasses special hardware and software components. It utilizes a real-time information computing/processing engine that gets information legitimately from the in-memory (fundamental memory/RAM) accelerating the information retrieval tasks.
2Q) What are the advantages of SAP HANA?
Ans: Following points are advantages of SAP HANA:
SAP HANA helps users to make decision-making capability and real-time analysis. It enables the user to process a huge amount of information while the business is going on. Thus it proves that it gives real-time inputs to the user.
The in-memory database tech allows the user to analyze and explore the transaction and process the data in real-time.
SAP HANA grants the user to store and process the data in rows and columns in the database. So, SAP HANA proves that operation can be parallelly processed which escalates the operation speed.
Users who are using the traditional database can utilize one transactional process at a time. But in SAP HANA, users can use the in-memory database to utilize various databases for analytical (OLAP) and transactional (OLTP) inquiries at a time.
Users can fetch information from different external sources due to the source-agnostic capabilities of SAP HANA.
In SAP HANA, without interrupting any business operations, users can implement aggregation and data integration.
3Q) Why is SAP HANA unique?
Ans: SAP HANA ends up being a unique tool for clients from various perspectives. The purposes behind uniqueness are:
SAP HANA is the principal innovation actually to be utilized for both OLTP and OLAP application preparation.
It gives the question of preparing the climate to organize just as unstructured information. That is, for both social information base (tables) and less organized (messages, charts) separately.
The multi-center handling motors of the SAP HANA framework measure information parallelly. The equal handling is done inside various segments of a similar information base. Utilizing a columnar information base, the framework advances information structure and facilitates putting away enormous information by compacting it.
4Q) Explain the components that comprise the SAP HANA technology?
Ans: SAP HANA is an innovation that is an assortment of various technology and tools that work to get its presence. There are four advances which on the whole make SAPA HANA:
SAP HANA DB: It is the center in-memory information base which is integral to the working of SAP HANA.
SAP HANA Studio: It has the displaying tool for management and data handling.
SAP HANA Appliance: It is the Vendor equipment where we introduce SAP HANA programming.
SAP HANA Application Cloud: It is the cloud-based foundation guaranteeing the working of appliances.
5Q) Which platform SAP HANA supports?
Ans: SAP HANA supports the following platforms:
Microsoft Windows Vista, 7, 8, Server 2008 (32-bit)
Microsoft Windows 7, 8, 10, Server 2008 / R2 (64-bit)
SUSE Linux Enterprise Server (SLES) 11 (64-bit)
Red Hat Enterprise Linux (RHEL) 6 (64-bit)
Mac OS X Mavericks (10.9)
Want to analyze business operations which are based on Big Data, enroll in our " SAP HANA Training"
6Q) Explain in-memory computing and its significance in SAP HANA?
Ans: In the in-memory processing, an immense measure of information as the data is put away in the Random-Access Memory (RAM) rather than outside capacity plates. This innovation replaces the conventional method of putting away information in plates and uses social information base administration strategies to bring and deal with the information. In-memory processing innovation is a lot less expensive and quicker than the conventional information-based framework.
Applications in SAP HANA are created in close relationship with the information base and there is near no information development required from the data set to the framework. SAP HANA keeps an essential duplicate of the information prepared in-memory stockpiling which brings about information access and handling for specially appointed announcing investigation of information progressively, and snappy question reaction. Likewise, it lessens information intricacy, information repetition, information impression, equipment and IT costs.
7Q) Explain the primary components of the SAP HANA?
Ans: Following are the key components of the SAP HANA:
In-memory processing motor: This is segment dwelling inside the Index Server. It has a few sub-parts, for example, Session Management, Planning Engine, Disk Storage, Execution Control, Request Processing, Relational Engine, and so on
Information base: This component has raw information dwelling in the ERP information base which is shipped off the HANA data set. Replication Agent (in ERP DB) and Replication Server (in the registering motor) arranges this information development. This part gives log-based information provisioning.
SAP Business Objects BI 4: This part incorporates devices like SBO BI Information Designer apparatus, Data Services Designer, Data Services Server, and Data workers, and so on We utilize the parts for work-based information provisioning. They plan and actualize an occupation on information and store the reports made subsequently. Subsequently, it likewise goes about as a repository.
SAP HANA Studio: This is a client interfacing stage which is an Eclipse-based tool where we can oversee, regulate, and control information. We can chip away at a few perspectives like Calculation, Attribute, and Analytic.
Clients: These are random revealing tools which we can associate with the registering motor by using explicit drivers. We can plan and share reports by using these tools and custom applications.
8Q) Explain the replication server?
Ans: The replication server is liable for managing the replication of metadata and table data from various data sources.
9Q) Explain about the persistence layer?
Ans: The persistence layer is basically responsible for handling information reinforcements intermittently and putting away it for all time. This is known as "Savepoints" and naturally, the savepoint recurrence in every 5 seconds. The information is stored in data volumes and log volumes.
10Q) Explain about the architectural components of SAP HANA?
Ans: SAP HANA system contains various components which makes a system architecture:
Index server: The Index Server is the primary worker in SAP HANA. It has the information stockpiling and preparing motor. Inquiries in various dialects like SQL and MDX are gotten in the file worker. At that point, the inquiries are handled by various segments and workers inside it. The record worker additionally deals with the exchanges and confirmations. It likewise has a segment that oversees exchange logs and specifically stores information.
Furthermore, the file worker is additionally isolated into more modest segments like social information motor, meeting chief, approval of executives, arranging motor, calc motor, and tirelessness layer.
Name server: The name server keeps up the data of the geography or scene of SAP HANA framework climate. It contains data identified with the name and area of the HANA segments. This worker oversees and screens the geography of the apparent multitude of dispersed workers or hubs. It builds the preparing time by diminishing the re-ordering measure as it keeps the data on what information stores in which worker.
Pre-processor worker: Pre-processor worker is a book breaking down the worker who measures printed information. The administration given by this part is utilized during a text search. At whatever point a solicitation starts, this worker measures printed information and gives it to the client.
SAP HANA Studio Repository: The storehouse stores data identified with the recently delivered refreshes. We can refresh the old adaptation to the most recent ones with the assistance of this.
XS Engine: It encourages communication between the outside applications (Java and HTML based) and SAP HANA framework through HTTP/HTTPS in an internet browser. The XS Engine changes over the framework's state from the persistence stored in the database into the utilization model for customers.
11Q) List out the components of an Index Server?
Ans: Following six components in Index Server:
Relational data engine
Connection and Session manager
12Q) What are the two types of relational data stored in SAP HANA?
Ans: There are two types of relational data stored in SAP HANA:
13Q) Explain about a modeling studio in SAP HANA?
Ans: Modeling studio performs multiple tasks in SAP HANA. Following are the multiple tasks that are performed in SAP HANA:
Announces which tables are stored in HANA, the initial segment is to get the meta-information and afterward plan information replication jobs.
Maintaining the Data Services to enter the information from SAP Business Warehouse and different frameworks
Maintains the ERP instances association, the current delivery doesn't uphold interfacing with a few ERP occasions
Use information administrations for the demonstrating
Do displaying in HANA itself
Basic licenses for SAP BO data administrations
14Q) What are the different compression techniques in SAP HANA?
Ans: Following are the three different compression techniques in SAP HANA:
15Q) Explain about transformation rules in SAP HANA?
Ans: Transformation rule is the standard determined in the serious replication setting exchange for the source table with the end goal that information is transformed during the replication cycle.
SAP HANA Certification Questions
16Q) What are the advantages of SLT replications?
Ans: Following points state the importance of SLT replications in SAP HANA:
SAP SLT deals with trigger-based methodology; such methodology has no quantifiable execution sway in the source framework
It offers transformation and filtering capacity
It empowers constant information replication, recreating just related information into HANA from non-SAP and SAP source frameworks
It is completely coordinated with HANA studios
Replication from a few source frameworks to one HANA framework is permitted, likewise from one source framework to various HANA frameworks is permitted.
17Q) How to avoid unnecessary data from being stored in the SAP HANA database?
Ans: To avoid storing unnecessary data in the SAP HANA database, users need to pause the replication by killing the schema related jobs in HANA.
18Q) Explain the role of a master controller job in SAP HANA?
Ans: The job is arranged on insistence and it is responsible for the following tasks:
Creating the logging table and triggers the database into the source system.
Updating the new entries in the admin table in the SLT server when a table is loaded.
19Q) What will happen if the replication is suspended for a long time in the SAP HANA system?
Ans: The logging tables increase when replication is suspended for a long time in the SAP HANA system.
20Q) What is the role of the transaction manager and session in the SAP HANA system?
Ans: The transaction chief coordinates database exchanges and tracks running and shut transactions. At the point when the exchange is moved back or submitted, the exchange director advises the included stockpiling motors about the function so they can run vital activities.
SAP HANA Interview Questions for freshers
21Q) Explain about different types of license keys in the SAP HANA system? What is their validity?
Ans: Following are various types of license keys in SAP HANA:
Temporary License keys are mechanically installed when you install the HANA database. These keys are substantial just for 90 days and you should demand lasting permit keys from SAP commercial center before the expiry of this 90 days time span after establishment.
Permanent License keys are substantial till the predefined termination date. Permit keys determine the measure of memory authorized to target the HANA establishment.
22Q) How many types of permanent license keys in the HANA System?
Ans: There are two types of permanent license keys in the SAP HANA System:
Unenforced − If an unenforced permit key is installed and utilizing the HANA framework surpasses the permit measure of memory, the activity of SAP HANA isn't influenced by this situation.
Enforced − If the Enforced permit key is installed and utilizing the HANA framework surpasses the permit measure of memory, the HANA framework gets bolted. On the off chance that this circumstance happens, the HANA framework must be restarted or another permit key ought to be mentioned and introduced.
23Q) What is the use of different folders when you add a HANA System to the Studio?
Ans: Reinforcement − It is utilized to perform for reinforcement and recuperation in the SAP HANA framework. You can check reinforcement setup subtleties, run manual reinforcement, to check the last effective back performed, and so on for information and log reinforcement.
Index − This contains RDBMS objects like patterns, tables, sees, methodology, and so on You can open SQL manager and plan information base articles
Content − This is utilized to keep up the configuration time archive. You can make new bundles and plan Information sees in the HANA framework. Different perspectives can be made under substance tab to meet the business necessity and to perform systematic reports on the highest point of the Modeling sees.
Provisioning − This is utilized for Smart information admittance to associate with different data sets like HADOOP, TERADATA and SYBASE
Security − This is utilized to characterize clients and to allocate jobs. You can characterize different benefits on various clients utilizing the Security tab. You can dole out Database and Package benefits to various clients to control the information access.
24Q) Differentiate Open data preview and open definition?
Ans: Open data preview: This is used to store the data in a modeling view and object table. When preview the data following are the three options:
Open Definition: It uses the structure of the table, keys, column name, column data types, etc.
25Q) What is meant by SAP HANA Cockpit?
Ans: SAP HANA cockpit is a SAP Fiori Launchpad web page that permits you with a solitary purpose-of-admittance to a scope of Web-based applications for the online organization of SAP HANA. You access the SAP HANA cockpit through a Web program.
To open SAP HANA Cockpit → Right click on HANA system in Studio → configuration and monitoring → open SAP HANA cockpit
26Q) Differentiate between Content tab and Catalog?
Ans: The catalog consists of RDBMS objects like views, tables, procedures, schemas, procedures, etc, and also a user can open design database objects and SQL editor.
Content is used to maintain the design-time repository and also you can create new design data views and new packages in the HANA system. Different perspectives can be made under substance tab to meet the business necessity and to perform investigative reports on the highest point of the modeling views.
27Q) What is the use of semantics, data foundation, star join in SAP HANA system?
Ans: Semantics is defined as a user parameter and to define dimensions and measures.
Star Join is used to add other types of views.
The Data Foundation is used to add column base tables.
28Q) Explain different user parameters that can be defined in the semantic layer?
Ans: Following are various user parameters that define the semantic layer.
Measure and Attribute
New Calculated Column
29Q) What are the default nodes that are available in semantic layers?
Ans: Following are the default nodes that are available in the semantic layer:
30Q) What are the different modes in data provision in HANA Studio?
Ans: Following are the various modes in data provision in HANA Studio:
31Q) Explain about sizing in SAP HANA?
Ans: Sizing in SAP HANA refers to governing the hardware prerequisites for explicit SAP HANA establishment necessities. Hardware segments significant for sizing perspective are CPU, memory (RAM) and hard plate. The most vital assignment in measuring is to gauge the size of the worker most appropriate for the business client's prerequisites.
In SAP HANA, the user can perform sizing in the following ways:
Using ABAP report
Using quick sizer tool
Using DB script
32Q) Explain about row and column storage in SAP HANA?
Ans: In SAP HANA, the data is stored in the following two ways:
Row Storage is the technique for putting away information in an even manner. It is like how information is put away customarily in circle data sets. In any case, there is one fundamental distinction between the SAP HANA column stockpiling and conventional line stockpiling. That is, in SAP HANA, information is put away in lines in the fundamental memory, and in customary information bases, information is put away in lines in the circle stockpiling.
Column Storage technique stores the information in a columnar manner (direct/vertical). Information is packed effectively in segment stores. It improves SAP HANA's exhibition by upgrading both the peruse and compose procedure on the information. Information is put away in the segment stockpiling region which is separated into two segments; Main stockpiling and Delta Storage.
33Q) What are the various perspectives in SAP HANA Studio?
Ans: SAP HANA studio contains various perspectives which a user can choose to work on them. Following are most used perspectives:
SAP HANA Administration Console
SAP HANA Modeler
SAP HANA Development
34Q) Explain about SAP HANA system monitor?
Ans: Utilizing the framework screen in SAP HANA Studio, we can oversee and screen the framework's well-being and accessibility of SAP HANA segments. Additionally, utilizing the framework screen, we can get to the framework's subtleties and setups and the administrations offered by various SAP HANA parts.
We can screen a few perspectives through the SAP HANA framework screen, for example, the alarms, plate space, log circles, follow the circle, information plate, memory, execution, volume, and so forth In this way, it is advantageous to oversee singular viewpoints, errands, and segments.
35Q) Explain about all administrative operations that can we achieve from the administrative console?
Ans: Various authoritative tasks can be acted in the SAP HANA Studio, for example, controlling (start/stop) administrations, observing the framework, review strategy, and security design, client the board and approval, reinforcement and recuperation, memory the executives, permit the board, alarms and messages, and so on
Following tasks can be performed from different tabs present in the administration console of SAP HANA Studio:
Alerts (position and view the details of the alerts)
System Information (access system information files and queries)
Volumes (details of the logs and data volumes)
Configuration (includes the information on system configuration files)
Trace Configuration (includes the traces set up information)
Diagnosis Files (includes the system log files)
Landscape (check of all running services)
Performance (evaluates the performance of the system for the activities happening in the database)
Overview (monitor and general management)
SAP HANA Admin Interview Questions
36Q) Explain about SAP HANA Information Modeler?
Ans: Information Modeler explains data perspectives or models on top of SAP HANA information base utilizing tables in it. Such models are made to serve a business rationale and activity. They are created straightforwardly on top of the HANA information base layer. The data modeler gives the interface and devices to choose ascribes and gauges from the information base tables with the goal that the client can make numerous data sees utilizing the actual tables of value-based information put away in the information bases. The data sees a consistent portrayal of the information which can be additionally distributed or burned-through for investigative purposes. Data demonstrating executes on the SAP HANA Modeler viewpoint of SAP HANA Studio.
37Q) Differentiate Information Modeler and Information Composer?
Ans: The two contrast from one another dependent on track clients. SAP HANA Information Modeler is for specialized clients with broad information displaying prerequisites and specialized information. They can play out a scope of cutting-edge tasks identified with demonstrating, for example, making property sees, logical perspectives, figuring sees, preparing models, information the executives and organization, information stacking and import/send out tables.
Though, data arrangers are made for non-specialized clients who are not IT and information science specialists (with no data set or demonstrating information). The data writer has intended to the point that it helps non-specialized clients with easy to understand interface, movements, clues, and proposals for displaying and announcing.
38Q) Explain about three types of information views?
Ans: Following are three types of information views:
Attribute View: It utilizes credits or the non-quantifiable, non-quantifiable information to configuration perspectives and models as per the business rationale. In this way, the information utilized in quality view is alluded to as 'Ace information' as it is utilized as reference data from different perspectives (expository and figuring). The tables in the trait see don't contain any realities or measure.
Analytical view: We can make star compositions, having a focal exchange or truth table, and various measurement tables connected to it through essential keys. The measures are contained uniquely in the focal exchange table which can be assembled or gotten together with various measurement tables.
Calculation view: It is a serious model that utilizes both quality and investigative view components in it to make a mind-boggling information model after complex business rationale.
It gives us the opportunity to join and make from a scope of alternatives like tables, section sees, investigative perspectives, trait see, and so forth It empowers us to do multidimensional revealing utilizing measures and measurements from various sources.
39Q) Explain about the SAP Business Objects BI 4 reporting tools?
Ans: SAP Business Objects BI 4 customer instruments are SAP items that offer revealing applications and apparatuses that utilization information from SAP BW and SAP HANA for announcing and investigation reasons. The rundown of detailing and dashboarding devices accessible under SAP Business Objects BI 4 bundle is:
SAP Crystal Reports
40Q) How to create a table in SAP HANA System?
Ans: There are two different ways of making tables in SAP HANA. One strategy is a Command-line technique, where we utilize the SQL comfort to compose SQL content and make a table. The subsequent strategy is a GUI based technique where we utilize a graphical interface to make a table.
41Q) Explain about different connecting drivers that are used by SAP HANA reporting tools?
Ans: Following are various connecting drivers that are used by SAP HANA reporting tool:
ODBO (OLE DB for OLAP): The ODBO driver is a driver by Microsoft for interfacing MS Excel to the SAP HANA information base. This driver is explicitly for multi-dimensional announcing (multi-dimensional information stores) and it imparts through MDX language.
ODBC: ODBC represents Open DataBase Connectivity. The ODBC driver is for setting up social information base associations between detailing instruments and SAP HANA information base. Announcing instruments like CR Report and Universe layer (IDE) use an ODBC driver that conveys through SQL.
JDBC: JDBC driver is a Java-based association administration. We likewise use it for social revealing by announcing apparatuses like Explorer, UNX utilizing IDT, CR Report. JDBC drivers speak with the information base through SQL inquiries. JDBC represents Java DataBase Connectivity.
BICS: The BICS driver is SAP legitimacy associating driver. Detailing instruments that utilization SQL DB language as the association language with SAP information base uses BICS driver.
42Q) How SQL statements are processed in SAP HANA System?
Ans: In the HANA information base, each SQL proclamation is essentially actualized in the reference of the exchange. In this manner in the further cycle, the new meeting is apportioned to another exchange.
43Q) Why will users choose SAP HANA?
Ans: Real-time – SAP HANA Provides Real-time Data provisioning and Real-time Reporting of information.
Speed – SAP HANA gives elevated level velocities preparing on enormous information and this is expected to In-Memory Technology.
Open to Data/Source-SAP HANA can get to different information sources with no issues including the Structured and Unstructured information from SAP or Non-SAP information source.
Cloud-SAP HANA application and information base can be effectively sent to the Cloud climate.
Simplicity SAP HANA is most popular for its effortlessness. It additionally decreases the endeavors behind the ETL cycle, Data Aggregation, Indexing, and Mapping.
Cost factor–SAP expresses that SAP HANA Software can diminish the complete IT cost of any organization.
Choice option available: SAP HANA is upheld by the diverse equipment seller and has a rundown of the Software supplier, so dependent on the prerequisite, the client has such a large number of alternatives to can pick the best one.
44Q) Explain about different editions of SAP HANA?
Ans: Following are various editions of SAP HANA:
SAP HANA Platform Edition: This stage gives the Core information base innovation. There is an Integration of SAP segment including SAP HANA information base, SAP HANA Studio, and SAP HANA customers. It is for clients who as of now have a permit for SAP business objects Data administration and when they need to utilize ETL-based replication.
SAP HANA Enterprise Edition: This version contains information provisioning (SLT, BODS, DXC) part including center information base innovation. It is just for clients who need to utilize trigger-based replication or ETL-based replication and doesn't have the whole essential permit needed for SAP Business Objects Data Services.
SAP HANA Extended Edition: This all-inclusive version contains information provisioning the highlights more than some other Platform and Enterprises release. It is the ideal decision for the clients who need to utilize the maximum capacity of all accessible replication situations, even the log-based replication.
45Q) What is the part of the transaction administrator and session?
Ans: The exchange chief co-ordinates database exchanges and keeps a record of running and shut transactions. When the exchange is moved back or submitted, the exchange supervisor informs the included stockpiling motors about the occasion so they can run essential activities.
46Q) Clarify how you can maintain a strategic distance from un-vital logging data from being put away?
Ans: You can maintain a strategic distance from un-vital logging data from being put away by delaying the replication by halting the blueprint related occupations.
47Q) Define the Five-minute rule?
Ans: It is a rule of thumb for deciding whether a data item should be kept in memory, or stored on disk and read back into memory when required. The rule is “randomly accessed disk pages of a cache are re-used every 5 minutes”.
48Q) Define Stall?
Ans: Waiting for data to be loaded from the main memory into the CPU cache is called Stall.
49Q) Describe SAP HANA Database Architecture in brief?
Ans: The SAP HANA database is developed in C++ and runs on SUSE Linux Enterprise Server. IT consists of multiple servers and the most important component is the Index Server. It consists of Index Server, Name Server, Statistics Server, Pre-processor Server, and XS Engine.
The database persistence layer is responsible for the durability and atomicity of transactions. It ensures that the database can be restored to the most recent committed state after a restart and that transactions are either completely executed or completely undone.
The index server uses the preprocessor server for analyzing text data and extracting the information on which the text search capabilities are based.
It owns the information about the topology of the SAP HANA system. In a distributed system, it knows where the components are running and which data is located on which server.
The statistics server collects information about status, performance, and resource consumption from the other servers in the system.. The statistics server also provides a history of measurement data for further analysis.
Session and Transaction Manager
The Transaction manager coordinates database transactions, and keeps track of running and closed transactions. When a transaction is committed or rolled back, the transaction manager informs the involved storage engines about this event so they can execute necessary actions.
XS Engine is an optional component. Using XS Engine clients can connect to the SAP HANA database to fetch data via HTTP.
For in-depth knowledge on SAP HANA, click on below
- Performance Tuning in SAP HANA
- Security in SAP HANA
- Analytical Privileges in SAP HANA
- Advanced Analysis with SAP HANA Tables and Views