How Well Do You Know About SAP HANA?

The target audience for SAP Web Development Workbench is application developers. This tool is specifically designed to assist developers in creating and maintaining web applications within the SAP environment. It provides a range of features and functionalities that cater to the needs of developers, such as code editing, debugging, and testing tools. Administrators, installation engineers, and project managers may also interact with the Workbench, but their roles are more focused on managing and overseeing the development process rather than actively developing the applications themselves.

XS does not cleanse data, it is not an interface, and it does not handle excessive data loads — XS is an lightweight application server. Refer to HA100, Unit 2 Architecture of SAP HANA for details.

A secondary read-only HANA is used to continuously capture and replay the database log from a primary HANA. The secondary read-only HANA can then be used for any read-intense tasks, thereby off-loading this work from the primary HANA to balance the workloads and increase overall performance.

You can use SAP SLT for real-time replication from SAP and non SAP sources. 

With fuzzy search, when you enter ', SAP HANA will return words that are closely matched in spelling. Fuzzy search is a technique that allows for approximate matching of words, taking into account spelling variations, misspellings, and typos. In this case, SAP HANA will provide suggestions or results that closely resemble the entered query, even if there are slight spelling differences.

A multi-target application (MTA) is built with XS Advanced and allows single development projects to be deployed to on premise or cloud. With XS you cannot build MTAs.

SAP HANA security services include audit logging, authentication, encryption, and authorization. Audit logging is the process of recording and monitoring activities within the system to ensure compliance and detect any unauthorized access or changes. Authentication is the process of verifying the identity of users before granting them access to the system. Encryption is used to protect sensitive data by converting it into unreadable format, ensuring confidentiality. Authorization involves granting or denying access to specific resources or functionalities based on user roles and privileges. These security services collectively help safeguard the SAP HANA system and its data from unauthorized access and potential threats.

A multistore table is a new feature of SAP HANA 2.0, where partitions can be spread across memory and extended storage.

SAP HANA does not handle antivirus protection. Refer to HA100, Unit 2 Architecture of SAP HANA for details.

Functions can only produce one tabular output whereas Procedures can produce multiple tabular outputs.

SAP HANA Cockpit provides key HANA system performance information as well as many other administration tools.

Column tables are more efficient when there is lots of repeating data values in columns. This is because we can remove all duplicates of each value and in place use binary integers for a smaller footprint and faster processing.

The SAP Web Development Workbench supports Calculation views. Calculation views are used in SAP HANA to perform complex calculations and aggregations on data from multiple tables. They allow users to define and execute complex calculations and transformations on data, making it easier to analyze and derive insights from large datasets. Calculation views are an important tool in SAP HANA for building analytical applications and performing advanced data analysis.

The Business Function Library refers to the set of re-useable building blocks that have been defined by SAP for SAP HANA based applications. These building blocks can be used to quickly and efficiently develop applications on the SAP HANA platform, saving time and effort in the development process. By using the pre-defined functions and components provided in the library, developers can focus on implementing the specific business logic required for their applications, rather than starting from scratch. This promotes consistency, standardization, and reusability across different applications built on SAP HANA.

SAP recommends using the Calculation view because it allows users to perform complex calculations and aggregations on data from multiple tables. Calculation views provide a flexible and powerful way to analyze data by combining various data sources and applying calculations, filters, and aggregations. This type of view is especially useful for creating reports and dashboards that require advanced calculations and data transformations.

False. It is a browser-based interface.

A perspective in SAP HANA refers to a collection of views in the SAP HANA Studio that are organized by role. This means that different users with different roles can have access to different perspectives, allowing them to view and analyze data based on their specific needs and responsibilities. Perspectives help to streamline the user experience and make it more efficient by organizing relevant views in a logical manner.

SAP HANA does not use predefined aggregates. This means that SAP HANA does not rely on pre-calculated or pre-aggregated data to perform queries and analysis. Instead, it uses an in-memory computing technology that allows for real-time processing of large volumes of data. This enables users to access and analyze data without the need for pre-aggregations, resulting in faster and more flexible data analysis.

In a visual application that uses SAP HANA spatial processing, the most likely way to represent the location of an ATM would be through a point. A point represents a specific location on a map and is commonly used to denote a single point of interest, such as an ATM. This allows for easy identification and visualization of the ATM's location within the application.

SQL permissions only secure the database object, not data values. Authorisation object is an ABAP object, not used in SAP HANA. Analytic Privilege is used to define security around rows (data).

When creating a system connection in SAP HANA Studio, it is essential to have a valid user and password, as well as the host and instance information. The user and password are necessary to authenticate and access the system. The host is the name or IP address of the server where the SAP HANA database is running. The instance refers to the specific SAP HANA instance or system that you want to connect to. These pieces of information are crucial for establishing a successful connection to the SAP HANA system.

SAP HANA is used as an accelerator by working alongside a disk-based database to enhance the read access for existing SAP applications. This means that instead of replacing the entire database, SAP HANA is integrated with the existing system to improve the speed of retrieving data. By utilizing its in-memory computing capabilities, SAP HANA can quickly process and retrieve data, resulting in faster access and improved performance for SAP applications.

SAP HANA uses multi-level cache in order to provide excellent performance: Refer to Unit 1 Describing SAP HANA for details.

R is an open source language commonly used for creating custom predictive algorithms. It provides a wide range of statistical and graphical techniques, making it a popular choice among data scientists and statisticians. R has a vast library of packages that offer various functionalities for data manipulation, visualization, and machine learning, making it a powerful tool for developing predictive models. Its flexibility, extensive community support, and ability to handle large datasets make R a preferred language for predictive analytics tasks.

