[Jul-2021] Pass SAP E-HANAAW-17 Exam in First Attempt Guaranteed!
Full E-HANAAW-17 Practice Test and 176 unique questions with explanations waiting just for you, get it now!
NEW QUESTION 40
An Analytic Privilege consists of several restrictions. What are they? There 3 correct answers to this question
- A. Activity restrictions
- B. Analytic restrictions
- C. Cube restrictions
- D. Validity restrictions
- E. View restrictions
Answer: A,C,D
NEW QUESTION 41
Which SQL syntax is used to create a read only procedure?
- A. READS SQL DATA
- B. READS PROCEDURE
- C. NO-SIDE-EFFECT
- D. READ-ONLY
Answer: A
NEW QUESTION 42
Which system schema contains the list of Activated and inactive Objects?
- A. _SYS_BI
- B. _SYS_REPO
- C. _SYS_BIC
- D. _SYS_XS
Answer: B
NEW QUESTION 43
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. Data Transferred Language
- C. The Database Language
- D. The Data Definition Language
- E. The Data Control Language
Answer: A,D,E
NEW QUESTION 44
What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? There are 2 correct answers to this question.
- A. All fields in the GROUP BY clause must be separated by commas.
- B. All Keywords are case sensitive.
- C. All arithmetic expressions can be used for all type of variables
- D. All ABAP variables must be escaped with a proceeding @ sign.
Answer: A,D
NEW QUESTION 45
Before migrating to SAP HANA, which Code Inspector check do you have to consider to avoid functional regressions?
- A. Use of the ADBC interface
- B. Standard Web Dynpro checks
- C. Search for DB operations across modularization units
- D. SELECT statements that bypass the table buffer
Answer: A
NEW QUESTION 46
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 provider
- B. By setting the hidden property flag of the attribute in the View
- C. By setting the hidden property flag of the attribute in the Semantics screen
- D. By setting the hidden property flag of the attribute column
Answer: C
NEW QUESTION 47
Which recent software innovations are applied in SAP HANA? 3 ans
- A. Automated de-installation at system shutdown
- B. Improved data compression algorithms
- C. Random Undefined Multi-Memory Swapping (RUMMS)
- D. Columnar data storage
- E. Insert Only approach
Answer: B,D,E
NEW QUESTION 48
You want to implement business logic on the database layer.
Which approach do you follow when implementing an ABAP Managed Database Procedure?
- A. The Near-Far approach
- B. The Left-Right approach
- C. The Top-Down approach
- D. The Inside-Out approach
Answer: C
NEW QUESTION 49
Which of the following objects can you use in the ABAP layer when using the top-down approach to bring code to data? There are 2 correct answers to this question
- A. ABAP managed database procedures
- B. Stored procedure
- C. Core data services views
- D. Calculation views
Answer: A,C
NEW QUESTION 50
Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? There are 3 correct answers to this question.
- A. ABAP test cockpit (transaction ATC)
- B. Data base performance monitor (transaction DB50)
- C. Code inspector (transaction SCI)
- D. SQL monitor (transaction SQLM)
- E. SQL Trace (transaction ST05)
Answer: A,C,D
NEW QUESTION 51
What is the main purpose of Analytic Privilege?
- A. Restrict row level access so that user will be able to see only certain portion of the data
- B. Restrict users to access database tables
- C. Restrict user to access modeling view
Answer: A
NEW QUESTION 52
What is the full form of HANA?
- A. High-Performance Analytic Accelerator
- B. High-Performance Analytic Application
- C. High-Performance Analytic Appliance
- D. High Accelerator Numeric Analytics
Answer: C
NEW QUESTION 53
How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement?
Please choose the correct answer.
- A. As many result sets as there are input parameters in the procedure
- B. As many result sets as there are table output parameters in the procedure
- C. Two result sets
- D. One result set
Answer: D
NEW QUESTION 54
What are the two different kinds of Identifiers used to represent names used in SQL statement? There are 2 correct answers to this question
- A. Limited identifiers
- B. Numeric identifiers
- C. Delimited identifiers
- D. Undelimited Identifiers
Answer: C,D
NEW QUESTION 55
Analytic Privilege can be applied to (3 Answers)
- A. Table
- B. Analytic views
- C. Calculation views
- D. SQL View
- E. Attribute views
Answer: B,C,E
NEW QUESTION 56
Which functional problem can you detect when using the Runtime Check Monitor (SRTCM )?
- A. Use of Native SQL and DB Hints
- B. Direct access to table pools/cluster
- C. Missing ORDER BY or SORT after SELECT
- D. Existence check for secondary indexes
Answer: C
NEW QUESTION 57
How can you consume a Core Data Services (CDS) view? 2 ans
- A. Use the CDS maintenance transaction (SCDSV).
- B. Use it as a data source in the FROM clause of an Open SQL query.
- C. Use the Data Preview in ABAP Development Tools for SAP NetWeaver.
- D. Use the ABAP language statement WRITE and the CDS view name as the argument.
Answer: B,C
NEW QUESTION 58
Which statement is true for SAP HANA?
- A. SAP has partnered with major hardware providers like HP, FUJITSU, CISCO, IBM, HITACHI etc. SAP only provides SAP HANA software which can run on the hardware provided by these partners
- B. SAP provides both hardware and software for SAP HANA.
Answer: A
NEW QUESTION 59
What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question.
- A. Perform expensive calculations on the database.
- B. Transfer all data from the database to the ABAP layer, and then aggregate the results.
- C. Use native SQL to access SAP HANA built-in functions.
- D. Aggregate data on the database, and transfer the results to the ABAP layer.
- E. Perform expensive calculations on the ABAP application server.
Answer: A,C,D
NEW QUESTION 60
AM DP can detect 3 types of syntax errors in active or inactive source code. What are these errors ? There are 3 correct answers to this question.
- A. HANA specific syntax errors
- B. Database independent syntax errors
- C. Database platform syntax errors
- D. SQLScript errors
- E. UNION specific syntax errors
Answer: A,B,D
NEW QUESTION 61
What are the features associated with ABAP CDS? There are 3 correct answers to this question.
- A. Distribution
- B. Export
- C. Read
- D. Create
- E. Update
Answer: C,D,E
NEW QUESTION 62
What is the system privilege required to drop analytic privilege?
- A. CREATE PRIVILEGE
- B. STRUCTUREDPRIVILEGE ADMIN
- C. CREATE STRUCTURED PRIVILEGE
- D. PRIVILEGE ADMIN
Answer: B
NEW QUESTION 63
What are the Perspectives and Views of SAP HANA Studio? There are 2 correct answers to this question.
- A. Administration console
- B. Open system properties
- C. Development properties
- D. System Properties
Answer: A,B
NEW QUESTION 64
Which tasks does the ABAP managed database (AMDP) framework perform? There are 2 correct answers to this question.
- A. Delete the obsolete versions of the database procedure asynchronously
- B. Delete the obsolete versions of the database procedure synchronously
- C. Create a new version of the database when the AMDP is first called
- D. Create a new version of the database when the AMDP is first activated
Answer: A,C
NEW QUESTION 65
......
Get Latest E-HANAAW-17 Dumps Exam Questions in here: https://www.braindumpspass.com/SAP/E-HANAAW-17-practice-exam-dumps.html
