SAP HANA ACTUAL UPDATED Exam
Questions and CORRECT Answers
What must I create to develop a predictive model?
a) Procedure
b) Flowgraph
c) Predictive Analysis Library
d) Calculation View - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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. - CORRECT ANSWER - 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. - CORRECT ANSWER - 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) - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - d. In- memory
technology and multicore CPUs
Questions and CORRECT Answers
What must I create to develop a predictive model?
a) Procedure
b) Flowgraph
c) Predictive Analysis Library
d) Calculation View - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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. - CORRECT ANSWER - 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. - CORRECT ANSWER - 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) - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - d. In- memory
technology and multicore CPUs
