C_HANATEC_11 Exam Questions

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

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

Which security settings can you apply in analytic privileges? There are 2 correct answers to this question. Response:

Which tasks can you perform using the resident SAP HANA lifecycle management tool? There are 3 correct answers to this question. Response:

You execute an authorization trace in the SAP HANA studio. Where can you review the outcome? Please choose the correct answer. Response:

Which of the following memory indicators can you reset to measure the impact of a new workload on memory usage? Please choose the correct answer. Response:

When you try to create a delivery unit from the SAP HANA studio you receive the following error message. 'Cannot create Delivery Unit as content vendor is not defined for this syst...

Which of the following Kerberos implementations is supported for single sign-on in SAP HANA? There are 2 correct answers to this question. Response:

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

SAP Support needs to access a customer's SAP HANA studio remotely. Which entry must the client maintain in SAP Service Marketplace? Please choose the correct answer. Response:

The statistics server was stopped during an upgrade by the system administrator. Which of the following parameters in statisticsserver.ini do you modify to restart the statistics s...

What must you do to configure SAP HANA high availability? Please choose the correct answer. Response:

Which of the following Information Platform Services components must you install for Data Services 4.0? There are 2 correct answers to this question. Response:

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

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

Which feature is supported by the backup and recovery process within the standard delivery of SAP HANA? Please choose the correct answer. Response:

What does the save point process in SAP HANA do? Please choose the correct answer. Response:

You are using the Change and Transport System (CTS) with SAP HANA. When is the transport strategy determined? Please choose the correct answer. Response:

Which tools can you use to monitor the query time from SAP HANA? Please choose the correct answer. Response:

Which component of SAP HANA Database is used when you query an SAP HANA information model to populate a pivot table in Microsoft Excel? Please choose the correct answer. Response:

The log volume is full and the SAP HANA database does not accept any new requests. How can you solve this problem and bring the SAP HANA database online? Please choose the correct...

Which authorization error do you troubleshoot using the Authorization Dependency Viewer? Please choose the correct answer Response:

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

Which of the following are required to enable SAP HANA high availability? There are 2 correct answers to this question. Response:

A backup catalog became unusable. What can you do to recover existing backups? Please choose the correct answer. Response:

How can you delete old data and log backups from both the backup catalog and physically from the server? Please choose the correct answer. Response:

What do you have to consider when you design a backup plan? There are 2 correct answers to this question. Response:

Which of the following SAP HANA tools is used to collect diagnostic information? Please choose the correct answer. Response:

You have created a file named backup.sql with the following information to run a backup: /c -n <server name> -i<instance number> -u <user> -p <password> BACKUP DATA USING FILE ('ba...

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

You need to retrieve data from SAP HANA that is restricted to a certain region and specific users. How can you implement this security strategy? Please choose the correct answer. R...

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

Which of the following users allow you to install SAP HANA studio on a Windows client platform? There are 2 correct answers to this question. Response:

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

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

Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying database? Please choose the correct answer. Response:

You are investigating a problem with the SAP HANA database. You opened a customer message with SAP support. SAP support asks you to provide diagnostic information from the SAP HANA...

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

Which of the following connection types does Direct Extractor Connection (DXC) use to transfer data to SAP HANA? Please choose the correct answer. Response:

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

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

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

Which parameters do you change to configure the trace file rotation? There are 2 correct answers to this question. Response:

Which of the following components must be installed in SAP HANA to enable SAP Early Watch Alerts? There are 2 correct answers to this question. Response:

How can you make space available inside the log volume in a productive SAP HANA system? Please choose the correct answer. Response:

You have to size an SAP HANA system for SAP NetWeaver BW. The SAP NetWeaver BW system is currently running on a non-SAP RDBMS. Which of the following factors influences the size of...

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. Response:

You want to create a role that grants read-only access to the content of the system and monitoring views and to statistics services. Which of the following privileges should the ro...

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. Response:

You installed SAP HANA Database using 51 as your system number. Which network port is used for Standard SQL communication for client access? Please choose the correct answer. Respo...