C_HANATEC_15 Real Questions To Pass SAP Certified Technology Associate – SAP HANA 2.0

Are you looking for the latest C_HANATEC_15 Real Questions?There are many providers offering questions for SAP Certified Technology Associate – SAP HANA 2.0,you need to choose the latest to prepare for your test,PassQuestion C_HANATEC_15 Real Questions will introduce you to the core logic of a variety of topics to ensure that you not just learn, but you also understand different technologies and subjects. We assure that studying with our C_HANATEC_15 Real Questions will adequately prepare you for the C_HANATEC_15 exam.

Practice Online SAP Certified Technology Associate C_HANATEC_15 Free Questions

1. Reloading column tables in this way restores the database to a fully operational state more quickly.

However, it does create performance overhead, and may not be necessary in nonproductive systems, how can you deactivate the the reload feature? Please choose the correct answer.

Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to true

Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false

Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to false

Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false

2. Which of the following are characteristics of SAP HANA Smart Data Streaming? Please choose the correct answer.

It uses databases queries.

It is a standalone product for use with any target system.

It acts based on combinations of events.

It provides reports and analysis on the received data.

3. Which of the following recovery types is not supported for delta backups? Choose the correct answer.

Recover the database to its most recent state.

Recover the database to a specific point in time.

Recover the database to a specific data backup.

4. You created data and log backups on the file system. Due to a hardware failure, you use the Recover Database app in SAP HANA cockpit 2.0 to recover the crashed SAP HANA database.

From which location does the Recover Database app read the recovery information by default? Please choose the correct answer.

$(DIR_INSTANCE)/../global/hdb/custom/config

$(DIR_INSTANCE)/backup/log

$(DIR_INSTANCE)/<hostname>/trace

$(DIR_INSTANCE)/backup/data

5. Which combination of source and target systems is allowed when you perform a database copy in a scale-out scenario? Please choose the correct answer

The source system can have 4 hosts.
The target system can have 2 hosts.

The source system can have 4 index servers.
The target system can have 2 index servers.

The source system can have 2 hosts.
The target system can have 4 hosts.

The source system can have 2 index servers.
The target system can have 4 index servers.

6. How many tiers do you usually find in an SAP HANA application? There are 2 correct answers to this question.

7. Which of the following actions triggers the replication of SAP BW authorizations in SAP HANA? There are 3 correct answers to this question.

System restart

InfoProvider activation

Execution of "Replicate BW user authorizations to HANA database" process chain

Execution of report "RS2HANA_AUTH_RUN"

8. Which tool do you use to create a new tenant when you install SAP HANA multitenant database containers? Please choose the correct answer.

Manage Databases app of SAP HANA cockpit 2.0

Administration Console of the SAP HANA studio

HDBSQL command line and the CREATE SCHEMA statement

System Configuration tab of the DBA Cockpit

9. You implement a multi-host SAP HANA system with auto-failover capabilities.

What are the requirements for the disk storage? There are 2 correct answers to this question.

The slave node is set to backup standby.

The failed worker host gets fenced during failover.

The standby host has file access.

The master node is fully clustered.

10. Which R3load mode is used during a database migration option procedure? Please choose the correct answer.

Pipe

File

Network

Socket

11. For which scenarios is it mandatory to define the authorizations at HANA Level? There are 2 correct answers to this question.

SAP HANA Live for SAP Business Suite

Business Suite on HANA

SAP S/4HANA

Web-based native applications based on XS

12. What happens when an SAP HANA system is restarted? There are 2 correct answers to this question

The list of open transactions is left open.

All row tables are loaded into the memory except the row tables that are configured to be loaded on demand.

All row tables and row table attributes are loaded into the memory.

The Redo log is replayed from the last savepoint.

13. In the Aggregate Health Monitor application, you are viewing the overall status of all tenants assigned to your SAP HANA cockpit user.

Which user retrieves this database status information? Please choose the correct answer.

A named user with monitor permissions

The system user

The cockpit_admin user

A technical user with limited permissions

14. You need to check the new monitoring option in SAP HANA cockpit 2.0.

Which SAP HANA cockpit 2.0 app do you use? Please choose the correct answer.

Monitor Performance

Configure Alerts

Manage Database Backups

Configure System Properties

15. You define the parameters for password policy of an SAP HANA tenant database where the parameters are stored? Please choose the correct answer.

indexserver.ini