ODBC, JDBC and ABAP are not database query languages. MDX and SQL are database query languages supported by SAP HANA.

In an SAP HANA application, you usually find two or three tiers. The first tier is the client tier, where the user interacts with the application. The second tier is the application server tier, which processes the user's requests and communicates with the database. The third tier, if present, is the database tier, where the data is stored and managed. Having multiple tiers allows for a separation of concerns and improves scalability and performance of the application.

Running SAP BW on SAP HANA can lead to improvements in data loading performance and reporting performance. With SAP HANA's in-memory computing capabilities, data can be loaded and processed much faster, resulting in reduced loading times and improved overall performance. Additionally, HANA's advanced analytical capabilities enable faster and more efficient reporting, allowing users to access real-time insights and make data-driven decisions more quickly.

‘Voice of Customer’ is a standard dictionary used in sentiment analysis that contains expressions that customers may use to describe how they feel about products or services.

SAP Enterprise Architecture Designer is a tool used to design and build a logical data model, and then, optionally, generate a corresponding physical data model.

In SAP HANA Studio, you can connect to different SAP HANA systems using different user IDs. The same user ID is not required for each connection. Therefore, the statement is false.

SDS (for streaming) and SDA (for virtualizing) are not part of EIM.

The four SAP HANA platform services are Processing Services, Database Services, Application Services, and Integration Services. Processing Services refer to the capabilities that allow data to be processed and analyzed in real-time. Database Services include the features and functionalities related to data storage, retrieval, and management. Application Services involve the tools and services that enable the development and deployment of applications on the SAP HANA platform. Integration Services focus on integrating SAP HANA with other systems and applications to ensure seamless data flow and interoperability.

SAP HANA runs only on Intel x86 and IBM Power Series platforms. SAP HANA runs on Linux not Unix.

We are moving away from disk and towards memory based data storage and processing using multi-core processors: Refer to HA100 Unit 1 Describing SAP HANA for details

In a native SAP HANA application (built with XS/XSA) we need only the presentation layer and SAP HANA. SAP HANA provides both the application services and also the database services.

The main benefit of using DXC is the ability to re-use the built-in extraction technology in SAP source systems. This means that instead of having to develop and implement a separate extraction process for each data source, DXC allows users to leverage the extraction capabilities already present in SAP source systems. This saves time, effort, and resources, making the data extraction process more efficient and streamlined.

Scale-out is the use of standby servers that we can switch over to in case of primary server failure. It is also the use of multiple servers to help spread the workload.

Flowgraph is used to create SAP HANA EIM (Enterprise Information Management) jobs. A flowgraph is a visual representation of a data flow process that allows users to design and execute complex data integration and transformation tasks. It provides a graphical interface for designing and configuring data flows, making it easier for users to define the sequence of operations and transformations required for EIM jobs. With flowgraph, users can visually connect different data sources, apply transformations, and load data into SAP HANA for further analysis and reporting.

Neither SAP HANA Studio nor Web Based Workbench are used with XSA, as they are used with XS application development only. Web IDE is not used with SAP HANA, as it is used for SAP Fiori and SAPUI5 application development.

The persistent layer is needed to off-load low priority data from memory to disk when memory is full. It is also used to store periodic snapshots of memory in case we lose power and need to recover memory from the last saved snapshot.

Catalog is not a view in Web IDE. Refer to HA100, Unit 2 Architecture of SAP HANA for more details.

SAP HANA 1.0 is the ‘stability’ release, SAP HANA 2.0 is the ‘innovation’ release and receives upgrades every 6 months with new features.

Transactional processing and analysis are now coming back together to support a simpler landscape and enable real-time decision making removing the need to move the data from one system to another.

The correct answer is SAP BW, edition for SAP HANA. This version of SAP BW was specifically developed and optimized to run on the SAP HANA platform. It leverages the in-memory capabilities of SAP HANA to provide faster data processing and real-time analytics.

Data Distribution Optimizer is a key tool of Data Warehouse foundation and it helps you to manage data locality by ensuring tables that are frequently processed together, stay together and are not split up across nodes in a scale-out landscape.

SAP HANA supports Computational Continuous Language as a standard data streaming language. This language allows for continuous processing and analysis of data streams in real-time. It enables users to perform complex calculations and transformations on streaming data, making it suitable for processing large volumes of data in real-time scenarios.

SAP HANA Live is a solution that provides consumption ready views of operational data sourced from SAP systems. It also includes supplied tools that allow users to explore and extend the SAP HANA Live content. This means that users can easily access and analyze real-time data from SAP systems, making it easier to make informed business decisions.

Column store tables are optimized for read-intense analytical processing, not transactional processing where read and write is needed. They also use automatic compression to reduce the footprint and we only need to load columns that are required into memory. Also, you can partition column tables. You can’t do any of these things with row tables. Refer to HA100 Unit 2, Architecture of SAP HANA, for details.

Mixed modeling integrates SAP HANA Calculation views and SAP HANA optimized BW models such as DSOs.

To maintain good read performance in a constantly changing database, two components are used: Delta storage and Main storage. Delta storage is used to store the changes or updates made to the database, allowing for efficient retrieval of the most recent data. Main storage, on the other hand, stores the primary data and provides fast access to frequently accessed information. By utilizing both Delta storage and Main storage, the database can effectively handle constant changes while ensuring optimal read performance.