SAP C_HANAIMP_12 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_12 Online Questions & Answers

• Question 71:

  You want to retrieve data from SAP HANA and restrict access to certain data columns for specific user groups. Where can you implement this?

  A. In the analytic privileges
  B. In the data foundation
  C. In the business layer
  D. In the SQL privileges
  C. In the business layer

• Question 72:

  When you activate a procedure, in which schema is the procedure stored?

  A. SYSTEM
  B. _SYS_BIC
  C. SYS_REPL
  D. _SYS_BI
  B. _SYS_BIC

• Question 73:

  You need real-time profitability reporting from an SAP ECC system running on a non-SAP database. Which of the following steps must you perform to implement the SAP CO-PA Accelerator? (Choose two)

  A. Configure an ABAP dataflow in SAP Data Services.
  B. Create an SAP Landscape Transformation configuration.
  C. Build attribute and analytic views in SAP HANA.
  D. Install SAP HANA as a secondary database.
  B. Create an SAP Landscape Transformation configuration.
  D. Install SAP HANA as a secondary database.

• Question 74:

  You want to use a UNION to combine two information objects in a calculation view. Which steps do you have to perform? (Choose two)

  A. Define a constant column in the target.
  B. Sort the columns in the output structure.
  C. Connect the information objects to the UNION node.
  D. Define the mapping of columns of the information objects.
  C. Connect the information objects to the UNION node.
  D. Define the mapping of columns of the information objects.

• Question 75:

  Which of the following can be part of an analytic view?

  A. Query transformation
  B. Unions
  C. Logical joins
  D. Data foundation
  E. Attributes
  C. Logical joins
  D. Data foundation
  E. Attributes

• Question 76:

  Which of the following ways of publishing SAP HANA information model content could require some JavaScript knowledge?

  There are 2 correct answers to this question.

  Response:

  A. Creating business intelligence content with SAP BusinessObjects Design Studio
  B. Creating a composite provider in SAP BW
  C. Creating a REST web service in the SAP HANA XS engine
  D. Creating a report in SAP Crystal Reports for Enterprise
  A. Creating business intelligence content with SAP BusinessObjects Design Studio
  C. Creating a REST web service in the SAP HANA XS engine

• Question 77:

  Which programming language do you use for streaming projects? Please choose the correct answer. Response:

  A. SQLScript
  B. JavaScript
  C. SQL
  D. CCL
  D. CCL

• Question 78:

  What does the C in ACID-compliant stand for? Please choose the correct answer. Response:

  A. Complexity
  B. Constant
  C. Complete
  D. Consistency
  D. Consistency

• Question 79:

  Which join type makes use of date ranges? Please choose the correct answer. Response:

  A. Inner join
  B. Temporal join
  C. Text join
  D. Spatial join
  B. Temporal join

• Question 80:

  You have a list of map locations for clinics. The government wants to build a new clinic, but wants to build it where there is the greatest need.

  You need to find the largest distance between any two clinics. With your current knowledge, how do you do this?

  Please choose the correct answer.

  Response:

  A. Use a temporal join to find the distance between clinics. Use a union with constant values to "pivot" the values.
  B. Use a dynamic join to find the longest distance between clinics. Use a ranking to find the top 10 values.
  C. Use a spatial join to find the distance between clinics. Use an aggregation with the maximum option.
  D. Use a spatial join to find the distance between clinics. Use a level hierarchy for drilldown.
  C. Use a spatial join to find the distance between clinics. Use an aggregation with the maximum option.