Knowledge quiz

It's time to put what you've learned to the test, get 8 right to pass this week.

During query preparation, which components are mainly affected by the number of consumed objects in a calculation view?

There are three correct answers.

Calculation Engine - Instantiation time

Calculation Engine - Optimization time

Compilation time

Database memory consumption

Network latency

What can you use to find the performance bottleneck in a PlanVisualizer trace?

There are three correct answers.

Dominant Operators (TOP 3)

Timeline

Operator List

SQL Query

Property Window

If you see very high compilation times in a calculation view model after upgrading, which of the following statements are true?

There are two correct answers.

Blocking calculation view unfolding may alleviate the issue in the short-term

Analyzing SQL plan cache usage is helpful

You always need to buy additional CPU/memory resources

Removing SQL plan cache blockers will increase cache hits

Which of the following are engines in SAP HANA?

There are three correct answers.

Join and OLAP Engine

Calculation Engine

HEX and ESX Engine

Raptor Engine

Quantum Engine

Which tools are useful when migrating from SAP HANA Studio to SAP HANA Cloud?

There are two correct answers.

XSA migration assistant

The migration wizard in SAP HANA Studio

HDI-to-XSA converter

Cloud-to-repository converter

XSA-to-HDI converter

When reusing SAP Web IDE calculation view projects in SAP HANA Cloud, what additional tasks should you expect?

Choose the correct answer.

No additional tasks are expected, and the project can simply be imported into SAP Business Application Studio.

Some modifications might be needed, for example, features that are not available in SAP HANA Cloud need to be compensated for.

The project first needs to be converted to SAP HANA Studio content before it can be used in SAP HANA Cloud.

You need to set the migration flag for every migrated calculation view in SAP Business Application Studio.

What is the status of attribute views?

There are two correct answers.

Attribute views are supported in SAP HANA Cloud.

Attribute views are not supported in SAP HANA Cloud.

Attribute views should be replaced by graphical calculation views in SAP HANA Cloud.

Attribute views should be replaced by analytic views.

Calculation views should be replaced by attribute views.

What leads to the creation of QO containers (Ce2Qo)?

There are two correct answers.

Blocked calculation view unfolding

Execute in the SQL Engine is set on the calculation view mode

Execute in the SQL Engine is not set on the calculation view model

Complete calculation view unfolding

Which steps are executed during the instantiation process?

There are three correct answers.

Load and merge scenarios

Authorization check

Push down filters

Resolve variables and remove non-requested attributes

Re-order joins

10.

Which tool helps you identify an unfolding blocker?

Choose the correct answer.

PlanVisualizer

Plan Sequencer

SQL trace

Network trace