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 different DW systems in place, which of the below DW system focus on predicting future outcomes using complex mathematical models?
Predictive analysis is about finding and quantifying hidden patterns in the data using complex mathematical models that can be used to predict future outcomes.
Q 2 - SAP HANA Administrator is using instance 00 to connect to HANA Studio. Which port is used in HANA system for this instance?
Q 3 - In SAP HANA database, while creating a new column base table we can define a null value for a Primary key?
A Primary key is always unique and not null.
Q 4 - In SAP HANA Data Replication, Which of the below is a trigger based method for data provisioning and used for real time business scenarios in HANA database?
SAP LT uses trigger based approach: has no measureable performance impact in source system.
It provides transformation and filtering capability.
It allows real-time (and scheduled) data replication, replicating only relevant data into HANA from SAP and non-SAP source systems.
It is fully integrated with HANA Studio.
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?
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.?
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?
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?
Q 9 - Which of the below component in SAP HANA Architecture distributed environment is used to store System landscape and topology information of system?
NAME server contains System Landscape information of HANA system. In distributed environment, there are multiple nodes with each node has multiple CPU’s, Name server holds topology of HANA system and has information about all the running components and information is spread on all the components.
Topology of SAP HANA system is recorded here.
It decreases the time in re-indexing as it holds which data is on which server in distributed environment.
Q 10 - While creating a Relational connection to HANA database, where you can define connection pool time out details?
This is defined in Connection parameters – Time out, array fetch size, batch size, etc.