C_HANATEC_10 Online Practice Questions and Answers

You have to create an SAP HANA architecture that meets the following requirements:

-

Data provisioning is performed in batch mode

-

Data transformation is performed during the load step,

-

Reporting is run using analytic data models.

Which of the following scenarios would you implement?

Please choose the correct answer.

Response:

A.

An operational data mart

B.

SAP HANA as application platform

C.

An SAP HANA accelerator

D.

An agile data mart

Which of the following must you do in the SAP HANA studio to be able to use the Change and Transport

System(CTS)?

There are 2 correct answers to this question.

Response:

A. Create a delivery unit that contains all of the information models.

B. Create the HTTP connection CTSDEPLOY

C. Use a user who is authorized to attach SAP HANA content to transport requests.

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

Which Linux kernel parameters need to be adapted during SAP HANA installation depending on the SAP

HANA system size?

Please choose the correct answer.

Response:

A. net.ipv4.tcp_slow_start_after_idle and kernel.shmmni

B. kernel.shmall and fs.file-max

C. fs.file-max and net.core.wmem_max

D. net.core_rmem_max and kernel.sysrq

Which user must have SELECT privilege with the grant option on the data schema?

Please choose the correct answer.

Response:

A. ADM

B. SYSTEM

C. _SYS_BIC

D. _SYS_REPO

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?

Please choose the correct answer.

Response:

A. Asynchronous system replication with continuous memory loading

B. Synchronous system replication with continuous memory loading

C. Asynchronous system replication with shadow processes

D. Synchronous storage replication with shadow processes

When you try to create a delivery unit from the SAP HANA studio you receive the following error message.

'Cannot create Delivery Unit as content vendor is not defined for this system'. How do you troubleshoot this

issue?

Please choose the correct answer.

Response:

A. Maintain the vendor ID

B. Maintain the content_vendor parameter

C. Grant REPO.MAINTAIN_NATIVE_PACKAGES privilege

D. Grant REPO.MAINTAIN_DELIVERY_UNITS privilege

Which of the following can be done by the SAP HANA lifecycle manager?

There are 3 correct answers to this question.

Response:

A. Copy an SAP HANA system

B. Add an additional SAP HANA system

C. Change the SAP HANA license type

D. Rename an SAP HANA system

E. Uninstall an SAP HANA system

A customer complains about poor performance when they query a column table with 5 billion records.

You suspect that this table is partially loaded into memory. Where can you to check the load status of this

table?

There are 2 correct answers to this question.

Response:

A. On the Runtime Information tab of the table definition

B. In the M_TABLES view

C. In the M_CS_TABLES view

D. In the M_TABLE_PERSISTENCE_LOCATIONS view

When does SAP recommend that you execute the first system backup? Please choose the correct answer.

Response:

A. After completing the post-installation steps

B. After the first data load

C. After a complete load of master data

D. Before updating the system

Which of the following are parts of SAP HANA sizing? There are 3 correct answers to this question. Response:

A. Disk sizing

B. Network bandwidth sizing

C. Memory sizing

D. CPU sizing

E. Data and log file sizing

What do you have to consider when you design a backup plan?

There are 2 correct answers to this question.

Response:

A. The newest data must be backed up most often.

B. The column table data needs to be compressed before a backup.

C. The backup execution must be monitored.

D. The database backup must be stored at a different location than the database server.

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

Please choose the correct answer

Response:

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

B. An offline SAP HANA database

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

D. An online SAP HANA database

Which of the following tools can you use to create and manage SAP HANA database users?

There are 2 correct answers to this question.

Response:

A. SAP Solution Manager

B. Microsoft Active Directory

C. SAP Netweaver Identity Management

D. hdbsql

Which of the following SAP HANA tools is used to collect diagnostic information?

Please choose the correct answer.

Response:

A. landscapeHostConfiguration.py

B. hdbnsutil

C. hdbsql

D. fullSystemInfoDump.py

Which connectivity options can you use to create an SAP BusinessObjects universe on SAP HANA?

There are 2 correct answers to this question.

Response:

A. Relational connection using ODBC

B. Relational connection using BICS

C. Relational connection using JDBC

D. Relational connection using MDX