Cloud Provisioning and Adm

How many daily backups are retained in the SAP HANA Cloud, SAP HANA database backup cycle?. 15. 14. 30. 28.

Which database technology does native storage extension utilize in SAP HANA Cloud?. Data fabric. Disk-based. Multi-cloud. Row store.

What happens every day at midnight with your SAP HANA Cloud trial instance?. It is stopped. It is deleted. It is backupped. It is restarted.

In which schema does the SAP HANA Cloud, SAP HANA database instance store historical performance data?. _SYS_WORKLOAD_REPLAY. _SYS_SOL_ANALYZER. _SYS_STATISTICS. _SYS_EPM_DATA.

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 Native. SAP HANA native storage extension. Logical volume manager. Network file system.

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

How are you authenticated when you open the SAP HANA database explorer in SAP HANA Cloud?. SAP ID service. Username/password. SAP Authenticator. Microsoft Authenticator.

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.

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

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

Which feature do you use to dynamically manage SAP HANA database workloads per client session?. Workload classes. Parallel execution of SOL statements. Non-uniform memory access (NUMA). Admission control.

In which virtual environment does SAP HANA Cloud, SAP HANA database run?. Kyma. VMware. Kubemetes. KVM.

In which view is the pre-installed statements library stored?. M_EXECUTED_STATEMENTS. M_REMOTE_STATEMENTS. M_SYSTEM_INFORMATION_STATEMENTS. M_PREPA RED_STATEMENTS.

Which trace can you activate in the SAP HANA cockpit?. Performance. SQL. Plan. Expensive Statement.

Which tool can you use to restore an SAP HANA Cloud database?. SAP HANA cockpit. SQL Console. SAP BTP CLI. SAP HANA Cloud Central.

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

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

Which tool allows you to examine service trace files in SAP HANA Cloud?. SAP HANA SQL Trace Analyzer. SAP HANA Cloud Central. SAP HANA cockpit. SAP HANA database explorer.

What is the purpose of the SAP HANA Cloud, SAP Adaptive Server Enterprise storage option?. To support mission-critical applications with extreme online transaction processing (XOLTP) technology. To distribute data across application landscapes with minimal resources and support data integrity. To combine OLTP and OLAP technologies, complemented with a multi-model engine for relational and document data. To provide high-performance, on-demand analytics, supporting customers with timely, data driven insights.

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

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

Which audit trail target can you select in the SAP HANA Cloud, SAP HANA database?. CSV text file. Kernel trace. Linux syslog. Database table.

Which information is shown in the backup generations chart?. Encryption key hash values and the backint 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. Available data snapshots to quickly identify a possible database time-travel point. Successful complete data backups available after the last failed complete data backup.

A new release of SAP HANA Cloud, SAP HANA database is available as of 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 release?. 7 months. 2 weeks. 1 year. 3 months.

What properties of the SAP HANA Cloud Data Lake can you specify?. The operating system type. The amount of RAM. The number of Compute CPUs. The amount of disk storage.

Which option of the Manage Table Distribution tool do you use to evaluate if a partitioned table needs to be repartitioned?. Balance table distribution. Redistribute tables after adding host(s). Check the correct location of tables and partitions. Check the number of partitions.

As an database administrator, which tool can you use to execute a SQL query in SAP HANA Cloud?. Hdbsql. SAP HANA Studio. Database Explorer. SAP HANA Cockpit.

What is the correct account structure in SAP BTP?. Global account -> Region -> Space -> Subaccount. Global account -> Space -> Region -> Subaccount. Global account -> Subaccount -> Region -> Space. Global account -> Region -> Subaccount -> Space.

What is the technology behind SAP HANA Cloud, SAP Adaptive Server Enterprise replication?. Full table replication. Log-based replication. Snapshot replication. Transactional replication.

