Latest Certified Success Dumps Download

CISCO, MICROSOFT, COMPTIA, HP, IBM, ORACLE, VMWARE
C_HANAIMP151 Examination questions (September)

Achieve New Updated (September) SAP C_HANAIMP151 Examination Questions 111-120

September 25, 2015

Ensurepass

 

QUESTION 111

You want to create a graphical calculation view using the SAP HANA studio. Which steps are mandatoryfor this task?

 

A.

Define a projection.

B.

Write an SQL script.

C.

Save and activate the view.

D.

Define output fields.

E.

Choose a data source.

 

Answer: CDE

 

 

 

QUESTION 112

You create an analytic view and want to restrict access to departments with specific values using analytic privileges. Which tasks do you have to perform to accomplish this?

 

A.

Assign restricted values to the attribute view.

B.

Assign values to be restricted. Choose at least one information model to assign restrictions.

C.

Assign the analytic privilege to a user or role.

D.

Assign values to be restricted to a content table.

E.

Choose an attribute to define restricted values for it.

 

Answer: BCE

 

 

QUESTION 113

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 114

Where is the physical data stored, on which a calculation view is based?

 

A.

In the _SYS_BI schema

B.

In a schema

C.

In the _SYS_BIC schema

D.

In a package

 

Answer: B

 

 

 

QUESTION 115

You receive an activation error in a scripted calculation view that uses the following function: CE_PROJECTION(:table1, [“AMOUNT”], ‘”PROD” = A’)

 

What could be a reason for this error?

 

A.

The filter condition is not set within square brackets.

B.

The projection list contains a field that is not specified in the filter condition.

C.

The filter condition must be specified inside the projection list.

D.

The filter condition contains a field that is not part of the projection list.

 

Answer: D

 

 

QUESTION 116

Which of the following criteria indicate that you should store data in row tables?

 

A.

The tables have a large number of columns.

B.

The tables require frequent write access.

C.

The information models search the table based on the values of a few columns.

D.

The information models frequently needs to access complete records.

 

Answer: BD

 

 

QUESTION 117

Where does SAP recommend you create calculated measures?

 

A.

In a column view

B.

In a business layer

C.

In an attribute view

D.

In an analytic view

 

Answer: D

 

 

QUESTION 118

 

Which versions of your information models are visible on the History tab of the Modeler perspective in the SAP HANA studio?

 

A.

Only the last active version

B.

All active and inactive versions

C.

All active versions

D.

The last active and inactive version

 

Answer: C

 

 

QUESTION 119

In which of the following can you use a FOR loop over your data?

 

A.

Monitoring View

B.

Calculation View

C.

Analytic View

D.

Analytic View

 

Answer: B

 

 

QUESTION 120

What do you have to define in an attribute view to reduce the initial amount of data selected from the data foundation tables?

 

A.

A static filter value on any column in the data foundation tables

B.

A column marked as “Hidden” in the output structure

C.

A restricted column in the output structure

D.

A dynamic filter value on a measure in the attribute view

 

Answer: A

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 …