How Well Do You Know About SAP HANA?

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Bob
B
Bob
Community Contributor
Quizzes Created: 2 | Total Attempts: 1,400
Questions: 75 | Attempts: 349

SettingsSettingsSettings
How Well Do You Know About SAP HANA? - Quiz

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?


Questions and Answers
  • 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 processors
    Explanation
    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

    Rate 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 platform
    Explanation
    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 content
    Explanation
    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 warehouse
    Explanation
    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. Authorisation
    Explanation
    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 applications
    Explanation
    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. R
    Explanation
    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 spelling
    Explanation
    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. Point
    Explanation
    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-use
    Explanation
    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. Calculation
    Explanation
    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 volume
    Explanation
    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 partitioned
    Explanation
    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. False
    Explanation
    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. Procedures
    Explanation
    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. Instance
    Explanation
    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 server
    Explanation
    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 algorithms
    Explanation
    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 systems
    Explanation
    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 capture
    Explanation
    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 Language
    Explanation
    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. FlowgrapH
    Explanation
    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. SDQ
    Explanation
    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. True
    Explanation
    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 Duplication
    Explanation
    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 possibilities
    Explanation
    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 HANA
    Explanation
    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 performance
    Explanation
    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. Dashboards
    Explanation
    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. MDX
    Explanation
    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 both
    Explanation
    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 Services
    Explanation
    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. True
    Explanation
    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 applications
    Explanation
    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 loading
    Explanation
    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. 3
    Explanation
    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. False
    Explanation
    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 role
    Explanation
    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 developers
    Explanation
    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. Calculation
    Explanation
    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. False
    Explanation
    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 storage
    Explanation
    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 failure
    Explanation
    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 performance
    Explanation
    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. Authorisation
    Explanation
    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 privilege
    Explanation
    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. False
    Explanation
    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 CRM
    Explanation
    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 CDS
    Explanation
    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, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 29, 2019
    Quiz Created by
    Bob
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.