- 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 - Consider the Data Modeling concept in HANA, Which of the below statement is incorrect about Schema?
A - In Star Schema, you can have multiple fact tables and Dim tables
B - In Star Schema, Dim tables are not normalized
C - In Galaxy Schema, you have multiple fact tables and multiple Dim tables.
D - In Snowflakes schema, you have multiple Dim tables in normalized form.
Answer : A
Explanation
In Star schema, you have one fact table and multiple dim tables.
Q 2 - Which of the below statement is true about Union and Union All set operators?
A - Union prints all the rows from both the tables.
Answer : B
Explanation
UNION is used to combine the results of two or more Select statements. However it will eliminate duplicate rows
Union All
This operation is similar to Union. But it also shows the duplicate rows.
Q 3 - A SAP HANA Modeler is using Calculation view with Star Join to add measures from multiple fact tables. Which of the below statement is correct about Calculation view with Star Join?
A - You can only add base Column tables at Star Join level.
B - You can only add Attribute Views or Analytical views at Star Join
C - You can only add Dimension Calculation View at Star Join
D - You can add other Calculation views without Star Join and data type Cube
Answer : C
Explanation
You can only use dimension Calculation views in Calculation view without Star Join.
Q 4 - In SAP HANA Modeling, to copy an existing view and without making any changes to it, which of the below option should be used?
Answer : B
Explanation
Copy from − If you want to use already existing attribute view s template then go for this(you can modification if required for current one).
Derived − This is kind of reference type. You cannot do modifications to the current one (Do the changes for main one).
Q 5 - In SAP HANA Job based replication, which of the below can be used to add a schedule, to trace, monitor and error check a replication job?
B - Data Service Repository Manager
Answer : C
Explanation
Data Service Management Console – You can trace, monitor, error check replication jobs in repository.
Q 6 - Which of the below privilege type is used for Backup/Restore, User Administration, Instance start and stop, etc.?
Answer : B
Explanation
System privileges are used for Backup/Restore, User Administration, Instance start and stop, etc.
Q 7 - To provide unfiltered read only access to all system views, which of the below system privilege type should be added to user profile?
Answer : B
Explanation
It authorizes users to have unfiltered read-only access to all system views.
Normally, the content of these views is filtered based on the privileges of the accessing user.
Q 8 - While performing SAP HANA data Replication using SLT method, which of the below is not a supported mode?
Answer : E
Explanation
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 user can access HANA system via HTTP/HTTPS applications and doesn’t have access to create objects in schema in HANA database?
Answer : C
Explanation
Restricted users are those users who access HANA system with some applications and they don’t have SQL privileges on HANA system. When these users are created they don’t have any access initially.
If we compare restricted users with Standard users −
Restricted users can’t create objects in HANA database or their own Schemas.
They don’t have access to view any data in database as they don’t have generic Public role added to profile like standard users.
They can connect to HANA database only using HTTP/HTTPS
To Continue Learning Please Login