SAP C_HANAIMP_12 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_12 Online Questions & Answers

• Question 171:

  As what are most of the views in SAP HANA Live created? Please choose the correct answer. Response:

  A. Table functions
  B. Calculation views
  C. Cubes
  D. CDS data sources
  B. Calculation views

• Question 172:

  What do you have to define in an attribute view to reduce the initial amount of data selected from the data foundation tables?

  A. A static filter value on any column in the data foundation tables
  B. A column marked as "Hidden" in the output structure
  C. A restricted column in the output structure
  D. A dynamic filter value on a measure in the attribute view
  A. A static filter value on any column in the data foundation tables

• Question 173:

  What is the default node for a calculation view of type cube? Please choose the correct answer. Response:

  A. Projection node
  B. Join node
  C. Aggregation node
  D. Star join node
  C. Aggregation node

• Question 174:

  What spatial data type would you use to store multiple shop locations? Please choose the correct answer. Response:

  A. ST _MultiPoint
  B. ST _MultilineString
  C. ST_Point
  D. ST_Polygon
  A. ST _MultiPoint

• Question 175:

  You want to load a large amount of source data (more than one billion rows) into SAP HANA for read-intensive information models. Which table type is recommended for this scenario?

  A. Global temporary table
  B. Decision table
  C. Row table
  D. Column table
  D. Column table

• Question 176:

  What does SAP HANA smart data integration use for data provisioning?

  A. SAP HANA smart data access
  B. SAP HANA smart data streaming
  C. Database triggers
  D. Database logs
  E. Real-time adapters
  A. SAP HANA smart data access
  D. Database logs
  E. Real-time adapters

• Question 177:

  What can you do in the Raw tab of the data preview in SAP HANA studio? There are 2 correct answers to this question. Response:

  A. Create a graph while analyzing the entire data result set.
  B. Sort the entire data result set and show the top 200 records.
  C. Show all distinct values in the entire data result set.
  D. Export the entire data result set to your local machine.
  B. Sort the entire data result set and show the top 200 records.
  D. Export the entire data result set to your local machine.

• Question 178:

  You are running an SAP BusinessObjects Web Intelligence report that fetches data from an analytic view. Which of the following 4 components is used by SAP HANA to provide data for this report?

  A. SAP host agent
  B. Delivery unit
  C. XS engine
  D. OLAP engine
  D. OLAP engine

• Question 179:

  You build a financial report for the company's board members that allows them to choose if they want the report to be in euros or dollars.

  What do you use?

  Please choose the correct answer.

  Response:

  A. A variable from the semantics node
  B. A variable from a projection node
  C. An input parameter from an aggregation node
  D. An input parameter from the semantics node
  D. An input parameter from the semantics node

• Question 180:

  What statement do you have to run before you can return table results from a procedure? Please choose the correct answer. Response:

  A. CREATE VIEW
  B. CREATE TABLE
  C. CREATE TYPE
  D. CREATE TABLE TYPE
  C. CREATE TYPE