Which of the following SQLScript features allows for the creation of reusable code segments in SAP HANA? Triggers Procedures Libraries Views.
In SQLScript, which command is used to define a table that will store temporary results? DEFINE TABLE CREATE TEMPORARY TABLE DECLARE TABLE SET TABLE.
Scenario: You are developing a complex calculation view and need to break down the logic into smaller, reusable pieces. Which SQLScript feature should you use? Table functions Scalar functions Triggers Procedures Libraries.
Which tool in SAP HANA allows developers to create, debug, and deploy multi-target applications? SAP HANA Studio SAP Web IDE SAP HANA Cockpit SAP HANA Database Explorer.
Scenario: Your team is developing a multi-target application in SAP HANA. You need to integrate a Node.js module to handle server-side logic. Which of the following steps are essential for this integration? Create a Node.js module Execute the Node.js module Debug the Node.js application Access the database from Node.js Deploy the Node.js application to the cloud.
In a Multi-Target Application, what is the primary purpose of the XSA application Command-Line client? To provide a graphical interface for app development To manage database tables and views To execute SQL queries and scripts To manage and deploy application components.
Which of the following is NOT a feature of OData in SAP HANA? OData key specification OData navigation properties OData triggers Custom exits in OData.
Scenario: You are tasked with creating an OData service that allows users to access and modify data in an SAP HANA database. Which of the following steps are crucial for this task? Define OData key specification Set up OData navigation properties Implement custom exits in OData Configure OData triggers Ensure proper authorization for data access.
In SAP HANA, what is the primary purpose of exposing data as OData services? To provide a RESTful API for data access and manipulation To backup database tables To enhance database security To optimize SQL queries.
Which of the following is a key feature of SAP HANA calculation views? They are used for backup and recovery They allow for complex calculations and data transformations They are used to set up database triggers They define database security roles.
Scenario: You are designing a dashboard for a sales team and need to display aggregated sales data with filters for regions and product categories. Which SAP HANA feature would be most suitable for this requirement? Graphical calculation views Input parameters of calculation views Join types in calculation views Table functions in calculation views SQLScript procedures.
In SAP HANA, what is the primary advantage of using calculation views over standard SQL queries? Calculation views provide real-time data backup Calculation views allow for modular and reusable design Calculation views enhance database security Calculation views reduce database storage requirements.
In SAP HANA, which of the following is essential for creating a persistence data model? Calculation views Core data services (CDS) OData services SQLScript triggers.
Scenario: You are designing a persistence data model for a retail application. The application needs to store customer details, order history, and product information. Which of the following entities and relationships are crucial for this design? Customer entity with attributes like name, address, and contact details Order entity linked to the customer and product entities Product entity with attributes like product ID, name, and price OData service for customer data retrieval Relationship between orders and products to track order history.
Which tool is primarily used for creating and integrating the UI in SAP HANA applications? SAP Fiori SAP HANA Studio SAP Web IDE SAP Data Services.
Which of the following is NOT a feature of the persistence data model in SAP HANA? Defining database tables and views Creating relationships between tables Exposing data as RESTful APIs Defining primary and foreign keys.
Scenario: You are tasked with creating a user-friendly dashboard for an SAP HANA application that displays real-time sales data. The dashboard should be accessible on both desktop and mobile devices. Which of the following tools and features would you utilize? SAP Fiori templates Responsive design principles OData services for data retrieval SQLScript procedures for data processing SAP HANA Studio for UI design.
In SAP HANA, which feature allows for the integration of custom UI elements and controls in applications? SAPUI5 libraries Core data services (CDS) Calculation views SQLScript triggers.
In SAP HANA, which of the following is essential for defining application security? Calculation views OData services Roles and privileges SQLScript triggers.
Scenario: You are tasked with ensuring that only specific users can access sensitive financial data in an SAP HANA application. Which of the following steps would you take to achieve this? Define roles with specific privileges Assign roles to users based on their job functions Implement row-level security Expose data using OData services without any restrictions Monitor user access logs regularly.
Which feature in SAP HANA allows for restricting data access at the row level based on user attributes? Calculation views Dynamic data masking Row-level security SQLScript procedures.
In the context of SAP HANA development, why is Git integration important? To enhance database performance To expose data as OData services To manage and version source code To define application security.
Scenario: Your development team is working on a large SAP HANA project with multiple developers. You want to ensure that code changes are tracked, and developers can work simultaneously without overwriting each other's work. Which of the following Git features would be most beneficial? Branching and merging Committing changes Cloning repositories Pull requests and code reviews OData service integration.
In SAP HANA, which tool provides integrated Git functionality for managing source code? SAP Fiori SAP HANA Studio SAP Web IDE SAP Data Services.
Which of the following is a key aspect of database security in SAP HANA? Creating calculation views Exposing data as OData services Implementing encryption at rest and in transit Managing source code using Git.
Scenario: You are the database administrator for an SAP HANA instance. There have been reports of unauthorized data access attempts. Which of the following measures would you implement to enhance security? Monitor database logs for suspicious activity Implement strong password policies Encrypt sensitive data at rest Expose all data as public OData services Regularly update and patch the database system.
In SAP HANA, which feature allows for masking sensitive data so that unauthorized users see obfuscated data? Calculation views Dynamic data masking Row-level security OData services.
Which of the following are characteristics of database procedure? Database procedures canhave both input and output parameters; however, a parameter cannot be both input and output. Database procedures can have several output parameters, and a mix of both scalar and table types is possible. if, in the database procedure header, you use the READS SQL DATA option, the INSERT statements are prohibited; however, dynamic SQL is allowed. if, in the database procedure header, you use the SQL SECURITY INVOKER option, then only the owner of the procedure can start it.
you need to edit a database procedure, You are concerned that the version of the database procedure file you have in your local git repository may not be synchronized with the latest version in the remote git repository, but at this time, you do NOT want to sync the file. You only want to see the commits applied to the file in the remote repository. Which command must you use? Git stash Git fetch Git Merge Git pull.
which of the following can be used when implementing transaction management logic in SQLScript using savepoints? Release savepoint Rollback to savepoint Savepoint Reverse savepoint After system savepoint.
What types of user-defined function are supported by SAP HANA? Table Scalar Aggregate Hierarchy.
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? Keep flag Dynamic join Transparent filter Non-equijoin.
You created an hdi database role, using the SAP Web IDE for SAp HANA and deployed your project. Afterward, you made some modifications to the runtime role. What happens when you change and re-build the design-time role? The runtime modifications are overwritten. The deployment of the role fails. You need to confirm the runtime modifications The runtime modification are kept.
A Node.js module is executed for the first time in SAP HANA extended application services, advanced model (XS advanced). Which of the following activities area performed automatically? A new service is executed on the application server. The source code is compiled to create an executable binary file. The required modules are downloaded based on module dependencies. A new SAP HANA Deployment infrastructure (HDI) container is created.
What are the characteristics of the calculation view of type "SQL Access Only"? Can be directly used as modelled data source for another view Can be directly used for multidimensional analysis Can be directly exposed to all client tools Can be direct accessed via SQL.
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? Installation on Linux OS Installation on Windows Server Usage of virtual machine on Microsoft Windows Installation on Mac OS.
Which keywords do you use to define an OData association? DEPENDENT UNIOR JOIN PRINCIPAL MULTIPLICITY.
In a calculation view, what are the different types of input mapping available in Table Function? Variable Formula Constant Data Source Column.
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? /Products /Products/$metadata /Products/' /Products/ALL.
You need to consume a Node.js service in an SAPUI5 application. in which section of the mta.xml file do you define the variable for the exposed service? In the provides section of the Node.js module In the requires section of the HTML5 module In the properties section of the MTA resources In the path section of the Node.js module.
Which metadata declarations can you specify in a SQL Script procedure when you use the SAP HANA Deployment infrastructure? Language Authorization Security Default schema.
Which SAP HANA exxtended application services, advanced model (XS advanced) tools can you use to retieve the URL for the SAP WebIDE for SAP HANA? XS advanced Controller Start Screen Runtime tool Organization and Space Management tool XS Advanced command-line client tool.
Which of the following elements can be part of the UI5 applications index.html file? Backend Connection Bootstrap UI-Area Framework Reference.
You create a simple data model to store user information. The model contais two tables: one for the user information, and the other for user address details. The user can only have one address. You also need a view to show the complete information of the user including the address. Which actions do you perform if you use CDS artifacts only? Create two entities for the user and address. Create a User Details calculation view and join the user and address information Create two entities for the user and address. Create an addociation in the user entity to the addrress entity. Define a User Details view using select on the address entity and using the association to read the user information. Create two entities for the user and address. Create an association in the user entity to the address entity. Define a User Detail view using select on the user entity and using the association to read the address information. Create two entities for the user and address. Extend the user entity with address columns. Create a view named user details using select on the user entity.
which Node.js module do you use to run an SQL statement against the SAP HANA database? @sap/hdbext @sap/hdi @sap/xsenv @sap/xssec.
You need to combine data from different database tables within you OData service. which capability do you use for this relationship? Entity sets Aggregations Projections Associations.
What key words are contained in the application descriptor file (xs-app.json)? tenant-mode authentication method role-templates routes.
What are the issue categories that SQL Script Code Analyser scans for? Performance Security Business logic Privileges Consistency.
Which activities do you perform on an application in the SAP HANA XS Advanced Cockpit? Display HDI container content Deploy application to SAP Cloud Platform Start, stop, and restart applications. Monitor applications assigned to the current space.
You wnat to esclusively use delcarative logic in as SQL Script procedure. Which of the following operator can you use? IF condition MAP_REDUCE function COMMIT statement TABLE variable.
Which functionality is provided by SAP WebIDE for SAP HANA? Build and deploy applications Organizaiton and space management User management Syntax-aware editors for code.
|
