It’s time to put what you’ve learned to the test, get 8 questions right to pass this week.
Q1.
Which enumerators process JOIN first?
There are 2 correct answers.
A
AGGR_THRU_JOIN
B
JOIN_THRU_AGGR
C
PREAGGR_BEFORE_JOIN
D
PREAGGR_BEFORE_UNION
E
JOIN_THRU_UNION
Q2.
Which steps are skipped during parameterized query processing among SAP HANA query components if the plan cache is hit?
There are 2 correct answers.
A
Join engine
B
SQL front end
C
SQL Optimizer
D
Row store engine
E
Column store engine
Q3.
Suppose that each clause can be used only once in a query: What is the first operator to process from the given operator options in the general SQL query execution order?
Choose the correct answer.
A
SELECT
B
DISTINCT
C
FROM
D
GROUP BY
Q4.
When the plan cache is hit, which components in SAP HANA are skipped?
There are 2 correct answers.
A
SQL plan cache
B
SQL front end
C
SQL Optimizer
D
Row store engine
E
Column store engine
Q5.
Which component in SAP HANA compiles and generates a SQL plan?
Choose the correct answer.
A
SQL plan cache
B
SQL front end
C
SQL Optimizer
D
SQL engine
Q6.
Assume the parameterized query has not been executed before: What is the preparation count for a successfully executed parameterized query?
Choose the correct answer.
A
1
B
2
C
3
D
4
Q7.
What is the SQL clause to filter the aggregated data in the general SQL query execution order?
Choose the correct answer.
A
DISTINCT
B
SELECT
C
HAVING
D
FROM
Q8.
Which SQL HINT do you use when you want to trigger compilation by skipping plan cache lookup?
Choose the correct answer.
A
JOIN_THRU_JOIN
B
IGNORE_PLAN_CACHE
C
AGGR_THRU_JOIN
D
NO_INLINE
Q9.
Which component in SAP HANA checks query statements both syntactically and semantically?
Choose the correct answer.
A
SQL plan cache
B
SQL front end
C
SQL Optimizer
D
Column store engine
Q10.
What is the optimization step called where predefined rules are applied sequentially and the plan is usually simplified?