C_HANATEC_12 Online Practice Questions and Answers

Which of the following actions are required in the SAP HANA studio to use the Enhanced Change and Transport System (CTS+)? (Choose two.)

A. Use an authorized user to attach SAP HANA content to transport requests.

B. Create the HTTP connection named CTSDEPLOY.

C. Configure the connection to the CTS in the preferences.

D. Create a delivery unit that contains all of the runtime objects.

A company wants to restrict data access to a specific year for certain users. Which privilege type must you define in SAP HANA to achieve this requirement?

A. Analytic privileges

B. System privileges

C. Package privileges

D. SQL privileges

You deleted billions of records from several tables in the SAP HANA database. However, the file system for the data volumes did not gain any free space.

What is the reason?

A. You did not execute the ALTER SYSTEM RECLAIM LOG.

B. SAP HANA keeps the space for later reuse.

C. You did not execute a full backup and restore to reduce the size of the data volumes.

D. SAP HANA did not trigger a delta merge yet.

Which of the following configuration files contains the backup locations of log and data files?

A. attributes.ini

B. indexserver.ini

C. localclient.ini

D. global.ini

Which of the following requires a dedicated network interface to SAP HANA?

A. SAP HANA studio

B. SAP BusinessObjects Business Intelligence platform

C. SAP LT

D. Backup destination

Which of the following memory indicators can you reset to measure the impact of a new workload on memory usage?

A. Virtual memory

B. Peak used memory

C. o Resident memory

D. Used memory

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?

A. GRANT SELECT ON SCHEMA TO _SYS_BIC

B. GRANT SELECT ON SCHEMA TO _SYS_BI WITH GRANT OPTION

C. GRANT SELECT ON SCHEMA TO _SYS_REPO WITH GRANTOPTION

D. GRANT CREATE ANY ON SCHEMA TO _SYS_REPO

Which driver is required for the connection between SAP HANA and SAP BusinessObjects Explorer?

A. ODBO

B. JDBC

C. BICS

D. ODBC

You have to implement disaster recovery for an SAP HANA production system. You also want to use the secondary SAP HANA appliance for development and testing. The data centers are more than 100km (60 miles) apart; the network capacity between them is restricted.

Which disaster recovery option would you implement?

A. Asynchronous system replication with continuous memory loading

B. Asynchronous system replication with shadow processes

C. Synchronous system replication with continuous memory loading

D. Synchronous storage replication with shadow processes

You need to recover an SAP HANA database. What is a prerequisite?

A. An offline SAP HANA database

B. An online SAP HANA database

C. Use the SAP DBA Cockpit to perform a database recovery.

D. Use the SAP HANA cockpit to perform a database recovery.