T5

Which file formats can you use to import data into an SAP HANA Cloud database instance when using the SAP HANA database explorer? There are 2 correct answers to this question. CSV. Parquet. Binary. YAML.

Which parameters can you change when creating a data lake in SAP HANA Cloud using an SAP BTP enterprise account? There are 2 correct answers to this question. The amount of storage. The number of workers. The number of replicas. The amount of memory.

Which service is exclusively available in an SAP HANA database instance of SAP HANA Cloud?. Index server. Compile server. Name server. SAP Web Dispatcher.

Which option of the Table Redistribution Plan Generator do you use to evaluate if a partitioned table needs to be re-partitioned?. Check the number of partitions. Balance table distribution. Housekeeping. Check the correct location of tables and partitions.

What type of privilege do you need to create a schema using the SQL Console in SAP HANA Cloud?. System. Object. Package. Application.

Which of the following are some of the use cases for SAP HANA Cloud? There are 2 correct answers to this question. Data warehousing and analytics. Expand on-premises capacity. Set up a secondary data center. Use as a data backup location.

Which actions can you perform in SAP HANA database explorer? There are 2 correct answers to this question. Navigate the catalog. Show instance overview. Configure trace files. Examine host diagnostic files.

What option do you have when upgrading an SAP HANA Cloud, SAP HANA database in an SAP BTP enterprise account?. Revert to a previous version. Upgrade without restart. Select the version to install. Upgrade the replica first.

Who owns all database objects deployed using the SAP HANA Deployment Infrastructure (HDI)?. The DBADMIN user of the tenant database. The container-specific technical user. The user who created the role. The _SYS_REPO technical user.

.What is the only assignable privilege for the Privileges on Users type?. AUDIT OPERATOR. SCENARIO ADMIN. ATTACH DEBUGGER. CATALOG READ.

Which tools are available In SAP HANA Cloud Central? There are 2 correct answers to this question. Service plan assignments. Recovery wizard. Cloud Foundry CLI. Instance configuration editor.

How can you view the audit trail in the SAP HANA Cloud, SAP HANA database? There are 2 correct answers to this question. Using the SQL Console In the SAP HANA database explorer. Using the Auditing card in the SAP HANA cockpit. Using the kernel profiler trace in the SAP HANA database explorer. Using the expensive statements trace in the SAP HANA cockpit.

From which system views can you export content when using the Performance Monitor app? There are 3 correct answers to this question. SYS.M_WORKLOAD. SYS.M_SERVICE_STATISTICS. SYS.M_LOAD_HISTORY_HOST. SYS.M_DATABASE. SYS.M_SERVICES.

Which user is automatically created when you add a data lake to an SAP HANA Cloud, SAP HANA database?. HDLADMIN. SAPSA. DBADMIN. DBA.

Which options can you use when creating a role In the SAP HANA Cloud. SAP HANA database? There are 3 correct answers to this question. Assign to Role Group. Create Role in Schema. Create Group Admin. Assign User Groups. Assign LDAP Groups.

Which privilege types are available In SAP HANA Cloud? There are 3 correct answers to this question. Object. Application. Analytic. System. Package.

Which storage service type is one of the possible options when adding a data lake to an existing SAP HANA Cloud, SAP HANA database?. SAP HANA native storage extension. Logical volume manager. SAP Native. Network file system.

What is the purpose of the statement library in the SAP HANA database explorer? There are 2 correct answers to this question. To execute scripts from the SQL statement collection for SAP HANA. To determine special database information not available in the SAP HANA cockpit. To collect all the executed SQL statements and generate a searchable library list. To share custom SQL scripts with the whole administrator team.

Which configuration changes can you perform after you have deployed an SAP HANA Cloud, SAP HANA database in an SAP BTP trial account? There are 2 correct answers to this question. Enable the cloud connector. Change the availability zone. Add a data lake. Increase the memory size.

