Online Access Free C-HANAIMP131 Practice Test

You have two analytic views. One contains actual data and the other one contains plan data. You want to combine the two result sets and keep actual and plan data on separate records.
In the SAP HANA studio, which of the following can you use to achieve this?

• A.JOIN in an analytic view
• B.UNION in a calculation view
• C.JOIN in a calculation view
• D.PROJECTION in a calculation view

When you use SAP Landscape Transformation (SLT) replication, which of the following can you set up in the advanced replication settings?(Choose two)

• A.Change a character field length of a table.
• B.Assign a specific mass transfer ID to a table.
• C.Add a field to a table.
• D.Change the target table for specific records of a table.

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

Which of the following remote data sources can you access with SAP HANA smart data access?(Choose three)

• A.Apache Hadoop
• B.SAP Sybase Adaptive Service Enterprise
• C.Microsoft SQL Server
• D.Teradata Database
• E.SAP NetWeaver Business Warehouse

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.Create a derived attribute view with an alias for ID_1.
• B.Update the alias in the properties of ID_1.
• C.Change the label of ID_1.
• D.Create a restricted column with a different name based on ID_1.