SAP C_HANAIMP151 Online Practice Questions and Exam Preparation

SAP C_HANAIMP151 Online Questions & Answers

• Question 51:

  Which of the following must an analytic view contain?

  A. A measure
  B. A calculated measure
  C. A hierarchy
  D. An attribute view
  A. A measure

• Question 52:

  If you want to create or drop tables in a schema, which privilege type do you need?

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

• Question 53:

  Which of the following would you use to determine the engines that are used when an information model is queried?

  A. SQL plan cache
  B. Timeline
  C. Explain plan
  D. Visualize plan
  C. Explain plan
  D. Visualize plan

• Question 54:

  When you activate an analytic view, a column view is created. In which schema is this column view stored?

  A. _SYS_BIC
  B. _SYS_BI
  C. _SYS_REPO
  D. _SYS
  A. _SYS_BIC

• Question 55:

  When loading data into SAP HANA, which of the following tasks can you perform using SAP Data Services?

  A. Replicate data using database triggers.
  B. Read data from SAP ERP using the embedded SAP BW system.
  C. Replicate data by reading database logs
  D. Read data from SAP ERP using ABAP data flows.
  D. Read data from SAP ERP using ABAP data flows.

• Question 56:

  Union can be performed only at...

  A. Analytic
  B. Attribute
  C. Calculation
  D. Analytic / Calculation
  C. Calculation

• Question 57:

  Which SAP HANA model is recommended for reporting purposes where read operations on mass data are required?

  A. Analytic view
  B. Calculation view using SQL
  C. Calculation view using SQL Script
  D. Attribute view
  A. Analytic view

• Question 58:

  Two attribute views in the same analytic view contain the same column name: the ID from the Customer attribute view and the ID from the Product attribute view. In the output, the system automatically renamed one column to ID_1. You want to indicate that ID_1 originated from the Product attribute view by renaming it to ID_PRODUCT.

  Where in the attribute properties of ID_1 can you change this?

  A. In the alias label
  B. In the label
  C. In the alias name
  D. In the name
  A. In the alias label
  C. In the alias name

• Question 59:

  What is features available in Project Creation Wizard

  A. New option to auto-share an XS Project to the SAP HANA Repository during the project creation wizard
  B. New option to auto-share an XS Server - side Project to the SAP HANA Repository during the project creation wizard
  C. New option to auto-share an XS client - side Project to the SAP HANA Repository during the project creation wizard
  D. New option to auto-share an XS Server - side secure Project to the SAP HANA Repository during the project creation wizard
  A. New option to auto-share an XS Project to the SAP HANA Repository during the project creation wizard

• Question 60:

  You are using SAP Landscape Transformation to replicate data into SAP HANA.

  Which of the following can you use to define the schema that the replicated data populates?

  A. Advanced replication settings (transaction iuuc_repl_content)
  B. Change Authoring Schema in the Quick Launch view
  C. Data Provisioning in the Quick Launch view
  D. Configuration and Monitoring Dashboard (transaction LTR)
  D. Configuration and Monitoring Dashboard (transaction LTR)