What attributes can you control when creating an SAP HANA Cloud, data lake Instance? There are 3 correct answers to this question. Availability zone. Automatic backup creation. Compatibility with Apache Hadoop. Number of coordinators. Compatibility with SAP IQ.

What can you store in the statement library? There are 2 correct answers to this question. The SAP SQL statement collection. Your personal stored procedures. The executed statements trace. Your personal SQL scripts.

What are the supported resource sizes when you deploy an SAP HANA Cloud, SAP HANA database instance in an SAP BTP trial account?. 45GB RAM, 4 vCPUs, and 120GB storage. 30GB RAM, 2 vCPUs, and 120GB storage. 45GB RAM, 2 vCPUs, and 120GB storage. 30GB RAM, 4 vCPUs, and 120GB storage.

What is the maximum number of replicas you can configure for SAP HANA Cloud?. 4. 1. 3. 2.

Which database storage technology does native storage extension utilize in SAP HANA Cloud?. Dynamic tiering. Extension node. Disk-based. In-memory.

What can you assign to a user group in the SAP HANA Cloud, SAP HANA database? There are 2 correct answers to this question. Password policies. Users. Permissions. Roles.

In SAP HANA Cloud, which tasks are handled by the cloud provider? There are 3 correct answers to this question. Installing, configuring, and upgrading the operating system. Managing users, roles, and permissions in the database. Tuning the database to run optimally on the underlying operating system and hardware. Backing up the operating system and the database software. Sizing, provisioning, and monitoring the database.

Which output channels can the SAP Alert Notification service for SAP BTP use for notification actions? There are 3 correct answers to this question. ServiceNow. Skype. Signal. Slack. Outlook.

What is the SAP HANA Cloud, SAP HANA database recovery point objective (RPO)?. Less than 10 minutes. Equal to 0 minutes. Less than 5 minutes. Less than 15 minutes.

You are using Git in SAP Business Application Studio for version control. You have initialized Git and would like to include the files in your new local repository. What command do you use?. git add. git commit. git push. git init.

What are the aspects of a Multi-Target Application (MTA) model in the lifecycle management of distributed applications?There are 3 correct answers to this question. Integration. CI/CD. Configuration. Composition. Dependencies.

Which of the following elements are part of the SAPUI5 application's index.html file? There are 2 correct answers to this question. Bootstrap. Service layer. UI area. Database.

What is the correct syntax to use common types for model reuse?. using { Country } using '@sap/cds/common';entity Addresses {town : String;country : Country;}. using { Country } extract from '@sap/cds/common';entity Addresses { town:String; country :Country; }. using { Country } from '@sap/cds/common';entity Addresses { town : String; country : Country; }. using { Country } in '@sap/cds/common';entity Addresses {town : String;country : Country; }.

You are using Git from switch view in SAP Business Application Studio and have staged a file after modifications. What is the status of the file?. Deleted(D). Modified(M). Copied(C). New(A).

What are the properties of access control with @restrict? There are 3 correct answers to this que-stion. read. grant. to. delete. where.

You are asked to develop a UI application that can be used by a global audience. Which UI5 features can support this requirement? There are 3 correct answers to this question. Role-based app experience. Easy adoption for different devices. Translation and internationalization. Extensibility concepts at code and application level. High contrast theme to aid visually impaired users.

Which part of the MTA development descriptor file contains API keys?. Global elements. Modules. Resources. Properties.

In SAP HANA Cloud, which tasks are handled by the cloud provider? There are 3 correct answers to this question. Backing up and restoring, and recovering the database software. Sizing, provisioning, and monitoring the database. Tuning the database to run optimally on the underlying operating system, and hardware. Managing users, roles, and permissions in the database. Installing, configuring, and upgrading the operating system.

In Node.js, which file do you use to define external module dependencies?. package.json. server.js. mta.yaml. pom.xml.

What can you do to personalize SAP Business Application Studio? There are 2 correct answers to this que-stion. Customize its native functionalities. Implement the available user exits. Implement an open-source extension. Customize its native version control.

