C_HANATEC_12 Online Practice Questions and Answers

Which of the following are benefits of implementing SAP HANA? (Choose three.)

A. SAP HANA combines OLTP and OLAP in one system.

B. SAP HANA replaces SAP BW.

C. SAP HANA performs much faster than the standard SAP ERP.

D. SAP HANA provides pre-configured BI Content.

E. SAP HANA provides real-time analytics.

You are reviewing the execution plan of an SQL statement. You want to find out which plan operators (POPs) have been executed in parallel and for how long each of them has been active.

Where can you accomplish this?

A. In SAP HANA studio: Administration Console -> Performance -> Job Progress

B. In HDB admin -> Performance trace -> Show Column Plans

C. In SAP NetWeaver: DBA Cockpit (DBACOCKPIT) -> SQL Plan Cache -> EXPLAIN (graphically)

What must you configure in Data Services 4.0 to establish a connection to SAP ERP?

A. An RFC connection

B. A DB connection

C. A datastore

D. An InfoObject

You plan to install an SAP HANA database in an SAP HANA Tailored Datacenter Integration (TDI) scenario.

Which SAP HANA installation tools are required? (Choose two.)

A. hdblcm

B. hdbsetup

C. hdblcmgui

D. hdbinst

You need to create a role that allows read-only access to the tabs of SAP HANA Administration Editor. Which of the following privileges do you need to assign to that role? (Choose two.)

A. SQL privilege SELECT for the SQL object SYS_STATISTICS

B. System privilege CONTENT_ADMIN

C. System privilege SERVICE_ADMIN

D. System privilege DATA_ADMIN

What can you use to transform data from SAP Business Warehouse (BW) into SAP HANA?

A. SAP Legacy System Migration Workbench (LSMW)

B. SAP Landscape Transformation (SLT)

C. SAP BW extractors

D. SAP BusinessObjects Data Services

Which connectivity options can you use to create an SAP BusinessObjects universe on SAP HANA? (Choose two.)

A. Relational connection using BICS

B. Relational connection using JDBC

C. Relational connection using MDX

D. Relational connection using ODBC

A long-running SQL query issued by an SAP NetWeaver work process also seems to use a lot of system resources.

How can you find out which ABAP module and which SAP NetWeaver user called the query?

A. Go to the Performance tab of SAP HANA studio- Check the System load diagram

B. Open Transaction Global Work Process Overview (SM66) in the SAP NetWeaver system- Sort the list by CPU time- Select the top entry

C. Open Transaction Process Overview (SM50) in the SAP NetWeaver system-Sort the list by CPU time-Select the top entry- Check the User and Report columns

D. In SAP HANA studio, check the session overview- Identify the logical CONNECTION ID for the SAP NetWeaver workprocess- Check the columns APPLICATIONSOURCE and APPLICATIONUSER

Which of the following must be shared by SAP HANA nodes in a high availability scenario?

A. Virtual host name

B. Network

C. Shared memory

D. Storage

Your SAP HANA usage scenario does not require SAP HANA XS.

What do you have to consider before you remove the SAP HANA XS service from the configuration? (Choose three.)

A. All applications using the SAP HANA instance must be stopped.

B. A data backup must be taken after the SAP HANA XS service has been removed.

C. User adm is required to remove the SAP HANA XS service.

D. The SAP HANA XS service must be removed from all hosts of the SAP HANA instance.

E. The user privileges for accessing SAP HANA XS must be revoked.