SAP C_HANAIMP142 Online Practice Questions and Exam Preparation

SAP C_HANAIMP142 Online Questions & Answers

• Question 201:

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

  Which CE function do you use?

  A. CE_UNION
  B. CE_CALC
  C. CE_COLUMN_TABLE
  D. CE_PROJECTION
  D. CE_PROJECTION

• Question 202:

  Which of the following tools can you use to monitor the query time from SAP HANA?

  A. Central Management Console
  B. Performance tab of the System Monitor
  C. Event Viewer
  D. SQL Trace
  D. SQL Trace

• Question 203:

  Which of the following steps is required for configuring SAP Landscape Transformation (SLT)?

  A. Define the number of background work processes in SLT.
  B. Define an RFC connection from SLT to SAP HANA.
  C. Define a DB connection from SLT to the source system.
  D. Define the number of jobs to be used for data replication.
  D. Define the number of jobs to be used for data replication.

• Question 204:

  What is an example of a selective data load using SAP Landscape Transformation?

  A. Selected data field values are randomized and loaded into SAP HANA.
  B. Selected units or currencies are converted into recalculated amounts or values and loaded into SAP HANA.
  C. Selected data for transformation is split into portions.
  D. Selected data for a range of years is loaded into SAP HANA.
  D. Selected data for a range of years is loaded into SAP HANA.

• Question 205:

  You have an SAP NetWeaver Business Warehouse (SAP NetWeaver BW) on SAP HANA system installed on multiple nodes. Which of the following information objects are stored on the master node?

  A. SAP NetWeaver BW master data tables
  B. DataStore Objects (DSOs)
  C. ABAP system tables
  D. Persistent Staging Area (PSA) tables
  C. ABAP system tables

• Question 206:

  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
  B. Projection
  C. Aggregation

• Question 207:

  Your information model needs real-time access to external data stored in Microsoft SQL Server 2011. How can you implement this scenario in SAP HANA? (Choose two)

  A. Create a virtual table and use it in attribute view
  B. Create a batch job in SAP Data Services
  C. Create a virtual table and use it in a calculation view
  D. Perform replication using SAP Replication Server
  C. Create a virtual table and use it in a calculation view
  D. Perform replication using SAP Replication Server

• Question 208:

  Which of the following operations can you use when you create a calculation view using the SAP HANA studio graphical interface? (Choose two)

  A. PROJECTION
  B. UNION
  C. INTERSECT
  D. INSERT
  A. PROJECTION
  B. UNION

• Question 209:

  Which of the following is used to make hierarchies available to reporting tools?

  A. CE Functions
  B. MDX
  C. SQLScript
  D. SQL
  B. MDX

• Question 210:

  Which privilege type do you have to assign to a role, when you want to provide row-level access to data?

  A. ANALYTIC
  B. PACKAGE
  C. SYSTEM
  D. SQL
  A. ANALYTIC