In a SQLScript procedure, which feature can you use to initialize IN/OUT table parameters?. SET. IS_EMPTY. DEFAULT EMPTY. DEFAULT.

What does the service document of an OData service list? There are 3 correct answers to this question. Singletons. Entity sets. Functions. Actions. Types.

How can domain experts and developers collaborate to focus on domain problems using the SAP Cloud Application Programming Model? There are 2 correct answers to this question. By maximizing boilerplate code to real custom logic. By fueling generic runtimes to serve recurring tasks automatically. By declaratively capturing domain knowledge in CDS models. By integrating the data with other SAP systems.

Which aspect of model reuse can you use to add both Created by/Created at and Changed by/Changed as information for records?. managed. temporal. localized. cuid.

Which APIs are used by the event handler to interact with remote or database services? There are 2 correct answers to this question. Querying. Construct. Messaging. Reflection.

Which of the following deployment option of persistence models offer quick development and test cycles?. Global. Local. Virtual. Persistence.

How do you debug a Node.js module in SAP Business Application Studio?. Attach the debugger to the application. Add the sap.hana.xs.debugger::Debugger role to the HDI container's #RT user. Set the enabled parameter to true in the section debugger of the xsengine.ini file. Start the debugger from the CF command line interface and run the program.

Which components are part of SAP HANA Cloud? There are 3 correct answers to this question. SAP Adaptive Server Enterprise. SAP Enterprise Architecture Designer. SAP Analytics Cloud. SAP HANA database. Data lake.

Which solutions form the SAP Business Technology Platform? There are 2 correct answers to this question. Analytics. Intelligent Suite. Experience Management. Application Development & Integration.

What is the sequence of steps to debug a procedure?. Select the procedure to be debugged from the Database Explorer. Open the procedure for debugging and set the breakpoint. Open the debug panel and link the debugger to a session. Execute the procedure. Open the debug panel and link the debugger to a session. Select the procedure to be debugged from the Database Explorer. Open the procedure for debugging and set the breakpoint. Execute the procedure. Open the procedure for debugging and set the breakpoint. Open the debug panel and link the debugger to a session. Select the procedure to be debugged from the Database Explorer. Execute the procedure. Select the procedure to be debugged from the Database Explorer. Open the debug panel and link the debugger to a session. Open the procedure for debugging and set the breakpoint. Execute the procedure.

Which feature of domain modeling can you use to model document structures through contained- in relationships?. Associations. Entities. Namespace. Compositions.

In the Run Configurations view, you can see the available dependencies as defined in the package.json file. To which of the following can you bind or unbind these dependencies? There are 3 correct answers to this question. User-provided service. SAP HANA Cloud database. Local database. External OData service. SAP Job Scheduling service.

To which authorization objects can the SAP HANA Cloud Administrator assign business users?. Role-collections. Scopes. Authorizations. Role-templates.

You have to create an association between Books and Authors entities using Core Data Services (CDS). Which syntax is applicable?. entity Books { key ID : Integer; title : String; author : Association to Authors;} Authors { key ID : Integer;name : String;}. entity Books {key ID : Integer;title : String; author : Association to Authors;entity Authors {key ID : Integer; name : String;}}. entity Books {key ID : Integer; title : String; author : Association to entity Authors { key ID : Integer;name : String;} ;}. entity Books { key ID : Integer; title : String; author : Association to Authors;}entity Authors { key ID : Integer;name : String;}.

Which environments are available on SAP Business Technology Platform? There are 3 correct answers to this que-stion. SAP HANA Cloud. Kyma. Eclipse. Cloud Foundry. ABAP.

Which of the following types of data model can you develop with SAP HANA Cloud? There are 3 correct answers to this que-stion. Semantic. Spatial. Graph. Composite. Predictive.