Where can you start/stop an SAP HANA Cloud database?. SAP BTP cockpit. SAP HANA Cloud Central. SAP HANA database explorer. SAP HANA cockpit.

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, 4 CPUs, and 120GB storage. 45GB RAM, 2 CPUs, and 120GB storage. 30GB RAM, 2 CPUs, and 120GB storage. 45GB RAM, 4 CPUs, and 120GB storage.

In the SAP HANA cockpit, which trace can you activate?. Plan. Expensive Statement. SQL. Performance.

Which tool would you use to diagnose and analyze errors in database trace files?. SAP HANA database explorer. SAP HANA Cloud Central. SAP HANA smart data access. SAP HANA smart data integration.

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

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

Which tool can you use to upgrade an SAP HANA Cloud, SAP HANA database?. SAP HANA database lifecycle manager. SAP BTP CU. SAP HANA Cloud Central. SQL Console.

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

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

Which tool can you use to examine the trace files of the SAP HANA Cloud instance services?. SAP HANA cockpit. SAP HANA database explorer. SAP HANA Cloud Central. Trace viewer.

You are still running SAP HANA Cloud, SAP HANA database in version QRC1. To which release will SAP automatically upgrade your SAP HANA database if you don't perform an upgrade manually?. QRC3. QRC3 latest available revision. QRC2 latest available revision. QRC2.

Which tool can be used for user administration?. SAP HANA Database Lifecycle Manager. SAP HANA Cloud Central. Resident hdblcm. SAP HANA Cockpit.

Which tool can you use to upgrade a SAP HANA Cloud database?. SAP HANA Database Explorer. SAP HANA Cockpit. SAP HANA Database Lifecycle Manager. SAP HANA Cloud Central.

How long after registration will your SAP BTP trial account be automatically deleted?. 3 months. 6 months. 9 months. 12 months.

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

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

Which protocol is used by the SAP ID service to authenticate users for single sign-on to SAP cloud solutions?. XACML. OpenlD. SAML 2.0. 0Auth2.

What is the SAP HANA Cloud, SAP HANA database recovery point objective (RPO)?. < 10 minutes. < 5 minutes. = 0 minutes. < 15 minutes.

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

When creating an SAP BTP trial instance, how does the SAP ID service version?. By SAP S-user account. By company address. By telephone number. By e-mail address.

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 is used by developers to store and execute their development work. It holds log and trace files and other diagnosis, error, and information files. It represents the data dictionary, including all adapters, indexes, libraries, and data structures.

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

Which options can you use when creating a role in the SAP HANA Cloud, SAP HANA database? There are 2 correct answers to this question. Assign user groups. Assign LDAP groups. Create role in schema. Create group admin.

Which data storage options are activated by default when you provision an SAP HANA Cloud, SAP HANA database? There are 2 correct answers to this question. The data lake data store. The native storage extension data store. The in-memory data store. The SAP Adaptive Server Enterprise replicate data store.

In which cases can you load and unload individual tables and table columns manually in an SAP HANA Cloud, SAP HANA database? There are 2 correct answers to this question. To extend the scale-out memory. To optimize the standby node memory. To measure total table memory. To actively free up 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. Users. Roles. Password policies. Permissions.

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

Which traces are available in SAP HANA Cloud? There are 2 correct answers to this question. indexserver trace. webdispatcher trace. xsengine trace. dpserver trace.

What are the consequences of NOT executing a delta merge? There are 2 correct answers to this question. New records are not read. Read performance decreases. Memory is not optimized. Aggregates are not adjusted.

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

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 with the data lake on premise. Create an SAP HANA Cloud database and include a data lake in one step.

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.

How are user group administrators and user groups related? There are 2 correct answers to this question. Only one user group per user group administrator. Multiple user groups per user group administrator. Only one user group administrator per user group. Multiple user group administrators per user group.

Which type of SAP HANA Cloud instances can you provision in SAP BTP? There are 2 correct answers to this question. SAP SQL Anywhere. SAP Adaptive Server Enterprise. SAP IQ. Data lake.

