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. The objects on which other users have privileges are dropped. The objects on which other users have privileges are NOT dropped The objects owned by other users are NOT dropped. The objects owned by other users are dropped. .
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. Template SAP HANA database version Namespace Project Name .
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 (DOUBLE CHECK) SAP Web IDE for SAP HANA SAP HANA Studio SAP HANA Repository GIT Repository .
You create an SAP HANA extended application services, advanced model (XS advanced) multi-target application. What does the mta.xml file contain? Please choose the correct answer. You create an SAP HANA extended application services, advanced model (XS advanced) multi-target application. What does the mta.xml file contain? Please choose the correct answer. The application global elements, modules, resources, properties, and parameters The application router description with the authentication methods and access routes. The plugin name and version for every supported file suffix .
Which OData service do you use to prevent changes to existing line items of the sap.test :myTable table? Please choose the correct answer. service { "sap.test::myTable" update no-authorization; } service { "sap.test::myTable" update forbidden; ) service { "sap.test:myTable" update prohibited; ) service { "sap.test:myTable" update exclude;).
Which SAP HANA system views contain information about the object ownership? There are 2 correct answers to this question. OBJECTS ROLES SCHEMAS TABLES.
Which Git command do you use to consolidate all changes from one branch with another branch using a single commit? Please choose the correct answer. Merge Commit Rebase Push.
How do you specify the target currency for currency conversion in calculation views? There are 3 correct answers to this question. In a table function With a fixed value With an input parameter In a column In a procedure.
What are some of the advantages of SQLScript compared to plain SQL Queries It increases performance by parallel execution of complex SQL statements It retrieves a high data volume from a database It enables modular parameterized programming It contains a well-defined ANSI standard.
What do you use to set up unit testing for your SQL Script procedure? Please choose the correct answer. SQL Script logging procedures A library with language SQLSCRIPT TEST The SQL Script debugger The SQL Script Code Analyzer.
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. The HDI container is created when the design-time object is saved. descriptive representation of the object is created in Hot during runtime. The corresponding runtime object is created in the database module of the multitarget application during runtime. The corresponding runtime object is created in the HDI container on deployment.
Why do you use associations in your persistence model for SAP HANA extended application services, advanced model (XS advanced)? Please choose the correct answer. To define multiplicity and key of an entity relation To set relationships between multiple contexts To enforce database-level constraints To define the relationships between contexts and views.
Which OData capacity do you use when you need to restrict the number or selection of exposed columns? Please choose the correct answer. Key Specification Property Projection Parameter Entity Sets Aggregation.
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. Index Association Storage Type Import.
In application development with XS advanced, which of the following entities belong to a specific SPACE? There are 2 correct answers to this question. Users Organizations Applications Processes.
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. Subfolder mixinTypes name hdbtable.
You need to initially load data from a .csv file into a Core Data Services table in SAP HANA extended application services, advanced model (XS advanced). Which file type do you create?
Please choose the correct answer.
A file with extension .hdbtable A file with extension .hdbti A file with extension .hdbtable data A file with extension .hdbdd.
Which join type is NOT supported by join optimization (pruning)? Please choose the correct answer. Inner Join Outer Join Referential Join Text Join.
You define exception handling in a SQL Script procedure. What can you use declare exit handlers for? There are 2 correct answers to this question. Specific SQL conditions Generic SQL Exceptions Generic SQL conditions Specific SQL Error codes.
What are the disadvantages when deploying Dynamic SQL? There are 2 correct answers to this question Limited opportunities for optimization Additional SQL execution privileges are required No possibility to bind the result to a SQL Script Variable No possibility to use SQL Script variables.
Which of the following SQL Script elements do you use to transform a set of arrays into an intermediate table variable? Please choose the correct answer. UNSET UNNEST ARRAY SET.
You need to create a native SAP HANA application that fully leverages the SAP HANA platform. How do you implement data-intensive calculations? Please choose the correct answer. Push the calculations onto the database layer Distribute calculations between application layer and presentation layer Push the calculations onto the presentation layer Push the calculations onto the application layer.
Which elements can you specify with the SAP Web IDE for SAP HANA graphical editor for Core Data Services data models? There are 3 correct answers to this question. Synonym Association Procedure Context Entity.
You need to synchronize all unsynchronized changes of the remote Git branch with a local Git branch. Which operation do you use? Please choose the correct answer. Rebase Reset Pull Push.
What are the characteristics of SAP HANA calculation views? There are 2 correct answers to this question. Do NOT need an application server to execute Need database tables to execute Do NOT need database tables to execute Need an application server to execute.
Which of the following joins can be defined only with multi-column join in calculation views? Please choose the correct answer. Dynamic Join Multi Join Text Join Temporal Join.
What statement must you insert to the following OData service to complete the navigation definition from the customer entity set to the corresponding sales orders? Please choose the correct answer.
service{ "sample.odata::customer" as customer” navigates ("Customer_Orders- as "toOrders); "'sample.odata::salesorder"” as "Orders"))
Aggregation Key specification Join condition Association.
You developed a multi-target application that contains only a database module. Which environment are the runtime objects created in? Please choose the correct answer. Java Runtime Environment (JRE) SAP HANA Runtime Tools (HRTT) HANA Deployment Infrastructure Container SAP Web IDE for SAP HANA.
You create a multi-target application in SAP Web IDE for SAP HANA. Which source code management option do you use? Please choose the correct answer. SAP HANA Repository Workspace SAP HANA Repository SVC-based Repository Git-based Repository.
What are the main SAP HANA engines responsible for executing calculation views? There are 3 correct answers to this question. OLAP Engine Join Engine XS Engine Java Engine Calculation Engine.
You use APPLY_FILTER to add a dynamic WHERE clause on SELECT statements. On which objects can you apply the filter? There are 2 correct answers to this question. Scalar Variables Database tables Virtual tables Intermediate table variables.
How do you debug a Node.js module in SAP Web IDE for SAP HANA? Please choose the correct answer. Add the sap.hana .xs.debugger::Debugger role to the HDI Container's #RT User. Attach the debugger to the application in the SAP Web IDE for SAP HANA. Start the debugger from the XS command line interface and run the program in SAP Web IDE for SAP HANA. Set the enabled parameter to true in the section debugger of the xsengine.ini file.
Which parameter do you adapt to change the file that is initially delivered by an HTMLS5 module? Please choose the correct answer. Welcome file parameter of the xs-app.json file Runners parameter of the project json file Service_url parameter of the mta.xml file Start parameter of the package.json file.
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. $format $service definition $metadata $schema.
Which tool do you use to create a calculation view in a multi-target application? SAP HANA Web-based Development Workbench SAP Web IDE for SAP HANA SAP HANA database explorer SAP HANA studio.
Who owns the database objects created in an SAP HANA Deployment Infrastructure (HDI) container? Please choose the correct answer. The database user with the generated database role, suffix ";;:access_role' The generated, container-specific technical user The database user with the generated database role, suffix .external_privileges_role' The SAP HANA extended application services, advanced model (XS advanced) user who deployed the CDS model.
After reviewing the SQL Analyzer results, which of the following would you consider for optimizing the performance? There are 2 correct answers to this question Use CE functions Re-prioritize with Workload Management Modify SQL hints Change the data model.
Which of the ff. are characteristics of SAPUI5? Supports customer-specific theming Renders the Ul on the server side Enables responsive application design Provides an extensibility concept Provides a device-specific user experience.
You implement an asynchronous Node.js service that sends requests to the database. How do you handle the database responses? Register a callback method for every sent request Call a method directly after every send request Process the callback methods in the order in which the requests are sent by the servisse Process the callback methods in the order in which the requests are returned by the database.
You configure an OData service for a transactional SAPUIS5 application. What is the default data access behaviour of the OData service? Please choose the correct answer. Read: Yes Create: No Update: Yes Delete: No Read: Yes Create: No Update: No Delete: No Read: Yes Create: Yes Update: Yes Delete: No Read: Yes Create: Yes Update: Yes Delete: Yes.
In Node.js, which file do you use to define external module dependencies? Please choose the correct answer. package.json server.js pom.xml mta.yaml.
Which services can you use in SAP HANA, express edition? There are 3 correct answers to this question Dynamic Tiering System Replication Text Analytics Multi-core and parallelization Columner OLTP and OLAP.
What characterizes the Node.js environment?
Note: There are 2 correct answers to this question.
It is built on Google's V8 JavaScript engine. It is a client-side design-time environment for JavaScript. It uses a synchronous programming model. It is single-threaded.
You develop a Node.js application for the SAP HANA platform that executes a SQL statement in the SAP HANA database.
Which modules do you use?
Note: There are 2 correct answers to this question.
@sap/xsenv @sap/instance-manager @sap/node-vsi @sap/hdbext.
You are asked to produce sales value for the month using sales order line items (sales price per item x quantity sold) what do you use to achieve this in a calculated column of a calculation view?
There are 2 correct answers to this question.
Transparent Filter Non-Equijoin Keep Flag Dynamic Join.
What do you reference in a role template? Please choose the correct answer Role Routes Role collections Scopes.
What are the nodes where filter expressions can be used in a calculation view? There are 2 correct answers to this question. Union STAR Join Aggregation Rank.
Which Git commands are available with the SAP Web IDE for SAP HANA? There are 3 correct answers to this question. Merge changes Clone a repositor Push code Test changes Redeploy the code.
To perform a specific task of an XS advanced application, what does a user need? Please choose the correct answer. To have directly assigned a Role Collection To be assigned to a Space To have directly assigned a Scope To be assigned to an Organization.
To which SAP HANA authorisation entities can you grant a role? User Privilege Object Role.
What is the package descriptor package.json used for? There are 2 correct answers to this question To set the router version To define the routes To define back-end destinations To list the package dependencies.
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. Imports Procedures Views Synonyms.
Your multi-target application will use XSJS. Which module type do you create in your application project? Please choose the correct answer. HTML5 Node.js Java SAP HANA Database.
You work on a multi-target application that uses the SAP HANA Deployment Infrastructure (HDI). Which operations can you perform in the SAP Web IDE for SAP HANA?
There are 2 correct answers to this question.
Choose the supported SAP HANA versions Configure the artifact namespaces Create objects in the SAP HANA repositor Deploy HTMLS5 modules to the SAP HANA database.
Which application runtimes are currently supported by the SAP Cloud Application Programming Model? There are 2 correct answers to this question. Go Python Java Node.js.
Which of the following activities are part of the development lifecycle using SAP HANA extended application services, advanced model (XS advanced)? There are 2 correct answers to this question. Export the project as an MTA archive Create an MTA Project Activate artifacts via _SYS_REPO Store the source in the SAP HANA Repository.
What are the key characteristics of the calculation view's Input Parameter? There are 3 correct answers to this question. It can be used to pass values to table functions. It is passed using a WHERE clause. It can be used in a conditional expression. It is passed via reserved word PLACEHOLDER. It can NOT be used to filter measure values.
You need to check user input data in your OData request. Which exit type do you use? Please choose the correct answer Modification Validation Verification Consistency.
You need to manage an exception in a SQLScript.
Which SQLScript features can you use?
Note: There are 2 correct answers to this question.
DEFINE RESIGNAL CREATE EXIT HANDLER SIGNAL DECLARE EXIT HANDLER.
Which parameter do you adapt to change the file that functions as an entry point for an HTML5 module? /Products/$metadata /Products /Products/ALL /Products/’.
Which parameter do you adapt to change the file that functions as an entry point for an HTML5 module? Start parameter of the package.json file WelcomeFile parameter of the xs-app.json file Runners parameter of the project.json file Service_url parameter of the mta.yaml.
You need to view the data model exposed by an OData V2 service. What must you append to the service URL? $metadata $format $schema $servicedefinition.
Which new components can you use to develop native SAP HANA applications in SAP HANA extended application services, advanced model (XSA application)?
Note: There are 2 correct answers to this question. Git repositor SAP HANA repositor SAP Web IDE for SAP HANA SAP HANA studio.
Who owns the database objects created in an SAP HANA Deployment Infrastructure (HDI) container? The database user with the generated database role, suffix I::access_rolel The database user with the generated database role, suffix I::external_privileges_rolel The generated, container-specific technical user The SAP HANA extended application services, advanced model (XSA application) user who deployed the CDS model.
What are the different types of graphical calculation views that can handle measures?
Note: There are 2 correct answers to this question.
Attribute Cube with star Join SQL Access Only Cube.
Which configuration file determines the program that is executed upon startup when you run the Node.js module? server.js project.json mta.yaml package.json.
In which of the following objects can you use Commit and Rollback statements? Scripted calculation view Scalar user-defined function SQLScript procedure Table user-defined function.
What is the package.json package descriptor used for?
Note: There are 2 correct answers to this question.
To define the routes To list the package dependencies To set the application router version To define back-end destinations.
Which of the following joins can be defined only with multi-column join in calculation views? Multi Join Temporal Join Dynamic Join Text Join.
What are the main SAP HANA engines responsible for executing calculation views? Note: There are 3 correct answers to this question. OLAP engine Join engine XS engine Java engine Calculation engine.
Which OData capability do you use when you need to restrict the number or selection of exposed columns? Key specification Property projection Aggregation Parameter entity sets.
What do you use to set up unit testing for your SQLScript procedure? SQLScript logging procedures The SQLScript debugger The SQLScript Code Analyzer Alibrary with language SQLSCRIPT TEST.
Which services can you use in SAP HANA, express edition? Note: There are 3 correct answers to this question. System replication Multi-core and parallelization Columnar OLTP and OLAP Dynamic tiering Text analytics.
What are the disadvantages when deploying dynamic SQL? Note: There are 2 correct answers to this question. Additional SQL execution privileges are required No possibility to use SQLScript variables No possibility to bind the result to a SQLScript Variable Limited opportunities for optimization.
Which rules apply to declarative logic in SQLScript? Note: There are 2 correct answers to this question. It is free of side effects. It supports the full set of SQLScript. It defines how data is processed. It declares the intent of a request.
You implement a native SAP HANA application using SAP HANA extended application services, advanced model (XSA application) and SAPUI5. Where is the Ul rendering executed? On the SAP Fiori front-end server On the XSA application server On the XSA application router On the front-end client device.
What characterizes the Node.js environment?
There are 2 correct answers to this question.
It is a client-side design-time environment for JavaScript. It is built on Google's V8 JavaScript engine. It uses a synchronous programming model. It is single-threaded.
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?
There are 3 correct answers to this question.
Create a view that refers to the table. Create a synonym for the remote table object. Create a synonym that refers to the view. Create/update the .hdbgrants file providing authorizations for the remote schema. Create a view that refers to a synonym.
Which of the following are characteristics of SAPUI5?
There are 3 correct answers to this question.
Provides an extensibility concept Supports customer-specific theming Enables responsive application design Renders the Ul on the server side Provides a device-specific user experience.
You implement an asynchronous Node.js service that sends requests to the database. How do you handle the database responses?
There are 2 correct answers to this question.
Process the callback methods in the order in which the requests are sent by the service. Call a method directly after every send request. Process the callback methods in the order in which the requests are returned from the database. Register a callback method for every sent request.
What are some of the advantages of SQLScript compared to plain SQL queries?
There are 2 correct answers to this question.
It contains a well-defined ANSI standard. It enables modular parameterized programing. It retrieves a high data volume from a database. It increases performance by parallel execution of complex SQL statements.
You develop a Node.js application for the SAP HANA platform that executes a SQL statement in the SAP HANA database. Which modules do you use?
There are 2 correct answers to this question.
@sap/instance-manager @sap/node-vsi @sap/xsenv @sap/hdbext.
To which SAP HANA authorization entities can you grant a role?
There are 2 correct answers to this question.
User Role Privilege Object.
You develop an OData service using XSODATA. Which HTTP commands can you use to define the operations on the resources?
There are 3 correct answers to this question.
READ GET PUT INSERT POST.
You need to manage an exception in a SQLScript. Which SQLScript features can you use?
There are 2 correct answers to this question.
DEFINE RESIGNAL CREATE EXIT HANDLER SIGNAL DECLARE EXIT HANDLER.
Which tool do you use to create a calculation view in a multi-target application?
Please choose the correct answer.
SAP Web IDE for SAP HANA SAP HANA studio SAP HANA Web-based Development Workbench SAP HANA database explorer.
How do you specify the target currency for currency conversion in Calculation Views? (3 Correct) In a procedure With an input parameter In a column In a table function With a fixed value.
During the delta merge process, to which memory areas is data inserted? (2 Correct) Main 2 Main 1 Delta 1 Delta 2.
What do you need in a Multitenant Database Container (MDC) system to run queries across tenant databases? (2 Correct) The bidirectional communication channel must be whitelisted. The user in the source system must have sufficient privileges in the target database. The cross-tenant database communication must be explicitly activated. The user in the source system must be associated with a user in the target database.
Your multi-target application shall use XSJS. Which module type do you create in your application project? Java Node.js SAP HANA database HTML5.
Which of the following are characteristics of SAPUI5? (3 Correct) Renders the Ul on the server side Provides an extensibility concept Enables responsive application design Provides a device-specific user experience Supports customer-specific theming.
Which of the following SQLScript elements do you use to transform a set of arrays into an intermediate table variable? ARRAY SET UNSET UNNEST.
Which is the relationship between the user group operators and the user groups? (2 Correct) Multiple user groups per user group operator Only one user group operator per user group Only one user group per user group operator Multiple user group operators per user group.
How can you perform a complete back up of an SAP HANA database system? Backup the complete storage system. Back up the system database and all tenant databases individually. Back up the system database and all tenant databases in one step. Back up the complete database system.
Which preparation steps do you need to perform before replaying a captured workload using the SAP HA NA capture and replay tool? (3 Correct) Restore the source system tenant backup to the target tenant. Store the logon credentials of the replayer user in the secure store. Create a replayer user account on the target operating system. Create a replayer user account in the target database system. Preprocess the captured workload on the source system.
What is the first node limit for planning an SAP S/4HANA scale-out system? (2 Correct) >=6TB >=8TB >=12CPU >=8CPU.
You need to access a remote database table object within your HDB module in an MTA project. In SAP HANA extended application services, advanced model (XSA) a user-provided service was created to access the external schema. The service is already declared in the MTA project YAML file. Which activities do you perform? (3 Correct) Create a view that refers to the table Create a view that refers to a synonym Create a synonym that refers to the view Create a synonym for the remote table object Create/update the .hdbgrants file providing authorizations for the remote schema.
What are the key characteristics of the Calculation View's Input Parameter? (3 Correct) It is passed using a WHERE clause It can be used to pass values to table functions It is passed via reserved word PLACEHOLDER It can be used in a conditional expression. It cannot be used to filter measure values.
Which tools do you use to delete diagnosis files? (2 Correct) SAP HANA cleaner SAP HANA Web-based Development Workbench SAP HANA cockpit SAP HANA database explorer.
In an SQLScript procedure, which feature do you use to initialize IN/OUT table parameters? IS_EMPTY DEFAULT DEFAULT EMPTY SET.
Which OData capacities are supported in SAP HANA extended application services, advanced model (XSA)? (3 Correct) Union Aggregation Join Association Projection.
You developed a multi-target application that contains only a database module. Which environment are the runtime objects created in? SAP Web IDE for SAP HANA SAP HANA Runtime Tools (HRTT) Java Runtime Environment (JRE) HANA Deployment Infrastructure Container.
You define exception handling in a SQLScript procedure. What can you use declare exit handlers for? (2 Correct) Generic SQL conditions Specific SQL error codes Specific SQL conditions Generic SQL exceptions.
Which parameters does the APPLY_FILTER function support? (2 Correct) Join condition Entity set Table Variable Filter condition.
|
