You are working on an entity using Core Data Services.
Which properties can you define inside the Technical Configuration section? Note: There are 2 correct answers to this question.
- A . Import
- B . Storage Type
- C . Index
- D . Association
You need to view the data model exposed by an OData V2 service .
What must you append to the service URL?
- A . $servicedefinition
- B . $schema
- C . $metadata
- D . $format
Which tool can you use to perform an in-place upgrade of SAP HANA 2.0, express edition?
- A . SAP Software Download Center
- B . SAP Cloud Appliance Library
- C . Download Manager
- D . SAP HANA Lifecycle Management
Which of the following activities are part of the development lifecycle using SAP HANA extended application services, advanced model (XS advanced)? Note: There are 3 correct answers to this question.
- A . Synchronize source with GIT repository
- B . Store source in SAP HANA repository
- C . Activate artifacts via _SYS_REPO
- D . Create an MTA project
- E . Export project as MTA archive
Which GIT command do you use to consolidate all changes from one branch with another branch using a single commit?
- A . Commit
- B . Push
- C . Rebase
- D . Merge
You need to restrict the selected columns exposed to the client .
Which OData capability do you use?
- A . Parameter entity sets
- B . Key specification
- C . Aggregation
- D . Property projection
What are the main SAP HANA engines responsible for executing calculation views? There are 3 correct answers to this question.
- A . XSEngine
- B . Join Engine
- C . OLAP Engine
- D . Java Engine
- E . Calculation Engine
Which are the artifacts that are contained in an SAP HANA Deployment Infrastructure (HDI) container? Note: There are 2 correct answers to this question.
- A . JavaScript programs
- B . Data services
- C . SQL Script procedures
- D . Table definitions
A user is dropped with the "cascade" option. The user schema also contains objects owned by other users, or on which other users have privileges.
What happens to the objects? There are 2 correct answers to this question.
- A . The objects owned by other users are NOT dropped.
- B . The objects owned by other users are dropped.
- C . The objects on which other users have privileges are dropped.
- D . The objects on which other users have privileges are NOT dropped.
You create triggers using the SQL Console. Where are the triggers stored?
- A . Repository
- B . Application server
- C . Package
- D . Catalog
Which parameters does the APPLY_FILTER function support? There are 2 correct answers to this question.
- A . Entity set
- B . Join condition
- C . Table variable
- D . Filter condition
Which functionality is provided by SAP web IDE for SAP HANA? Note: There are 2 correct answers to this question.
- A . Syntax-aware editors for code
- B . Organization and space management
- C . Build and deploy applications
- D . User management
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 used for multidimensional analysis
- B . Can be direct y accessed via SQL
- C . Can be directly exposed to all client tools
- D . Can be directly used as modeled data source for another view
Which content can you include in a Node.js module of the multi-target application? Note:
There are 3 correct answers to this question.
- A . Data services in Java
- B . Node apps
- C . XSJS apps
- D . Java apps
- E . OData services in JavaScript
What are some of the benefits of developing applications on SAP HANA? Note: There are 2 correct answers to this question.
- A . Execution of stored procedures is faster due to the in-memory database.
- B . Reliable segregation of OLAP and OLTP workloads on different SAP HANA databases.
- C . Faster response times by using SAP HANA integrated UI rendering.
- D . HTML5-compliant Web-based user interface is supported.
Which services can you use in SAP HANA 2.0, express edition? Note: There are 3 correct answers to this question.
- A . Text analytics
- B . Dynamic tiering
- C . System replication
- D . Columnar OLTP and OLAP
- E . Multi-core and parallelization
Which of the following are characteristics of an SAP HANA Deployment Infrastructure container? Note: There are 3 correct answers to this question.
- A . It is the same as a tenant database.
- B . It is logically similar to an SAP HANA schema.
- C . It contains table and view objects.
- D . It performs version management of runtime artifacts.
- E . It is created by a container-specific technical user.
Which programming paradigms are supported by SQL Script? Note: There are 2 correct answers to this question.
- A . Symbolic
- B . Declarative
- C . Logic
- D . Imperative
What happens if you define a database object in the persistence model and deploy it using the SAP HANA Deployment Infrastructure (HDI)?
- A . The corresponding runtime object is created in the database module of the multi-target application during runtime.
- B . The corresponding runtime object is created in the HDI container on deployment.
- C . A descriptive representation of the object is created in HDI during runtime.
- D . The HDI container is created when the design-time object is saved.
For what do you use the RESIGNAL statement in SQLScript?
- A . System exceptions
- B . Specific SQL error codes
- C . Generic SQL exceptions
- D . User-defined exceptions
Which parameter do you adapt to change the file that is initially delivered by an HTML5 module? Please choose the correct answer.
- A . Service_url parameter of the mta.xml file
- B . Start parameter of the package.json file
- C . Runners parameter of the projectjson file
- D . Welcome file parameter of the xs-app.json file
You use APPLY_FILTER to add a dynamic WHERE clause on SELECT statements.
On which objects can you apply the filter? Note: There are 2 correct answers to this question.
- A . Database tables
- B . Intermediate table variables
- C . Virtual tables
- D . Scalar variables
Which metadata declarations can you specify in an SQL Script procedure when you use the SAP HANA Deployment Infrastructure? Note: There are 2 correct answers to this question.
- A . Authorization
- B . Default schema
- C . Security
- D . Language
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?
- A . subfolder
- B . mixinTypes
- C . hdbtable
- D . name
What do you use to set up unit testing for your SQL Script procedure? Please choose the correct answer.
- A . A library with language SQLSCRIPTTEST
- B . The SQL Script debugger
- C . SQL Script logging procedures
- D . The SQL Script Code Analyzer
How do you specify the target currency for currency conversion in calculation views? There are 3 correct answers to this question.
- A . With an input parameter
- B . With a fixed value
- C . In a column
- D . In a procedure
- E . In a table function
Who owns the database objects created in an SAP HANA Deployment Infrastructure container?
- A . The generated, container-specific technical user
- B . The database user with the generated database role, suffix ‘;;external_privileges_role’
- C . The SAP HANA extended application services, advanced model (XS advanced)user who deployed the CDS model
- D . The database user with the generated database role, suffix ‘;;access_role!
You implement a native SAP HANA application using SAP HANA extended application services, advanced mode (XS advanced) and SAPUI5.
Where is the UI rendering executed?
- A . On the XSadvanced application server
- B . On the SAPUI5 HTML5 module
- C . On the front-end client device
- D . On the SAP Fiori front-end server
To which SAP HANA authorization entities can you grant a role? There are 2 correct answers to this question.
- A . Role
- B . Privilege
- C . Object
- D . User
Your multi-target application will use XSJS .
Which module type do you create in your application project? Please choose the correct answer.
- A . SAP HANA database
- B . HTML5
- C . Java
- D . Node.js
You need to check user input data in your OData request .
Which exit type do you use?
- A . Consistency
- B . Modification
- C . Verification
- D . Validation
You develop native SAP HANA applications in SAP HANA extended application services, advanced model (XS advanced).
What are some of the advantages compared to developing in SAP HANA extended application services, classic model (XS classic)? Note: There are 3 correct answers to this question.
- A . No additional SAP HANA components are required.
- B . It supports different runtime containers.
- C . The source code repository is built into the SAP HANA database.
- D . Advanced GIT/GERRIT source code management is available.
- E . The application layer can be separate from the database.
You need to manage an exception in a SQL Script.
Which SQL Script features can you use? Note: There are 2 correct answers to this question.
- A . CREATE EXIT HANDLER
- B . DECLARE EXIT HANDLER
- C . SIGNAL
- D . DEFINE RESIGNAL
Where do you add controls to the user interface?
- A . JSON model
- B . OData model
- C . XML view
- D . Manifest file
You create an SAP HANA extended application services, advanced model (XS advanced) multi-target application using the SAP Web IDE for SAP HANA.
Which files can be generated automatically by the wizard when you create the SAP HANA database (HDB)
module? Note: There are 2 correct answers to this question.
- A . hdiconfig
- B . package.json
- C . hdinamespace
- D . server.js
Which of the following activities are part of the development lifecycle using SAP HANA extended application services, advanced model (XS advanced)? Note: There are 2 correct answers to this question.
- A . Export the project as an MTA archive.
- B . Store the source in the SAP HANA repository.
- C . Create an MTA project.
- D . Activate artifacts via _SYS_REPO.
You create a multi-target application in SAP Web IDE for SAP HANA .
Which source code management option do you use?
- A . SVC-based repository
- B . SAP HANA repository
- C . GIT-based repository
- D . SAP HANA repository workspace
Your team develops an application using SAP Web IDE for SAP HANA .
How can you share the application source code with other team users?
- A . Share the project in the application project settings.
- B . Assign a shared workspace to users in XS Advanced Administration.
- C . Store the source code in a shared Git repository.
- D . Store the project in a shared package within the SAP HANA repository.
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 . Security
- D . Business logic
- E . Privileges
Which SAP HANA system views contain information about the object ownership? There are 2 correct answers to this question.
- A . ROLES
- B . TABLES
- C . SCHEMAS
- D . OBJECTS