Online Access Free C_HANAIMP131 Exam Questions

Two attribute views in the same analytic view contain the same column name (ID from attribute view Customer and ID from attribute view Product). In the output, the system automatically renamed one column to ID_1.
Which of the following can you do to indicate that ID_1 originated from attribute view Product?

• A.Change the label of ID_1.
• B.Update the alias in the properties of ID_1.
• C.Create a restricted column with a different name based on ID_1.
• D.Create a derived attribute view with an alias for ID_1.

Which of the following objects would SAP HANA identify as the left object of a join in the graphical calculation view?

• A.The object that is displayed on the left hand side in the graphical calculation view.
• B.The object that is displayed on the left hand side in the join details panel.
• C.The object that is connected to the join node first.
• D.The object that has its field identified first in the join output.

You are using SAP NetWeaver Business Warehouse (SAP NetWeaver BW) in your company as the enterprise data warehouse. You want to use SAP NetWeaver BW as a data provisioning tool for SAP HANA without disturbing your BW reporting.
Which of the following are SAP recommended actions?(Choose two)

• A.Automate the ETL processes in SAP NetWeaver using process chains.
• B.Create new InfoObjects for the SAP HANA InfoProviders.
• C.Write data back from SAP HANA into the replicated SAP NetWeaver BW tables.
• D.Schedule the real-time data loads into SAP HANA.

How can you improve the performance of a scripted calculation view?

• A.Read data from column tables using nested SELECT statements
• B.Convert SQL code to equivalent CE functions
• C.Combine analytic views using a CE_JOIN function
• D.Combine data from the row store and column store

You want to use a UNION to combine two information objects in a calculation view. Which steps do you have to perform?(Choose two)

• A.Define the mapping of columns of the information objects.
• B.Connect the information objects to the UNION node.
• C.Sort the columns in the output structure.
• D.Define a constant column in the target.