SAP HANA Questions And Answers With Complete
Study Updates
What must I create to develop a predictive model?
a) Procedure
b) Flowgraph
c) Predictive Analysis Library
d) Calculation View ANS b) Flowgraph
What are the advantages of columnar storage?
There are 2 answers to this question.
a) Improved performance when all fields are selected
b) Improved data reading performance
c) Improved compression
d) Improved data writing performance ANS b. Improved data reading performance
c. Improved compression
Which of the following views can you extend with the SAP HANA Live Extension Assistant?
Please choose the answer.
a) Your own custom views
b) Reuse views
c) All SAP-delivered views
d) Query views with a union ANS b. reuse views
What information can you find in the Plan Graph?
,There are 2 answers to this question.
a) Number of records returned in each step
b) Execution engines used
c) Time taken for each step
d) SQL Plan Cache ANS a. number of records returned in each step
c. time taken for each step
In which direction do you build calculation views when including the source tables in Join nodes?
Please choose the answer.
a) From the Join nodes up to the semantics node
b) From the Semantics node up to the default node
c) From the Semantics node down to the Join nodes
d) From the Join node down to the default node ANS a. from the join nodes up to the semantic node
6. What should you keep in mind when using imperative logic in SQLScript?
Please choose the answer.
a) It matches SQL's set-oriented paradigm.
b) You can only use if-then logic.
c) It delivers the best possible performance.
d) You can loop through records. ANS d. you can loop through records
Why is an integrated deployment approach preferred over the side-car approach to SAP HANA Live?
,There are 2 answers to this question.
a) It offers a simplified landscape.
b) It provides a quick start for customers using Business Suite on non HANA databases.
c) Data is available in real time using SLT.
d) There is no data movement. ANS a. it offers a simplified landscape
d. there is no data movement
Which spatial data formats can you import into SAP HANA?
There are 2 answers to this question.
a) ESRI shapefiles
b) GeoJSON
c) Scalable Vector Graphic (SVG)
d) Well-Known Text (WKT) ANS a. ESRI Shapefiles
d. Well- Known Text (WKT)
What technique is used to convert record updates into insert statements in the delta buffer?
Please choose the answer.
a) Sorted inserts
b) Parallelism
c) Unsorted inserts
d) Insert-only ANS d. insert- only
What is the default node for a calculation view of type cube?
, Please choose the answer.
a) Aggregation node
b) Star join node
c) Projection node
d) Join node ANS a. aggregation note
What combination enabled real-time computing?
Please choose the answer.
a) Multicore CPUs with large level 1 caches
b) In-memory technology with solid-state disks
c) Multicore CPUs and solid-state disks
d) In-memory technology and multicore CPUs ANS d. In- memory technology and multicore CPUs
What spatial data type would you use to store multiple shop locations?
Please choose the answer.
a) ST_Polygon
b) ST_MultiLineString
c) ST_Point
d) ST_MultiPoint ANS d. ST_MultiPoint
You have to build a parent-child hierarchy. What type of join do you expect to use?
Please choose the answer.
Study Updates
What must I create to develop a predictive model?
a) Procedure
b) Flowgraph
c) Predictive Analysis Library
d) Calculation View ANS b) Flowgraph
What are the advantages of columnar storage?
There are 2 answers to this question.
a) Improved performance when all fields are selected
b) Improved data reading performance
c) Improved compression
d) Improved data writing performance ANS b. Improved data reading performance
c. Improved compression
Which of the following views can you extend with the SAP HANA Live Extension Assistant?
Please choose the answer.
a) Your own custom views
b) Reuse views
c) All SAP-delivered views
d) Query views with a union ANS b. reuse views
What information can you find in the Plan Graph?
,There are 2 answers to this question.
a) Number of records returned in each step
b) Execution engines used
c) Time taken for each step
d) SQL Plan Cache ANS a. number of records returned in each step
c. time taken for each step
In which direction do you build calculation views when including the source tables in Join nodes?
Please choose the answer.
a) From the Join nodes up to the semantics node
b) From the Semantics node up to the default node
c) From the Semantics node down to the Join nodes
d) From the Join node down to the default node ANS a. from the join nodes up to the semantic node
6. What should you keep in mind when using imperative logic in SQLScript?
Please choose the answer.
a) It matches SQL's set-oriented paradigm.
b) You can only use if-then logic.
c) It delivers the best possible performance.
d) You can loop through records. ANS d. you can loop through records
Why is an integrated deployment approach preferred over the side-car approach to SAP HANA Live?
,There are 2 answers to this question.
a) It offers a simplified landscape.
b) It provides a quick start for customers using Business Suite on non HANA databases.
c) Data is available in real time using SLT.
d) There is no data movement. ANS a. it offers a simplified landscape
d. there is no data movement
Which spatial data formats can you import into SAP HANA?
There are 2 answers to this question.
a) ESRI shapefiles
b) GeoJSON
c) Scalable Vector Graphic (SVG)
d) Well-Known Text (WKT) ANS a. ESRI Shapefiles
d. Well- Known Text (WKT)
What technique is used to convert record updates into insert statements in the delta buffer?
Please choose the answer.
a) Sorted inserts
b) Parallelism
c) Unsorted inserts
d) Insert-only ANS d. insert- only
What is the default node for a calculation view of type cube?
, Please choose the answer.
a) Aggregation node
b) Star join node
c) Projection node
d) Join node ANS a. aggregation note
What combination enabled real-time computing?
Please choose the answer.
a) Multicore CPUs with large level 1 caches
b) In-memory technology with solid-state disks
c) Multicore CPUs and solid-state disks
d) In-memory technology and multicore CPUs ANS d. In- memory technology and multicore CPUs
What spatial data type would you use to store multiple shop locations?
Please choose the answer.
a) ST_Polygon
b) ST_MultiLineString
c) ST_Point
d) ST_MultiPoint ANS d. ST_MultiPoint
You have to build a parent-child hierarchy. What type of join do you expect to use?
Please choose the answer.
