Ensurepass

 


Exam A

 

QUESTION 1

Which delivered role is mandatory for a system administrator in SAP HANA?

 

A.

SYS_ADMIN

B.

CONTENT_ADMIN

C.

SAP_ALL

D.

IC MODELER

 

Answer: B

 

 

QUESTION 2

You would like to authorize a user to select and delete data from a specific column table. The user should also be able to grant this authorization to other users.

 

Which privilege do you need to implement?

 

A.

Analytic privilege

B.

System privilege

C.

Package privilege

D.

Object privilege

 

Answer: D

 

 

QUESTION 3

In a reporting scenario you use an Opening Date attribute in the data foundation that contains information about your stores. You want to determine the number of years each store has been in business. How do you achieve this?

 

A.

Use calculated measures.

B.

Use time attributes.

C.

Use calculated attributes.

D.

Use private attributes.

 

Answer: C

 

 

 

QUESTION 4

Which of the following would you use to determine the engines that are used when an information model is queried?

 

A.

SQL plan cache

B.

Timeline

C.

Explain plan

D.

Visualize plan

 

Answer: CD

 

 

QUESTION 5

In an aggregation node of a calculation view, which is the default aggregation type for an aggregated measure?

 

A.

COUNT

B.

MAX

C.

SUM

D.

MIN

 

Answer: C

 

 

QUESTION 6

You want to run a report on data with multiple currencies. You want to allow end users to select the target currency at run time.

 

Which option does SAP recommend for defining the currency conversion?

 

A.

A calculated column in an analytic view

B.

Currency conversion during data load

C.

Measures enabled for conversion in an analytic view

D.

A CE_CONVERSION function in a calculation view

 

Answer: C

 

 

 

QUESTION 7

Which of the following are restrictions of the SAP HANA flat file upload?


 

A.

A table must have the same column order as the flat file when you append data.

B.

The upload does not allow to change the column names of new tables.

C.

A new table must have a 1:1 mapping between the flat file columns and the table columns.

D.

The upload prevents data type changes when appending data.

 

Answer: CD

 

 

QUESTION 8

You are building a calculation view and want to select data from an analytic view. How can you achieve better performance for this requirement?

 

A.

Use CE functions

B.

Use SQL statements

C.

Use L programming

D.

Use table indexing

 

Answer: A

 

 

QUESTION 9

A company needs to load external data from a flat file into SAP HANA. How can you do this?

 

A.

SAP HANA Direct Extractor Connection (DXC)

B.

SAP System Landscape Transformation (SLT)

C.

SAP HANA SQL Import statement

D.

SAP BusinessObjects Data Services

 

Answer: CD

 

 

QUESTION 10

 

Which tasks can you perform with the data provisioning view in the SAP HANA studio?

 

A.

Start replication of tables

B.

Filter replicated data

C.

Apply data transformations

D.

Suspend replication of tables

 

Answer: AD

Free VCE & PDF File for SAP C_HANAIMP151 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …

Comments are closed.