DA test
![]() |
![]() |
![]() |
Title of test:![]() DA test Description: DA test for me, for study purposes |




New Comment |
---|
NO RECORDS |
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 storage. Logical volume manager. Network file system. SAP HANA native storage extension. Which output channels can the SAP Alert Notification service for SAP BTP use for notification actions? Note: There are 3 correct answers to this question. Skype. Outlook. Slack. Service Now. Signal. How does SAP HANA encrypt the data persistence layer?. By page level. By row level. By table level. By column level. When performing a standard SAP HANA database system installation, which users will be created or validated during that installation? Note: There are 2 correct answers to this question. SYSTEM. SAP<SID>. <sid>crypt. sapadm. Which parameters are mandatory when using the HDBLCM tool to install the SAP HANA database system in batch mode? Note: There are 2 correct answers to this question. Password of user sapadm. Installation path. Data and log path. SAP HANA System ID (SID). In which situations can you resume the failed recovery of your productive SAP HANA tenant database? Note: There are 2 correct answers to this question. An aborted recovery of a delta data backup. An aborted recovery of the configuration files. An aborted recovery of a complete data backup. An aborted recovery of a log backup. Which characteristics describe an SAP HANA multitenant database container (MDC) system? Note: There are 3 correct answers to this question. Database isolation increases the isolation between tenant databases on operating system level. The name servers owns information of tables and table partitions in databases. A multitenant database container system is identified by a single system ID (SID). The name server provides index server functionality for the system database. Each tenant database runs its own compile server and the preprocessor server. How can the system database administrator disable tenant database functionalities? Note: There are 2 correct answers to this question. Using the hdbuserstore tool. Using the Manage Restricted Features app. Using the Manage Database Configuration app. Using the resident hdblcm tool. Which file systems are supported for the data and log volumes of the SAP HANA 2.0 database system? Note: there are 2 correct answers to this question. Btrfs. GPFS. XFS. OCFS2. Which file systems locations do you need to specify when installing the SAP HANA multi-host database system using the default settings? Note: There are 2 correct answers to this question. /hana/shared. /usr/sap/<SID>. /hana/log/<SID>. /usr/sap/hostctrl. How are savepoints triggered? Note: There are 2 correct answers to this question. By performing a delta merge. By a database soft shutdown. By issuing a transactional commit. By performing a database backup. You are updating an AS Java-based SAP System. Which tasks can you perform when using the SAP HANA database lifecycle manager (HDBLCM) from the SAP HANA installation media? Note: There are 2 correct answers to this question. Uninstall the SAP HANA database system and its components. Update the SAP HANA database system and its components. Rename the SAP HANA database system. Extract the SAP HANA database system components. What is the correct sequence of the following four steps when you restart the SAP HANA database system?. 1.Row tables are loaded into memory. 2. Open transactions are recovered. 3. Aborted transactions are rolled back. 4. Column tables are loaded. 1.Aborted transactions are rolled back. 2. Row tables are loaded into memory 3. Open transactions are recovered 4. Column tables are loaded. 1.Row tables are loaded into memory. 2. Column tables are loaded. 3. Open transactions are recovered. 4. Aborted transactions are rolled back. 1. Aborted transactions are rolled back 2. Open transactions are recovered. 3. Row tables are loaded into memory. 4. Column tables are loaded. Which app types require SAP HANA as system database? Note: There are 2 correct answers to this questions. Fact sheet apps. Analytical apps. Classical applications. Transactional apps. What action(s) can you perform in the SAP HANA cockpit to back up the complete database system?. Back up the system using a fallback snapshot for every database. Back up the system using a data snapshot. Back up the system database and all tenant databases in one step. Back up the system database and all tenant databases individually. For an SAP HANA tailored datacenter integration (TDI) approach, what is the additional disk space factor required during delta merge operations?. 1.2. 2.0. 1.6. 3. Which services can you stop in the SAP HANA cockpit from the SYSTEMDB Manage Services app? Note: There are 2 correct answers to this question. Compile server. Index server. Daemon. Preprocessor. You are running an SAP HANA database in log mode "normal". Under what circumstances does the database automatically execute a regular log backup? There are 2 correct answers to this question. When the log segment is full. When a commit occurs. When the log buffer is full. When the time threshold is exceeded. What is the purpose of the SAP HANA secure user store (hdbuserstore)? Note: There are 2 correct answers to this question. To store connection information on the SAP HANA XS advanced engine. To store connection information on the SAP HANA database client. To configure an SAP HANA auto-restart for fault recovery. To configure failover support in a 3-tier scenario. How long are SAP HANA Cloud, SAP HANA database backups retained by default?. 4 weeks. 2 weeks. 3 weeks. 1 week. In which virtual environment does SAP HANA Cloud, SAP HANA database run?. Kubernetes. Kyma. VMware. KVM. Who owns all database objects deployed using the SAP HANA Deployment Infrastructure (HDI)?. The container-specific technical user. The DBADMIN user of the tenant database. The user who created the role. The_SYS_REPO technical user. How are user group administrator and user groups related? Note: There are 2 correct answers to this question. Multiple user groups per user group administrator. Only one user group administrator per user group. Multiple user group administrators per user group. Only one user group per user group administrator. From which system views can you export content when using the Performance Monitor app? Note: There are 3 correct answers to this question. SYS.M_SERVICES. SYS.M_LOAD_HISTORY_HOST. SYS.M_WORKLOAD. SYS.M_DATABASE. SYS.M_SERVICE_STATISTICS. Which of the following services are part of SAP BTP? Note: There are 3 correct answers to this question. ABAP runtime. Node.js runtime. Kyma runtime. Cloud Foundry runtime. Python runtime. Which options for Audited Action Status are available in the SAP HANA Cloud, SAP HANA database? Note: There are 2 correct answers to this question. All. Enabled. Unsuccessful. Critical. Which database instance restore options are available in SAP HANA Cloud, SAP HANA database? Note: There are 2 correct answers to this question. Recreate. Recover. Duplicate. Clone. What can you assign to a user group in the SAP HANA Cloud, SAP HANA database? Note: There are 2 correct answers to this question. Password policies. Users. Roles. Permissions. Which audit trail target is used by default in the SAP HANA Cloud, SAP HANA database?. Database table. CSV text file. Kernel trace. Linux syslog. Which files can you open using the SAP HANA database explorer? Note: There are 2 correct answers to this question. Compile server trace. Backint log. Available log. Dpserver trace. Which instance types can you create in SAP HANA Cloud? Note: There are 2 correct answers to this question. Data lake. SAP HANA database. SAP Adaptive Server Enterprise. Kubernetes container. Where can you start/stop an SAP HANA Cloud, SAP HANA database?. SAP HANA cockpit. SAP BTP cockpit. SAP HANA Cloud Central. SAP HANA HDBSQL. Which SAP HANA Cloud tools would you use to diagnose and analyze errors in database trace files? Note: There are 2 correct answers to this question. SAP HANA Cloud Central. Full system information dump. SQL trace analyser. SAP HANA database explorer. Which properties can you change in the Alert Definitions app? Note: There are 3 correct answers to this question. The category. The thresholds. The interval settings. The schedule. The proposed solution. What can you store in the statement library? Note: There are 2 correct answers to this question. The executed statements trace. Your personal stored procedures. Your personal SQL scripts. The SAP SQL statement collection. You want to compare and analyze session-specific data. In what format can you save data sets from the SAP HANA cockpit sessions app? Note: There are 3 correct answers to this question. HTML file. XML file. TXT file. JSON file. CSV file. How can you view the audit trail in the SAP HANA Cloud, SAP HANA database? Note: There are 2 correct answers to this question. 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 explorer. From which sources can you import catalogue objects when using the SAP HANA database explorer? Note: There are 3 correct answers to this question. HPE Green Lake. Google Cloud Storage. Data lake files. Local computer. IBM public cloud. What is the only assignable privilege for the Privileges on Users type?. STRUCTURED PRIVILEGE ADMIN. CATALOG READ. ATTACH DEBUGGER. AUDIT OPERATOR. Which object types are stored in an SAP HANA catalog? Note: There are 5 correct answers to this question. HDI containers. Agents. Cubes. JSON collections. Cockpit roles. Procedures. Tables and view. Which options can you use when creating a role in the SAP HANA Cloud, SAP HANA database? Note: There are 3 correct answers to this question. Create Role in Schema. Assign User Groups. Create Group Admin. Assign to Role Group. Assign LDAP Groups. Which user is automatically created when you add a data lake to an SAP HANA Cloud, SAP HANA database?. DBA. SAPSA. HDLADMIN. DBADMIN. In SAP HANA Cloud, which tasks are handled by the cloud provider? Note: There are 3 correct answers to this question. Tuning the database to run optimally on the underlying operating system and hardware. Sizing, provisioning, and monitoring the database. Backing up the operating system and the database software. Managing users, roles, and permissions in the database. Installing, configuring, and upgrading the operating system. What information is shown in the backup generations chart?. Successful complete data backups available after the last failed complete data backup. Encryption key hash values and the backint backup IDs mapped to the SAP HANA backup IDs. Available data snapshots to quickly identify a possible database time-travel point. Backup types that were created after a complete data backup, up to the next complete backup. What is the maximum number of replicas you can configure for SAP HANA Cloud?. 1. 2. 4. 3. Which data stores are activated by default when you provision an SAP HANA Cloud, SAP HANA database? Note: There are 2 correct answers to this question. Native storage extension. Hadoop distributed file system. Data lake. In-memory. 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?. QRC2. QRC3 latest available version. QRC3. QRC2 latest available version. Which services are shared in the Manage Services app in the SAP HANA Cloud database? Note: There are 2 correct answers to this question. DI server. Compile server. Name server. DP server. Which tool can you use to upgrade an SAP HANA Cloud, SAP HANA database?. SAP BTP command line interface. SAP HANA Database Lifecycle Manager. SQL Console. SAP HANA Cloud Central. HANA Cockpit. SAP HANA Database Explorer. What attributes can you control when creating an SAP HANA Cloud, data lake instance? Note: There are 3 correct answers to this question. Automatic backup creation. Compatibility with SAP IQ. Compatibility with Apache Hadoop. Number of coordinators. Availability zone. Which database storage technology does native storage extension utilize in SAP HANA Cloud?. Disk-based. Dynamic tiering. Extension node. In-memory. What is the purpose of the statement library in the SAP HANA database explorer? Note: There are 2 correct answers to this question. 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 determine special database information not available in the SAP HANA cockpit. To share custom SQL scripts with the whole administration team. A new version 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 version?. 7 months. 3 months. 1 year. 2 weeks. Which container types are available in SAP HANA Deployment Infrastructure (HDI)? Note: There are 2 correct answers to this question. Design time. Runtime. Kubernetes. Docker. What is the SAP HANA Cloud, SAP HANA database recovery point objective (RPO)?. Less than 10 minutes. Equal to 0 minutes. Less than 15 minutes. Less than 5 minutes. What possibilities do you have when upgrading an SAP HANA Cloud, SAP HANA database instance?. Revert to a previous version. Select the version to install. Upgrade the replica first. Upgrade without restart. In which view is the preinstalled statements library stored?. M_ACTIVE_STATEMENTS. M_EXECUTED STATEMENTS. M_SYSTEM_INFORMATION_STATEMENTS. M_PREPARED_STATEMENTS. 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 with the data lake on premise. Create an SAP HANA Cloud database and later add a data lake. Which storage tier is used to manage rarely changing, persistent data?. Data lake. Native storage extension. WORM device. Replica. What are the supported resource sizes when you deploy an SAP HANA Cloud, SAP HANA database instance in a trial model for SAP BTP?. 30GB RAM, 1 vCPUs, and 120GB storage. 16GB RAM, 2 vCPUs, and 120GB storage. 16GB RAM, 1 vCPUs, and 80GB storage. 30GB RAM, 2 vCPUs, and 80GB storage. How do you initiate a recovery of your SAP HANA Cloud, SAP HANA database instance?. In the SAP HANA cockpit, select the Start Recovery option and set the timestamp. In an SQL Console, execute the RECOVER DATABASE statement with the timestamp. In SAP HANA Cloud Central, select the Start Recovery option and set the timestamp. In an SAP BTP CLI, execute the RECOVER DATABASE command with the timestamp. You want to use the multi-environment database administration tools to administer an SAP HANA Cloud, SAP HANA database instance. Which SAP BTP entitlement service plans do you need? Note: There are 2 correct answers to this question. relational data lake. tools. multi-environment tools. hana. Which feature do you use to dynamically control SAP HANA database workloads per client session?. Load unit configuration. Admission control. Workload analysis. Workload classes. Which configuration changes can you perform after you have deployed an SAP HANA Cloud, SAP HANA database in a free tier model for SAP BTP? Note: There are 2 correct answers to this question. Add a data lake. Enable the cloud connector. Increase the memory size. Change the availability zone. Which resources will be changed when you scale down an SAP HANA Cloud, SAP HANA database instance? Note: There are 2 correct answers to this question. Replicas. vCPUs. Memory. Storage. On a SAP HANA Cloud, SAP HANA database what properties can you edit in the Alert Definitions app? Note: There are 2 correct answers to this question. Thresholds. E-mail recipient. Category. Interval. Where does the SAP HANA Cloud, SAP HANA database run in SAP BTP? Note: There are 2 correct answers to this question. Kubernetes container. Kyma runtime. SAP HANA Cloud Central. Cloud Foundry runtime. Which privilege types are available in SAP HANA Cloud? Note: There are 3 correct answers to this question. Analytic. System. Package. Application. Object. 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": {"service Stopped": false}}". cf start <APPLICATION_NAME>. Which connection type is used by default for restricted users?. HTTP/S. JDBC. LDAP. TLS/SSL. Which tools are available in SAP HANA Cloud Central? Note: There are 2 correct answers to this question. Recovery wizard. Service plan assignments. Cloud Foundry CLI. Instance configuration editor. Which actions can you perform on a SAP HANA Cloud, SAP HANA database using the Cloud Foundry CLI? Note: There are 2 correct answers to this question. Create instance. Decrease data volume size. Change instance backup schedule. Recover instance. What tools can you use to view the expensive statement trace file? Note: There are 2 correct answers to this question. SAP BTP cockpit. SAP HANA database explorer. SAP HANA cockpit. SAP HANA Cloud Central. You want to change a standard user account into a restricted user account. Which attributes do you need to adjust? Note: There are 3 correct answers to this question. PUBLIC role must be set to "No". User Group must be set to "Restricted". Creation of Objects in Own Schema must be set to "No". Authorization method must be set to "LDAP". Disable ODBC/JDBC Access must be set to "Yes". Which are benefits of SAP HANA Cloud data compression? Note: There are 2 correct answers to this question. Fit entire enterprise databases into memory and avoid disk access. Improve read performance by accessing pre-aggregated data. Get more data into CPU cache and therefore reduce main memory access. Which types of data can SAP HANA Cloud store and process? Note: There are 3 correct answers to this question. Spatial. Un-Structured. Graph. Text. On SAP HANA cloud, SAP HANA database, which tool can be used for user administration?. Resident hdblcm. SAP HANA Cloud Central. SAP HANA Cockpit. SAP HANA Database Lifecycle Manager. Why can't IT develop next-generation applications using their existing technology? Note: There are 3 correct answers to this question. Current landscapes have become too complex. It is difficult to manage increasing data growth. Legacy applications have become difficult to extend. Business users prefer cloud applications to on-premise applications. What tools are available to monitor a SAP HANA Cloud database? Note: There are 2 correct answers to this question. SAP HANA Cockpit. SAP Management Console. SAP HANA Studio. SAP HANA Database Explorer. Which SAP HANA Cockpit card start the Performance Monitor app to monitor their KPIs? Note: There are 3 correct answers to this question. Disk usage. CPU usage. Table usage. Memory usage. In which non-SAP Public cloud you can deploy SAP HANA CLOUD? Note: There are 2 correct answers to this question. SalesForce. Alibaba. Google cloud. IBM. Up to how many days can you extend your SAP HANA Cloud trial account?. 90 days. 365 days. 30 days. Unlimited number of days. Which Services are used in a Standalone SAP HANA Cloud Data Lake? Note: There are 2 correct answers to this question. Coordinator. Name. Compile. Worker. What happens every day at midnight with your SAP HANA Cloud trial instance?. It is backed up. It is restarted. It is Stopped. It is deleted. What can you assign to a catalog role in SAP HANA Cloud? Note: There are 2 correct answers to this question. Roles. Groups. Application privileges. Users. What properties of the SAP HANA Cloud Data Lake can you specify? Note: There are 2 correct answers to this question. The operating system type. The number of compute vCPUs. The amount of memory. The amount of disk storage. The amount of workers. The amount of replicas. What can you Identify using the Threads app in SAP HANA Cockpit? Note: There are 2 correct answers to this question. Currently executed SQL statements in the DB. Internal Statements or procedures being executed. Internal Process communication port. Currently blocked transactions in the DB. What is SAP HANA Cloud?. A fully-managed, cloud data platform which includes an in-memory database and data lake. A business suite that includes functions such as finance and procurement, that runs on an in memory database. Why might customers choose to implement SAP HANA Cloud versus SAP HANA on-premise? Note: There are 3 correct answers to this question. Control the lifecycle of SAP HANA Cloud. Easy to scale. Reduced administration effort on customer side. Fast deployment. What are advantages of column store tables versus row store tables? Note: There are 3 correct answers to this question. Only the columns required for processing are actually loaded to memory. Columns can be partitioned to improve performance. Data footprint is automatically reduced through compression. Writing and updating records is optimized. Which new development approaches are supported by SAP HANA Cloud? Note: There are 2 correct answers to this question. Sharing of data across application by moving data in real-time. No need to calculate and store pre-aggregated data. Push-down of data processing to the database. As an database administrator, which tool can you use to execute a SQL query in SAP HANA Cloud?. Database Explorer. SAP HANA Studio. hdbsql. SAP HANA Cockpit. What is the purpose of the delta-merge in SAP HANA Cloud?. To combine and cleanse data arriving from multiple source systems. To maintain good read performance of column tables following record updates. Which hardware technology improvements does SAP HANA Cloud exploit to maximize performance? Note: There are 2 correct answers to this question. Larger memory sizes. Faster disks. Multi-core CPUs. Which traces are available in SAP HANA Cloud? Note: There are 2 correct answers to this question. dpserver trace. xsengine trace. indexserver trace. webdispatcher trace. Which traces are available in the SAP HANA Cloud database instance?. Performance trace. Plan trace. Expensive Statement trace. Kernel profile trace. What are the supported operating systems for SAP HANA on IBM Power Servers? Note: There are 2 correct answers to this question. For SAP HANA 1.0, Red Hat Enterprise Linux (RHEL) 7.2. For SAP HANA 2.0, Red Hat Enterprise Linux (RHEL) 9.x. For SAP HANA 1.0, SUSE Linux Enterprise Server (SLES) 11 SP2. For SAP HANA 2.0, SUSE Linux Enterprise Server (SLES) 15 SPx. Which actions can you perform in SAP HANA database explorer for SAP HANA Cloud? Note: There are 2 correct answers to this question. Navigate the catalog. Configure trace files. Examine host diagnostic files. Show instance overview. You install an SAP HANA database and SAP NetWeaver AS for ABAP on one productive system. Wich of the following installation requirements are mandatory for both systems? Note: There are 2 correct answers to this question. The disk resources must be the same. The memory resources must be added. The instance number must be the same. The system IDs (SIDs) must be different. Why do we model in SAP HANA? Note: There are 2 correct answers to this question. To design an efficient data storage architecture. To push data-intensive processing away from the application and to the database. To avoid heavy load in the database. To develop reusable data processing logic in the database. What are scale-out scenarios with SAP HANA? Note: There are 2 correct answers to this question. Use of multiple servers to increase data storage capacity. Provision of extra redundant standby servers that can be switched to in case of hardware failure. Deployment of low-cost generic servers to support high volume data streaming applications. What can you develop using SQLScript? Note: There are 2 correct answers to this question. OData services. Stored procedures. Database functions. What is meant by SAP HANA Tailored Data Center Integration?. Partners provide cloud infrastructure on which SAP HANA can be installed. The customer creates a customized hardware platform on which to install SAP HANA, by reusing existing and SAP certified hardware components. Partners provide a fully installed SAP HANA on certified hardware for use on-premise. What do you need to size before you install SAP HANA in a tailored data center integration (TDI) scenario? Note: There are 3 correct answers to this question. Input/output operations per second (IOPS). Main memory. Persistent storage. Network throughput. SAP Application Performance Standard (SAPS). A development space provides all of the tools and resources needed for developing your application. True. False. Which service is exclusively available in an SAP HANA database instance of SAP HANA Cloud?. Compile server. Index server. Name server. SAP Web Dispatcher. What methods can you use to size a SAP HANA database system? Note: There are 2 correct answers to this question. Use the The SAP HANA Hardware Directory website. Use the SAP Quick Sizer website. Use the ABAP report RSPFPAR. Use the ABAP report /SDF/HDB_SIZING. Which memory areas are part of the SAP HANA memory pool? Note: There are 3 correct answers to this question. Allocated memory pool (free). Database management. Table data. Database used memory. Code and stack. Why do we still need a disk layer when SAP HANA is referred to as an in-memory database? Note: There are 2 correct answers to this question. To store data that has been unloaded from memory when memory becomes full. To enable full database recovery in the event of a power failure. To store data that is frequently used. To hold the delta store for newly-arrived records. What is the correct SAP HANA Maintenance Strategy?. A new release every 6 months and 3 months maintenance support. A new release every 6 months and 2 years maintenance support. A new release every year and 2 years maintenance support. Which features are supported by the SAP HANA platform lifecycle management tools? Note: There are 2 correct answers to this question. Creating and deploying SAP HANA CDS views. Installing or updating an SAP HANA database system. Adding or removing additional SAP HANA hosts. Performing SAP HANA database backups. Which file formats can you use to import data into an SAP HANA Cloud database instance when using the SAP HANA database explorer? Note: There are 2 correct answers to this question. YAML. Parquet. Binary. CSV. When is a new release of SAP HANA Cloud available?. Monthly. Yearly. Quarterly. Which are key roles of an SAP HANA project? Note: There are 3 correct answers to this question. Modeler. Security expert. Application developer. Change management consultant. Your SAP HANA database is running in log mode Normal and automatic log backups are enabled. With this configuration, in which situations are the log segments backed up automatically? There are 3 correct answers. The log segment is full. The log segment is closed after 3 seconds. The database is started. The database is stopped. The log segment is closed after exceeding the configured timeout threshold. What are the advantages of using the delta merge in the memory management of the column store? There are three correct answers. Write operations only affect the delta storage but not the main storage. High write performance by implementing a delta storage mechanism, which uses only basic compression. Highly compressed data in the main storage to realize read optimization. Partial loading is possible in the delta storage. Which backup types are available when you schedule a data backup? There are two correct answers. Snapshot. Complete. Interval. Differential. Which users are able to start and stop a distributed SAP HANA database system? There are two correct answers. root. SYSTEM. <sid>adm. sapadm. The password policy parameters for the system database of a multiple-container system are maintained in the indexserver.ini file. Choose the correct answer. True. False. You can only generate the full system information dump file using the SAP HANA cockpit. Choose the correct answer. True. False. Which protocol is used by the statistics service to collects statistical and performance information? Choose the correct answer. JSON. MDX. SNMP. SQL. What component of an SAP HANA appliance do you need to consider for sizing? Choose the correct answer. Memory. CPU. Storage. What is the minimum space requirement for the Data Volume? There are two correct answers. Min. 0.5 * RAM. 1.2 * RAM (TDI). 3 * RAM (Appliance). Min. 1 * RAM. On SAP HANA database, to diagnose backup errors, you can use the backup.log and backint.log files. Choose the correct answer. True. False. Which user account is used when a tenant database connection is automatically added to the database explorer? Choose the correct answer. Your personal SAP HANA database user. Your personal SAP HANA cockpit user. The tenant COCKPIT_MONITOR user. The tenant SYSTEM user. Under which user runs the local secure store (LSS) on the SAP HANA server? Choose the correct answer. sapadm. <sid>crypt. SYSTEM. <sid>adm. Which certified hardware components are listed on the SAP HANA hardware directory? Note: There are 2 correct answers to this question. Enterprise storage systems. Enterprise backup solutions. Appliances. Network switches. Which resource can you dynamically influence using workload classes? There are two correct answers. statement IO throughput limit. Statement commit rate limit. Statement thread limit. Statement memory limit. SAP HANA tailored data center integration (TDI) is an open and flexible approach for the integration of SAP HANA in the data center. TDI can reduce hardware and operation costs by reusing existing hardware components and processes. Choose the correct answer. False. True. Which of the following SAP HANA license key types locks down the system when the current memory consumption of SAP HANA exceeds the licensed amount of memory? Choose the correct answer. Temporary license key. Enforced license key. Unenforced license key. The creation of storage snapshots has a big impact on the system, and recovery from storage snapshots takes longer. Choose the correct answer. False. True. What parts of the SAP HANA database system can be backed up and restored separately? There are two correct answers. Virtual tables. Configuration files. Schemas. Tenants. What is the default external SQL port number of the tenant database that is automatically created when you install a single-tenant system? Choose the correct answer. 3<instance>13. 3<instance>41. 3<instance>03. 3<instance>15. Assume the following scenario: An SAP HANA system is configured for the parameter savepoint_interval_s with the value 300s on the DEFAULT layer, but the SYSTEM layer value is 450s, and as a third parameter value, the included tenant is configured on the DATABASE layer with the value 600s. Which value will be taken into account during runtime for the tenant database? Choose the correct answer. The SYSTEM layer value 450s, because a tenant-specific savepoint parameters are not allowed. The DEFAULT layer value 300s, because it is recommended by SAP and ignores all other values. The DATABASE layer value 600s, because it overrides SYSTEM and DEFAULT layer values. In which SAP HANA server processes does the statistics scheduler thread run? Choose the correct answer. Name server. Compile server. Index server. SAP start service. Which of the following statements is true for the SAP HANA preinstalled role (SAP_INTERNAL_HANA_SUPPORT) for support cases? Choose the correct answer. It can only be granted further object privileges. It can be granted to the SYSTEM user. It can be granted to another role. It can only be granted further system privileges. From which backup types can SAP HANA resume a recovery? There are two correct answers. Incremental. Fallback snapshot. Complete. Log. Which of the following system views provides violation information about unsupported values for configuration parameters in your SAP HANA database system? Choose the correct answer. M_BACKUP_CONFIGURATION. M_CONFIGURATION_PARAMETER_VALUES. M_LANDSCAPE_HOST_CONFIGURATION. CONFIGURATION_PARAMETER_PROPERTIES. Which tools can you use to update SAP HANA cockpit? There are two correct answers. hdblcm. SWPM. SUM. hdblcmgui. The index server runs in the system database and contains the actual data stores and the engines for processing the data. Choose the correct answer. True. False. Which of the following administration tools provide the ability for central landscape management? There are two correct answers. SAP HANA hdbsql. DBA Cockpit. SAP HANA studio. SAP Landscape Management. Which backup types are delta backups in SAP HANA? There are two correct answers. Incremental. Differential. Full. Mirror. Which components of the SAP HANA Memory Pool are part of the SAP HANA Used Memory? There are three correct answers. Code and Stack. Column and Row Tables. Database Management. Allocated Memory. What is the correct order when registering databases and creating groups and SAP HANA cockpit users with the cockpit manager? Choose the correct answer. There is no fixed order to follow. Databases, Groups, Cockpit Users. Cockpit Users, Databases, Groups. Groups, Databases, Cockpit Users. What is the system database used for in a multi-container SAP HANA system? There are two correct answers. Store information about the location of tables in all tenant databases. User management for all tenant databases. Resource management for all tenant databases. System-wide parameter settings. When configuring SAP HANA alerts, you can only enter one email recipient per alert. Choose the correct answer. False. True. In the SAP HANA database explorer, as the user SYSTEM, you can access the table data in every database schema. Choose the correct answer. True. False. What is the best location to use when importing data when the file size is larger than 1GB? Choose the correct answer. SAP HANA host. Local computer. A Samba share. SAP HANA cloud. Which schema stores the historical performance data of SAP HANA? Choose the correct answer. _SYS_EPM_DATA. _SYS_TELEMETRY. _SYS_STATISTICS. _SYS_BI. In SAP HANA databases, user groups are mandatory and have to be used by customers. Choose the correct answer. False. True. You cannot force all clients who communicate with the SAP HANA database through the SQL interface to use a secured connection. Choose the correct answer. True. False. For which system landscape types can you use the SAP HANA Hardware and Cloud Measurement tools to determine if your hardware meets the minimum performance criteria required to run SAP HANA in production use? There are two correct answers. A scale-out setup. A standby host setup. A single host setup. A system replication setup. By default, from where reads an SAP ABAP application server the database connection information? Choose the correct answer. The hdbuserstore on the SAP ABAP application server. The Local Secure Store on the SAP ABAP application server. The Secure Storage in File System on the SAP HANA server. The hdbuserstore on the SAP HANA server. In your backup cycle, you can use daily fallback snapshots. Choose the correct answer. True. False. In the context of the SAP HANA maintenance strategy, new features and functions on the SAP HANA platform are shipped in what kind of bundle? Choose the correct answer. Support package stack (SPS). SAP HANA standard revisions. Support packages (SP). SAP HANA maintenance revisions. In which circumstances do you create a column store table? There are three correct answers. When aggregations or fast search are required. When accessing complete records. When the calculations are based on a small number of columns. When the table has a large number of columns. Which system view allows you to review the authentication method assigned to your user account? Choose the correct answer. M_CONNECTIONS. M_SERVICES. M_REMOTE_SOURCES. M_SECURESTORE. Which of the following tools can be used for user administration? There are three correct answers. Resident hdblcm. SAP HANA cockpit. SAP Identity Management. hdbsql. Which of the following privileges allow read access to data in SAP HANA information models depending on certain values or combination of values? Choose the correct answer. System privileges. Package privileges. Analytic privileges. Object privileges. When connected to the SAP HANA database, which HDBSQL command displays general information about the database? Choose the correct answer. \c. \di. \a. \s. Which SAP HANA lifecycle management tool can be used to install the SAP HANA database system? Choose the correct answer. hdbupd. hdblcmweb. Resident hdblcm. hdblcm. In SAP HANA, the database administrator can't manually unload table data. Choose the correct answer. True. False. Which of the following recovery types is not supported for delta backups? Choose the correct answer. Recover the database to a specific data backup. Recover the database to a specific point in time. Recover the database to its most recent state. What is contained in SAP HANA Cockpit Support Packages? There are two correct answers. Support Package Stacks. Feature Packs. Bug fixes. New features. What software innovations did SAP deliver with SAP HANA? There are two correct answers. Insert only on column store. Partitioning. Compression and decompression. Column and delta store. The resident HDBLCM located on the SAP HANA installation media performs administrative tasks like installing and updating an SAP HANA database and its core components. Choose the correct answer. True. False. How does the SAP HANA database organize the storage of column store data on the disk volume? Choose the correct answer. Pages with sizes from 4 KB to 16 MB. Pages with a fixed size of 64 MB. Pages with sizes from 4 KB to 16 MB, which are arranged in superblocks of 64 MB. Pages with a fixed size of 16 KB, which are arranged in superblocks of 64 MB. Which of the following elements are required for implementing a database copy? There are two correct answers. The host number of the source and the target system are identical. Source and target databases can have different number and types of services. The target database must have the same or higher version than the source database. A data backup (file-based backups or backups using a third-party backup tool) or storage snapshot of the source system is available. SAP HANA cockpit can only be installed on dedicated hardware. Choose the correct answer. True. False. From which Web site can you securely download the full SAP HANA documentation as a .zip file? Choose the correct answer. https://launchpad.support.sap.com/#/softwarecenter. https://community.sap.com/topics/hana. https://help.sap.com/docs/SAP_HANA_PLATFORM. When a registered SAP HANA resource is offline, the version number 0.00.000.00.0 (UNKNOWN) is displayed on the Database Directory page of SAP HANA cockpit to indicate an improper shutdown. Choose the correct answer. True. False. Which of the following traces has the default configuration status "Active"? Choose the correct answer. Performance trace. Plan trace. SQL trace. Database trace. The database migration option (DMO) is part of which tool? Choose the correct answer. Software Update Manager (SUM). Software Provisioning Manager (SWPM). SAP Add-On Installation Tool (SAINT). Support Package Manager (SPAM). |