Practice Questions

These practice questions will help you evaluate your understanding of the topics covered in this chapter. The questions shown are similar in nature to those found on the certification examination. Although none of these questions will be found on the exam itself, they will allow you to review your knowledge of the subject. Select the correct answers and then check the completeness of your answers in the Practice Question Answers and Explanations section. Remember that on the exam you must select all correct answers, and only correct answers, to receive credit for the question.

  1. Which development tools are available for creating SAP HANA information models? (There are 2 correct answers)

    A. Java-based Eclipse tool
    B. Web-based development tool

    C. iPad app for development
    D. Java applet in the browser

  2. In which SAP HANA studio perspective do you find the Quick View tab options?

    A. Administration perspective
    B. Developer perspective
    C. Modeler perspective

    D. Plan visualizer perspective

  3. In which subarea (folder) in the Systems view of SAP HANA studio can you find the SAP HANA database schemas?

    A. Security area
    B. Content area
    C. Catalog area

    D. Provisioning area

  4. Where in SAP HANA studio can you unload a table’s data from memory?

    A. The context menu of the table
    B. The list of export destinations
    C. The data preview of the table
    D. The table definition

  5. Where in SAP HANA studio can you see if a table is row-based or column-based? (There are 2 correct answers.)

    A. The tooltip that appears on mouse hover over the table title
    B. The table definition
    C. The context menu of a table
    D. The table’s icon

  6. What can you do in the Raw tab of the data preview in SAP HANA studio? (There are 2 correct answers.)

    A. Sort the entire data result set and show the top 200 records.
    B. Show all distinct values in the entire data result set.
    C. Create a graph while analyzing the entire data result set.
    D. Export the entire data result set to your local machine.

  7. Where in the Systems view of SAP HANA studio can you create new SAP HANA models?

    A. In the schemas of the Catalog area
    B. In the packages of the Catalog area
    C. In the packages of the Content area
    D. In the schemas of the Content area

  8. Which modeling objects can you create in a package in SAP HANA studio? (There are 2 correct answers.)

    A. Calculation views
    B. Procedures
    C. Triggers
    D. Schemas

  9. Which modeling views are fading out and are not available in the SAP HANA web-based development workbench? (There are 2 correct answers.)

    A. Analytic views
    B. Scripted calculation views
    C. Graphical calculation views
    D. Attribute views

  10. Which steps do you have to perform once before you can create SAP HANA development objects? (There are 2 correct answers.)

    A. Create a dataflow model in the AFM.
    B. Create a predictive model using PAL.
    C. Create a repository workspace
    D. Create an SAP HANA XS project.

  11. True or False: The performance analysis mode is available for graphical calculation views in the SAP HANA web-based development workbench.

    A. True
    B. False