Which design time files can you create in an SAP HANA database module? There are 3 correct answers to this que-stion. .hdbcalculationview. .yaml. .hdbprocedure. .hdinamespace. .cds.

Why would you create a calculation view?. To define a function that can be consumed by SQL. To define data distribution rules. To store layers of pre-aggregated results. To define a virtual modeling layer on top of tables.

Which database features are typically NOT required by analytical applications that run on SAP HANA Cloud? There are 2 correct answers to this question. Pre-calculated aggregates. Indexes. Stored procedures. Table partitions.

Which package can you use to read bound services?. @sap/xsenv. @sap/xssec. @sap/hdi. @sap/hdbext.

Which Node.js module do you use to run an SQL statement against the SAP HANA database?. @sap/xssec. @sap/xsenv. @sap/hdbext. @sap/hdi.

Which of the following are Cloud Foundry service types that are supported for binding in the Run Configurations view? There are 3 correct answers to this question. Space. application-logs. xsuaa. auditlog. managed-hana.

Which of the following are predefined pseudo-roles supported by the SAP Cloud Application Programming Model? There are 2 correct answers to this question. system-user. authenticated-user. database-user. application-user.

Which sequence of steps do you follow to enable the SAP Job Scheduling service to work with a new application?. Create an instance of the SAP Job Scheduling service.Create an xsuaa service instance.Deploy the application.Bind the SAP Job Scheduling service instance to your application.Bind the xsuaa service instance to your application. Create an instance of the SAP Job Scheduling service.Create an xsuaa service instance.Deploy the application.Bind the xsuaa service instance to your application.Bind the SAP Job Scheduling service instance to your application. Create an instance of the SAP Job Scheduling service.Create an xsuaa service instance.Bind the xsuaa service instance to your application.Bind the SAP Job Scheduling service instance to your application.Deploy the application. Create an instance of the SAP Job Scheduling service.Create an xsuaa service instance.Bind the SAP Job Scheduling service instance to your application.Bind the xsuaa service instance to your application.Deploy the application.

What is the SAP Business Application Studio user interface made up of?. Tiles. Frames. Windows. Views.

What do you use to update the Git history of the local file you are working on?. Check out. Commit. Stage. Save.

What can you use for Core Data Services (CDS)-based security in the SAP Cloud Application Programming Model? There are 2 correct answers to this question. Scopes. Privileges. Authorizations. Roles.

How do you define an entity for a business application that supports multiple languages dynamically? There are 2 correct answers to this question. The entity attributes that need to support multiple languages need to be marked with a special keyword called localized. A text table gets created for each entity that has attributes defined as localized. The entity that needs to support multiple languages needs to be marked with a special keyword called localized. A text table gets created for each entity attribute that is defined as localized.

What properties can you set in the procedure header when developing a procedure? There are 3 correct answers to this question. Begin/end statements. Language (SQLScript/R). Read/write access. Expression. Security (invoker/definer).

How do you initiate a recovery of your SAP HANA Cloud, SAP HANA database instance?. In the SAP BTP cockpit, select the Start Recovery option, and set the timestamp. In an SQL Console, execute the RECOVER DATABASE statement with the timestamp. In an SAP BTP CLI, execute the RECOVER DATABASE command with the timestamp. In the SAP HANA Cloud Central, select the Start Recovery option, and set the timestamp.

Which tool do you use to execute SQL queries on the SAP HANA Cloud database?. HDBSQL. SQL Console. SQLScript. SQL Editor.

Which actions can you perform on a SAP HANA Cloud, SAP HANA database using the Cloud Foundry CLI? There are 2 correct answers to this question. Create instance. Decrease instance memory. Recover instance. Change instance backup schedule.

Which database instance restore options are available in SAP HANA Cloud, SAP HANA database? There are 2 correct answers to this question. Clone. Recreate. Recover. Duplicate.

What is the recommended tool for developing cloud foundry applications?. SAP HANA Cloud Central. SAP HANA cockpit. SAP Business Application Studio. SAP HANA Web IDE.

