[Sep-2021] E_HANAAW_17 Dumps Full Questions - SAP Certified Development Specialist Exam Study Guide
Exam Questions and Answers for E_HANAAW_17 Study Guide
NEW QUESTION 56
What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container? (2 right answers)
- A. Changes to Delta Container
- B. Automatic release of units
- C. Take snapshot manually before releasing of the container
- D. You need to refresh the content of the container manually
Answer: C,D
NEW QUESTION 57
You want to execute a native SQL statement in your program. Why should you use ABAP Database Connectivity (ADBC)? (Choose Two)
- A. It supports where-used list.
- B. It supports exception handling
- C. It has syntax check as compile time.
- D. It supports locking and commit handling
Answer: B,D
NEW QUESTION 58
What are the benefits includes with SAP HANA Full Text Search? There are 2 correct answers to this question
- A. Exploit structured contents in SQL
- B. Large number of toolkits are available
- C. Fewer data duplication and movement
- D. Easy to use modeling tool
Answer: C,D
NEW QUESTION 59
Which of the following statements are true about "Content"?
- A. It represents SAP HANA's data dictionary.
- B. It contains the design-time artifacts.
- C. All the physical tables and views can be found under the Catalog node.
Answer: B
NEW QUESTION 60
You import an ABAP workbench request into a SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package 2HA400_00. WHICH PREREQISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database? There are 2 correct answers to this question.
- A. PACKAGE ZHA400J30 HAS deployment Mode A
- B. View CA_CUSTOMER has deployment mode A.
- C. Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK
- D. SYSTEM P81 has SAP HANA has primary database
Answer: C,D
NEW QUESTION 61
Which TADIR object type is used for the definition of a Core Data Services (CDS) view?
- A. R3TR DDLS
- B. R3TR DDIC
- C. R3TR VIEW
- D. R3TR TABL
Answer: A
NEW QUESTION 62
What are the two types of editors available in ADT? There are 2 correct answers to this question.
- A. SAP (GUI)
- B. Client (native)
- C. ABAP (native)
- D. Eclipse (native)
Answer: A,D
NEW QUESTION 63
How can you check if Core Data Services (CDS) views with scalar input parameters can be used in Open SQL queries in your system?
- A. Check the Open SQL statement in the Explain SQL Statement transaction (SDBE).
- B. Check the value of the ABAP system field sy-cdsfeatures.
- C. Perform a static code check using the FUNCTIONAL_DB variant.
- D. Use the static method use_features of class cl_abap_dbfeatures.
Answer: D
NEW QUESTION 64
Which SAP HANA engine executes Calculation view? (2 answers)
- A. SQL Engine
- B. JOIN Engine
- C. OLAP Engine
- D. Calculation Engine
Answer: A,D
NEW QUESTION 65
Where can you consume associations in a Core Data Services (CDS) view? 3 ans
- A. In the FROM clause
- B. In the WHERE and HAVING clauses
- C. In the input parameter list
- D. In the projection list
- E. In the name list
Answer: A,B,D
NEW QUESTION 66
Which of the below statements are true for SAP HANA Studio? (3 right answers)
- A. SAP HANA Studio can be used to manage the SAP HANA database, to create and manage user authorizations, to create new or modify existing models of data etc
- B. SAP HANA Studio is integrated in SAP GUI > 7.40
- C. SAP HANA Studio is an Eclipse-based, integrated development environment (IDE) that is used to develop artifacts in a HANA server.
- D. SAP HANA Studio is a client tool, which can be used to access local or remote HANA system.
Answer: A,C,D
NEW QUESTION 67
You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP HANA is used as the db In the check parameters, which value would you use for the percentage of fields that are effectively used?
Please choose the correct answer.
- A. A higher value than on a traditional, row-store only based database
- B. A value that you calculate based on the number of tables
- C. A lower value than on a traditional, row-store only based database
- D. The same value as on a traditional, row-store only based database
Answer: C
NEW QUESTION 68
What are the different types of Calculation View? (2 answers)
- A. Graphical Calculation View
- B. Text-Based Calculation
- C. Scripted Calculation View
- D. OLAP Calculation View
Answer: A,C
NEW QUESTION 69
User STUDENT_A creates and activates a design-time Object. In which schema is the runtime object generated?
- A. SYSTEM
- B. _SYS_BIC
- C. SYS_BI
- D. STUDENT_A
Answer: B
NEW QUESTION 70
You are using a calculated column COUNTS within your Dimension Calculation View and an aggregation node. This is the data that goes into the aggregation node:
- A. AT Vienna 11
AT Vienna 15
DE Berlin 13
DE Berlin 13 - B. AT Vienna 26
DE Berlin 26 - C. AT Vienna 11
AT Vienna 15
DE Berlin 13 - D. AT Vienna 11
DE Berlin 13
Answer: D
NEW QUESTION 71
You analyse SQL Monitor data in transaction SQLMD. You know that program X accesses database table Y.
You made sure that program X was executed while the SQL Monitor collected its dat a. But the relevant database access is NOT listed in SQLMD.
What could be the reason?
Note: There are 3 correct answers to this question.
- A. Program X was executed in the background.
- B. SQL monitor was activated with a filter that excludes database table Y
- C. The data has NOT yet been transferred to the SQL monitor database tables
- D. SQL Monitor was activated for a specific application server
- E. Database table Y is a buffered table.
Answer: B,C,D
NEW QUESTION 72
What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster? There are 2 correct answers to this question
- A. High availability configuration
- B. Active clusters for all servers
- C. Services-Name and index server on all nodes
- D. Shared file systems for only one server
Answer: A,C
NEW QUESTION 73
What can you include in the projection list of a Core Data Services (CDS) view? 3 ans
- A. ABAP system fields such as sy-langu or sy-mandt \/ CI String constants and literal values
- B. Aggregation functions over fields of ABAP Dictionary tables used in the FROM clause
- C. A field from the projection list of another CDS view used in the FROM clause
- D. A field from the structural output of an ABAP Managed Database Procedure used in the FROM clause
Answer: B,C,D
NEW QUESTION 74
Which of the following information is mandatory in the definition of an association in a Core Data Services (CDS) view?
- A. The alias for the association
- B. The filter condition for the association
- C. The cardinality of the association
- D. The target entity of the association
Answer: D
NEW QUESTION 75
Open SQL largely standardized, three sub-languages. What are these sub-languages? There are 3 correct answers to this question
- A. The Data Definition Language (DDL)
- B. Data Evaluation Language(DEL)
- C. Data Manipulation Language (DML)
- D. Data Transferring Language(DTL)
- E. The Data Control Language (DCL)
Answer: A,C,E
NEW QUESTION 76
Which is better from performance point of view?
- A. SQLScript Procedure
- B. Modeling Views
Answer: B
NEW QUESTION 77
Why is not a key factor of ALV for HAN A? Please choose the correct answer.
- A. The data display is restricted to a maximum of 2 billion cell
- B. To activate and execute the program in the application
- C. To supply suitable values for any input parameters
- D. Derived column headings from the data element
Answer: B
NEW QUESTION 78
You have defined the following SQLScript procedure: CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL DATA.
Which type of database procedures can be called in this SQLScript procedure? Please choose the correct answer.
- A. Read only
- B. Read-write
- C. Read-update
- D. Write only
Answer: A
NEW QUESTION 79
......
SAP Certified Development Specialist - ABAP for SAP HANA 2.0 Free Update With 100% Exam Passing Guarantee: https://www.examcollectionpass.com/SAP/E_HANAAW_17-practice-exam-dumps.html