C_HANAIMP_12 Online Practice Questions and Answers

Which of the following authentication methods are supported for Single Sign-On for SAP HANA?

A. Kerberos

B. LDAP over SSL

C. Secure Network Communication (SNC)

D. SAML CAS (Central Authentication Service)

When table replication is suspended, what does the SAP Landscape Transformation (SLT) server do?

A. It prevents the RFC connection from reading the source system logging tables.

B. It deletes the database triggers and the logging tables in the source system.

C. It stops the RFC connection and deletes the target tables in SAP HANA.

D. It keeps reading via the RFC connection from the source system but does not load the data into SAP HANA.

Which of the following nodes do you use to implement filters in a graphical calculation view? (Choose two)

A. Join

B. Projection

C. Aggregation

D. Union

Which of the following privileges do you need to activate views?

A. SELECT option on the _SYS_BIC schema

B. SELECT option on the _SYS schema

C. SELECT option on the _SYS_BI schema

D. SELECT option on the _SYS_REPO schema

Your customer wants to implement a SAP product that:

Provides near real-time replication to SAP HANA Connects SAP HANA to a non-SAP source system and SAP BW Uses SAP extractors What do you recommend?

A. SAP Legacy System Migration Workbench (LSMW)

B. SAP Landscape Transformation (SLT)

C. Sybase Replication Server

D. SAP BusinessObjects Data Services 4.0

Which of the following are phases of an SAP rapid-deployment solution (RDS)?

A. Start

B. Blueprint

C. Deploy

D. Run

E. Realization

You have a Web Intelligence report that requires data from SAP HANA filtered for a specific year. Where do you apply the filter for optimal performance?

A. In the universe

B. In the Web Intelligence report

C. In the analytic view

D. In the calculation view using an attribute value variable

Which engine is used for calculation and aggregation based on star schema

A. Join Engine

B. Calculation Engine

C. SQL Optimizer Engine

D. OLAP Engine

You build a financial report for the company's board members that allows them to choose if they want the

report to be in euros or dollars.

What do you use?

Please choose the correct answer.

Response:

A. A variable from the semantics node

B. A variable from a projection node

C. An input parameter from an aggregation node

D. An input parameter from the semantics node

What statement do you have to run before you can return table results from a procedure? Please choose

the correct answer.

Response:

A. CREATE VIEW

B. CREATE TABLE

C. CREATE TYPE

D. CREATE TABLE TYPE

Your schemas in development and production have different names. What do you use to ensure you do

not receive activation errors when importing information models into production? Please choose the

correct answer.

Response:

A. Refactoring

B. CDS

C. Mass copy

D. Schema mapping

You want to call a procedure in a SELECT statement (like a table function). Which clauses do you have to

specify?

There are 2 correct answers to this question.

Response:

A. READS SQL DATA

B. LANGUAGE SQLSCRIPT

C. SEQUENTIAL EXECUTION

D. WITH RESULTS VIEW

What is the preferred way to create a procedure?

Please choose the correct answer.

Response:

A. Create a .hdbprocedure file.

B. Create a .procedure file.

C. Use the CREATE PROCEDURE statement in the SQL Console.

D. Use the context menu of a package.

Which tasks are part of the migration tool workflow? There are 2 correct answers to this question. Response:

A. The tool requires a graphical calculation view as input.

B. The tool requires a script-based calculation view as input.

C. The tool produces a table function linked to a graphical calculation view.

D. The tool produces only a table function.

Which actions does refactoring typically use? There are 2 correct answers to this question. Response:

A. Deleting

B. Moving

C. Renaming

D. Transporting