NEW 2021 Certification Sample Questions E-HANAAW-17 Dumps & Practice Exam
E-HANAAW-17 Deluxe Study Guide with Online Test Engine
SAP ABAP for HANA Certification Exam Details:
| Reference Books | HA400, HA300, HA100, BC404 |
| Exam Name | SAP Certified Development Specialist - ABAP for SAP HANA 2.0 |
| Exam Price | $550 (USD) |
| Exam Code | E_HANAAW_17 |
| Level | Associate |
| Passing Score | E_HANAAW_17 - 56% |
| Schedule Exam | SAP Training |
| Sample Questions | SAP ABAP for HANA Certification Sample Questions |
| Number of Questions | 40 |
| Duration | 90 mins |
NEW QUESTION 67
How will you hide the attributes that are not required for client consumption? Choose the correct answer
- A. By setting the hidden property flag of the attribute in the View
- B. By setting the hidden property flag of the attribute column
- C. By setting the hidden property flag of the attribute provider
- D. By setting the hidden property flag of the attribute in the Semantics screen
Answer: D
NEW QUESTION 68
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. Unit conversion
- B. Nested CASE expression
- C. CASTE Expression
- D. CASE expression
- E. Currency Conversion
Answer: A,D,E
NEW QUESTION 69
Which of the statements are true for SQLScript? (2 answers)
- A. SQLScript is used to push down data intensive logic into the database.
- B. SQLScript is a collection of extensions to SQL.
- C. SQLScript is an open standard.
Answer: A,B
NEW QUESTION 70
You plan a database migration to SAP HANA and want to check your ABAP coding for performance optimization potential.
Which Code Inspector check variant can you use?
- A. CHECK_PERFORMANCE
- B. FUNCTIONAL_DB
- C. PERFORMANCE_DB
- D. PERFORMANCE_OPT
Answer: C
NEW QUESTION 71
Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question.
- A. Perform all calculations and aggregations in the ABAP layer
- B. Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES
- C. Use array variants of INSERT UPDATE MODIFY and DELETE
- D. Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement
Answer: B,C
NEW QUESTION 72
What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question.
- A. A new and advanced Open SQL
- B. Buffer system services
- C. Core Data services
- D. Advanced and specific models
Answer: A,C
NEW QUESTION 73
You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SOJD). Which SELECT statement would you use in the definition? Please choose the correct answer.
- A. select from snwd_so {so_id( sum(net_amount) as sum_amount} group by net_amount
- B. select from snwd_so {so_id( sum(net_amount) as sum_amount} order by sojd
- C. select from snwd_so {so_id( sum(net_amount) as sum_amount} group by sojd
- D. select from snwd_so {sojd, sum(net_amount) as sum_amount}
Answer: C
NEW QUESTION 74
Explain the Authorization Concept and the types of privileges associated with it? There are 3 correct answers to this question
- A. Package privileges
- B. Object privileges
- C. Analytic privileges
- D. Application privileges
- E. System privileges
Answer: B,C,E
NEW QUESTION 75
Which is not a Golden Rule for Open SQL? Please choose the correct answer.
- A. Reduce the Database Load
- B. Minimize the Amount of Data Transferred
- C. Keep the result set large
- D. Minimize the Number of Database Accesses
Answer: C
NEW QUESTION 76
You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause? (3 right answers)
- A. ABAP Dictionary table used in the procedure body
- B. SAP HANA views used in the procedure body
- C. function used in the procedure body
- D. AMDP used in the procedure body
- E. ABAP Dictionary views used in the procedure body
Answer: A,D,E
NEW QUESTION 77
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
DE Berlin 13 - B. AT Vienna 26
DE Berlin 26 - C. AT Vienna 11
AT Vienna 15
DE Berlin 13
DE Berlin 13 - D. AT Vienna 11
AT Vienna 15
DE Berlin 13
Answer: A
NEW QUESTION 78
One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration. What should you search for and if necessary replace in the existing custom ABAP code? There are 3 correct answers to this question.
- A. ORDER BY Clauses in Open SQL statements
- B. Code that relies on implicit database sorting
- C. Direct access to a cluster on the database
- D. Left outer joins in open SQL statements
- E. Native SQL statements
Answer: B,C,E
NEW QUESTION 79
What are the features associated with ABAP CDS? There are 3 correct answers to this question.
- A. Export
- B. Create
- C. Read
- D. Distribution
- E. Update
Answer: B,C,E
NEW QUESTION 80
What is the main purpose of Analytic Privilege?
- A. Restrict users to access database tables
- B. Restrict row level access so that user will be able to see only certain portion of the data
- C. Restrict user to access modeling view
Answer: B
NEW QUESTION 81
What are the benefits includes with SAP HANA Full Text Search? There are 2 correct answers to this question
- A. Easy to use modeling tool
- B. Large number of toolkits are available
- C. Fewer data duplication and movement
- D. Exploit structured contents in SQL
Answer: A,C
NEW QUESTION 82
Which code-to-data capability is responsible for the Optimizations & Translation of "Open SQL SELECT FOR ALL ENTRIES clauses into native SQL?. Please choose the correct answer.
- A. HANA Specific features
- B. Database Optimization
- C. Buffer system Optimization
- D. Transparent Optimizations
Answer: D
NEW QUESTION 83
Which system schema contains the list of Activated and inactive Objects?
- A. Maintain, Monitor and test secondary database connection
- B. Maintain only HANA specific objects
- C. Used to access local or remote database system
- D. Use Schema for the Connections
Answer: A,C
NEW QUESTION 84
Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in the Classical ABAP workbench?
There are 3 correct answers to this question.
- A. Core Data service (CDS) view
- B. Full-text index
- C. External view
- D. ABAP program containing new Open SQL
- E. Database procedure proxy
Answer: A,C,E
NEW QUESTION 85
Explain the Enterprise Information System of- SAP HANA Implementation Scenarios? There are 3 correct answers to this question
- A. All HANA Combinations on one platform
- B. All SAP applications on one SAP HANA platform
- C. Business Suite on HANA/ BW on SAP HANA
- D. HANA Modeling
- E. HANAAccelerators
Answer: B,C,E
NEW QUESTION 86
What are the types of schemas in HANA? (3 correct)
- A. System Defined Schema
- B. User Defined Schema
- C. Dynamic Schema
- D. SLT Derived Schema
Answer: A,B,D
NEW QUESTION 87
Analytic Privilege can be applied to (3 Answers)
- A. Calculation views
- B. Table
- C. SQL View
- D. Attribute views
- E. Analytic views
Answer: A,D,E
NEW QUESTION 88
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 a client tool, which can be used to access local or remote HANA system.
- 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 integrated in SAP GUI > 7.40
Answer: A,B,C
NEW QUESTION 89
What are the benefits of using the SQL Monitor (transaction SQLM)? There are 2 correct answers to this question.
- A. It displays the database execution plan for all SQL statements.
- B. It schedules ABAP programs to monitor and log all database accesses.
- C. It collects monitoring data asynchronously without additional database interaction.
- D. It can be active in a production system with minimal performance overhead.
Answer: C,D
NEW QUESTION 90
What is the operating system supported by HANA? (2 correct answers)
- A. Both Linux and Window 8
- B. Only Windows 8
- C. SUSE Linux Enterprise Server
- D. Red Hat Enterprise Linux (RHEL)
Answer: C,D
NEW QUESTION 91
......
E-HANAAW-17 dumps review - Professional Quiz Study Materials: https://www.dumpsactual.com/E-HANAAW-17-actualtests-dumps.html
