C_HANATEC142 Exam Questions

What are the recommended ways to perform a database backup? There are 2 correct answers to this question.

You have an SAP HANA productive system with sensitive data. How can you restrict modeling users from viewing this data? There are 2 correct answers to this question.

Which of the following privileges are mandatory for the initial user to configure SAP LT to populate the SAP HANA database? There are 2 correct answers to this question.

You are using continuous system replication between SAP HANA systems in two separate data centers. What are the advantages of this scenario? There are 2 correct answers to this que...

When you install SAP HANA, which of the following disk size requirements apply? There are 2 correct answers to this question.

A user is locked due to too many failed logon attempts. Which SQL command can solve this problem? Please choose the correct answer. Choose one:

Which of the following can you do in the SAP HANA studio and also in the DBA Cockpit? There are 3 correct answers to this question.

Which of the following update scenarios can be selected for execution in the SAP HANA lifecycle manager? There are 2 correct answers to this question.

Where do you specify the instance number during the installation of SAP HANA? Please choose the correct answer.

Which of the following are required to monitor SAP HANA in SAP Solution Manager? There are 2 correct answers to this question.

Of the databases that can be used for Data Services 4.0, which of the following is bundled with Information Platform Services (mini-BOE)? Please choose the correct answer. Choose o...

A company wants to restrict data access to a specific year for certain users. Which privilege type must you define in SAP HANA to achieve this requirement? Please choose the correc...

A customer complains about poor performance when they query a column table with 5 billion records. You suspect that this table is partially loaded into memory. Where can you to che...

You want to make sure that all data accesses to a specific view will be logged in the audit trail. As part of an update of the database schema, the view is dropped and recreated un...

What must you do in SAP LT to establish a connection between a non-SAP source system database and SAP HANA? There are 3 correct answers to this question. Choose:

Which new connection type is available as of SAP BusinessObjects Data Services 4.0? Please choose the correct answer.

You are using SAP BusinessObjects Data Services as your ETL tool. What is the next step required after you have created the datastore and imported the metadata from an SAP ERP syst...

You are replicating data in real-time from a source system to SAP HANA using System Landscape Transformation (SLT). The source system had to be restored using a point-in- time reco...

Which of the following are benefits of using accelerators with SAP HANA? There are 2 correct answers to this question. Choose:

Which of the following situations can trigger a delta merge? Please choose the correct answer.

A user cannot query an information model because of missing authorizations. How can the user find out which authorization is missing? Please choose the correct answer.

An organization has the following infrastructure standard: - Separate Server and User network managed by the internal network team - Centralized shared storage (SAN) with RAID-5 -...

What can you use to transform data from SAP Business Warehouse (BW) into SAP HANA? Please choose the correct answer. Choose one:

In addition to the in-memory database, which of the following technologies are part of SAP HANA? There are 2 correct answers to this question. Choose:

Which of the following can be done by the SAP HANA lifecycle manager? There are 3 correct answers to this question. Choose:

In Microsoft Windows, to which folder are the logs written by default during the SAP HANA studio installation? Please choose the correct answer. Choose one:

You are reviewing the execution plan of an SQL statement. You want to find out which plan operators (POPs) have been executed in parallel and for how long each of them has been act...

What is the recommended approach by SAP when loading tables into SAP HANA from SAP ERP via Data Services? Please choose the correct answer.

You create an analytic view and want to restrict access to departments with specific values using analytic privileges. Which tasks do you have to perform to accomplish this? There...

How do you configure an SAP HANA system of 4 nodes when implementing high availability? Please choose the correct answer. Choose one:

Which of the following privileges do you need to activate views? Please choose the correct answer.

A long-running SQL query issued by an SAP NetWeaver work process also seems to use a lot of system resources. How can you find out which ABAP module and which SAP NetWeaver user ca...

You have to transport data models from one SAP HANA system to another using the Change and Transport System (CTS). Where do you install the CTS plug in? Please choose the correct a...

Which tab in SAP HANA studio displays CPU load history data? Please choose the correct answer.

How can you find out which SAP HANA parameters have been changed in your system? There are 2 correct answers to this question.

Which of the following would you use to upgrade an SAP HANA system and keep the downtime to a minimum? Please choose the correct answer.

Which of the following is used to deploy SAP-delivered content in SAP HANA? Please choose the correct answer. Choose one:

Which of the following are benefits of implementing SAP HANA? There are 3 correct answers to this question.

Which of the following authentication methods does SAP HANA support for http(s) access? There are 2 correct answers to this question. Choose:

To ensure the supportability of SAP HANA, who must install the SAP HANA database on the SAP HANA appliance hardware? Please choose the correct answer.

Which of the following steps allow you to create a test system (system A) based on a productive SAP HANA standalone system (system B)? There are 2 correct answers to this question....

Your SAP HANA usage scenario does not require SAP HANA XS. What do you have to consider before you remove the SAP HANA XS service from the configuration? There are 3 correct answer...

Which of the following are characteristics of a design-time role? There are 2 correct answers to this question. Choose:

Which of the following can you use to analyze an expensive SQL statement? There are 2 correct answers to this question. Choose:

Which of the following must you implement for high availability in an SAP HANA production system? There are 3 correct answers to this question.

You need to replicate data from an SAP ERP production system to SAP HANA. Where does SAP recommend that you install the productive SAP Landscape Transformation (SLT) instance? Plea...

Which of the following components enables SAP HANA high availability? Please choose the correct answer. Choose one:

You need to combine unstructured data from an Apache Hadoop database with data in your SAP HANA system. What do you use to achieve this? Please choose the correct answer.

Which of the following must be installed during the installation of SAP Landscape Transformation (SLT)? There are 2 correct answers to this question.

Which of the following is influenced by the audit level? Please choose the correct answer.