SAP C_HANADEV_18 Exam With Confidence Using Practice Dumps

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.

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

The SAP Web IDE for SAP HANA graphical editor for Core Data Services (CDS) data models allows you to specify the following elements12:

• Entity: An entity is a CDS artifact that defines a data structure with attributes, keys, and associations. An entity can be mapped to a database table or view, or it can be used as a source for another entity or a calculation view. You can create an entity by dragging the entity icon from the palette to the canvas, and then defining its properties and attributes in the properties panel.
• Context: A context is a CDS artifact that defines a namespace for other CDS artifacts, such as entities, views, types, or associations. A context can be used to organize and group related CDS artifacts, and to avoid name conflicts. You can create a context by dragging the context icon from the palette to the canvas, and then defining its name and description in the properties panel. You can also add other CDS artifacts to the context by dragging them from the project explorer or the palette to the context node in the canvas.
• Association: An association is a CDS artifact that defines a relationship between two entities, based on a join condition. An association can be used to navigate from one entity to another, and to filter, aggregate, or project data from the target entity. You can create an association by dragging the association icon from the palette to the canvas, and then connecting it to the source and target entities. You can also define the cardinality, join condition, and exposed attributes of the association in the properties panel.

The other options are not correct because they are not elements that can be specified with the SAP Web IDE for SAP HANA graphical editor for CDS data models. A synonym is a database object that provides an alternative name for another database object, such as a table, view, or procedure. A synonym is not a CDS artifact, and it cannot be created or edited with the graphical editor. A procedure is a database object that contains a set of SQL statements that perform a specific task. A procedure can be created or edited with the SQL editor, but not with the graphical editor. A procedure can also be exposed as a CDS artifact, but it cannot be specified with the graphical editor. References:

• SAP HANA Platform, SAP HANA Modeling Guide for SAP HANA Web Workbench, Core Data Services
• SAP HANA Platform, SAP HANA Developer Guide for SAP HANA Web IDE, Developing Core Data Services Models, Using the Graphical Editor