SAP SAP Certifications C_HANAIMP_1 Questions & Answers

• Question 61:

  When building a business layer to report on SAP HANA, what do you have to do if you want to display more than 5,000 rows?

  A. Remove all filters from the analytic views.

  B. Deactivate the Limit Size of Result Set parameter in the Central Management Console.

  C. Set the Array Fetch Size parameter to the maximum in the relational connection.

  D. Deactivate the Limit Size of Result Set parameter in the business layer.

  Correct Answer: D

• Question 62:

  Which of the following are direct outputs of an analytic view? (Choose three)

  A. Hierarchies

  B. Private attributes

  C. Restricted attributes

  D. Measures

  E. Attribute views

  Correct Answer: BDE

• Question 63:

  You have an SAP HANA productive system with sensitive data.How can you restrict modeling users from viewing this data? (Choose two)

  A. Remove ALTER SYSTEM in the system privileges for the modeling users.

  B. Use randomized data for the development of data models.

  C. Allow modeling only on the SAP HANA development system and export/import the models to the productive system.

  D. Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users.

  Correct Answer: BC

• Question 64:

  You want to use an extractor to build a model in SAP HANA. Which table can you use to view detailed information about the extractor?

  A. BSEG

  B. RODELTAM

  C. ROOSOURCE

  D. RSOLTPSOURCE

  Correct Answer: C

• Question 65:

  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

  Correct Answer: C

• Question 66:

  Which of the following are benefits of implementing SAP HANA? (Choose three)

  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.

  Correct Answer: ABD

• Question 67:

  Which of the following sequences of steps is used to implement SAP HANA with SAP ERP?

  A. Data Provisioning ? SAP HANA system setup ? Modeling ? Consumption

  B. SAP HANA system setup ? Modeling ? Data Provisioning ? Consumption

  C. SAP HANA system setup ? Data Provisioning ? Modeling ? Consumption

  D. SAP HANA system setup ? Data Provisioning ? Consumption ? Modeling

  Correct Answer: C

• Question 68:

  Which of the following tools can you use to monitor the query time from SAP HANA?

  A. Central Management Console

  B. Performance tab of the System Monitor

  C. Event Viewer

  D. SQL Trace

  Correct Answer: D

• Question 69:

  You modify an existing view. How can you determine which models are affected by this change?

  A. Use the audit trail.

  B. Use the History feature for the changed model.

  C. Use the "Where-Used List" feature for the changed model.

  D. Use the "Auto Documentation" to compare the object version of the changed model.

  Correct Answer: C

• Question 70:

  You want to create a custom attribute in addition to your data model.

  How can you achieve this?

  A. Create the attribute as a calculated attribute within the analytic view.

  B. Create the attribute and add it to the appropriate system table manually.

  C. Create the attribute as a calculated measure within the attribute view.

  D. Create the attribute as a restricted attribute within the calculation view.

  Correct Answer: A