Which are use-cases for SAP HANA Cloud? There are 2 correct answers to this question. Expand on-premise capacity. Data warehousing and analytics. Use as a data backup location. Setup a secondary data center.

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

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

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

In SAP HANA Cloud, which tasks are handled by the cloud provider? There are 3 correct answers to this question. Managing users, roles, and permissions in the database. Installing, configuring, and upgrading the operating system. 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.

Which mechanisms could 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.

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

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 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. You want to use SAP Business Application Studio.

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

Which import sources are supported by the SAP HANA database explorer to import data into an SAP HANA Cloud, SAP HANA database? There are 2 correct answers to this question. Alibaba Cloud OSS. IBM public cloud. Azure Cloud Storage. Exoscale Object Storage.

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

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

Which object types are stored in the SAP HANA Catalog? There are 2 correct answers to this question. Tables and view. Procedures. Cockpit Roles. HDI Containers.

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

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

Which tools are available in SAP HANA Cloud Central? There are 2 correct answers to this question. SAP Business Application Studio. SAP HANA Cloud Capacity Unit Estimator. SAP HANA cockpit. SAP HANA database explorer.

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 memory. The number of workers. The number of replicas. The amount of storage.

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. Parquet. CSV. Binary. JSON.

What attributes can you control when creating an SAP HANA Cloud, data lake instance? There are 2 correct answers to this question. Compatibility with SAP Adaptive Server Enterprise. Compatibility with SAP IQ. The number of workers. The number of coordinators.

What are the advantages of column store tables compared to row store tables? There are 3 correct answers to this question. Additional indexes are used. Higher data compression rates. Improved write performance on frequent update. Higher performance for query operations. Parallel access is improved.

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

Which database restore options are available in SAP HANA Cloud, SAP HANA database? There are 2 correct answers to this question. Increase the memory size. Enable the cloud connector. Change the availability zone. Add a data lake.

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

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

Which components are part of SAP HANA Cloud? There are 3 correct answers to this question. Composite. Semantic. Graph. Spatial. Predictive.

Which SAP HANA security tasks can be performed in combination with a Lightweight Directory Access Protocol (LDAP) server? There are 2 correct answers to this question. User group assignment. User creation. Password policy configuration. Role assignment.

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

What is automatically created when you set up an SAP HANA Cloud trial instance? There are 3 correct answers to this question. An SAP BTP, Kyma runtime. An SAP region on the nearest hyperscaler. A global account. An SAP BTP, Cloud Foundry runtime. A subaccount.

In the SAP BTP account model, why would you create directories? There are 2 correct answers to this question. To assign quotas and entitlements. To organize and filter subaccounts. To manage users and roles. To purchase SAP BTP services.

Which services can you restart from the Manage Services app in the SAP BTP trial account SAP HANA cockpit? There are 3 correct answers to this question. Compile server. Index server. Name server. DP server. DI server.

Which features are available in the Alert Definitions app? There are 3 correct answers to this question. Activate/deactivate alerts. Change interval settings. Adjust thresholds. Copy alert definitions. Apply changes to other databases.

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

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

What can you assign to a catalog role in SAP HANA Cloud? There are 2 correct answers to this question. Roles. Users. Application privileges. Groups.

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

What are some of the typical tasks performed by the SAP HANA Cloud modeler role? There are 2 correct answers to this question. Create graph workspaces. Develop calculation views. Manage data tiers. Develop Fiori apps.

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 Usage Analytics. In Quotas. In Regions. In Entitlements.

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 Auditing card in the SAP HANA cockpit. Using the audit trail trace in the SAP HANA database explorer. Using the SQL Console in the SAP HANA database explorer. Using the Loggregator via the Cloud Foundry CU.

In SAP HANA Cloud Central, which credentials are used to stop an SAP HANA Cloud database instance?. Subaccount. DBADMIN. E-mail address. SYSTEM.

What data do you need to provide when you create a personal sap.com account? There are 2 correct answers to this question. Company name. E-mail address. Credit card number. Mobile number.