最新的SAP C-HANAIMP151免費考試真題

問題1

What are characteristics of a constraint filter?

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

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

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

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

正確答案: B,C

問題2

In an SQLScript calculation view, one variable contains the records that are the result of a SELECT * statement from a database table with 10 fields. You want to use this variable to populate a new variable with the same result set restricted to 1 of the 10 fields.
Which CE function do you use?

A. CE_PROJECTION

B. CE_AGGREGATION

C. CE_COLUMN_TABLE

D. CE_CALC

正確答案: A

問題3

Which of the following does an SAP BusinessObjects universe use to communicate with SAP HANA?

A. SQL

B. MDX

C. ABAP

D. BICS

正確答案: A

問題4

In a calculation view you define a calculated column and set the Calculate Before Aggregation flag.
Which of the following activities is mandatory to activate the view?

A. Mark the column as hidden

B. Add a new aggregation node

C. Set the column type to Attribute

D. Select the aggregation type

正確答案: D

問題5

Which package privileges are required to extend an SAP HANA Live view?

A. REPO.ACTIVATE_NATIVE_OBJECTS

B. REPO.READ

C. REPO.EDIT_NATIVE_OBJECTS

D. REPO.MAINTAIN_NATIVE_PACKAGES

E. REPO.EDIT_IMPORTED_OBJECTS

正確答案: A,B,C

問題6

Which of the following objects can you use when you build an analytic view?

A. Hierarchies

B. Projections

C. Attribute views

D. Analytic views

E. Variables

正確答案: A,C,E

問題7

Which SAP tool would you use for data cleansing before data is loaded into SAP HANA?

A. SAP Landscape Transformation

B. SAP BusinessObjects Data Services

C. SAP BusinessObjects Information Steward

D. SAP NetWeaver Master Data Management

正確答案: B

問題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. Aggregation node

B. Projection node

C. Referential join

D. Union

正確答案: D

問題9

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 to a content table.

C. Choose an attribute to define restricted values for it.

D. Assign the analytic privilege to a user or role.

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

正確答案: C,D,E

問題10

How can you restrict SAP HANA modeling users from viewing sensitive data?

A. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users.

B. Use scrambled source data.

C. Remove ALTER SYSTEM in the system privileges for the modeling users.

D. Use the pre-delivered MODELER role.

正確答案: B

問題11

What are the advantages of using SAP BusinessObjects Data Services to load data into SAP HANA?

A. You can merge data streams.

B. You can use the same hardware.

C. You can use BI Content extractors or function modules.

D. You can perform real-time data replication.

E. You can load unstructured data into SAP HAN

正確答案: A,C,E

問題12

You want to retrieve data from SAP HANA and restrict access to certain data columns for specific user groups. Where can you implement this?

A. In the SQL privileges

B. In the analytic privileges

C. In the data foundation

D. In the business layer

正確答案: D

問題13

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

A. Create a measure with the measure type Simple

B. Set the Enable for Conversion option

C. Base the target currency on a currency column

D. Create the target currency using an input parameter

正確答案: B

問題14

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

正確答案: B

問題15

Which of the following are functions of the controller in the SAP Landscape Transformation (SLT) server?

A. Write data to the SAP HANA system using the DB connection.

B. Schedule replication processes.

C. Create repositories in the source system.

D. Map database structures between SAP HANA and the source system.

正確答案: B,D

最新的SAP Certified Application Associate - SAP HANA (Edition 2015) - C-HANAIMP151免費考試真題

聯系我們

站內鏈接

最新更新