SAP C_HANAIMP_12 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_12 Online Questions & Answers

• Question 121:

  What does SAP HANA load when starting up and before indicating that it is ready? There are 3 correct answers to this question. Response:

  A. Some column tables
  B. Some row tables
  C. All partitions
  D. All system tables
  E. All row tables
  A. Some column tables
  D. All system tables
  E. All row tables

• Question 122:

  Which sentence best describes SAP HANA Live?

  Please choose the correct answer.

  Response:

  A. Analytical reporting moving back to the OLAP system
  B. Operational reporting moving back to the OLTP system
  C. Operational reporting moving back to the OLAP system
  D. Analytical reporting moving back to the OLTP system
  B. Operational reporting moving back to the OLTP system

• Question 123:

  You are using SAP NetWeaver Business Warehouse (SAP NetWeaver BW) in your company as the enterprise data warehouse. You want to use SAP NetWeaver BW as a data provisioning tool for SAP HANA without disturbing your BW reporting.

  Which of the following are SAP recommended actions? (Choose two)

  A. Automate the ETL processes in SAP NetWeaver using process chains.
  B. Write data back from SAP HANA into the replicated SAP NetWeaver BW tables.
  C. Create new InfoObjects for the SAP HANA InfoProviders.
  D. Schedule the real-time data loads into SAP HANA.
  A. Automate the ETL processes in SAP NetWeaver using process chains.
  C. Create new InfoObjects for the SAP HANA InfoProviders.

• Question 124:

  You have a Web Intelligence report that requires data from SAP HANA filtered for a specific year. Where do you apply the filter for optimal performance?

  A. In the universe
  B. In the Web Intelligence report
  C. In the analytic view
  D. In the calculation view using an attribute value variable
  C. In the analytic view

• Question 125:

  What can a variable be used for? Please choose the correct answer. Response:

  A. Currency conversion
  B. Calculated column expression
  C. Call decision table in SQLScript
  D. Filtering
  D. Filtering

• Question 126:

  In a fuzzy search, when would you perform a freestyle search?

  A. When you want to search with a low fuzziness threshold
  B. When you want to search in only one column
  C. When you want to search in multiple columns
  D. When you want to search with a high fuzziness threshold
  C. When you want to search in multiple columns

• Question 127:

  You are given an old government paper form with lines, blocks, and fields. You are asked to create a report that looks like this form. Which business intelligence tools do you use? Please choose the correct answer. Response:

  A. SAP BusinessObjects Design Studio
  B. SAP Crystal Reports for Enterprise
  C. SAP Lumira
  D. SAP BusinessObjects Web Intelligence
  B. SAP Crystal Reports for Enterprise

• Question 128:

  What should you keep in mind when using dynamic SQL?

  There are 2 correct answers to this question.

  Response:

  A. It is always bad for security.
  B. You can dynamically change your data sources.
  C. It could be used for SQL injection.
  D. It delivers the best possible performance.
  B. You can dynamically change your data sources.
  C. It could be used for SQL injection.

• Question 129:

  What statement is allowed in a user-defined function? There are 2 correct answers to this question. Response:

  A. COMMIT
  B. EXEC
  C. JOIN
  D. INSERT
  C. JOIN
  D. INSERT

• Question 130:

  What PAL algorithm would you use to analyze shopping baskets? Please choose the correct answer. Response:

  A. Decision tree
  B. K-means
  C. Apriori
  D. Link prediction
  C. Apriori