Upon build, the CDS entity triggers the generation of a database view with the corresponding name and structure.
TRUE FALSE.
In the SAP Web IDE for SAP HANA, you want to use Core Data Services to define the persistency layer. Which extension do you use for the design time file?
.hdbtable .hdbddl
hdbcds.
Which of the following statements are true about SAP HANA Express Edition? (3 Correct)
It can only run on certified hardware.
It is packed with essential SAP HANA features, yet utilizes a smaller footprint.
It is free to use up to 32 GB memory use, and expandable to 128 GB for a fee.
It can be used in production scenarios.
.
What is the SAP Fiori Master-Detail template?
A demo application, part of SHINE (SAP HANA Interactive Education)
A guideline document that explains the best practice to create a Fiori compliant Master-Detail application
A wizard that generates a UI5 Master-Detail application based on an existing OData service
A Master-Detail application, used to generate a documentation template for your application
.
What is OData?
A software tool
A protocol
An SAP design guideline
A document format.
How can you access the schema WALLDORF of HDI container WALLDORF?
By using the credentials of user WALLDORF#OO.
By assigning your user the role WALLDORF::access_role.
By creating a service binding to the deploy service and using the generated credentials.
By creating a service key and using the generated WALLDORF_..._DT user.
.
You are setting up security for an HTML application. Where do you link an HTML page with the role needed to visualize it?
In the scope definition.
In a route definition.
In the authentication method definition.
In the role definition.
.
What do you use calculation views for?
To read data in real time for analytical reporting.
To code using the R programming language.
To resolve complex mathematical equations.
To provision data from remote sources.
.
Which keywords are used in an XSODATA association definition? (2 Correct)
Join Key
Principal
Dependent
.
In SAP HANA, you create a stored procedure. What can you set in the header properties? (3 Correct)
Global variables
Security
Read/write access
Programming language
Storage type
.
Which checks are executed when you run the Hardware Configuration Check Tool (HWCCT)? (3 Correct)
Measurement of data throughput between the Linux kernel and CPU
Validation of the LPAR configuration settings on IBM Power servers
Measurement of data throughput between the Linux kernel and CPU
Measurement of the data throughput between SAP HANA nodes and storage
Validation of the operating system configuration settings for the Linux kernel
.
Which file extension do you use for the definition file for an OData service?
.odata
.xsodata
.data
.
In the SAP Web IDE for SAP HANA, when you create a new SAP HANA database module, what is added to the mta.yaml file? (2 Correct)
A module of type HDB
A service of type com.sap.xs.hdi-container
A route to the SAP HANA database
A service of type OData
.
Which features are provided by the Manage Full System Information Dumps app in SAP HANA cockpit? (2 Correct)
Diagnosis information
End-to-end Trace
SAP HANA minichecks
Runtime environment
.
What is Node.js?
It is a scripting language specialized in the execution of data intensive calculations.
It is a server-side runtime environment for JavaScript. It is a client-side JavaScript library, providing components to design the user interface.
.
Marta creates an HDI container PORTEMONNAIE and deploys it in space COAT_POCKET. Which user owns the created schema PORTEMONNAIE?
Portemonnaie, which was created during deployment.
Marta, because she deployed the container.
Marta, because she created the container.
Portemonnaie#OO, which was created during the deployment.
.
Compared to standard SQL, which of the following are the advantages of SQLScript? (3 Correct)
It returns a single set.
It enables complex logic to be broken up into smaller chunks of code that enables modular programming, reuse, and a better understanding by functional abstraction.
It has control logic, such as if/else.
One can make use of table variables structure complex SQL statements.
.
Waldemar creates a plain database schema and grants Constanze the CREATE ANY privilege on that schema. Who can access the table DUMMY which Constanze creates in Waldemars schema? (2 Correct)
Every user owning an object in Waldemars schema
Every user having theCREATE ANY privilege
Waldemar, because he own the schema Constanze, because she owns the table
.
Which file contains route definitions?
security.json
package.json
mta.yaml
xs-app.json
.
What can you directly assign to a user with the Manage Users app in SAP HANA cockpit? (2 Correct)
Role collections
Scopes
Privileges
Roles
.
Which properties can you adjust in SAP HANA Admission Control? (3 Correct)
Maximum request queue size
SQL statement request memory limit
CPU threshold for rejecting requests
Maximum parallel 10 requests
Memory limit for queuing requests
.
What is the origin of the name “Multi-target Application”?
It is an application targeting multiple user profiles.
It is an application made of modules that can be reused across applications.
It is an application made of multiple modules running in different runtime environments.
It is an application made to run on multiple front-end devices.
.
In the SAP Web IDE for SAP HANA, what features are provided in the SQLScript debugger pane? (3 Correct)
Runtime code change
Runtime analysis
Console
Expressions
Watchpoints.
What is Git?
A tool for static code analysis
A tool for tracking changes in source code during software development
A tool for web-based team code collaboration
A tool for automated code testing
.
In your HTML page, you want to have a placeholder replaced at runtime with the actual URL of the back-end application. Which design time files do you modify to obtain this? (2 Correct)
security.json
package.json
mta.yaml
xs-app.json
.
Which tasks can you perform using the SAP HANA database lifecycle manager (HDBLCM) on installation media? (2 Correct)
Update SAP HANA and its components.
Extract components.
Uninstall SAP HANA database components.
Rename the SAP HANA database system.
.
What is OpenUI5?
A guideline for an optimal user experience
A platform providing free video courses
An extensibility framework for UI5
An open-source project
.
Which preparation tasks do you need to perform before starting the Database Migration Option (DMO) procedure? (2 Correct)
Update the SAP Host Agent to the latest version
Extract the SAP HANA database software installation archive.
Check if the latest SPAM/SAINT update is applied.
Move the latest R3trans update archive into the download folder.
.
Which part of a full-stack application is defined within the HTML5 module? (2 Correct)
The HTTP services
The user interface
The router configuration
The security role templates
.
Which information source is based on YouTube videos?
SAP HANA Interactive Education
SAP Help Portal
SAP HANA Academy
openSAP.
You are creating the index.html file of an UI5 application. What does the bootstrap contain?
The primary UI anchor The libraries to be loaded
The initial construction of the application
.
Eva creates an HDI container Franntz. It only contains a view with the statement SELECT BRICKS FROM MILANO.DUOMO. Why does the deployment fail?
EVA is not the object owner of MILANO.DUOMO.
Schema references are not allowed in HDI containers.
Tables need to be consumed via calculation views.
Franntz#OO wasn't granted privileges on MILANO.DUOMO.
.
What are the two features of the storage engine in the SAP HANA index server that enable data consistency and maintain durable changes?
Metadata Manager and Transaction Manager
Session Management and log Volumes
Page Management and logger
Column Store and Row Store
.
How can you assign the authorizations needed to perform specific tasks executing XS Advanced applications?
You can directly assign the necessary permissions to the user.
You can add the necessary roles to a role collection and then assign this role collection to the user.
You can directly assign the necessary roles to the user.
You can add the necessary permissions to a role collection and then assign this role collection to the user.
.
You are programming using the SAP Cloud Application Programming Model. You need to define an OData service. Which is the extension of the file you create?
cds xsodata hdbcds odata.
CDS associations define:
Distribution of entity data across multiple database tables.
Relationships between columns of the same entity.
Relationships between entities.
.
You are developing the persistency layer for a multi-target application. You want to create a database view that reads data from a table in a remote SAP HANA schema. What do you need to use?
An OData service
A remote desktop connection
A user-defined service
A schema synonym
.
Who is the Object Owner in SAP HANA?
The administrator of the HDI Container group
The technical user _SYS_REPO
The creator of the schema containing the object
The user who created the object
.
Which resources do you find in XS Advanced spaces? (3 Correct)
Application domains
Services
Memory
Application routes
.
What do you have to consider when you perform a Tailored Data Center Integration (TDI) installation for a productive SAP HANA database system? (2 Correct)
Obtaining the hardware certification from SAP for the existing hardware you are going to use.
Obtaining C_HANATEC_XX Certification.
Having 10 GBit/s for storage zone and 1 GBit/s for internal zone for network connectivity.
Having the data and log volumes on the different disks.
.
In SAP HANA, the debugger needs to be attached to a Node.js module before it stops at any breakpoint. TRUE
FALSE
.
|
