Practice Question Answers and Explanations
- Correct answers: A, B
We have SAP HANA studio, which is a Java-based Eclipse tool, and the SAP HANA web-based development workbench. There are no Java applets or iPad apps for modeling.
- Correct answer: C
The Quick View tab is located in the modeler perspective (see Figure 5.2).
- Correct answer: C
The SAP HANA database schemas are housed in the Catalog area of SAP HANA studio (see Figure 5.3).
- Correct answer: A
You can unload a table’s data from memory in the context menu of the table (see Figure 5.3).
- Correct answers: B, D
The table definition (see Figure 5.4) and the table icon in the Catalog area both show if a table is row-based or column-based.
- Correct answers: A, D
Although all of the options are possible in the data preview, you can only 1) sort all the data result sets and show the top 200 records and then 2) export that data result set to your local machine from the Raw tab of the data preview. The other two actions are available in the other tabs.
- Correct answer: C
You can only create models in the Content area, so any reference to the Catalog area is invalid. There are no schemas in the Content area. Schemas are only found in the Catalog area. (See Figure 5.9.)
- Correct answers: A, B
Calculation views and procedures are created in the Content area. Triggers and schemas are created in the Catalog area. (See Figure 5.9.)
- Correct answers: A, D
Attribute and analytic views are fading out. We recommend using graphical calculation views going forward.
- Correct answers: C, D
You have to create a repository workspace an SAP HANA XS project once. A flowgraph model (in AFM) is an SAP HANA development object, and you create it many times once you have performed the correct setup. A predictive model using PAL is an example of a flowgraph model. Answers A and B are therefore basically the same.
- Correct answer: A
As of SAP HANA SPS 10, the web-based development environment can use the Performance Analysis Mode option for graphical calculation views. Please note that there are no true–false questions in the actual certification exam.