Top SAP HANA Admin Interview Question Answers pdf

16. What area unit the most elements of the SAP HANA environment?

Ans:

The primary elements of the SAP HANA surroundings are:

In-memory computing engine: this can be a part residing among the Index Server. it’s got many sub-components like designing Engine, Session Management, Disk Storage, Request process and Execution management, relative Engine, etc.

Database: This has data residing within the ERP info that is shipped to the HANA info. Replication Agent (in ERP DB) and Replication Server (in the computing engine) provisions this knowledge movement. This part provides log-based knowledge provisioning. (sap Hana admin interview questions)

SAP Business Objects metallic element 4: This part includes tools like SBO metallic element info Designer tool, knowledge Services Designer, knowledge Services Server, and knowledge servers, etc. we tend to use the elements for job-based knowledge provisioning. The style and implement employment on knowledge and store the reports created within the variety of a result. Therefore, it additionally acts as a repository.

SAP HANA Studio: this can be a user interfacing platform that AN Eclipse-based tool wherever we will manage, administer and manipulate knowledge. we will work on many views like Attribute, Analytic, and Calculation.

Clients: These area unit miscellaneous reportage tools that we will connect with the computing engine by utilizing specific drivers. we will style and share reports by utilizing these tools and consumer applications.

17. what’s the performance of a Replication server?

Ans:

The replication server is accountable for managing the replication of table knowledge similarly to information from the information supply.

18. what’s a persistence layer?

Ans:

The persistence layer is especially accountable for process knowledge backups sporadically and storing them for good. this can be called “Savepoints” and by default, the savepoint frequency is in every five minutes. {the knowledge|the info|the information} stores as log volumes and data volumes.

19. What area unit the subject area elements of SAP HANA?

Ans:

The SAP HANA system consists of various elements that along with making its system design.

Index server: The Index Server is that the main server in SAP HANA. it’s the information storage and process engine. Queries in several languages like SQL and MDX area unit received within the index server. Then, the queries area unit is processed by completely different elements and servers among it. The index server additionally manages the transactions and authentications. It additionally features a part that manages dealings logs and by selection stores knowledge. (SAP HANA Online Training)

Besides, the index server is additionally divided into smaller elements like relative knowledge engine, session manager, authorization management, designing engine, calc engine, and persistence layer.

Name server: The name server maintains the data of the topology or landscape of SAP HANA system surroundings. It contains info associated with the name and size of the HANA elements. It will increase the time interval by decreasing the re-indexing method because it keeps {the information|the knowledge|the knowledge} on what datastores during which server. (sap Hana admin interview questions)

Pre-processor server: Pre-processor server could be a text analyzing server that processes matter knowledge. The service provided by this part is employed throughout text search. Whenever an invitation initiates, this server processes matter knowledge and provides it to the user.

SAP HANA Studio Repository: The repository stores info associated with the freshly free updates. we will update the previous version to the newest ones with the assistance of this.

XS Engine: It facilitates communication between the external applications (Java and HTML based) and SAP HANA system via HTTP/HTTPS in an exceedingly applications program. The XS Engine converts the system’s state from the persistence model keep within the info into the consumption model for purchasers.

Subscribe for gratis Demo
Your Name
Your Email
Mobile variety

20. what’s the foremost necessary part of SAP HANA architecture?

Ans:

The Index Server is that the most significant part of SAP HANA design. it’s the info storage (having the particular data) part and a process engine. Queries in several languages like SQL and MDX square measure received within the index server. These queries square measure processed by completely different parts and servers at intervals of the index server.

21. Name the parts of the associate index server.

Ans:

There square measure six main parts of associate index server:

• Relational knowledge engine
• Connection and Session manager
• Authorization manager
• Planning engine
• Calc engine
• Persistence layer

22. what’s filler in SAP HANA?

Ans:

Sizing in SAP HANA refers to determinative the hardware necessities for specific SAP HANA installation necessities. Hardware parts are necessary for the filler purpose of reading square measure central processor, memory (RAM), and disc. the foremost crucial task in the filler is to estimate the scale of the server best suited to the business user’s necessities. (SAP HANA Training Videos)

In SAP HANA, we can perform filler in 3 ways:

Using fast Sizer tool
Using dB script
Using ABAP report

23. What square measure row and column storage in SAP HANA?

Ans:

Data within the SAP HANA info stores in 2 ways;

Row storage

Column storage.

Row storage is that the technique of storing knowledge in an exceedingly horizontal fashion. it’s just like however knowledge is held on historically in disk databases. However, there’s one main distinction between the SAP HANA row storage and ancient row storage. That is, in SAP HANA, knowledge is held on in rows within the main memory, and in ancient databases, knowledge is held on in rows within the disk storage.

