Online Access Free C-HANATEC142 Practice Test

You created an information model in the SAP HANA studio and activated it successfully. When you execute the data preview you get an error message indicating missing privileges.
Which of the following could solve the problem?
Please choose the correct answer.

• A.GRANT SELECT ON SCHEMA <schema_name> TO _SYS_BIC
• B.GRANT SELECT ON SCHEMA <schema_name> TO _SYS_BI WITH GRANT OPTION
• C.GRANT CREATE ANY ON SCHEMA <schema_name> TO _SYS_REPO
• D.GRANT SELECT ON SCHEMA <schema_name> TO _SYS_REPO WITH GRANT OPTION

Which delivered role is mandatory for a system administrator in SAP HANA?
Please choose the correct answer.

• A.IC MODELER
• B.CONTENT_ADMIN
• C.SAP_ALL
• D.SYS_ADMIN

A user cannot query an information model because of missing authorizations.
How can the user find out which authorization is missing?
Please choose the correct answer.

• A.Use the authorization dependency viewer.
• B.Check the assigned roles in the user editor.
• C.Query the system view EFFECTIVE_PRIVILEGES.
• D.Investigate the authorization trace.

In Microsoft Windows, to which folder are the logs written by default during the SAP HANA studio installation?
Please choose the correct answer.
Choose one:

• A.%USERNAME%\hdb_studio_
• B.C:\Program Files (x86)\hdb_studio_
• C.%USERPROFILE%\hdb_studio_<time_stamp>
• D.%TEMP%\hdb_studio_<time_stamp>

What are the recommended ways to perform a database backup? There are 2 correct answers to this question.

• A.Use SQL commands
• B.Use SAP HANA Studio
• C.Use the BRBACKUP command
• D.Use the./hdbsetup command