multidb.ini

nameserver.ini

global.ini

16. You create a new user by copying an existing user.

Which predelivered role of the existing user is automatically granted to the new user?

Modeling

Runtime

Monitoring

Repository

17. You need to set up an SAP HANA system where several companies share the same SAP HANA instance. You have to provide each company a dedicated share of the instance for its data, configuration and user management.

Which deployment scenario do you use? Please choose the correct answer.

Multitenant database containers (MDC)

Technical co-deployment (TCD)

Multiple Components on One Database (MCOD)

Multiple Components on One System (MCOS)

18. The administration console is pre-delivered by SAP. You can access the administration console in one of the following ways. There are 3 correct answers to this question.

Choose the Administration button in the upper left corner

Choose the Administration button in the upper right corner

Double-click the system in the system monitor

Double-click the system monitor in the Navigator view

Double-click the system in the Navigator view

19. Which of the following tasks requires the BACKUP ADMIN authorization? There are 2 correct answers to this question.

Backing up the database without a user interface.

Recovering the database without a user interface

Physically deleting data and log backups and obsolete versions of the backup catalog from the backup location.

Administration tasks executed on a tenant database through the system database.

20. Which of the following elements are required for implementing a database copy? There are 2 correct answers to this question.

The target database must have a the same or higher version than the source database.

You don’t have to be concerned about disk space and memory of the target database.

Source and target databases can have different number and types of services.

A data backup (file-based backups or backups using a third-party backup tool) or a storage snapshot of the source system is available.

21. Which of the following statements are true about SAP HANA Live? There are 2 correct answers to this question.

SAP HANA Live for SAP Business Suite comes with a comprehensive set of predefined models from across the SAP Business Suite.

SAP HANA Live for SAP Business Suite is an accelerator.

SAP HANA Live for SAP Business Suite focuses on Enterprise Data Warehouse cases.
and not on live operational reporting.

SAP HANA Live for SAP Business Suite comprises of an Analytical Model.

SAP HANA Live for SAP Business Suite is a Rapid Deployment Solution.

22. Which of the following statements are true regarding In-Memory computing security? There are 2 correct answers to this question.

Data and undo log information (part of data) are automatically saved to disk at regular savepoints

The log is also saved to disk continuously and synchronously after each COMMIT of a database transaction

The redo log captures last 5 minutes changes by database transactions

After a power failure the system returns to its last consistent state by replaying the undo log since the last savepoint

23. How can you minimize the database migration option (DMO) downtime? Please choose the correct answer.

Adjust the number of R3load processes during benchmarking and the DMO procedure.

Use the benchmarking tool for a productive database migration with the DMO procedure.

Provide the measured table migration duration for table sequencing during benchmarking.

Run the benchmarking tool parallel to the DMO to automatically adjust the number of R3load processes.

24. Why might you want to reference a user-provided service in a project? Please choose the correct answer.

To access data from another container

To access data from a classic database schema

To access data from your project container

25. You migrate a database using the database migration option.

Which tools are available to monitor the migration? There are 2 correct answers to this question.

Process Bucket monitor

Log Tail Viewer monitor

Table Depooling monitor

Table Splitting monitor

26. You install an SAP HANA database and SAP NetWeaver AS ABAP 7.5 on one server. This system will be your customer’s productive system.

Which of the following installation requirements are mandatory? There are 2 correct answers to this question.

