[Dec 15, 2023] Free SAP C_HANADEV_18 Exam Questions and Answer
Verified C_HANADEV_18 dumps Q&As Latest C_HANADEV_18 Download
NEW QUESTION # 32
An OData service contains an entity set called Products. Which resource path do you add to the OData service URL to view all available products?
Please choose the correct answer.
- A. /Products/$metadata
- B. /Products/'
- C. /Products
- D. /Products/ALL
Answer: C
NEW QUESTION # 33
You are working on an entity using Core Data Services. Which properties can you define inside the Technical Configuration section? There are 2 correct answers to this question.
- A. Association
- B. Index
- C. Import
- D. Storage Type
Answer: B,D
NEW QUESTION # 34
In which of the following objects can you use Commit and Rollback statements? Please choose the correct answer.
- A. SQL Script procedure
- B. Scalar user-defined function
- C. Table user-defined function
- D. Scripted calculation view
Answer: A
NEW QUESTION # 35
Which of the following are characteristics of SAPUI5? There are 3 correct answers to this question.
- A. Enables responsive application design
- B. Provides an extensibility concept
- C. Supports customer-specific theming
- D. Renders the UI on the server side
- E. Provides a device-specific user experience
Answer: A,B,C
NEW QUESTION # 36
You need to install SAP HANA 2.0, express edition to develop a native SAP HANA application. Which of the following deployment options do you have?
There are 2 correct answers to this question.
- A. Installation on Linux OS
- B. Usage of virtual machine on Microsoft Windows
- C. Installation on Windows Server
- D. Installation on Mac OS
Answer: A,B
NEW QUESTION # 37
In application development with XS advanced, which of the following entities belong to a specific SPACE? There are 2 correct answers to this question.
- A. Processes
- B. Applications
- C. Organizations
- D. Users
Answer: A,C
NEW QUESTION # 38
You need to combine data from different database tables within your OData service. Which capability do you use for this relationship? Please choose the correct answer.
- A. Associations
- B. Aggregations
- C. Projections
- D. Entity sets
Answer: A
NEW QUESTION # 39
Which of the following information must you specify when you create a new project in SAP Web IDE for SAP HANA? There are 2 correct answers to this question.
- A. Project name
- B. SAP HANA database version
- C. Namespace
- D. Template
Answer: A,C
NEW QUESTION # 40
In an SQL Script procedure, which feature do you use to initialize IN/OUT table parameters? Please choose the correct answer.
- A. IS_EMPTY
- B. SET
- C. DEFAULT EMPTY
- D. DEFAULT
Answer: C
NEW QUESTION # 41
What are the characteristics of SAP HANA calculation views? There are 2 correct answers to this question.
- A. Need an application server to execute
- B. Need database tables to execute
- C. Do NOT need an application server to execute
- D. Do NOT need database tables to execute
Answer: B,C
NEW QUESTION # 42
Which of the following are characteristics of database procedures?
- A. Database procedures can have several output parameters, and a mix of both scalar and table types is possible.
- B. If, in the database procedure header, you use the SQL SECURITY INVOKER option, then only the owner of the procedure can start it.
- C. If, in the database procedure header, you use the READS SQL DATA option, then INSERT statements are prohibited; however, dynamic SQL is allowed.
- D. Database procedures can have both input and output parameters; however, a parameter CANNOT be both input and output.
Answer: A
NEW QUESTION # 43
What are the disadvantages when deploying Dynamic SQL? There are 2 correct answers to this question.
- A. Limited opportunities for optimization
- B. No possibility to use SQL Script variables
- C. No possibility to bind the result to a SQL Script variable
- D. Additional SQL execution privileges are required
Answer: A,C
NEW QUESTION # 44
What happens if you define a database object in the persistence model and deploying using the SAP HANA Deployment Infrastructure (HDI)?
Please choose the correct answer.
- A. The corresponding runtime object is created in the HDI container on deployment
- B. The HDI container is created when the design-time object is saved.
- C. The corresponding runtime object is created in the database module of the multi-target application during runtime.
- D. A descriptive representation of the object is created in Hot during runtime.
Answer: B
NEW QUESTION # 45
What is the package descriptor package.json used for? There are 2 correct answers to this question.
- A. To define the routes
- B. To set the router version
- C. To list the package dependencies
- D. To define back-end destinations
Answer: B,C
NEW QUESTION # 46
What are the issue categories that SQL Script Code Analyser scans for? There are 3 correct answers to this question.
- A. Performance
- B. Consistency
- C. Business logic
- D. Privileges
- E. Security
Answer: A,B,E
NEW QUESTION # 47
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 schem a. The service is already declared in the Multi-target application project YAML file.
Which activities do you perform?
- A. Create a synonym for the remote table object.
- B. Create/update the .hdbgrants file providing authorizations for the remote schema.
- C. There are 3 correct answers to this question.
- D. Create a view that refers to a synonym. n Create a synonym that refers to the view.
- E. Create a view that refers to the table.
Answer: A,B,C
NEW QUESTION # 48
Which keywords do you use to define an OData association? There are 3 correct answers to this question.
- A. UNION
- B. DEPENDENT
- C. JOIN
- D. MULTIPLICITY
- E. PRINCIPAL
Answer: B,D,E
NEW QUESTION # 49
What are the characteristics of the calculation view of type "SQL Access Only"? There are 2 correct answers to this question.
- A. Can be directly exposed to all client tools
- B. Can be directly used as modelled data source for another view
- C. Can be direct y accessed via SQL
- D. Can be directly used for multidimensional analysis
Answer: B,C
NEW QUESTION # 50
What are the nodes where filter expressions can be used in a calculation view? There are 2 correct answers to this question.
- A. Union
- B. Star join
- C. Aggregation
- D. Rank
Answer: B,C
NEW QUESTION # 51
You created several database tables in a multi-target application and need to keep their names as short as possible. Which parameter of the .hdinamespace file do you set to ignore? Please choose the correct answer.
- A. mixinTypes
- B. subfolder
- C. hdbtable
- D. name
Answer: B
NEW QUESTION # 52
You need to view the data model exposed by an OData V2 service. What must you append to the service URL? Please choose the correct answer.
- A. $metadata
- B. $schema
- C. $format
- D. $service definition
Answer: A
NEW QUESTION # 53
Which OData capacity do you use when you need to restrict the number or selection of exposed columns? Please choose the correct answer.
- A. Property projection
- B. Key specification
- C. Aggregation
- D. Parameter entity sets
Answer: A
NEW QUESTION # 54
Which Git commands are available with the SAP Web IDE for SAP HANA? There are 3 correct answers to this question.
- A. Clone a repository
- B. Redeploy the code
- C. Merge changes
- D. Push code
- E. Test changes
Answer: A,C,D
NEW QUESTION # 55
......
Use Real Dumps - 100% Free C_HANADEV_18 Exam Dumps: https://testking.realvce.com/C_HANADEV_18-VCE-file.html