SAP Updated C_HANADEV_18 Exam Questions and Answers by aleksandra

 The database objects created in an SAP HANA Deployment Infrastructure (HDI) container are owned by a generated, container-specific technical user. This user is created automatically when the HDI container is created and has a name that starts with ‘#DI_’ followed by a random string. This user has full access to the objects in the HDI container and can grant privileges to other users or roles. The other options are incorrect because the XS advanced user who deployed the CDS model, the database user with the access role, and the database user with the external privileges role are not the owners of the database objects in the HDI container, but rather have different levels of access to them depending on the privileges granted by the HDI container owner or administrator. References:

• SAP HDI Containers - SAP Help Portal
• The SAP HANA Deployment Infrastructure - SAP Press
• HDI Container Administration on HANA Cloud - SAP Blogs

The SAP Web IDE for SAP HANA is a web-based development tool that allows you to create and manage multi-target applications (MTAs) that use the SAP HANA Deployment Infrastructure (HDI). The SAP Web IDE for SAP HANA is itself an XS advanced application that runs on the XS advanced runtime and can be accessed via a URL. To retrieve the URL for the SAP Web IDE for SAP HANA, you can use the following XS advanced tools:

• XS advanced Controller Start Screen: This is a web-based tool that provides an overview of the XS advanced environment and the available applications and services. You can access the XS advanced Controller Start Screen by opening the URL https://:330/ in a browser, where is the host name of your SAP HANA system and is the instance number of your SAP HANA system. From the XS advanced Controller Start Screen, you can see the list of applications and their URLs under the Applications tab. You can find the SAP Web IDE for SAP HANA application by its name (webide) and click on its URL to open it in a new tab.
• XS Advanced command-line client tool: This is a command-line tool that allows you to perform various operations on the XS advanced environment and the applications and services. You can access the XS Advanced command-line client tool by opening a terminal and entering the command xs. To retrieve the URL for the SAP Web IDE for SAP HANA, you need to first log in to the XS advanced environment by entering the command xs login and providing your credentials. Then, you need to switch to the SAP space by entering the command xs target -s SAP, where the SAP Web IDE for SAP HANA application is deployed. Finally, you need to list the applications and their URLs by entering the command xs apps. You can find the SAP Web IDE for SAP HANA application by its name (webide) and copy its URL to open it in a browser.

The following tools are not used to retrieve the URL for the SAP Web IDE for SAP HANA, but for other purposes:

• Runtime tool: This is a web-based tool that allows you to monitor and manage the runtime components of the XS advanced environment, such as applications, services, processes, and logs. You can access the Runtime tool by opening the URL https://:332/ in a browser, where is the host name of your SAP HANA system and is the instance number of your SAP HANA system. From the Runtime tool, you can see the status and details of the applications and services, but not their URLs.
• Organization and Space Management tool: This is a web-based tool that allows you to create and manage the organizational units of the XS advanced environment, such as organizations and spaces. You can access the Organization and Space Management tool by opening the URL https://:331/ in a browser, where is the host name of your SAP HANA system and is the instance number of your SAP HANA system. From the Organization and Space Management tool, you can see the list of organizations and spaces and their quotas and roles, but not the applications and their URLs.

References:

• [SAP HANA Deployment Infrastructure Reference], Chapter 5: HDI with XS Advanced, Section 5.1: Developing with the SAP Web IDE for SAP HANA, Subsection 5.1.1: Create a Project, p. 101.
• [SAP HANA Platform Documentation], SAP HANA Developer Guide for SAP HANA XS Advanced Model, Chapter 2: Getting Started with SAP Web IDE for SAP HANA, Section 2.1: Creating a Project, p. 17.

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.

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.