SAP C_HANAIMP142 Online Practice Questions and Exam Preparation

SAP C_HANAIMP142 Online Questions & Answers

• Question 131:

  You want to add a calculated column to an SAP BusinessObjects Web Intelligence report. In which application do you create the calculation to achieve best report performance?

  A. Central Management Console
  B. Information Design Tool
  C. Web Intelligence
  D. SAP HANA Studio
  D. SAP HANA Studio

• Question 132:

  Which of the following are required to build a SQLScript calculation view? (Choose two)

  A. Define a data foundation.
  B. Define a measure.
  C. Set the MultiDimensional Reporting property to false.
  D. Add columns to the var_out output parameter.
  B. Define a measure.
  D. Add columns to the var_out output parameter.

• Question 133:

  You are running an SAP BusinessObjects WebIntelligence report that fetches data from SAP HANA. Which components will be used inside SAP HANA for providing data to this report? (Choose two)

  A. Persistence Layer
  B. MDX
  C. Session Management
  D. Authorization Manager
  C. Session Management
  D. Authorization Manager

• Question 134:

  Which tasks can you perform with the data provisioning view in the SAP HANA studio? (Choose two)

  A. Start replication of tables
  B. Filter replicated data
  C. Apply data transformations
  D. Suspend replication of tables
  A. Start replication of tables
  D. Suspend replication of tables

• Question 135:

  You want to improve query performance by introducing filters into the SAP HANA information model. Which of the following can you use to reduce data transfer between views? (Choose two)

  A. Analytic privileges
  B. Calculated columns
  C. Client-independent views
  D. Constraint filters
  A. Analytic privileges
  D. Constraint filters

• Question 136:

  You need to retrieve data from SAP HANA that is restricted to a certain region and specific users. How can you implement this security strategy?

  A. By assigning SQL privileges to the necessary users
  B. By assigning Analytic privileges to the necessary users
  C. By assigning System privileges to the necessary users
  D. By assigning Package privileges to the necessary users
  B. By assigning Analytic privileges to the necessary users

• Question 137:

  Which of the following data provisioning tasks can you perform in the SAP HANA studio? (Choose three)

  A. Configure remote sources for SAP HANA smart data access.
  B. Activate the SAP Web Dispatcher service for SAP HANA Direct Extractor Connection (DXC).
  C. Start replication of tables for SAP Landscape Transformation (SLT).
  D. Create replication configurations for SAP Landscape Transformation (SLT).
  E. Create an SAP ECC extractor datastore for SAP Data Services.
  A. Configure remote sources for SAP HANA smart data access.
  B. Activate the SAP Web Dispatcher service for SAP HANA Direct Extractor Connection (DXC).
  C. Start replication of tables for SAP Landscape Transformation (SLT).

• Question 138:

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

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

  Your customer wants to use SAP BusinessObjects Data Services to migrate and transform large volumes of data to SAP HANA. What do you recommend?

  A. Use ABAP data flows.
  B. Use RFC/BAPI function calls.
  C. Use the RFC_READ_TABLE.
  D. Use IDOCs.
  A. Use ABAP data flows.

• Question 140:

  Which of the following automatically aggregates data? (Choose two)

  A. Analytic view
  B. Calculation view
  C. Column table
  D. Attribute view
  A. Analytic view
  B. Calculation view