Which connection type is used by default for restricted users?. JDBC. OLEDB. HTTP/S. ODBC.

When is the first column store compression executed?. When the table is created. When a delta merge is triggered. When partitions are regenerated. When a backup is started.

Where can you start/stop an SAP HANA Cloud database?. SAP BTP cockpit. SAP BTP command line interface. SAP HANA cockpit. SAP HANA Cloud central.

Which components are part of SAP HANA Cloud? There are 2 correct answers to this question. SAP Enterprise Architecture Designer. SAP Analytics Cloud. SAP HANA database. Data lake.

Which options for audited action status are available in the SAP HANA Cloud, SAP HANA database? There are 2 correct answers to this question. All. Procedure executed. Unsuccessful. Table accessed.

Which storage tier is used to manage rarely changing, persistent data?. In-memory. Native storage extension. Data lake. Extension node.

Which data stores are activated by default when you provision an SAP HANA Cloud, SAP HANA database? There are 2 correct answers to this question. Hadoop distributed file system. Native storage extension. In-memory. Data lake.

What are some of the characteristics of runtime roles in the SAP HANA Cloud, SAP HANA database? There are 2 correct answers to this question. They are granted directly using the SQL GRANT statement. They are owned by the user who creates them. They are contained in an underlying versioning system. They can be transported between systems.

Why would you choose an HDI-shared service plan instead of a schema service plan? There are 3 correct answers to this question. You want to use containers to isolate objects. You want to develop calculation views. You want to use SAP Business Application Studio. You want to create database objects using source files. You want to use synonyms to access external data.

Which properties can you edit in the Alert Definitions app? There are 2 correct answers to this question. E-mail recipient. Interval. Proposed solution. Thresholds.

How can you start an SAP HANA Cloud database instance using the command line?. alter system start database <DATABASE_NAME>. sapcontrol -nr <INSTANCE_NUMBER> -function StartSystem. cf update-service <SERVICE_INSTANCE> -c "{ "data": {"serviceStopped": true}}". cf start <APPLICATION_NAME>.

What are some of the typical roles in an SAP HANA Cloud implementation? There are 2 correct answers to this question. ABAP developer. Modeler. Data architect. Kubernetes expert.

Which mechanisms can you use to authenticate users created in SAP HANA Cloud? There are 3 correct answers to this question. JSON Web Token (JWT). OATH token. X.509 certificate. Security Assertion Markup Language (SAML). Kerberos external ID.

Which object types are stored in an SAP HANA catalog? There are 3 correct answers to this question. Agents. Cockpit roles. HDI containers. JSON collections. Cubes.

Which protocol is user by the SAP ID service to authenticate users for single sign-on to SAP cloud solutions?. OAuth2. SAML 2.0. XACML. OpenID.

You want to compare and analyze session-specific data. In what format can you save the data from the SAP HANA cockpit sessions app? (3 answers). HTML file. XML file. TXT file. JSON file. CSV file.

Which database features are typically NOT required by analytical applications that run on SAP HANA Cloud? There are 2 correct answers so this question. Indexes. Table partitions. Stored procedures. Pre-calculated aggregates.

Where does the SAP HANA Cloud, SAP HANA database run in SAP BTP? There are 2 correct answers so this question. Cloud Foundry runtime. Kubernetes container. SAP HANA Cloud Central. Kyma runtime.

What options do you have when deploying an SAP HANA Cloud, SAP HANA database with an integrated data lake? There are 2 correct answers to this question. Create an SAP HANA Cloud database and later add a data lake. Create an SAP HANA Cloud database with a separate data lake. Create an SAP HANA Cloud database and include a data lake in one step. Create an SAP HANA Cloud database with the data lake on premise.

Which files can you access from the SAP HANA database explorer? There are 2 correct answers to this question. Available log. Diserver trace. Compileserver trace. Backint log.