SAP HANA is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE. Its primary function as the software running a database server is to store and retrieve data as requested by the applications. How well do you know about SAP HANA?
In-memory database
Automatic compression of data
Removes the need for security screening
Combines database (OLTP) and data processing (OLAP) in one platform
Rate this question:
Consumption ready views of operational data that is sourced from SAP systems
Out of the box ready applications and systems
Supplied tools to explore and extend the SAP HANA Live content
A twice yearly check up and update of the system
Rate this question:
To power Enterprise Suites
To replace ABAP
As a general purpose database
For OEM partners to embed their SAP HANA into their applications
As a data warehouse
Rate this question:
Audit logging
Authentication
Encryption
Antivirus protection
Authorisation
Rate this question:
SAP defined re-useable building blocks for SAP HANA based applications
An interface to allow fine tuning of business logic
A list of published BAPIs that can be called from SAP HANA
A dedicated SAP HANA engine optimized for business functions
Rate this question:
R
L
C++
ABAP
Rate this question:
Words that are closely matched in spelling
Words that are closely matched in meaning
Rate this question:
Multi-polygon
Polygon
Line
Point
Rate this question:
Private
Re-use
Shared
Secured
Rate this question:
Calculation
Attribute
Database
Analytical
Rate this question:
Log area
Data volume
Memory
Delta store
Rate this question:
Data footprint is automatically reduced through compression
Only the columns required are actually loaded to memory
Columns can be partitioned
Aggregates can be created
Rate this question:
True
False
Rate this question:
Information/Calculation Views
Analytic Privileges
Procedures
Security Protocols
Tables
Rate this question:
A valid user and password
Host
URL
Instance
Rate this question:
A native, lightweight application server
An optional engine to handle excessive data loads
A data cleansing engine
A user interface
Rate this question:
Repository of ready made business functions
Repository of connections that can be used by business functions
Repository of ready made predictive algorithms
Repository of ready to run applications that are powered by SAP HANA
Rate this question:
Connectivity to a large number of data sources
Powerful data transformation
Re-use built in extraction technology in SAP source systems
Real time data loading
Rate this question:
Real time replication
Data cleansing
Data integration
Managing change data capture
Data streaming
Rate this question:
Computational Continuous Language
Dynamic SQL
Python
Pearl
Rate this question:
SAP HANA procedure
Graphical calculation view
SQLScript
Flowgraph
Rate this question:
SDI
SDA
SDS
SDQ
Rate this question:
True
False
Rate this question:
Virtualisation
Transformation
Real-time
Batch
Synchronisation/Data Duplication
Rate this question:
Automatic data type translation
Data cleansing functions
Evaluation and execution of push down possibilities
Data recovery services due to power outage
Rate this question:
The new table always has a 1:1 mapping between file and table columns
The supported file types for upload are: .csv and .txt
When loading new data in a table that already contains data, the new data is appended to the existing data
The import function does not allow the renaming of column changes to the data type for existing columns
Renaming of columns and changing data types is allowed when loading data to new HANA tables.
Rate this question:
SAP BW, powered by SAP HANA
SAP BW, run by SAP HANA
SAP BW, edition for SAP HANA
SAP BW, driven by SAP HANA
Rate this question:
Tighter security
Data loading performance
Superior data quality
Reporting performance
Rate this question:
Web Intelligence
Analysis
Design Studio
Excel
Dashboards
Rate this question:
ODBC
JDBC
SQL
ABAP
MDX
Rate this question:
SAP HANA runs on Intel x86 and SPARC hardware platforms
SAP HANA runs on Unix
SAP HANA can be installed only by certified engineers for production purposes
Customers can re-use their own certified hardware components in an SAP HANA system
SAP HANA is available in the cloud or on premise or a combination of both
Rate this question:
Processing Services
Database Services
Application Services
Security Services
Integration Services
Rate this question:
True
False
Rate this question:
To reduce the time it takes to develop and deploy an application on SAP HANA
To provide a way to vary the speed of SAP HANA in order to reduce resources
To improve the speed of data loading to SAP HANA
To work alongside a disk based database in order to speed up the read access for existing SAP applications
Rate this question:
For data cleansing
For data transformation
For data streaming
For data loading
For data acquisition
For data integration
Rate this question:
1
2
3
Rate this question:
True
False
Rate this question:
A group of users in a specific SAP HANA role
A collection of views in the SAP HANA Studio that are organised by role
A list of allowed objects in SAP HANA that can be changed by a particular role
A set of security permissions that aligns to a user's view of the data.
Rate this question:
Application developers
Administrators
Installation engineers
Project managers
Rate this question:
Analytical
Calculation
Attribute
Rate this question:
True
False
Rate this question:
Column store
Memory store
Delta storage
Main storage
Rate this question:
To store data that has been unloaded from memory
To hold delta store for newly arrived records
To enable full database recovery if we have a power failure
To store data that is frequently used
Rate this question:
Use of standby servers used in the event of hardware failure
Use of remote servers to store archived data that is rarely used
Use of commodity servers that are used in high volume streaming applications
Use of multiple servers to spread processing and improve performance
Rate this question:
Audit logging
Authentication
Encryption
Antivirus protection
Authorisation
Rate this question:
SQL permission
Authorisation project
Analytic privilege
Rate this question:
True
False
Rate this question:
SAP S/4 HANA
SAP ERP
SAP Business One
SAP CRM
Rate this question:
Quiz Review Timeline (Updated): Mar 21, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Wait!
Here's an interesting quiz for you.