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 user to access modeling view
• C.Restrict users to access database tables

Comment: *

Name: *

Email: *

Verification: *

When would you use a column store table instead of a row store table? There are 2 correct answers to this question.

• A.When there are mainly distinct values in the table
• B.When you want to enable a full-text-search of the table
• C.When you require aggregation and analysis of values
• D.When the table has a small number of records

Comment: *

Name: *

Email: *

Verification: *

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.

Comment: *

Name: *

Email: *

Verification: *

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.Perform a static code check using the FUNCTIONAL_DB variant.
• B.Use the static method use_features of class cl_abap_dbfeatures.
• C.Check the value of the ABAP system field sy-cdsfeatures.
• D.Check the Open SQL statement in the Explain SQL Statement transaction (SDBE).

Comment: *

Name: *

Email: *

Verification: *

What are the steps that supported several tools, which in total result in a Guided Performance Optimization?
There are 2 correct answers to this question.

• A.The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption
• B.A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues.
• C.Tools analyzing performance at run-time, to determine if critical constructs
• D.A new tool called SQL Monitor to determine the priority if different programs access the database intensively

Comment: *

Name: *

Email: *

Verification: *