C_HANAIMP_11 Free Demo Questions and Answers

Test Information:

Total Questions: 220

Test Number: C_HANAIMP_11

Vendor Name: SAP

Cert Name:  SAP HANA

Test Name: SAP Certified Application Associate - SAP HANA (Edition 2016)

Official Site:http://www.examsboost.com

For More Details: http://www.examsboost.com/test/C_HANAIMP_11/

Question: 1

   

What are characteristics of a constraint filter?

 

A. It is defined during the design time on a table.

B. It is applied on a table before the query execution.

C. It is applied on the result set of an SQL query.

D. It is defined during the runtime in the SQL query.

 

Answer: A, B   

 

Question: 2

 

Which of the following are direct outputs of an analytic view?

 

A. Hierarchies

B. Private attributes

C. Restricted attributes

D. Measures

E. Attribute views

 

Answer: B, D, E   

 

Question: 3

 

When you activate an analytic view, a column view is created. In which schema is this column view stored?

 

A. _SYS_BIC

B. _SYS_BI

C. _SYS_REPO

D. _SYS

 

Answer: A   

 

Question: 4

 

Which of the following SAP data provisioning methods provide complex transformations?

 

A. SAP Data Services

B. SAP HANA smart data access

C. SAP Replication Server

D. SAP HANA smart data quality

 

Answer: A, D   

 

Question: 5

 

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: C, D   

 

Question: 6

 

In an analytic view, you need two different logical joins from the data foundation to an attribute view. The analytic view already contains the attribute view but you have to use the attribute view again.

To which of the following do you connect the second join?

 

A. To a shared attribute view

B. To a derived attribute view

C. To a new instance of the attribute view

D. To a copy of the attribute view

 

Answer: B, D   

 

Question: 7

 

What must you do to enable currency conversions with a fixed currency in an analytic view?

 

A. Set the Enable for Conversion option

B. Create a measure with the measure type Simple

C. Base the target currency on a currency column

D. Create the target currency using an input parameter

 

Answer: A   

 

Question: 8

 

You create a graphical calculation view that is based on analytic views.

What do you use to combine the data from the analytic views?

 

A. Referential join

B. Projection node

C. Aggregation node

D. Union

 

Answer: D   

 

Question: 9

 

You want to model customer master data.

Which of the following must you select?

 

A. Filter

B. Table

C. Hierarchy

D. Key attribute

 

Answer: B, D   

 

Question: 10

 

You modified an active analytic view in the SAP HANA studio and saved it without activating it.

What is the consequence?

 

A. The inactive view is not available.

B. The inactive view is in "Read Only" mode.

C. The active view is not available.

D. The active view is in "Read Only" mode.

 

Answer: D   

 

Question: 11

 

When you activate a procedure, in which schema is the procedure stored?

 

A. SYSTEM

B. _SYS_BIC

C. SYS_REPL

D. _SYS_BI

 

Answer: B   

 

Question: 12

 

You want to create a graphical calculation view using the SAP HANA studio. Which steps are mandatory for 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: C, D, E   

 

Question: 13

 

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

 

Answer: C   

 

Question: 14

 

What is the lowest level of granularity you can use in an analytic privilege?

 

A. An attribute

B. A view

C. An attribute value

D. A column

 

Answer: C   

 

Question: 15

 

What must you configure to directly access an SAP HANA analytic view using SAP BusinessObjects Analysis edition for Microsoft Office?

 

A. RFC connection

B. SAP HANA Direct Extractor Connection (DXC)

C. Pre-delivered MODELING role

D. System DSN

 

Answer: D