100% Pass Top-selling C-HANADEV-18 Exams – New 2024 SAP Pratice Exam [Q15-Q31]

You can use Commit and Rollback statements in SQL Script procedures to control the transactional behavior of your code. Commit and Rollback statements allow you to commit or undo the changes made by the SQL statements within the procedure. You can also use them in exception handlers to handle errors and ensure data consistency. You cannot use Commit and Rollback statements in scalar user-defined functions, table user-defined functions, or scripted calculation views, as they are not allowed to have any side effects on the database. References: COMMIT and ROLLBACK, SQLScript Procedures, [SQLScript Functions].

The SAP HANA XS Advanced Cockpit is a web-based administration tool that allows you to manage the XS Advanced runtime environment, such as organizations, spaces, applications, services, and users. The XS Advanced Cockpit provides a graphical user interface that is similar to the SAP Cloud Platform Cockpit, to provide a consistent user experience in cloud and on-premise. The XS Advanced Cockpit is available for SAP HANA 2.0 SPS03 and later releases, and it replaces the deprecated XS Advanced Administration Tools.
One of the activities that you can perform on an application in the XS Advanced Cockpit is to monitor the applications assigned to the current space. A space is a logical grouping of applications and services that share a common development and runtime environment. Each space belongs to an organization, which is a collection of users and spaces that share a common quota of resources. You can use the XS Advanced Cockpit to view the list of applications deployed in a particular space, and see their status, instances, memory usage, disk usage, and bound services. You can also filter, sort, and search the applications by name, status, or type.
You can also drill down into the details of each application, such as logs, events, environment variables, routes, and service bindings.
Another activity that you can perform on an application in the XS Advanced Cockpit is to start, stop, and restart the applications. You can use the XS Advanced Cockpit to control the lifecycle of the applications deployed in a space, such as starting an application that is stopped, stopping an application that is running, or restarting an application that is experiencing issues. You can also scale the applications by changing the number of instances or the memory and disk quota allocated to each instance. You can also delete the applications that are no longer needed.
The other options are incorrect because they are not activities that you can perform on an application in the XS Advanced Cockpit. You cannot deploy applications to SAP Cloud Platform from the XS Advanced Cockpit, as the XS Advanced Cockpit is only for managing the XS Advanced runtime environment on SAP HANA. To deploy applications to SAP Cloud Platform, you need to use the SAP Cloud Platform Cockpit or the Cloud Foundry Command Line Interface (CF CLI). You also cannot display the HDI container content from the XS Advanced Cockpit, as the HDI container is a database object that is not directly related to the application. To display the HDI container content, you need to use the SAP HANA Database Explorer or the SAP Web IDE for SAP HANA. References:
* SAP HANA Platform 2.0 SPS06: SAP HANA XS Advanced Cockpit, Section 1
* SAP HANA Platform 2.0 SPS06: SAP HANA XS Advanced Cockpit, Section 2
* SAP HANA Platform 2.0 SPS06: SAP HANA XS Advanced Cockpit, Section 3
* SAP HANA Platform 2.0 SPS06: SAP HANA XS Advanced Cockpit, Section 4
* SAP HANA Platform 2.0 SPS06: SAP HANA XS Advanced Cockpit, Section 5

To produce sales value for the month using sales order line items (sales price per item x quantity sold), you can use a calculated column of a calculation view that performs the multiplication of the two columns and applies a transparent filter and a non-equijoin to restrict the data to the desired month. A transparent filter is a filter condition that is applied to the data source of a view node and is propagated to the subsequent nodes. A non-equijoin is a join condition that uses operators other than equality, such as greater than, less than, or between. For example, you can use a transparent filter to filter the sales order line items by the month of the order date, and then use a non-equijoin to join the sales order line items with the sales price table by the order date and the valid from and valid to dates of the sales price. References: Transparent Filters, Non-Equijoins, Create Calculated Columns.

According to the SAP HANA Developer Guide, declarative logic in SQL Script is a way of expressing complex data transformations by means of classical relational operators, such as selection, projection, join, aggregation, etc. Declarative logic does not specify how data is processed, but rather what the desired result is.
The SAP HANA database has the freedom to optimize the data flow and execution plan, which may result in better performance. Declarative logic is free of side effects, meaning that it does not modify any data or state outside the scope of the statement. Declarative logic declares the flow of data, meaning that it binds new variables that are referenced elsewhere in the body of the procedure or function. The other options are incorrect, because:
* Declarative logic does not support the full set of SQL Script, but only a subset of SQL features that are side-effect free and deterministic. For example, declarative logic does not support imperative constructs, such as loops, conditions, exceptions, etc.
* Declarative logic does not define how data is processed, but rather what the desired result is. How data is processed is determined by the SAP HANA database optimizer, which may choose different execution plans depending on the data characteristics, system resources, and other factors.
References: SAP HANA Developer Guide, Chapter 6, Section 6.4.2, page 2111.

When you create a multi-target application in SAP Web IDE for SAP HANA, you use a Git-based repository as the source code management option. A Git-based repository allows you to store, manage, and synchronize your code across multiple branches and versions. You can also collaborate with other developers and integrate your changes with the SAP HANA Deployment Infrastructure (HDI). A Git-based repository is the recommended option for developing multi-target applications in SAP Web IDE for SAP HANA. References: Developing Multi-Target Applications, Git Integration, SAP HANA Deployment Infrastructure.

Filter expressions can be used in a calculation view to restrict or modify the data that is displayed or processed by the view. Filter expressions can be used in the following nodes of a calculation view12:
* Aggregation: An aggregation node is a node that applies aggregation functions, such as sum, count, or average, to the data that is passed from the previous node. Filter expressions can be used in an aggregation node to filter the data before or after the aggregation, or to define the aggregation level or the measure attributes. For example, you can use a filter expression to show only the sales data for a specific region or product category, or to calculate the average revenue per customer.
* Union: A union node is a node that combines the data from two or more nodes that have the same structure and data types. Filter expressions can be used in a union node to filter the data from each input node, or to filter the data from the output node. For example, you can use a filter expression to exclude the duplicate rows from the union result, or to show only the data that matches a certain condition from each input node.
The other options are not correct because filter expressions cannot be used in these nodes of a calculation view. A star join node is a node that joins a fact table with one or more dimension tables, based on the common key attributes. A star join node does not support filter expressions, but it supports input parameters, which are variables that can be used to filter the data at runtime. A rank node is a node that ranks the data according to a specified order and criteria. A rank node does not support filter expressions, but it supports rank filters, which are conditions that can be used to limit the number or percentage of rows in the rank result.
References:
* SAP HANA Platform, SAP HANA Modeling Guide for SAP HANA Web Workbench, Calculation Views
* SAP HANA Platform, SAP HANA Developer Guide for SAP HANA Web IDE, Developing Database Modules, Developing Calculation Views, Using Filter Expressions