What are the issue categories that SQL Script Code Analyser scans for? There are 3 correct answers to this question.
Correct Answer: A,C,E
The SQL Script Code Analyser is a tool that scans SQL Script code for potential issues and provides suggestions for improvement. The tool can be accessed from the SAP Web IDE for SAP HANA or from the SAP HANA database explorer. The tool scans for issues in the following categories:
* Performance: This category covers issues that may affect the execution time or resource consumption of the SQL Script code, such as inefficient joins, missing indexes, unnecessary data transfers, etc. The tool provides recommendations for optimizing the code, such as using parallel processing, avoiding nested loops, using table variables, etc.
* Security: This category covers issues that may expose the SQL Script code to security risks, such as SQL injection, privilege escalation, data leakage, etc. The tool provides recommendations for securing the code, such as using parameterized queries, escaping literals, applying proper authorization checks, etc.
* Consistency: This category covers issues that may affect the readability, maintainability, or portability of the SQL Script code, such as coding style, naming conventions, documentation, compatibility, etc.
* The tool provides recommendations for improving the code quality, such as using consistent indentation, avoiding hard-coded values, adding comments, following best practices, etc.
The other options are incorrect because privileges and business logic are not issue categories that the SQL Script Code Analyser scans for. Privileges are handled by the SAP HANA Deployment Infrastructure framework, which automatically grants the necessary privileges to the technical users and roles that access the HDI container objects. Business logic is the domain-specific logic that defines the functionality and behavior of the SQL Script code, and it is not within the scope of the tool to verify or validate it. References:
* SQL Script Code Analyzer - SAP Help Portal
* SQL Script Code Analyzer in SAP Web IDE for SAP HANA - SAP Help Portal
* SQL Script Code Analyzer in SAP HANA Database Explorer - SAP Help Portal
* HA150 - SAP HANA 2.0 SPS06 SQLScript for SAP HANA - SAP Training