Column storage technique stores knowledge in an exceedingly columnar fashion (linear/ vertical). knowledge is compressed with efficiency in column stores. It improves SAP HANA’s performance by optimizing each scan and write operation on knowledge. knowledge is held on within the column cargo deck that is split into 2 sections; Main storage and Delta Storage.

24. What square measure the various views in SAP HANA Studio?

Ans:

The SAP HANA Studio contains completely different views that we can like better to work on. Some usually used views are:

• SAP HANA Administration Console
• SAP HANA modeler
• Application Development
• Lifecycle Management
• SAP HANA Development
• ABAP
• BW Modeling

25. what’s SAP HANA System Monitor?

Ans:

Using the system monitor in SAP HANA Studio, we can administer and monitor the system’s health and handiness of SAP HANA parts. Also, mistreatment the system monitor, we can access the system’s details and configurations and therefore the services offered by completely different SAP HANA parts.

We can monitor many aspects through the SAP HANA system monitor like the alerts, disk space, log disks, trace disk, data disk, memory, performance, volume, etc. Thus, it’s convenient to manage individual aspects, tasks, and parts.

26. What all body operations will we tend to succeed from the Administration Console?

Ans:

Several body tasks are often performed within the SAP HANA Studio such as; regulation (start/stop) services, observation of the system, audit policy, and security configuration, user management, and authorization,

All of those tasks are often performed from completely different tabs gift within the administration console of SAP HANA Studio such as:

Overview (monitor and general management)
Alerts (position and look at the main points of the alerts)
Performance (evaluates the performance of the system for the activities happening within the database)
System info (access system info files and queries)
Landscape (check of all running services)
Volumes (details of the logs and knowledge volumes)
Trace Configuration (includes the traces created information)
Configuration (includes the knowledge of system configuration files)
Diagnosis Files (includes the system log files)

27 what’s SAP HANA info Modeler?

Ans:

Information modeler lets US-style info views or models on high of the SAP HANA info mistreatment tables in it. Such models square measure created to serve a business logic and operation. they’re generated directly on high of the HANA info layer. {the info|the knowledge|the knowledge} modeler provides the interface and tools to pick out attributes and measures from the info tables so the user will produce multiple information views mistreatment the physical tables of transactional data hold on within the databases. the knowledge views square measure a logical illustration of the info which may be more revealed or consumed for analytical functions. info modeling implements on the SAP HANA modeler perspective of SAP HANA Studio.

28. what’s the distinction between info modeler and data Composer?

Ans:

The two disagree with one another supported target users. SAP HANA info modeler is for technical users with in-depth knowledge modeling necessities and technical information. they’ll perform a spread of advanced operations associated with modeling like making attribute views, analytic views, calculation views, process models, knowledge management and administration, knowledge loading, and import/export tables.

Whereas, info musician is formed for non-technical users WHO don’t seem to be IT and knowledge science consultants (with no info or modeling knowledge). the knowledge musician is therefore designed that aids non-technical users with an easy interface, animations, hints, and suggestions for modeling and coverage.

29. What square measure the 3 kinds of info views?

Ans:

The 3 kinds of info views are: Attribute read uses attributes, or the non-measurable, non-quantifiable knowledge to style views and models in step with the business logic. Thus, {the data|the info|the info} utilized in the attribute read is brought up as ‘Master data’ because it is employed as reference information in different views (analytic and calculation). The tables within the attribute read don’t contain any facts or measures.

In associate analytic read, we can produce star schemas, having a central dealing or truth table and multiple dimension tables joined thereto via primary keys. The measures square measure contained solely within the central dealing table which may be classified or joined with multiple dimension tables.

Calculation read is a complicated model that uses each attribute and analytic read components it to create complicated|a posh|a fancy} knowledge model following complex business logic.

It provides the US the liberty to mix and build from a spread of choices like tables, column views, analytic views, attribute views, etc. It allows the US to try and do two-dimensional coverage mistreatment measures and dimensions from a completely different source

30. What are the kinds of SAP HANA engines?

Ans:

There are 3 forms of SAP HANA engines:

Join Engine: we tend to use the be part of the engine on every occasion AN attribute read is made or used, or a be part of the condition is applied in an exceedingly native SQL command.
OLAP Engine: we tend to use the OLAP engine within the creation of analytic views. we tend to use it only attributes are utilized in the analytical read and no calculation is completed. If operations like calculations, counters, restricted measures are used then alternative engines sort of a calculation engine are employed besides the OLAP engine.
Calculation Engine: we tend to use the calculation engine in calculation besides getting used in alternative reads like analytical and attribute view whenever they apply complicated logic and calculation operations.