SAP E_HANAAW_17 Online Practice Questions and Exam Preparation

SAP E_HANAAW_17 Online Questions & Answers

• Question 151:

  In addition to closing the result set. What does the CLOSE method of the CL_SQL_RESULT_SET class when using ABAP Database Connectivity (ADBC) do? Please choose the correct answer.

  A. Release resources
  B. Update resources
  C. Update resources
  D. Update packages
  A. Release resources

• Question 152:

  You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias? There are 3 correct answers to this question.

  A. CASTE Expression
  B. CASE expression
  C. Currency Conversion
  D. Nested CASE expression
  E. Unit conversion
  B. CASE expression
  C. Currency Conversion
  E. Unit conversion

• Question 153:

  You use ABAP database connectivity (ADBC) to issue native SQL calls to the database, the native SQL call.

  Which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call? Please choose the correct answer.

  A. SET_PARAM_TABLE
  B. SET_PARAM
  C. EXECUTE_QUERY
  D. NEXT_PACKAGE
  D. NEXT_PACKAGE

• Question 154:

  Which feature can you use to improve the performance of data transformation in the Extract, Transform and Load (ETL) process?

  A. Service Adaptation Description Language (SADL)
  B. Process Agent Framework (PAF)
  C. ABAP Messaging Channels (AMC)
  D. ABAP Managed Database Procedures (AMDP)
  D. ABAP Managed Database Procedures (AMDP)

• Question 155:

  Where can you consume associations in a Core Data Services (CDS) view? 3 answers

  A. In the projection list
  B. In the name list
  C. In the input parameter list
  D. In the FROM clause
  E. In the WHERE and HAVING clauses
  A. In the projection list
  D. In the FROM clause
  E. In the WHERE and HAVING clauses

• Question 156:

  ANSI SQL owns features and adds languages. These languages divided into three parts. What are they? There are 3 correct answers to this question.

  A. Data Manipulation Language
  B. The Data Control Language
  C. The Database Language
  D. The Data Definition Language
  E. Data Transferred Language
  A. Data Manipulation Language
  B. The Data Control Language
  D. The Data Definition Language

• Question 157:

  List down the elements involved in User Management and Security in SAP Hana? There are 3 correct answers to this question

  A. Manage users
  B. Assign Job security
  C. Assign security
  D. Work Management
  E. Create users
  A. Manage users
  C. Assign security
  E. Create users

• Question 158:

  What is Core Data Services (CDS)?

  A. A collection of services that provide information about the data volumes of the SAP HANA core tables
  B. A collection of services for ABAP application programming that provide access to the core features of the SAP HANA database management system
  C. A collection of core features and services that provide data from the ABAP application server layer to the user interface
  D. A collection of domain-specific languages and services for definition and consumption of semantically rich data models
  D. A collection of domain-specific languages and services for definition and consumption of semantically rich data models

• Question 159:

  Analytic Privilege can be applied to (3 Answers)

  A. Calculation views
  B. Attribute views
  C. Analytic views
  D. Table
  E. SQL View
  A. Calculation views
  B. Attribute views
  C. Analytic views

• Question 160:

  Which engine is used to execute Analytic View?

  A. SQL Engine
  B. Calc Engine
  C. OLAP Engine
  D. Join Engine
  C. OLAP Engine