SAP C_HANAIMP151 Online Practice Questions and Exam Preparation

SAP C_HANAIMP151 Online Questions & Answers

• Question 201:

  Where can you reactivate a user after too many invalid logon attempts?

  A. In the SQL console
  B. In the user specific schema
  C. In the INVALID_CONNECT_ATTEMPS view
  D. In the user properties
  A. In the SQL console
  D. In the user properties

• Question 202:

  You want to add a column to a calculation view that displays the year-to-date revenue of the current fiscal year.

  How can you achieve this?

  A. Use a calculated attribute.
  B. Use a calculated measure.
  C. Use a variable.
  D. Use a CE function.
  B. Use a calculated measure.
  D. Use a CE function.

• Question 203:

  You have a table of transactional data with different transaction types. You want to create an analytic view for only one of the transaction types.

  How can you ensure that only rows with the required transaction type are displayed in the analytic view?

  A. Create an input parameter
  B. Create a filter on the table
  C. Create a calculated column
  D. Create a restricted column
  B. Create a filter on the table

• Question 204:

  Which of the following can you use to implement currency conversion in an information model?

  A. A calculated column in a calculation view
  B. A restricted column in an analytic view
  C. A calculated column in an analytic view
  D. A calculated column in an attribute view
  A. A calculated column in a calculation view
  C. A calculated column in an analytic view

• Question 205:

  Which of the following SAP data provisioning methods provide complex transformations?

  A. SAP Data Services
  B. SAP HANA smart data access
  C. SAP Replication Server
  D. SAP HANA smart data quality
  A. SAP Data Services
  D. SAP HANA smart data quality

• Question 206:

  In SAP HANA studio, in which of the following can you create users?

  A. The Administration console
  B. The Roles node
  C. The Content node
  D. The SQL editor
  A. The Administration console
  D. The SQL editor

• Question 207:

  You are running an SAP BusinessObjects WebIntelligence report that fetches data from SAP HANA. Which components will be used inside SAP HANA for providing data to this report?

  A. Persistence Layer
  B. MDX
  C. Session Management
  D. Authorization Manager
  C. Session Management
  D. Authorization Manager

• Question 208:

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

  Which CE function do you use?

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

• Question 209:

  What can you use to transform data from SAP Business Warehouse (BW) into SAP HANA?

  A. SAP Landscape Transformation (SLT)
  B. SAP BW extractors
  C. SAP BusinessObjects Data Services
  D. SAP Legacy System Migration Workbench (LSMW)
  C. SAP BusinessObjects Data Services

• Question 210:

  In which tool can you create information spaces for reporting?

  A. in the SAP HANA modeler perspective
  B. in the SAP HANA SQL editor
  C. in SAP BusinessObjects Explorer
  D. in the Information Design Tool
  C. in SAP BusinessObjects Explorer