SAP C_HANAIMP_12 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_12 Online Questions & Answers

• Question 111:

  Which of the following are reasons you should use Core Data Services (CDS) to create a schema? There are 2 correct answers to this question. Response:

  A. The focus is on the business requirements.
  B. The database administrator should not get those privileges in the production system.
  C. The database administrator might type the name wrong.
  D. The focus is on the database administration requirements.
  A. The focus is on the business requirements.
  B. The database administrator should not get those privileges in the production system.

• Question 112:

  The entity is the core artifact for persistence-model definition using the CDS syntax. You create a database entity as a design-time file in the SAP HANA repository. Which are the following prerequisites to create an entity in CDS (core data

  services)?

  There are 2 correct answers to this question

  Response:

  A. You must have deployed to schema for the CDS catalog objects
  B. You must have access to schema for the CDS catalog objects
  C. You must have access to an SAP HANA system
  D. You must have already created a development workspace and a project.
  C. You must have access to an SAP HANA system
  D. You must have already created a development workspace and a project.

• Question 113:

  Which business intelligence tool can publish storyboards? Please choose the correct answer. Response:

  A. SAP BusinessObjects Design Studio
  B. SAP BusinessObjects Web Intelligence
  C. SAP Predictive Analytics
  D. SAP BusinessObjects Analysis, edition for Microsoft Office
  C. SAP Predictive Analytics

• Question 114:

  Which tab in SAP HANA studio shows validation check errors? Please choose the correct answer. Response:

  A. Properties
  B. History
  C. Problems
  D. Job Log
  D. Job Log

• Question 115:

  What performance technique should you implement to improve join performance? Please choose the correct answer. Response:

  A. Use joins instead of unions for combining large data sets.
  B. Join on key fields between tables in a dimension view.
  C. Do NOT use dynamic joins if you require optimal performance.
  D. Always use referential joins in star join views.
  B. Join on key fields between tables in a dimension view.

• Question 116:

  A company needs to load external data from a flat file into SAP HANA. How can you do this?

  A. SAP HANA Direct Extractor Connection (DXC)
  B. SAP System Landscape Transformation (SLT)
  C. SAP HANA SQL Import statement
  D. SAP BusinessObjects Data Services
  C. SAP HANA SQL Import statement
  D. SAP BusinessObjects Data Services

• Question 117:

  What paradigm describes the SQL language? Please choose the correct answer. Response:

  A. Object-oriented
  B. Set-oriented
  C. Application-focused
  D. Procedural
  B. Set-oriented

• Question 118:

  Which tasks are part of the migration tool workflow? There are 2 correct answers to this question. Response:

  A. The tool requires a graphical calculation view as input.
  B. The tool requires a script-based calculation view as input.
  C. The tool produces a table function linked to a graphical calculation view.
  D. The tool produces only a table function.
  B. The tool requires a script-based calculation view as input.
  C. The tool produces a table function linked to a graphical calculation view.

• Question 119:

  What data source is available for join nodes in calculation views? Please choose the correct answer.

  Response:

  A. Scalar functions from all SAP HANA systems
  B. Web services from the Internet
  C. Calculation views from other tenants in an MDC system
  D. All procedures in the current SAP HANA system
  C. Calculation views from other tenants in an MDC system

• Question 120:

  Which of the following SAP data provisioning methods provide complex transformations? There are 2 correct answers to this question Response:

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