Online Access Free C_HANAIMP_14 Practice Test

Why would you implement the SAP HANA Data Warehousing Foundation?
Please choose the correct answer.
Response:

• A.To enable reporting on SAP HANA data using the full suite of SAP Business Objects
• B.To implement an SQL-driven approach to data warehousing
• C.To improve the loading and reporting performance of SAP Business Warehouse
• D.To add OLAP data warehousing capabilities to SAP HANA

Which data provisioning tools can use SAP HANA adapters?
There are 2 correct answers to this question.

• A.SDA
• B.SDS
• C.SDI
  SRS

Global session variables can be used in SQLScript to share a scalar value between procedures and functions that are running in the same session. The value of a global session variable is not visible from another session.
Please choose the correct answer.
Response:

• A.SET <key>= <value>;
• B.SET <value>= <key>;
• C.SET <global>= <key>;
• D.SET <key>= <global>;

Using SAP Analysis for Microsoft Office, your calculation view on SAP application data returns data from two clients. In SAP Web IDE, you have identified the column to be used as the client column.
Which of the following approaches will return data from only one client?
Please choose the correct answer.
Response:

• A.Set the default client property of the Semantic node to Session Client Set the preferred client in the user settings of SAP HANA.
• B.Create a Context for each client.
  Assign the relevant Context to each user.
• C.Create a Union node with two sources.
  Filter one source on client 001 and the other source on client 002.
• D.Create a variable on the client column in the properties of the Star join node.
  Set flexible default values set for each user.

If we change the transaction "Laura buys 10 apples" to "Laura buys 10 green apples," how would we store the color green?
Please choose the correct answer.
Response:

• A.Store green as an attribute
• B.Store green as a CDS view
• C.Store green as a measure
• D.Store green as a spatial data type