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

A. SAP HANA Direct Extractor Connection (DXC)

B. SAP System Landscape Transformation (SLT)

C. SAP HANA SQL Import statement

D. SAP BusinessObjects Data Services

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 information model can you use with measures from multiple fact tables?

A. Analytic privilege

B. Calculation view

C. Attribute view

D. Analytic view

In which View, client queries can be less optimized and could significantly be slower compare to other models

A. Analytic

B. Attribute

C. Calculation (SQL)

D. Calculation (CE Functions)

Which of the following are required elements when you create any type of hierarchy in SAP HANA?

A. A child node

B. An analytic view

C. A data foundation

D. An attribute view

Which data provisioning method can you use to load data from SAP business content DataSources into SAP HANA?

A. SAP Landscape Transformation (SLT)

B. SAP Landscape Directory (SLD)

C. SAP Direct Extractor Connection (DXC)

D. SAP BusinessObjects Data Services

What should you keep in mind about user-defined functions? Please choose the correct answer. Response:

A. They can call procedures.

B. They can commit transactions.

C. They can use dynamic SQL.

D. They can use imperative logic.

Which are the recommended assignments in SAP HANA?

There are 2 correct answers to this question.

Response:

A. Privileges to users

B. Roles to roles

C. Roles to privileges

D. Roles to users

In which deployment scenarios does security stay in the application server, and end users do not log into

the SAP HANA system?

There are 2 correct answers to this question.

Response:

A. SAP HANA as a database

B. SAP HANA as a sidecar solution

C. SAP HANA as a platform with an SAP HANA XS application

D. SAP HANA as an accelerator

What information can you find in the Administration Console? There are 2 correct answers to this question. Response:

A. The trace and log files

B. The list of operators

C. The execution engines used

D. The SQL Plan Cache