SAP C_HANAIMP151 Online Practice Questions and Exam Preparation

SAP C_HANAIMP151 Online Questions & Answers

• Question 11:

  Which type of connection does Direct Extractor Connection (DXC) use to transfer data to SAP HANA?

  A. RFC connection
  B. Secondary database connection
  C. http connection
  D. ODBC connection
  C. http connection

• Question 12:

  You want to create a sales analysis by combining your customer master data with your transactional sales data.

  How do you model your data to ensure best performance?

  A. - Model the transactional data in the data foundation of an analytic view - Model the master data in the data foundation of an attribute view -Join both in the logical join of analytic view
  B. - Model the transactional data in the projection node of an calculation view - Model the master data in the data foundation of an attribute view -Combine both in the union node of the calculation view
  C. - Model the transactional data in the data foundation of an analytic view - Model the master data in the projection node of a calculation view -Combine both in the union node of the calculation view
  D. - Model the transactional data in the projection node of an calculation view - Model the master data in the datafoundation of an attribute view -Combine both in the join node of the calculation view
  A. - Model the transactional data in the data foundation of an analytic view - Model the master data in the data foundation of an attribute view -Join both in the logical join of analytic view

• Question 13:

  A customer wants to report on large amounts of SAP HANA data. The users want to drill from the top aggregation level to the lowest granularity and try different types of graphical representations of the data on the fly. Which SAP BusinessObjects reporting tool would you recommend?

  A. SAP BusinessObjects Dashboards
  B. SAP BusinessObjects Web Intelligence
  C. SAP BusinessObjects Explorer
  D. SAP BusinessObjects Crystal Reports for Enterprise
  C. SAP BusinessObjects Explorer

• Question 14:

  Which of the following are functions of the DB trigger within SAP Landscape Transformation (SLT)?

  A. Ensure that replicated changes are kept within the logging tables.
  B. Record relevant changes in logging tables.
  C. Include only relevant tables for DB recording.
  D. Decluster table classes into a transparent format.
  B. Record relevant changes in logging tables.
  C. Include only relevant tables for DB recording.

• Question 15:

  You need to find out which users logged on to the SAP HANA system over the course of the last week.

  What would you check?

  A. The Audit log
  B. Entries in M_CONNECTIONS
  C. The nameserver_history.trc file
  D. The indexserver_alert.trc file
  A. The Audit log

• Question 16:

  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 17:

  How can you improve the performance of a scripted calculation view?

  A. Read data from column tables using nested SELECT statements
  B. Convert SQL code to equivalent CE functions
  C. Combine analytic views using a CE_JOIN function
  D. Combine data from the row store and column store
  B. Convert SQL code to equivalent CE functions

• Question 18:

  What are the advantages of using SAP BusinessObjects Data Services to load data into SAP HANA?

  A. You can load unstructured data into SAP HANA.
  B. You can merge data streams.
  C. You can use the same hardware.
  D. You can perform real-time data replication.
  E. You can use BI Content extractors or function modules.
  A. You can load unstructured data into SAP HANA.
  B. You can merge data streams.
  E. You can use BI Content extractors or function modules.

• Question 19:

  During loading of data into SAP HANA you want to filter the source data. Where can you apply the filters?

  A. In a query transformation in SAP BusinessObjects Data Services
  B. In a row generation transformation in SAP BusinessObjects Data Services
  C. In a SQL WHERE clause in SAP Landscape Transformation (SLT)
  D. In an ABAP code rule in SAP Landscape Transformation (SLT)
  A. In a query transformation in SAP BusinessObjects Data Services
  D. In an ABAP code rule in SAP Landscape Transformation (SLT)

• Question 20:

  What are benefits of using a business layer on top of SAP HANA?

  A. An extra layer of granular security
  B. Improved database calculation speed
  C. Fast throughput via BICS connectivity
  D. Users can use business names instead of technical names
  A. An extra layer of granular security
  D. Users can use business names instead of technical names