SAP C_HANAIMP151 Online Practice Questions and Exam Preparation

SAP C_HANAIMP151 Online Questions & Answers

• Question 191:

  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 a calculation view
  B. JOIN in an analytic view
  C. UNION in a calculation view
  D. PROJECTION in a calculation view
  C. UNION in a calculation view

• Question 192:

  Which of the following privileges do you need to activate views?

  A. SELECT option on the _SYS_BIC schema
  B. SELECT option on the _SYS schema
  C. SELECT option on the _SYS_BI schema
  D. SELECT option on the _SYS_REPO schema
  D. SELECT option on the _SYS_REPO schema

• Question 193:

  Which of the following tools can you use to load data into SAP HANA from SAP DataSource extractors?

  A. SAP Data Services
  B. SAP Sybase Replication Server
  C. SAP Landscape Transformation Server
  D. SAP Direct Extractor Connection
  A. SAP Data Services
  D. SAP Direct Extractor Connection

• Question 194:

  In which View, client queries can be less optimized and could significantly be slower compare to other models

  A. Analytic
  B. Attribute
  C. Calculation (SQL)
  D. Calculation (CE Functions)
  C. Calculation (SQL)

• Question 195:

  You create a role with the following command: CREATE ROLE "InfoUser" When you try to assign this role to user PETER with the following command:

  GRANT InfoUser to PETER you receive an error message "Invalid user privilege: INFOUSER".

  What must you do to avoid this problem?

  A. Recreate the role with the command CREATE ROLE InfoUser.
  B. Recreate user PETER with GRANT OPTION.
  C. Grant the role the WITH ADMIN OPTION.
  D. Recreate the role with the command CREATE ROLE INFOUSER.
  E. Grant the role with the command GRANT "InfoUser" to PETER.
  A. Recreate the role with the command CREATE ROLE InfoUser.
  D. Recreate the role with the command CREATE ROLE INFOUSER.
  E. Grant the role with the command GRANT "InfoUser" to PETER.

• Question 196:

  You have created an MS Excel report on SAP HANA data.

  On which of the following could you store the Excel file and make it available for other users?

  A. Shared network drive
  B. SAP BusinessObjects Information Design Tool
  C. SAP HANA database
  D. SAP HANA studio Content node
  A. Shared network drive

• Question 197:

  Your customer wants to implement a SAP product that: Provides near real-time replication to SAP HANA Connects SAP HANA to a non-SAP source system and SAP BW Uses SAP extractors What do you recommend?

  A. SAP Legacy System Migration Workbench (LSMW)
  B. SAP Landscape Transformation (SLT)
  C. Sybase Replication Server
  D. SAP BusinessObjects Data Services 4.0
  D. SAP BusinessObjects Data Services 4.0

• Question 198:

  Which of the following are benefits of implementing SAP HANA?

  A. SAP HANA provides real-time analytics.
  B. SAP HANA performs much faster than the standard SAP ERP.
  C. SAP HANA provides pre-configured BI Content.
  D. SAP HANA combines OLTP and OLAP in one system.
  E. SAP HANA replaces SAP BW.
  A. SAP HANA provides real-time analytics.
  B. SAP HANA performs much faster than the standard SAP ERP.
  D. SAP HANA combines OLTP and OLAP in one system.

• Question 199:

  Which SAP BusinessObjects tool do you use to visualize real-time key performance indicators with simu-lations?

  A. Explorer
  B. Analysis, edition for OLAP
  C. Web Intelligence
  D. Dashboards
  D. Dashboards

• Question 200:

  Which types of calendar are available for time attribute views in SAP HANA?

  A. Fiscal
  B. Factory
  C. Gregorian
  D. Julian
  A. Fiscal
  C. Gregorian