Which metadata declarations can you specify in a SQL Script procedure when you use the SAP HANA Deployment Infrastructure? There are 2 correct answers to this question.
Correct Answer: B,C
Question 62
From which tool can you run the XS command line? Please choose the correct answer.
Correct Answer: C
Question 63
Which artifacts do you define in the persistence model to access objects in an external SAP HANA Deployment Infrastructure container? Please choose the correct answer.
Correct Answer: D
Question 64
Which new components can you use to develop native SAP HANA applications in SAP HANA extended application services, advanced model (XS advanced)? There are 2 correct answers to this question.
Correct Answer: C,D
SAP HANA extended application services, advanced model (XS advanced) provides a comprehensive platform for the development and execution of micro-service oriented applications, taking advantage of SAP HANA's in-memory architecture and parallel execution capabilities1. XS advanced supports several programming languages and execution environments, such as Java and Node.js, and also provides compatibility with XS classic model2. To develop native SAP HANA applications in XS advanced, you can use the following new components: * Git repository: XS advanced integrates with Git, a distributed version control system, to manage the source code of your applications. You can use Git to clone, create, push, pull, merge, and branch your projects, and also to collaborate with other developers3. * SAP Web IDE for SAP HANA: XS advanced provides a web-based integrated development environment (IDE) that allows you to create, edit, test, debug, and deploy your applications. SAP Web IDE for SAP HANA supports various development tools and features, such as editors, wizards, templates, code completion, syntax highlighting, code analysis, debugging, testing, and deployment3. The other options are not correct because: * SAP HANA repository: This is a component of XS classic model, not XS advanced. The SAP HANA repository stores the design-time artifacts of your applications, such as views, procedures, and scripts. In XS advanced, the design-time artifacts are stored in Git repositories instead4. * SAP HANA studio: This is a desktop-based IDE that can be used to develop applications for XS classic model, but not for XS advanced. SAP HANA studio provides various perspectives and tools to access and manage the SAP HANA database, such as the administration console, the catalog, the content, and the security4. References: 2: SAP HANA Extended Application Services, Advanced Model 4: SAP HANA Extended Application Services 1: SAP HANA extended application services, advanced model 3: SAP HANA Developer Guide for SAP HANA XS Advanced Model (SAP Web IDE)
Question 65
You need to access a remote database table object within your HDB module in a Multi-target application project. In SAP HANA extended application services, advanced model (XS advanced) a user-provided service was created to access the external schema. The service is already declared in the Multi-target application project YAML file. Which activities do you perform?
Correct Answer: C,D,E
To access a remote database table object within your HDB module in a Multi-target application project, you need to perform the following activities: * Create/update the .hdbgrants file providing authorizations for the remote schema. This file defines the privileges that are granted to the HDI container technical users for accessing the remote schema. You need to specify the user-provided service name, the schema name, and the privileges, such as SELECT, INSERT, UPDATE, DELETE, EXECUTE, etc. You can also use the wildcard character (*) to grant privileges on all objects in the remote schema. * Create a synonym for the remote table object. A synonym is a database object that provides an alternative name for another database object, such as a table, view, or procedure. You can use synonyms to simplify the access to remote objects by avoiding the need to specify the full qualified name. You can create a synonym in your HDB module by using the .hdbsynonym file, where you specify the target object name, the target object schema, and the user-provided service name. * Create a view that refers to the table. A view is a database object that defines a logical table based on the result set of a SQL query. You can use views to access data from one or more tables, including remote tables, by applying filters, joins, aggregations, calculations, etc. You can create a view in your HDB module by using the .hdbview file, where you specify the SQL query that references the synonym of the remote table object. The other options are incorrect because you do not need to create a view that refers to a synonym, nor create a synonym that refers to a view. These are redundant steps that do not add any value to the access of the remote table object. References: * Accessing Remote Data - SAP Help Portal * Granting Privileges on Remote Schemas - SAP Help Portal * Creating Synonyms - SAP Help Portal * Creating Views - SAP Help Portal