The system ID (SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different.

The instance number for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.

The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added.

The disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.

27. How to open Web user interface for HDBLCM from SAP HANA Studio from the context menu? Please choose the correct answer.

HDBLCM ManagementPlatform Lifecycle ManagementSAP HANA Platform Lifecycle
Management

Lifecycle ManagementPlatform Lifecycle ManagementSAP HANA Platform Lifecycle
Management

Lifecycle ManagementPlatform Lifecycle ManagementOpen HDBLCM

28. USER A grants a privilege to USER B, and USER B grants the same to USER C afterwards.

What happens if you drop USER B from the HANA database? Choose the correct answer.

The privilege is revoked from both USER A and USER

The privilege is revoked from USER C, but not USER

The privilege remains assigned to both USER A and USER

The privilege is revoked from USER A, but not USER

29. Which activities are required when you execute an SAP HANA Near Zero Downtime upgrade? There are 2 correct answers to this question.

Perform a takeover3.

Upgrade the secondary system with the command line tool.

Stop the secondary system.

Restart the primary and secondary system.

30. What are the advantages of the DMO procedure? There are 3 correct answers to this question.

DMO combines several steps into one procedure.

DMO allows a lower target release on SAP HANA database.

DMO allows an easy reset during the procedure.

DMO is an inplace procedure by default, keeping the application server host.

31. Which partitioning type must you use to produce an equal distribution of rows in the SAP HANA database? Please choose the correct answer

Round-robin

Aging

Hash-range

Range

32. From an architectural standpoint, which of the following components belong to the SAP HANA Indexserver? There are 2 correct answers to this question.

External Interfaces

Preprocessor

Relational Engines

SAP Web Dispatcher

33. You need to test an ABAP report, which uses SAP HANA objects, in the quality assurance (QA) system.

Which tool do you use to import all objects to the QA system? Please choose the correct answer.

SAP HANA Application Lifecycle Manager

SAP HANA Quality Gate Maintenance

SAP HANA Change Request Management

SAP HANA Transport Containers

34. The data storage of your productive SAP HANA instance crashed, and you need to recover the database. The log storage is still intact.

You have a full data backup that is 9 hours old and an incremental backup that is 4 hours old. To which point in time can you recover to minimize the data loss?

The latest log backup

The latest incremental backup

The last commited transaction

The last full data backup

35. which action do you perform when SAP HANA Database is running out of space Please choose the correct answer.

Create a new tenant database

extend the file system size on the operating system level

create a new databse volume

extend the size of database volume

36. You are using USER01 and modelling a calculation view that combines existing calculation views with tables belonging to SCHEMA02. You want to activate the new calculation view, but you get a User is NOT Authorized error.

What is the cause of the error? Please choose the correct answer.

User _SYS_REPO is missing object privileges for SCHEMA02.

The calculation view was created in the sap package.

USER01 is missing object privileges for SCHEMA02.

The calculation view was created in the system-local package.

37. You are applying SAP Support Packages during an SUM DMO run to SAP HAN

Which options are possible to select in the main dialog Tool Configuration? There are 3 correct answers to this question.

Single System

Standard

Advanced

Expert Mode

38. Which of the following options are valid SAP HANA backup strategies? There are 2 correct answers to this question

A storage snapshot followed by incremental backups and differential backups

An offline backup followed by incremental backups and differential backups

A full data backup followed by incremental backups and differential backups

A data snapshot followed by incremental backups and differential backups

39. You imported the following objects.

Which of them always require an activity from you before they can be built? There are 2 correct answers to this question.

Synonyms definition

Multi-target application

Logical schema definition

SAP HANA database module

40. You need to secure client-server communication using transport layer security.

Which objects must you set up on the server side? There are 2 correct answers to this question.

User certificate

Private key

Root certificate

Server certificate

41. Which of the following traces has the default configuration status of “Active”? Choose the correct answer.

Performance trace

Database trace

SQL trace

Kernel profiler

42. Which tasks must you perform to convert a single database to a multitenant database system? There are 2 correct answers to this question.

Set the password for the system database user.

Trigger the conversion in the SAP HANA cockpit 2.0.

Generate the system database before the conversion.

Create an operating system user for the converted tenant database.

43. Who can access the runtime object generated from a repository object immediately after the activation? Please choose the correct answer.

The user who started the activation

The SYSTEM user

The _SYS_REPO user

The user who created the repository object

44. What do you have to ensure during the downtime phases of SUM? There are 3 correct answers to this question.

The source database must be stopped

End users can not log on to the SAP system

Batch jobs from daily business can not start

Interfaces from other SAP systems can not log on to the SAP system

45. Which table partitioning types does SAP HANA support? There are 3 correct answers to this question.

Hash

Composite

Round-robin

Cluster

Range

46. Which productive deployment option is valid when you combine SAP ERP and SAP SCM in one SAP HANA system? Please choose the correct answer.

SAP HANA AppServices

Multitenant database containers

Technical co-deployment

SAP HANA One

47. What is XS? Choose the correct answer.

A native, lightweight application server

An optional engine to handle excessive data loads

A data cleansing engine

A user interface

48. Your customer wants to know when the productive SAP HANA system was updated and to which version.

Where do you find this information? There are 2 correct answers to this question

In the General Information app of SAP HANA cockpit 2.0

In the administration editor of the SAP HANA studio

In the catalog view of the SAP HANA Web-based Development Workbench

In the SAP HANA database explorer for SAP HANA cockpit 2.0

49. What is XS? Choose the correct answer.

A native, lightweight application server

An optional engine to handle excessive data loads

A data cleansing engine

A user interface

50. 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

Object Privileges

Analytic Privileges

Package Privileges

51. Which security settings can you monitor in SAP HANA cockpit 2.0? There are 2 correct answers to this question.

Data Storage Security

Password Policy

Manage Database Backups

Manage Users

52. Which of the following elements are SAP HANA system components There are 2 correct answers to this question.

SAP HANA Database

SAP HANA Dynamic Tiering

SAP HANA Advanced Data Processing

SAP HANA Remote Data Sync

53. What is included with the Predictive Analysis Library (PAL)? There are 2 correct answers to this question.

Data preparation functions

Text mining functions

Predictive algorithms

Flowgraphs

54. In the context of the SAP HANA maintenance strategy, which of the following terms is connected to bundle new features and functions to the SAP HANA Platform? Choose the correct answer.

SAP HANA standard revisions

SAP HANA maintenance revisions

Support package stack (SPS)

Support packages (SP)

55. Which connection type can a standard restricted user use to connect to the SAP HANA database? Please choose the correct answer.

ODBC

TCP/IP

JDBC

HTTP(S)

56. Where can you check the trace and log files when your SAP HANA database is NOT available? Please choose the correct answer.

In the Trace app of the SAP HANA Web-based Development Workbench

in the $DIR_INSTANCE/exe/python_support directory

in the troubleshoot of unresponsive system app of HANA cockpit 2.0

in the troubleshoot of unresponsive system app of hana cockpit for offline administration

57. In which SAP HANA configuration file can you view the assignments of hosts to their scale-out role? Please choose the correct answer.

Sapprofile.ini

Indexserve.ini

Nameserver.ini

Multidb.ini

58. Which of the following database resources can be monitored at the DBA Cockpit Current Status Overview monitor? There are 3 correct answers to this question.

The time at which the database was started.

Disk consumption from the SAP HANA database.

Connection statistics about open connections.

Memory and CPU consumption from the SAP HANA database.

59. Your SAP HANA database is running in log mode “normal” and automatic log backups “enabled”.

With this configuration, In which situations are the log segments backed up automatically? There are 3 correct answers to this question.

The log segment is full.

The database is started.

The log segment is closed after exceeding the configured time threshold.

The database is stopped.

60. In SAP HANA Studio, what would you find in a Package? There are 3 correct answers to this question.

Calculation Views

Analytic Privileges

Procedures

Tables

61. Which backup scenarios are allowed in multitenant database containers? There are 2 correct answers to this question.

A backup of a tenant database can be recovered to an SAP HANA single-container system.

A tenant database can initiate its own backup unless this is prohibited by the system configuration.

A tenant database can initiate its own backup and the backup of the other tenant databases.

The system database can initiate its own backup and the backup of tenant databases.

62. Which encryption service can you activate in HANA There are 3 correct answers to this question.

Pages-in memory

Data

storage snapshot

backup

log

63. SAP HANA uses SSFS to protect the root encryption keys. These root keys protect all encryption keys used in the SAP HANA database from unauthorized access.

What other two main functions of the root encryption keys? There are 2 correct answers to this question.

The root key used for the internal data encryption service of the database

The root key used for data volume encryption

The root key used for users log encryption

The root key used for transactions volume encryption

64. What is a prerequisite for a system replication when the development (DEV) system and the quality (QA) system are installed on the secondary site? Please choose the correct answer.

The DEV and QA systems must be online during system takeover.

The preload of tables must be switched off.

The global allocation limit must be identical.

The SIDs and instance numbers must be identical.

65. In single-host SAP HANA systems, you can use plain attached storage devices, such as Small Computers System Interface hard drives, solid-state drives (SSDs), or storage area networks (SANs).

However, to build a multi-host system with failover capabilities, the storage must ensure which of the following conditions? There are 2 correct answers to this question.

The standby host has file access

SYSTEM users replaced by standby host

The failed worker host no longer has access to write to files

The standby host has access to write to files

66. Which of the following elements are valid rules for the location of the backup files? There are 3 correct answers to this question.

The Volume ID is automatically added to a specified file name.

The backup files should never be in the same directory and on the same file system as the data.

The backup ID is unique for each persistence only.

The backup folder will be created automatically when the backup process is started.

67. Which identity provider is used by default by SAP HANA extended application services, advanced model (XS Advanced)? Please choose the correct answer.

SAP HANA user store

SAP Identity Management

SAP ID service

SAP Cloud Identity

68. Which of the following tools can be used for User Administration? There are 3 correct answers to this question.

SAP HANA Cockpit

hdbsql

Resident hdblcm

SAP NetWeaver Identity Management

69. Which of the following authentication methods are available in SAP HANA? Please select all the correct answers that apply.

Use of SAML identity provider assertion tickets

Reuse the Kerberos ticket issued by the Active Directory

Use the SAP Logon ticket issued by another SAP ABAP system

70. SAP HANA, in the context of user management, allows you to do which of the following? There are 3 correct answers to this question.

Create and delete users

Lock and unlock users

Assign a user to a user group

Create a restricted user

71. In the General Licensing Process which of the following statements are true regarding Temporary license keys? There are 2 correct answers to this question.

Temporary license keys are manually installed by the SAP HANA system

Temporary license keys are automatically installed by the SAP HANA system

After 90 days, the temporary license expires and the system is locked down

After 28 days, the temporary license expires and the system is locked down

72. What is a characteristic of the synchronous in-memory system replication mode in SAP HANA? Please choose the correct answer.

The primary systems suspends transaction processing until the connection to the secondary system is re-established.

The primary system waits until the secondary system confirms the log was persisted.

The primary system does NOT wait for the confirmation of the secondary system.

The primary system waits until the secondary system confirms receiving the log.

73. Which of the following statement is not true regarding SAP HANA Server Components? Please choose the correct answer.

The index server contains the actual data stores and the engines for processing the data

Index server is access by SAP HANA Cockpit with SQL queries

Web based tools can access the index server with simple HTTP request

XS Engine process the client application with HTTP request

74. logical error occurred in one tenant of your SAP HANA database.

What action do you perform to make the tenant consistent again? Please choose the correct answer

Recover the system database. The affected tenant is recovered automatically.

Recover the system database first and then recover the affected tenant.

Recover the affected tenant. The system database is NOT recovered.

Recover the affected tenant first and then recover the system database.

75. You plan to implement SAP HANA multitenant database containers using a scale-out scenario with high availability.

What rules can be applied when you implement such an SAP HANA system? Note: There are 2 correct answers to this question.

Single tenant databases can be failed over to the standby host.

Tenant databases can be automatically distributed across all the available hosts.

An instance of the system database can run on all the nodes, including the standby host.

An instance of the system database can run on all the nodes, except the standby host.

76. You are monitoring the application server of an SAP S/4 HANA system. You need to investigate on the SAP HANA database, but someone locked your personal SAP HANA user.

Which tools can you use to execute an SQL query? There are 2 correct answers to this question.

SQL Command Editor of the DBA Cockpit on the application server

SAP HANA studio on the SAP HANA server

HDBSQL command line tool on the SAP HANA server

SAP HANA cockpit 2.0 on a central server

77. What are the prerequisites for configuring audit logging? There are 2 correct answers to this question.

AUDIT ADMIN system privilege

INIFILE ADMIN system privilege

AUDIT OPERATOR system privilege

INIFILE OPERATOR system privilege

78. Which security infrastructures can you integrate with SAP HANA? There are 2 correct answers to this question.

Linux syslog

Radius server

Identity management

Intrusion detection

79. A developer at your customer starts a badly designed query.

How do you stop this query? Please choose the correct answer.

Use the Threads app to cancel the thread.

Use the Monitor Statements app to interrupt the statement.

Use the Expensive Statements Trace app to stop the statement.

Use the Sessions app to end the session.

80. You must design a high-availability SAP HANA database system with 8 hosts (6 worker and 2 standby) that also uses multitenant database containers.

Which rules apply? There are 2 correct answers to this question.

The system database must run on the standby host.

The system database instance must run on all hosts (worker and standby).

The tenant databases must be able to be scaled out to all hosts (worker and standby).

The tenant databases must run on the worker hosts.

Question 1 of 80

C_HANATEC_15 Real Questions To Pass SAP Certified Technology Associate – SAP HANA 2.0

Practice Online SAP Certified Technology Associate C_HANATEC_15 Free Questions

Leave a Reply Cancel reply