QUESTION: 141
Where are Extended Tables stored? Please choose the correct answer.
A. They are cached in the SAP HANA in-memory RAM.
B. They are physically located in a special SAP HANA schema in a memory data columnar storage.
C. They are temporarily located in a compressed disk-based data columnar storage.
D. They are physically located in a compressed disk-based data columnar storage.
Answer: D
QUESTION: 142
You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP HANA is used as the database. 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 lower value than on a traditional, row-store only based database
B. The same value as on a traditional, row-store only based database
C. A value that you calculate based on the number of tables
D. A higher value than on a traditional, row-store only based database
Answer: A
QUESTION: 143
What should you do to follow the code-to-data approach to programming? Note: There are 2 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. Aggregate data on the database, and transfer the results to the ABAP layer.
D. Perform expensive calculations on the ABAP application server.
Answer: A, C
QUESTION: 144
What are functions of the ABAP Managed Database Procedure (AMDP) framework? Note: There are 2 correct answers to this question.
A. It deletes obsolete versions of the database procedure asynchronously
B. It creates the database procedure when the AMDP is first called.
C. It creates the database procedure when the AMDP is first activated.
D. It deletes obsolete versions of the database procedure synchronously.
Answer: A, B
QUESTION: 145
What information can you specify using annotations (marked with the @ sign) when you define a Core Data Services (CDS) view in an ABAP system? Note: There are 3 correct answers to this question.
A. The logic for aggregations, grouping records, and filtering groups of the CDS view
B. The join conditions of the CDS view
C. The name of the representation of the CDS view in the ABAP dictionary
D. The client dependency of the CDS view
E. The extent to which records of the CDS view should be buffered on the application server
Answer: C, D, E
QUESTION: 146
You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter? Please choose the correct answer.
A. {it_books}
B. :it_books
C. @it_books
D. it_books
Answer: C
QUESTION: 147
Where in the SAP HANA studio can you change the path of the backup folder? Note: There are 2 correct answers to this question.
A. global.ini
B. Backup catalog
C. Backup editor
D. executor.ini
Answer: A, C
QUESTION: 148
You are reviewing the execution plan of an SQL statement. You want to find out which operators have been executed in parallel in the current plan and for how long each of them has been active. How can you accomplish this? Please choose the correct answer.
A. Use the Plan Visualizer in the SAP HANA studio.
B. Use Performance Trace in HDB admin.
C. Use Job Progress in the SAP HANA studio.
D. Use EXPLAIN (graphically) in the DBA Cockpit.
Answer: A
QUESTION: 149
You have SAP HANA and ABAP content that is exclusively used by ABAP for SAP HANA. You want to transport this content together. Which of the following options can you use for this transport? Note: There are 2 correct answers to this question.
A. SAP HANA Application Lifecycle Manager (SAP HALM)
B. SAP HANA Transport Container (SAP HTC)
C. Enhanced Change and Transport System (CTS+)
D. Export and Import of the Delivery Unit (DU)
Answer: B, C
QUESTION: 150
Which of the following can you use to analyze an expensive SQL statement? Note: There are 2 correct answers to this question.
A. The plan explanation
B. The performance trace view
C. The hdbcons tool
D. The plan visualizer
Answer: A, D
No comments:
Post a Comment