C_HANATEC142 Online Practice Questions and Answers

Which of the following privileges do you need to activate views? Please choose the correct answer.

A. SELECT option on the _SYS_BIC schema

B. SELECT option on the _SYS_BI schema

C. SELECT option on the _SYS_REPO schema

D. SELECT option on the _SYS schema

Which of the following are allowed to be written to the disk space for the data volumes in an SAP HANA system?

There are 2 correct answers to this question.

A. Data exports

B. Backup data files

C. Log files

D. Runtime dump files

Which of the following are advantages of using the SAP CO-PA accelerator? There are 2 correct answers to this question.

A. Transforms data during the load step

B. Eliminates the need for customization

C. Provides business configuration

D. Reduces reporting time

Which of the following can you use to update SAP HANA (SPS06)? Please choose the correct answer.

A. SAP HANA lifecycle manager

B. SAP HANA update wizard

C. SAP HANA on-site configuration tool

D. Software update manager (SUM) for SAP HANA

How do you configure an SAP HANA system of 4 nodes when implementing high availability?

Please choose the correct answer.

Choose one:

A.

3 master nodes

1 standby node

1 master node

B.

2 slave nodes

1 standby node

C.

1 master node

3 slave nodes

D.

2 master nodes

1 slave node

1 standby node

Which of the following must be running to view SAP HANA Diagnosis Files if the SAP HANA database is offline?

Please choose the correct answer.

A. sapstartsrv

B. SMD Agent

C. r3trans

D. disp+work

You develop a disaster recovery plan. What do you have to ensure in case of a disk failure? There are 3 correct answers to this question.

A. Log volumes can be backed up

B. Non-committed transactions can be recovered

C. Configuration files can be restored automatically

D. Committed transactions can be recovered

E. Save points can be backed up

What must you do in SAP LT to establish a connection between a non-SAP source system database and

SAP HANA?

There are 3 correct answers to this question.

Choose:

A. Create the source database connection in table DBCON.

B. Add a source database connection in the DBA Cockpit.

C. Define an RFC connection to the source system.

D. Define the SAP LT RFC connection to SAP HANA.

E. Define the SAP LT database connection to SAP HANA.

You have to transport data models from one SAP HANA system to another using the Change and

Transport System (CTS).

Where do you install the CTS plug in?

Please choose the correct answer.

Choose one:

A. In SAP Solution Manager

B. In the source system

C. In the XS engine

D. In the SAP HANA studio

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 TO _SYS_BIC

B. GRANT CREATE ANY ON SCHEMA TO _SYS_REPO

C. GRANT SELECT ON SCHEMA TO _SYS_REPO WITH GRANT OPTION

D. GRANT SELECT ON SCHEMA TO _SYS_BI WITH GRANT OPTION

Which security settings can you apply in analytic privileges?

There are 2 correct answers to this question.

Choose:

A. Restrict access within an analytic view using attribute values.

B. Restrict access within an analytic view using measure values.

C. Grant access to analytic views.

D. Restrict access to hierarchies.

Where in the SAP HANA studio can you change the path of the backup folder?

There are 2 correct answers to this question.

Choose:

A. executor.ini

B. Backup catalog

C. Backup editor

D. global.ini

Which of the following SAP HANA tools is used to collect diagnostic information? Please choose the correct answer.

A. landscapeHostConfiguration.py

B. hdbnsutil

C. hdbsql

D. fullSystemInfoDump.py

Which actions to you need to perform to configure SAP HANA single sign-on? Please choose the correct answer.

A. Generate and import X.509 certificate

B. Generate and import PSE key

C. Generate and import Kerberos keytab

D. Generate and import SSH rsa key

In addition to the in-memory database, which of the following technologies are part of SAP HANA?

There are 2 correct answers to this question.

Choose:

A. Asymmetric multi-processing

B. Diskless data storage

C. Columnar store

D. Massive parallel processing