- SAP HANA Tutorial
- SAP HANA - Home
- SAP HANA Introduction
- SAP HANA - Overview
- In-Memory Computing Engine
- SAP HANA - Studio
- Studio Administration View
- SAP HANA - System Monitor
- SAP HANA - Information Modeler
- SAP HANA - Core Architecture
- SAP HANA Modeling
- SAP HANA - Modeling
- SAP HANA - Data Warehouse
- SAP HANA - Tables
- SAP HANA - Packages
- SAP HANA - Attribute View
- SAP HANA - Analytic View
- SAP HANA - Calculation View
- SAP HANA - Analytic Privileges
- SAP HANA - Information Composer
- SAP HANA - Export and Import
- SAP HANA Reporting
- SAP HANA - Reporting View
- Bi 4.0 Connectivity to HANA Views
- SAP HANA - Crystal Reports
- SAP HANA - Excel Integration
- SAP HANA Security
- SAP HANA - Security Overview
- User Administration & Management
- SAP HANA - Authentications
- SAP HANA - Authorization methods
- SAP HANA - License Management
- SAP HANA - Auditing
- SAP HANA Data Replication
- SAP HANA - Data Replication Overview
- SAP HANA - ETL Based Replication
- SAP HANA - Log Based Replication
- SAP HANA - DXC Method
- SAP HANA - CTL Method
- SAP HANA - MDX Provider
- SAP HANA Monitoring
- SAP HANA - Monitoring and Alerting
- SAP HANA - Persistent Layer
- SAP HANA - Backup & Recovery
- SAP HANA - High Availability
- SAP HANA - Log Configuration
- SAP HANA SQL
- SAP HANA - SQL Overview
- SAP HANA - Data Types
- SAP HANA - SQL Operators
- SAP HANA - SQL Functions
- SAP HANA - SQL Expressions
- SAP HANA - SQL Stored Procedures
- SAP HANA - SQL Sequences
- SAP HANA - SQL Triggers
- SAP HANA - SQL Synonym
- SAP HANA - SQL Explain Plans
- SAP HANA - SQL Data Profiling
- SAP HANA - SQL Script
- SAP HANA Useful Resources
- SAP HANA - Questions and Answers
- SAP HANA - Quick Guide
- SAP HANA - Useful Resources
- SAP HANA - Discussion
SAP HANA Online Quiz
Following quiz provides Multiple Choice Questions (MCQs) related to SAP HANA. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.
Q 1 - To perform complex calculations and aggregations, which of the table type is preferred?
Answer : B
Explanation
Column base tables are preferred to perform aggregations and calculations as similar data type comes together.
Q 2 - A SAP HANA developer wants to create HTML application and to host it on web server in HANA. Which of the below component in HANA architecture can be used by Web applications to access HANA database?
Answer : C
Explanation
XS Engine allows external applications to access the SAP HANA system via the XS Engine clients. It allows UI5 based applications to use SAP HANA via http/https or other protocols.
Q 3 - In SAP HANA Modeling, Attributes views are used −
A) in Analytic and Calculation views.
B) represents master data.
C) are designed to perform Star schema queries
D) are used to filter size of dimension tables in Analytic and Calculation View
E) are defined either graphical using HANA Modeling feature or scripted in the SQL Choose the correct option.
Answer : B
Explanation
Attribute views are dimensions, BW characteristics or master data.
Attribute views are used to join to a dimension or attribute view.
In most cases used to model master data like entities (like Product, Employee, Business Partner)
Highly re-used and shared in Analytic- and Calculation Views
Q 4 - Which of the below is used to handle queries and manipulates multidimensional data stored in OLAP cubes?
Answer : B
Explanation
HANA can act as both relational as well as OLAP. When we use BW on HANA then we create cubes in BW and HANA will act as relational database and it will always produce a SQL Statement but when we directly access HANA views using OLAP connection then it will act as OLAP and MDX will be generated.
Q 5 - In SAP Data Services to replicate the data from SAP ECC to HANA database, which data store type should be used to create a data store for ECC and HANA system?
Answer : D
Explanation
For ECC system, use SAP Applications while creating a datastore.
For SAP HANA, use Database as store type while creating a data store.
Q 6 - To perform Analytical reporting in SAP Business Objects on the top of HANA views, which of the below BI reporting tools can be directly connected to HANA system?
Answer : B
Q 7 - To manage remote objects from Teradata, Sybase IQ and Hadoop in HANA database, which of the below option can be used?
Answer : A
Explanation
SAP Smart data access
Q 8 - Which of the below is not an audit trial type while configuring an audit policy in HANA system?
Answer : D
Explanation
Syslog(default) − Logging system of Linux Operating System.
Database Table − Internal database table, user who has Audit admin or Audit operator system privilege he can only run select operation on this table.
CSV text − This type of audit trail is only used for test purpose in a non-production environment.
Q 9 - Which of the below option can be used to check the configuration, current alerts, all services running and manufacturer details in HANA system?
Answer : B
Explanation
Administration tab is used to get all the details- about manufacturer, services running, alerts, performance, volumes, etc.
Q 10 - Which of the below allows you to load the large amount of data to HANA database by using a text file or via a clipboard?
Answer : A
Explanation
SAP HANA Information Composer. You can perform data loading or manipulation using this tool.
To upload data this can be done in two ways −
- Uploading .xls, .csv file directly to HANA database
- Other way is to copy data to clipboard and copy from there to HANA database.
- It allows data to be loaded along with header.
To Continue Learning Please Login