2. Which database features are typically NOT required by analytical applications that run on SAP HANA Cloud?
Note: There are 2 correct answers so this question. Table partitions Pre-calculated aggregates Stored procedures Indexes.
3. Why would you create a calculation view? To store layers of pre-aggregated results To define data distribution rules To define a function that can be consumed by SQL To define a virtual modeling layer on top of tables.
1. Which of the following types of Excan you develop with SAP HANA Cloud?
Note: There are 3 correct answers so this question Semantic Spatial Graph Predective Composite.
4. What is the recommended tool for developing cloud foundry applications? SAP HANA Cloud Central SAP HANA cockpit SAP HANA Web IDE SAP Business Application Studio.
5. What are the consequences of NOT executing a delta merge? (Pagina 15)
Note: There are 2 correct answers so this question.
Aggregates are not adjusted New record are not read Memory is not optimized Read performance decreases.
6. What are some of the typical roles in an SAP HANA Cloud implementation? (Pagina 20)
Note: There are 2 correct answers so this question.
Data architect ABAP developer Modeler Kubernetes sap.
7. Why would you choose an HDI-shared service plan instead of a schema service plan?
Note: There are 3 correct answers to this question.
You want to use SAP Business Application Studio You want to use synonyms to access external data You want to develop calculation views You want to use containers to isolate objects You want to create database objects using source files
.
8. When is the first column store compression executed? When a delta merge is triggered When a backup is started When partitions are regenerated When the table is created
.
9. Which solutions forms the SAP Business Technology Platform?
Note: There are 2 correct answers to this question.
Application Development & Integration Analytics Intelligent Suite Experience Management.
10. In which virtual environment does SAP HANA Cloud, SAP HANA database run? KVM Kubernetes Kyma VMware.
11. What are the advantages of column store tables compared to row store tables?
Note: There are 3 correct answers to this question.
Higher data compression rates Improved write performance on frequent updates Additional indexes are used Higher performance for query operations Parallel access is improved.
12. Which tool allows you to examine service trace files in SAP HANA Cloud? SAP HANA SQL Trace Analyzer SAP HANA cockpit SAP HANA database explorer SAP HANA Cloud Central.
13. Which audit trail target is used by default in the SAP HANA Cloud, SAP HANA database Database table Linux syslog CSV text file Kernel trace.
14. Which connection type is used by default for restricted users? JDBC HTTPS ODBC OLEDB.
15. What type of privilege do you need to create a schema using the SQL Console in SAP HANA Cloud? System Object Package Application
.
16. Who owns all database objects deployed using the SAP HANA Deployment Infrastructure (HDI)? The _SYS_REPO technical user The DBADMIN user of the tenant database The container-specific technical user The user who created the role .
17. What is the only assignable privilege for the Privilege on Users type? AUDIT OPERATOR CATALOG READ SCENARIO ADMIN ATTACH DEBUGGER.
18. Which options can you use when creating a role in the SAP HANA Cloud, SAP HANA database?
Note: There are 2 correct answers to this question.
Assign user groups Create role in schema Assign LDAP groups Create group admin .
19. Which mechanisms can you use to authenticate users creates in SAP HANA Cloud?
Note: There are 3 correct answers to this question
OATH token Kerberos external ID X.509 certificate JSON Web Token (JWT) Security Assertion Markup Language (SAML)
.
20. Which feature do you use to dynamically control SAP HANA database workload per client session? Admission control Workload analysis Non-uniform memory access (NUMA) Workload classes.
21. Which tools are available in SAP HANA Cloud Center?
Note: There are 2 correct answers so this question.
SAP Business Application Studio SAP HANA Cloud Capacity Unit Estimator SAP HANA cockpit SAP HANA database explorer.
22. Which properties can you edit in the Alert Definitions app?
Note: There are 2 correct answers so this question.
Interval Thresholds E-mail recipient Proposed solution.
23. What is the purpose of the statement library in the SAP HANA database explorer?
Note: There are 2 correct answers so this question.
To determine special database information not available in the SAP HANA cockpit To execute scripts from the SQL statement collection for SAP HANA To collect all the executed SQL statements and generate a searchable library list To share custom SQL scripts with the whole administrator team.
24. Which trace can you activate in the SAP HANA cockpit? Plan SQL Expensive statement Performance.
25. Which properties can you change in the Alert Definitions app?
Note: There are 3 correct answers to this question.
The Interval settings The proposed solution The thresholds The category The schedule.
26. Which services are shared in the Manage Services app in the SAP HANA Cloud database?
Note: There are 2 correct answers to this question.
Name server Compile server DP server DI server.
27. What is automatically created when you set up an SAP HANA Cloud trial instance?
Note: There are 3 correct answers so this question.
An SAP region on the nearest hyperscaler A subaccount A global account An SAP BTP, Kyma runtime An SAP BTP, Cloud Foundry runtime.
28. When creating an SAP BTP trial instance, how does the SAP ID service verify your identity? By Microsoft Authenticator By e-mail address By SAP Authenticator By telephone number.
29. Where does the SAP HANA Cloud, SAP HANA database run in SAP BTP?
Note: There are 2 correct answers so this question.
Cloud Foundry runtime Kyma runtime Kubernetes container SAP HANA Cloud Central.
30. Which user is automatically created when you add a data lake to an SAP HANA Cloud, SAP HANA database? DBADMIN HDLADMIN SAPSA DBA.
31. What is the correct account structure in SAP BTP? Global account -> Region -> Subaccount -> Space Global account -> Subaccount -> Region -> Space Global account -> Space -> Region -> Subaccount Global account -> Region -> Space -> Subaccount.
32. What data do you need to provide when you create a personal sap.com account?
Note: There are 2 correct answers so this question
Credit card number Mobile number E-mail address Company name.
33. 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.
34. In which view is the pre-installed statements library stored? M_SYSTEM_INFORMATION_STATEMENTS M_REMOTE_STATEMENTS M_EXECUTED_STATEMENTS M_PREPARED_STATEMENTS.
35. Which user account is assigned by default when you open the SAP HANA database explorer in SAP HANA Cloud? DBADMIN HDLADMIN COCKPIT_MONITOR SYSTEM.
Which files can you access from the SAP HANA database explorer?
Note: There are 2 correct answers to this question.
Available log Compileserver trace Diserver trace Backint log.
37. What is the purpose of the SAP HANA Cloud, SAP HANA database explorer HDI container folder? It shows used memory and CPU, the most recently started service, and the version information It represents the data dictionary, including all adapters, indexes, libraries and data structures It is used by developers to store and execute their development work It holds log and trace files and other diagnosis, error and information files.
38. Which object types are stored in an SAP HANA catalog?
Note: There are 3 correct answers to this question
Cubes Cockpit roles HDI containers Agents JSON collections.
39. From which sources can you import catalog objects when using the SAP HANA database explorer?
Note: There are 3 correct answers to this question
Exoscale Object Storage Alibaba Cloud OSS Local Computer IBM public cloud Azure Storage.
40. Which information is shown in the backup generations chart? Available data snapshots to quickly identify a possible database time-travel point Encryption key hash values and the ….. backup IDs mapped to the SAP HANA backup IDs Backup types that were created after a complete data backup, up to the next complete backup Successful complete data backup available after the last failed complete data backup.
41. Which configuration changes can you perform after you have deployed an SAP HANA Cloud SAP HANA database in an SAP BTP trial account?
Note: There are 2 correct answers so this question
Increase the memory size Add a data lake Enable the cloud connector Change the availability zone
.
42. What is the SAP HANA Cloud, SAP HANA database recovery point objective (RPO)? Less than 5 minutes Equal to 0 minutes Less than 10 minutes Less than 15 minutes.
43. You are still running SAP HANA Cloud, SAP HANA database in a QRC1 version.
To which release will SAP automatically upgrade your SAP HANA database if you don’t perform an upgrade manually?
QRC3 QRC2 QRC2 latest available version QRC3 latest available version.
44. Where can you start/stop an SAP HANA Cloud database? SAP HANA cockpit SAP BTP command line interface SAP BTP cockpit SAP HANA Cloud central
.
45. How can you start an SAP HANA Cloud database instance using the command line? Alter system start database <DATABASE_NAME> cf update-service <SERVICE_INSTANCE> -e “{ “data””: {“serviceStopped”: true}}” cf start <APPLICATION_NAME> sapcontrol –nr <INSTANCE_NUMBER> -function StartSystem.
46. Which database instance restore options are available in SAP HANA Cloud, SAP HANA database?
Note: There are 2 correct answers to this question.
Duplicate Clone Recreate Recover.
47. Which tool can you use to restore an SAP HANA Cloud database? SAP HANA cockpit SAP BTP command line interface SAP HANA Cloud central SQL console.
48. Which type of SAP HANA Cloud instance can you provision in an SAP BTP enterprise account?
Note: There are 2 correct answers so this question.
SAP HANA database SAP IQ SAP SQL Anywhere Data lake.
49. What attributes can you control when creating an SAP HANA Cloud data lake instance?
Note: There are 2 correct answers so this question
The availability zone Compatibility with Apache Hadoop Compatibility with SAP IQ The number of coordinators.
50. Which storage tier is used to manage rarely changing, persistent data? Data lake Native storage extension Extension node In-memory.
51. Which parameters can you change when creating an SAP HANA Cloud, data lake using an SAP BTP enterprise account?
Note: There are 2 correct answers to this question.
The amount of storage The amount of memory The number of workers The number of replicas.
52. What is the maximum number of replicas you can configure for SAP HANA Cloud? 4 1 2 3.
53. Which database storage technology does native storage extension utilize in SAP HANA Cloud?
Extension node In-memory Disk-based Dynamic tiering.
54. 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 Network file system SAP Native.
55. What options do you have when deploying an SAP HANA Cloud, SAP HANA database with an integrated data lake?
Note: There are 2 correct answers to this question.
Create an SAP HANA Cloud database and include a data lake in one step Create an SAP HANA Cloud database with a separate data lake Create an SAP HANA Cloud database and later add a data lake Create an SAP HANA Cloud database with the data lake on premise.
) Which tool would you use to diagnose and analyze errors in database trace files? (2 answers) SQL Trace Analyzer FULL System Information Dump SAP HANA database explorer SAP HANA Cloud Central.
From which system views can you export content when using the Performance Monitor app?(3 answers) SYS M_LOAD_HISTORY_HOST SYS M_DATABASE SYS M_SERVICE_STATISTICS SYS M_SERVICES SYS M_WORKLOAD
.
You want to compare and analyze session-specific data. In what format can you save the data drom the SAP HANA cockpit sessions app? (3 answers) JSON file TXT file HTML file CSV file XML file.
In the SAP BTP account model, why would you create directories?(2 answers) To manage users and roles To purchase SAP BTP services To organize and filter subaccounts To assign quotas and entitlements.
) Which tool do you use to execute SQL queries on the SAP HANA CLOUD database? SQL Script SQL editor HDBSQL SQL console.
Which component are part of SAP HANA Cloud?(2 answers) SAP HANA Database SAP Enterprise Architecture Designer Data Lake Sap Analytics Cloud.
In SAP HANA Cloud, which tasks are handled by the cloud provide?(3 answeres) Backing up the operating system and the database software Installing, configuring, and upgrading the operating system Managing users, roles, and permissions in the database Sizing, provisioning and monitoring the database Tuning the database to run optimally on the underlying operating system and hardware.
You are working in the SAP BTP cockpit. Where can you find overall information regarding the provisioning and consumption of resources at a global account level? In quotas In Entitlements In Usage Analytics In Regions.
What are some of the typical tasks performed by the SAP HANA Cloud models role?(2 answers) Create graph workspaces Manage data tiers Develop calculation views Develop Fiori apps.
What can you store in the sistement library?(2 answers) Your personal SQL scripts The executed sistements trace Your personal stored rpocedures The SAP SQL statement collection.
Which actions can you perform an a SAP HANA Cloud, SAP HANA database using the Cloud Foundry CLI?(2 answer) Change instance backup schedule Decrease instance memory Recover instance Create instance.
What option do you have when upgrading an SAP HANA Cloud, SAP HANA database in an SAP BTP enterprise account? Select the version to install Upgrade without restart Revert to a previous version Upgrade the replica first.
A new version of SAP HANA Cloud, SAP HANA database is available form today. If you do not perform the upgrade manually, how much time do you have before your database will be automatically upgraded to the next version? 7 months 2 weeks 3 months 1 year.
How do you initiate a recovery of your SAP HANA Cloud, SAP HANA database instance? In an SAP BTP CLI, execute the RECOVER DATABASE command with the timestamp In the SAP BTP cockpit, select the Start Recovery option, and set the timestamp In the SAP HANA Cloud Central, select the Start Recovery option and set the timestamp In an SQL Console, execute the RECOVER DATABASE statement with the timestamp
.
How many backups are retained in the SAP HANA Cloud, SAP HANA database backup cycle? 30 28 14 15.
Which data stores are motivated by default when you provision on SAP HANA Cloud, SAP HANA database?2( answers) Native storage extension In-memory Hadoop distributed file system Data Lake.
Which tool can you use to upgrade an SAP HANA Cloud, SAP HANA database? SAP HANA database lifecycle manager Sap HANA Cloud central SAP BTP command line interface SQL Console.
How long after registration will your SAP BTP trial account be automatically deleted? 9 months 6 months 12 months 3 months.
What happens to your SAP HANA Cloud database trial instance every day at midnight? It is shut down It is backed up It is resisted It is initialized.
What can you assign to a user group in the SAP HANA Cloud, SAP HANA database?(2 answers) Password policies Roles Permissions Users.
How can you view the audit trail in the SAP HANA Cloud, SAP HANA database?(2 answers) Using the audit trail trace in the SAP HANA database explorer Using the Loggregator via the Cloud Foundry CLI Using the Auditing card in the SAP HANA cockpit Using the SQL Console in the SAP HANA database.
How are user group administrators and user groups related?(2 answers) Multiple user group administrators per user group Only one user group per user group administrator Multiple user groups per user group adiministrator Only one user group administrator per user group.
Which options for audited action status are available in the SAP HANA Cloud, SAP HANA database?(2answers) Unsuccessful All Procedure executed Table accessed.
What are some of the characteristics of runtime roles in the SAP HANA Cloud, SAP HANA database?(2 answers) They are owned by the user who creates them They are contained in an underlying versioning system They are granted directly using SQL GRANT statement They can be transported between system.
What are the supported resource sizes when you deploy an SAP HANA Cloud, SAP HANA database instance in an SAP BTP trial account? 30GB RAM, 2vcPUs, and 120GB storage 45GB RAM, 2vcPUs, and 120GB storage 45GB RAM, 4vcPUs, and 120GB storage 30GB RAM, 4vcPUs, and 120GB storage.
|
