SAP HANA placement test question papers - Set 4

SAP HANA placement test question papers - Set 4

1) What are the advantages of columnar tables?

A) Higher Data Compression Rates
B) Higher Performance for Column Operations
C) Elimination of Additional Indexes
D) All of the above
View Answer / Hide Answer


2) Is it possible to load and replicate data from one source system to multiple target database schemas of HANA system?

A) Yes, possible upto 2
B) Yes, possible upto 3
C) Yes, possible upto 4
D) Yes, possible upto 5
View Answer / Hide Answer


3) What can be the maximum column name length?

A) 127 characters
B) 150 characters
C) 154 characters
D) 158 characters
View Answer / Hide Answer


4) What can be exported from SAP HANA database?

A) Landscape
B) Tables
C) Models
D) All of the above
View Answer / Hide Answer


5) The master job can easily be stopped and restarted for the relevant configuration.

A) True
B) False
View Answer / Hide Answer


6) Savepoints and log writing protect your data against power failures. Savepoints do not help if the persistent storage itself is damaged.

A) True
B) False
View Answer / Hide Answer


7) Password rules are configured using parameters in which configuration file ?

A) global.ini
B) Indexserver.ini
C) Nameserver.ini
D) Statisticsserver.ini
View Answer / Hide Answer


8) Where will you check log and trace files in SAP HANA studio?

A) Administrator editor Diagnosis files tab
B) Administrator editor System information tab
C) Modeler Diagnosis files tab
D)Administration Editor Performance tab
View Answer / Hide Answer


9) Which of the following requires a dedicated network interface to SAP HANA ?

A) SAP LT
B) Backup destination
C) SAP HANA studio
D) SAP Business Objects Business Intelligence platform
View Answer / Hide Answer


10) What is the file extension associated with a design-time SQL view definition?

A) .hdbview
B) .vws
C) .hdbvws
D) .view
View Answer / Hide Answer