Practice Questions

These practice questions will help you evaluate your understanding of the topic. 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 Explanation section. Remember that on the exam you must select all correct answers and only correct answers to receive credit for the question.

1. Which are the recommended assignments in SAP HANA? (There are 2 correct answers.)

   A. Privileges to users
   B. Roles to users
   C. Roles to roles
   D. Roles to privileges

2. In which SAP HANA deployment scenarios will end users be created as users in the SAP HANA system? (There are 2 correct answers.)

   A. SAP BW powered by SAP HANA
   B. SAP S/4HANA
   C. SAP HANA as a platform
   D. SAP HANA Live

3. True or False: The default behavior of SAP HANA is to allow access.

   A. True
   B. False

4. Your newly created information view does NOT want to activate. For which system user must you grant read access to your schema?

   A. _SYS_REPO
   B. SYSTEM
   C. SYS
   D. _SYS_TASK

5. What do you have to assign to users to allow single sign-on?

   A. SQL analytic privileges
   B. Kerberos authentication
   C. TRUST ADMIN system privilege
   D. Application privileges

6. Where do you graphically create a design-time role in SAP HANA?

   A. In the Security area of the SAP HANA web-based development workbench
   B. In the Roles area under Security in SAP HANA studio
   C. In the Repository area in the development perspective in SAP HANA studio
   D. In the Editor area of the SAP HANA web-based development workbench

7. What system privilege do you need to create a delivery unit?

   A. REPO.EXPORT
   B. REPO.IMPORT
   C. REPO.MAINTAIN_DELIVERY_UNITS
   D. REPO.WORK_IN_FOREIGN_WORKSPACE

8. True or False: Object privileges on a table with SELECT rights will allow you to access to all the data.

   A. True
   B. False

9. What can you use to limit users to see only 2016 data? (There are 2 correct answers.)

   A. An object privilege
   B. A SQL analytic privilege
   C. A view with a filter
   D. A view with a restricted column

10. You have two calculation views for viewing manufactured products. The WORLD calculation view shows worldwide information. The INDIA calculation view is built on top of the WORLD calculation view and shows information for Indian products. What privilege must you assign to see your department’s specific data in a report built on the INDIA calculation view?

    A. An analytic privilege on the WORLD calculation view
    B. An analytic privilege on the INDIA calculation view
    C. An analytic privilege on the both calculation views
    D. An object privilege on the WORLD calculation view

11. True or False: You can limit access to a subpackage if you have given access to the higher level package.

    A. True
    B. False

12. You have created a SQL analytic privilege on an information view. Where do you tell the view to enable SQL analytic privileges?

    A. In the semantic node of the information model
    B. In the restrictions settings of the SQL analytic privilege
    C. In the SAP HANA studio preferences
    D. In the migration tool

13. What does the migration tool allow you to migrate?

    A. XML analytic privileges to table functions
    B. XML analytic privileges to SQL analytic privileges
    C. SQL analytic privileges to XML analytic privileges
    D. Object privileges to SQL analytic privileges