/
Browse
/
Courses
/
Using the Optimizer for SQLScript Programming in SAP HANA
/
Assignment Week 1
Understanding SAP HANA SQLScript Optimizer
Course introduction
SAP HANA SQLScript optimizer
SAP HANA SQLScript optimization rules – Part 1
SAP HANA SQLScript optimization rules – Part 2
SQLScript general analysis strategy
Downloads
Quiz
SAP HANA SQLScript Supportability Features
Investigating SQLScript Performance Caused by SQL
Knowledge quiz
It's time to put what you've learned to the test, get 8 right to pass this week.
1.
Which statements about the "constant propagation" rule are correct?
There are two correct answers.
The first step in constant propagation is to evaluate the SQL expression and folding constant.
During constant propagation, the value is propagated through the value chain.
The body of the callee SQLScript procedure is unfolded into the body of the caller SQLScript procedure.
SQL statements with no dependency can be executed in parallel.
SQL statements with dependency can be merged into a single SQL statement.
2.
Which statements about SAP HANA SQLScript are correct?
There are two correct answers.
The execution plan of a SQLScript procedure is stored in the SQL plan cache.
If an execution plan of a SQLScript procedure is stored in the SQL plan cache and is still valid, the SQLScript procedure is not compiled again when it is executed by the CALL statement.
The query plan of a SQL statement in a SQLScript procedure is stored in the SQL plan cache when its SQLScript procedure is compiled.
The SQL statement in a SQLScript procedure is always newly compiled whenever its SQLScript procedure is executed.
3.
Which statements about the SQLScript general analysis strategy are true?
There are two correct answers.
Inefficient usage of imperative programming constructs can cause performance issues.
Row-based calculation using CURSOR or LOOP is always efficient.
The compilation of inner SQL statements in a SQLScript procedure does not affect the performance of the SQLScript procedure.
It can happen that inner SQL statements in a SQLScript procedure take a long time to execute.
4.
Which statement about SAP HANA SQLScript is correct?
Choose the correct answer.
The SQLScript optimizer is a part of the SQL optimizer.
Only the query plan of inner SQL statements in the SQLScript procedure is stored in the SQL plan cache.
SQLScript is used only for a procedure.
SQLScript is a programming language of SAP HANA.
5.
Which statement about the SQLScript general analysis strategy is true?
Choose the correct answer.
The long compilation of an inner SQL statement in a SQLScript procedure can cause a long execution of the SQLScript procedure.
The long compilation of a SQLScript procedure is caused by long compilation of its inner SQL statements.
A long compilation and execution of an inner SQL statement in a SQLScript procedure does not affect the performance of the SQLScript procedure.
Efficient usage of imperative programming constructs always makes inner SQL statements efficient too.
6.
Which statement about the "control flow simplification" rule is correct?
Choose the correct answer.
The first step in control flow simplification is to evaluate the SQL expression and folding constant.
During control flow simplification, the value is propagated through the value chain.
The body of the callee SQLScript procedure is unfolded into the body of the caller SQLScript procedure.
Dead-code elimination is the most typical method of control flow simplification.
7.
Which part of SAP HANA executes the imperative programming constructs of the SQLScript procedure?
Choose the correct answer.
SQLScript engine
SQL engine
OLAP engine
HEX engine
8.
Which statement about the "procedure flattening" rule is correct?
Choose the correct answer.
The first step in procedure flattening is to evaluate the SQL expression and folding constant.
During procedure flattening, the value is propagated through the value chain.
The body of the callee SQLScript procedure is unfolded into the body of the caller SQLScript procedure.
SQL statements with no dependency can be executed in parallel.
9.
Which statements about the SAP HANA SQLScript procedure are correct?
There are two correct answers.
Both imperative programming constructs and declarative SQL statements can be used in the SAP HANA SQLScript procedure.
The CALL statement executes the SAP HANA SQLScript procedure.
Declarative SQL statements can be used only once in the SAP HANA SQLScript procedure.
The SAP HANA SQLScript procedure is compiled whenever it is executed.
The SAP HANA SQLScript procedure is compiled when it is created by the CREATE PROCEDURE statement.
10.
Which statement about SQLScript optimization is correct?
Choose the correct answer.
A constant value cannot be propagated through the value chain.
The CALL statement inside a SQLScript procedure is always executed separately.
SQL statements with dependency can be merged into a single SQL statement.
Dead code cannot be eliminated and is always executed.