How Well Do You Know About SAP HANA?
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?
- 1.
Which recent technology advances have made SAP HANA possible?
- A.
Faster internet speeds
- B.
Large and cheaper memory
- C.
Multi-core processors
- D.
Faster disk speeds
Correct Answer(s)
B. Large and cheaper memory
C. Multi-core processorsExplanation
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 detailsRate this question:
-
- 2.
What are the key features of SAP HANA?
- A.
In-memory database
- B.
Automatic compression of data
- C.
Removes the need for security screening
- D.
Combines database (OLTP) and data processing (OLAP) in one platform
Correct Answer(s)
A. In-memory database
B. Automatic compression of data
D. Combines database (OLTP) and data processing (OLAP) in one platformExplanation
SAP HANA uses multi-level cache in order to provide excellent performance: Refer to Unit 1 Describing SAP HANA for details.Rate this question:
-
- 3.
What is SAP HANA Live?
- A.
Consumption ready views of operational data that is sourced from SAP systems
- B.
Out of the box ready applications and systems
- C.
Supplied tools to explore and extend the SAP HANA Live content
- D.
A twice yearly check up and update of the system
Correct Answer(s)
A. Consumption ready views of operational data that is sourced from SAP systems
C. Supplied tools to explore and extend the SAP HANA Live contentExplanation
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.Rate this question:
-
- 4.
SAP HANA can be used in which scenarios?
- A.
To power Enterprise Suites
- B.
To replace ABAP
- C.
As a general purpose database
- D.
For OEM partners to embed their SAP HANA into their applications
- E.
As a data warehouse
Correct Answer(s)
A. To power Enterprise Suites
C. As a general purpose database
D. For OEM partners to embed their SAP HANA into their applications
E. As a data warehouseExplanation
SAP HANA can be used in various scenarios. It can be used to power Enterprise Suites, providing a high-performance platform for running business applications. It can also be used as a general-purpose database, allowing users to store and retrieve data efficiently. Additionally, SAP HANA can be embedded into applications by OEM partners, enabling them to leverage its capabilities. Lastly, it can be used as a data warehouse, allowing organizations to store and analyze large volumes of data for reporting and decision-making purposes.Rate this question:
-
- 5.
SAP HANA security services include which of the following?
- A.
Audit logging
- B.
Authentication
- C.
Encryption
- D.
Antivirus protection
- E.
Authorisation
Correct Answer(s)
A. Audit logging
B. Authentication
C. Encryption
E. AuthorisationExplanation
SAP HANA does not handle antivirus protection. Refer to HA100, Unit 2 Architecture of SAP HANA for details.Rate this question:
-
- 6.
What is the Business Function Library?
- A.
SAP defined re-useable building blocks for SAP HANA based applications
- B.
An interface to allow fine tuning of business logic
- C.
A list of published BAPIs that can be called from SAP HANA
- D.
A dedicated SAP HANA engine optimized for business functions
Correct Answer
A. SAP defined re-useable building blocks for SAP HANA based applicationsExplanation
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.Rate this question:
-
- 7.
Which open source language do you use to create custom predictive algorithms?
- A.
R
- B.
L
- C.
C++
- D.
ABAP
Correct Answer
A. RExplanation
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.Rate this question:
-
- 8.
With fuzzy search, when I enter ', what does SAP HANA return?
- A.
Words that are closely matched in spelling
- B.
Words that are closely matched in meaning
Correct Answer
A. Words that are closely matched in spellingExplanation
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.Rate this question:
-
- 9.
How would you most likely represent the location of an ATM in a visual application that uses SAP HANA spatial processing?
- A.
Multi-polygon
- B.
Polygon
- C.
Line
- D.
Point
Correct Answer
D. PointExplanation
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.Rate this question:
-
- 10.
Which are valid SAP HANA Live views?
- A.
Private
- B.
Re-use
- C.
Shared
- D.
Secured
Correct Answer(s)
A. Private
B. Re-useExplanation
The valid SAP HANA Live views can be categorized into two types: private and re-use. Private views are specific to a user and can only be accessed by that user. Re-use views, on the other hand, can be accessed and used by multiple users. Therefore, both private and re-use views are valid options for SAP HANA Live views.Rate this question:
-
- 11.
SAP recommends to use which of these types of view?
- A.
Calculation
- B.
Attribute
- C.
Database
- D.
Analytical
Correct Answer
A. CalculationExplanation
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.Rate this question:
-
- 12.
What are the two storage components used to restore the database in case of power failure?
- A.
Log area
- B.
Data volume
- C.
Memory
- D.
Delta store
Correct Answer(s)
A. Log area
B. Data volumeExplanation
The two components used are data volume, to store the savepoints that periodically capture snapshots of memory, and log area, to store the log that replays all committed transactions since the last save point. Refer to HA100, Unit 2 Architecture of SAP HANA for details.Rate this question:
-
- 13.
What are advantages of column store tables?
- A.
Data footprint is automatically reduced through compression
- B.
Only the columns required are actually loaded to memory
- C.
Columns can be partitioned
- D.
Aggregates can be created
Correct Answer(s)
A. Data footprint is automatically reduced through compression
B. Only the columns required are actually loaded to memory
C. Columns can be partitionedExplanation
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.Rate this question:
-
- 14.
TRUE or FALSE? SAP Web Development Workbench is installed on Windows.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
False. It is a browser-based interface.Rate this question:
-
- 15.
What would you find in a package?
- A.
Information/Calculation Views
- B.
Analytic Privileges
- C.
Procedures
- D.
Security Protocols
- E.
Tables
Correct Answer(s)
A. Information/Calculation Views
B. Analytic Privileges
C. ProceduresExplanation
In a HANA Studio package, you will find Calculation Views, Analytic Privileges, and Procedures but not tables. Tables are found in the schemas, which are located under the catalog node. Refer to HA100 Unit 2, Architecture of SAP HANA for more details.Rate this question:
-
- 16.
When creating a system connection in SAP HANA Studio, which of these is essential information?
- A.
A valid user and password
- B.
Host
- C.
URL
- D.
Instance
Correct Answer(s)
A. A valid user and password
B. Host
D. InstanceExplanation
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.Rate this question:
-
- 17.
What is XS?
- A.
A native, lightweight application server
- B.
An optional engine to handle excessive data loads
- C.
A data cleansing engine
- D.
A user interface
Correct Answer
A. A native, lightweight application serverExplanation
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.Rate this question:
-
- 18.
What is the SAP HANA Application Function Library (AFL)?
- A.
Repository of ready made business functions
- B.
Repository of connections that can be used by business functions
- C.
Repository of ready made predictive algorithms
- D.
Repository of ready to run applications that are powered by SAP HANA
Correct Answer(s)
A. Repository of ready made business functions
C. Repository of ready made predictive algorithmsExplanation
The SAP HANA Application Function Library (AFL) is a repository that contains ready-made business functions and predictive algorithms. It provides a collection of pre-built functions and algorithms that can be used by developers and analysts to perform various tasks and calculations within SAP HANA. These functions and algorithms are already built and optimized for use with SAP HANA, making it easier and more efficient to perform complex calculations and analysis.Rate this question:
-
- 19.
What is the main benefit for using DXC?
- A.
Connectivity to a large number of data sources
- B.
Powerful data transformation
- C.
Re-use built in extraction technology in SAP source systems
- D.
Real time data loading
Correct Answer
C. Re-use built in extraction technology in SAP source systemsExplanation
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.Rate this question:
-
- 20.
What are the key strengths of SAP Data Service?
- A.
Real time replication
- B.
Data cleansing
- C.
Data integration
- D.
Managing change data capture
- E.
Data streaming
Correct Answer(s)
B. Data cleansing
C. Data integration
D. Managing change data captureExplanation
The key strengths of SAP Data Service include data cleansing, data integration, and managing change data capture. Data cleansing refers to the process of identifying and correcting or removing errors, inconsistencies, and inaccuracies in the data. Data integration involves combining data from different sources and formats into a unified view. Managing change data capture allows for capturing and tracking changes made to the data over time. These strengths highlight the ability of SAP Data Service to ensure data quality, streamline data integration processes, and effectively manage data changes.Rate this question:
-
- 21.
Which standard data streaming language does SAP HANA support?
- A.
Computational Continuous Language
- B.
Dynamic SQL
- C.
Python
- D.
Pearl
Correct Answer
A. Computational Continuous LanguageExplanation
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.Rate this question:
-
- 22.
SAP HANA EIM jobs are created using which of the following?
- A.
SAP HANA procedure
- B.
Graphical calculation view
- C.
SQLScript
- D.
Flowgraph
Correct Answer
D. FlowgraphExplanation
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.Rate this question:
-
- 23.
SAP HANA EIM includes which components?
- A.
SDI
- B.
SDA
- C.
SDS
- D.
SDQ
Correct Answer(s)
A. SDI
D. SDQExplanation
SDS (for streaming) and SDA (for virtualizing) are not part of EIM.Rate this question:
-
- 24.
TRUE or FALSE? SAP SLT can be used for real-time replication from SAP and also non SAP sources.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
You can use SAP SLT for real-time replication from SAP and non SAP sources.Rate this question:
-
- 25.
What are typical characteristics of replication?
- A.
Virtualisation
- B.
Transformation
- C.
Real-time
- D.
Batch
- E.
Synchronisation/Data Duplication
Correct Answer(s)
C. Real-time
E. Synchronisation/Data DuplicationExplanation
Data replication with SAP HANA is typically the duplication of data in real time with no changes to data. Refer to HA100, Unit 4, Data Management with SAP HANA, for details.Rate this question:
-
- 26.
What are some features of SDA?
- A.
Automatic data type translation
- B.
Data cleansing functions
- C.
Evaluation and execution of push down possibilities
- D.
Data recovery services due to power outage
Correct Answer(s)
A. Automatic data type translation
C. Evaluation and execution of push down possibilitiesExplanation
SDA does not support cleansing or merging of multiple data sources.Rate this question:
-
- 27.
Which are correct statements relating to flat file loading?
- A.
The new table always has a 1:1 mapping between file and table columns
- B.
The supported file types for upload are: .csv and .txt
- C.
When loading new data in a table that already contains data, the new data is appended to the existing data
- D.
The import function does not allow the renaming of column changes to the data type for existing columns
- E.
Renaming of columns and changing data types is allowed when loading data to new HANA tables.
Correct Answer(s)
A. The new table always has a 1:1 mapping between file and table columns
C. When loading new data in a table that already contains data, the new data is appended to the existing data
E. Renaming of columns and changing data types is allowed when loading data to new HANA tables.Explanation
You cannot transform data during the load, but you can ignore fields and even add empty ones. Supported file types are CSV and XLS. Data is never overwritten. Renaming columns and changing data types is not allowed when loading to existing tables.Rate this question:
-
- 28.
What is the name of the version of SAP BW that was built just for SAP HANA?
- A.
SAP BW, powered by SAP HANA
- B.
SAP BW, run by SAP HANA
- C.
SAP BW, edition for SAP HANA
- D.
SAP BW, driven by SAP HANA
Correct Answer
C. SAP BW, edition for SAP HANAExplanation
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.Rate this question:
-
- 29.
In which key areas can we expect there to be improvements when running SAP BW on SAP HANA?
- A.
Tighter security
- B.
Data loading performance
- C.
Superior data quality
- D.
Reporting performance
Correct Answer(s)
B. Data loading performance
D. Reporting performanceExplanation
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.Rate this question:
-
- 30.
Which of these tools must access SAP HANA via the Semantic Layer?
- A.
Web Intelligence
- B.
Analysis
- C.
Design Studio
- D.
Excel
- E.
Dashboards
Correct Answer(s)
A. Web Intelligence
E. DashboardsExplanation
Web Intelligence and Dashboards must access SAP HANA via the Semantic Layer. The Semantic Layer acts as an intermediary between the reporting tools and the database, providing a simplified and business-friendly view of the data. Web Intelligence and Dashboards rely on this layer to access and retrieve data from SAP HANA, allowing users to create interactive reports and visualizations. Analysis, Design Studio, and Excel, on the other hand, can directly connect to SAP HANA without the need for the Semantic Layer.Rate this question:
-
- 31.
What are the database query languages used by SAP HANA?
- A.
ODBC
- B.
JDBC
- C.
SQL
- D.
ABAP
- E.
MDX
Correct Answer(s)
C. SQL
E. MDXExplanation
ODBC, JDBC and ABAP are not database query languages. MDX and SQL are database query languages supported by SAP HANA.Rate this question:
-
- 32.
Which are true statements?
- A.
SAP HANA runs on Intel x86 and SPARC hardware platforms
- B.
SAP HANA runs on Unix
- C.
SAP HANA can be installed only by certified engineers for production purposes
- D.
Customers can re-use their own certified hardware components in an SAP HANA system
- E.
SAP HANA is available in the cloud or on premise or a combination of both
Correct Answer(s)
C. SAP HANA can be installed only by certified engineers for production purposes
D. Customers can re-use their own certified hardware components in an SAP HANA system
E. SAP HANA is available in the cloud or on premise or a combination of bothExplanation
SAP HANA runs only on Intel x86 and IBM Power Series platforms. SAP HANA runs on Linux not Unix.Rate this question:
-
- 33.
What are the four SAP HANA platform services?
- A.
Processing Services
- B.
Database Services
- C.
Application Services
- D.
Security Services
- E.
Integration Services
Correct Answer(s)
A. Processing Services
B. Database Services
C. Application Services
E. Integration ServicesExplanation
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.Rate this question:
-
- 34.
TRUE or FALSE? SAP HANA does not use predefined aggregates.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 35.
How is SAP HANA used as an Accelerator?
- A.
To reduce the time it takes to develop and deploy an application on SAP HANA
- B.
To provide a way to vary the speed of SAP HANA in order to reduce resources
- C.
To improve the speed of data loading to SAP HANA
- D.
To work alongside a disk based database in order to speed up the read access for existing SAP applications
Correct Answer
D. To work alongside a disk based database in order to speed up the read access for existing SAP applicationsExplanation
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.Rate this question:
-
- 36.
Where is Smart Data Integration (SDI) used?
- A.
For data cleansing
- B.
For data transformation
- C.
For data streaming
- D.
For data loading
- E.
For data acquisition
- F.
For data integration
Correct Answer(s)
B. For data transformation
D. For data loadingExplanation
SDI is the in-built ETL component of SAP HANA and is used for data transformation and loading — SDQ is for cleansing — SDS is for streaming.Rate this question:
-
- 37.
How many tiers do you usually find in an SAP HANA application?
- A.
1
- B.
2
- C.
3
Correct Answer(s)
B. 2
C. 3Explanation
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.Rate this question:
-
- 38.
TRUE OR FALSE: You can connect to different SAP HANA systems from SAP HANA Studio but the same user id must be used in each connection.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 39.
What is a perspective?
- A.
A group of users in a specific SAP HANA role
- B.
A collection of views in the SAP HANA Studio that are organised by role
- C.
A list of allowed objects in SAP HANA that can be changed by a particular role
- D.
A set of security permissions that aligns to a user's view of the data.
Correct Answer
B. A collection of views in the SAP HANA Studio that are organised by roleExplanation
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.Rate this question:
-
- 40.
Who is the target audience for SAP Web Development Workbench?
- A.
Application developers
- B.
Administrators
- C.
Installation engineers
- D.
Project managers
Correct Answer
A. Application developersExplanation
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.Rate this question:
-
- 41.
Which views does SAP Web Development Workbench support?
- A.
Analytical
- B.
Calculation
- C.
Attribute
Correct Answer
B. CalculationExplanation
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.Rate this question:
-
- 42.
TRUE or FALSE? Row store tables are more efficient when there are lots of repeating data values in columns.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 43.
To maintain good read performance in a constantly changing database, which two components are used?
- A.
Column store
- B.
Memory store
- C.
Delta storage
- D.
Main storage
Correct Answer(s)
C. Delta storage
D. Main storageExplanation
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.Rate this question:
-
- 44.
Why do we still need a persistence layer?
- A.
To store data that has been unloaded from memory
- B.
To hold delta store for newly arrived records
- C.
To enable full database recovery if we have a power failure
- D.
To store data that is frequently used
Correct Answer(s)
A. To store data that has been unloaded from memory
C. To enable full database recovery if we have a power failureExplanation
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.Rate this question:
-
- 45.
What is scale out?
- A.
Use of standby servers used in the event of hardware failure
- B.
Use of remote servers to store archived data that is rarely used
- C.
Use of commodity servers that are used in high volume streaming applications
- D.
Use of multiple servers to spread processing and improve performance
Correct Answer(s)
A. Use of standby servers used in the event of hardware failure
D. Use of multiple servers to spread processing and improve performanceExplanation
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.Rate this question:
-
- 46.
SAP HANA security services include which of the following?
- A.
Audit logging
- B.
Authentication
- C.
Encryption
- D.
Antivirus protection
- E.
Authorisation
Correct Answer(s)
A. Audit logging
B. Authentication
C. Encryption
E. AuthorisationExplanation
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.Rate this question:
-
- 47.
Access to specific rows of a HANA data model are restricted by what?
- A.
SQL permission
- B.
Authorisation project
- C.
Analytic privilege
Correct Answer
C. Analytic privilegeExplanation
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).Rate this question:
-
- 48.
TRUE or FALSE? SAP HANA uses aggregates to ensure great read performance.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
SAP HANA does not use aggregates to ensure great read performance. Instead, it uses an in-memory computing engine that allows for real-time processing of data, eliminating the need for pre-aggregation. This enables faster data retrieval and analysis, making it unnecessary to use aggregates for performance optimization. Therefore, the statement that SAP HANA uses aggregates for great read performance is false.Rate this question:
-
- 49.
Which SAP applications does SAP HANA Live support?
- A.
SAP S/4 HANA
- B.
SAP ERP
- C.
SAP Business One
- D.
SAP CRM
Correct Answer(s)
B. SAP ERP
D. SAP CRMExplanation
SAP HANA Live supports SAP ERP and SAP CRM applications. These applications can leverage the real-time data processing capabilities of SAP HANA to provide users with up-to-date and actionable insights. By integrating with SAP HANA, SAP ERP and SAP CRM can deliver faster and more accurate analytics, reporting, and decision-making capabilities to businesses.Rate this question:
-
- 50.
The virtual data model for SAP S/4HANA is based on which of these?
- A.
ABAP CDS
- B.
SAP HANA Live
- C.
ABAP
- D.
SAP HANA CDS
Correct Answer
A. ABAP CDSExplanation
S/4HANA uses ABAP CDS for its virtual data model.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 29, 2019Quiz Created by
Bob
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Software Quizzes
Back to top