SAP C_HANATEC_1 Certified Technology Associate Practice Exam Set 2

Which tool do you use for complex data transformation of SAP ERP data?


Options are :

  • Sybase Replication Server
  • SAP Landscape Transformation (SLT)
  • SAP BusinessObjects Explorer
  • SAP BusinessObjects Data Services (Correct)

Answer : SAP BusinessObjects Data Services

You need to create a role that allows read-only access to the tabs of SAP HANA Administration Editor. Which of the following privileges do you need to assign to that role? (Choose two)


Options are :

  • SQL privilege SELECT for the SQL object SYS_STATISTICS (Correct)
  • System privilege SERVICE_ADMIN
  • System privilege DATA_ADMIN (Correct)
  • System privilege CONTENT_ADMIN

Answer : SQL privilege SELECT for the SQL object SYS_STATISTICS System privilege DATA_ADMIN

Which of the following do you add when you "scale out" SAP HANA?


Options are :

  • Servers (Correct)
  • Memory
  • CPUs
  • Data storage

Answer : Servers

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


Options are :

  • 55113
  • 35100
  • 35115 (Correct)
  • 31551

Answer : 35115

Which new connection type is available as of SAP BusinessObjects Data Services 4.0?


Options are :

  • Operational data provider (Correct)
  • Read table via ABAP data flows
  • BAPI function calls
  • IDOCs

Answer : Operational data provider

In Microsoft Windows, to which folder are the logs written by default during the SAP HANA studio installation?


Options are :

  • %USERNAME%\hdb_studio_
  • %USERPROFILE%\hdb_studio_
  • %TEMP%\hdb_studio_ (Correct)
  • C:\Program Files (x86)\hdb_studio_

Answer : %TEMP%\hdb_studio_

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 system into SAP HANA?


Options are :

  • Import data from the SAP ERP system into SAP HANA
  • Create a connection in SAP BusinessObjects Data Services to the SAP ERP system.
  • Import the metadata from SAP HANA into SAP BusinessObjects Data Services. (Correct)
  • Create an SAP BusinessObjects Data Services job to migrate data to SAP HANA.

Answer : Import the metadata from SAP HANA into SAP BusinessObjects Data Services.

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? (Choose three)


Options are :

  • Assign values to be restricted to a content table.
  • Assign the analytic privilege to a user or role. (Correct)
  • Assign values to be restricted. Choose at least one information model to assign restrictions. (Correct)
  • Choose an attribute and define restricted values for it. (Correct)

Answer : Assign the analytic privilege to a user or role. Assign values to be restricted. Choose at least one information model to assign restrictions. Choose an attribute and define restricted values for it.

In which of the following situations is a recovery of an SAP HANA database applicable? (Choose three)


Options are :

  • Corruption of kernel binary files
  • Reset of the system to a specific point in time (Correct)
  • Disk crash of the data area (Correct)
  • Disk crash of the log area (Correct)

Answer : Reset of the system to a specific point in time Disk crash of the data area Disk crash of the log area

Which of the following are required to monitor SAP HANA in SAP Solution Manager? (Choose two)


Options are :

  • Host agent running on SAP HANA (Correct)
  • SMD agent running on SAP Solution Manger
  • Host agent running on SAP Solution Manager
  • SMD agent running on SAP HANA (Correct)

Answer : Host agent running on SAP HANA SMD agent running on SAP HANA

Which of the following Information Platform Services components must you install for Data Services 4.0? (Choose two)


Options are :

  • Auditing Proxy Processing Service
  • File Repository Server (Correct)
  • Platform Processing Services (Correct)
  • Monitoring Processing Server

Answer : File Repository Server Platform Processing Services

Which of the following components enables SAP HANA high availability?


Options are :

  • Statistics server
  • Name server (Correct)
  • Index server
  • Preprocessor server

Answer : Name server

Which of the following privileges do you need to activate views?


Options are :

  • SELECT option on the _SYS_REPO schema (Correct)
  • SELECT option on the _SYS_BIC schema
  • SELECT option on the _SYS_BI schema
  • SELECT option on the _SYS schema

Answer : SELECT option on the _SYS_REPO schema

Which of the following URLs do you define for Software Update Manager?


Options are :

  • http://:8444/studio_repository/
  • https://:8444/studio_repository/
  • https://:8443/studio_repository/ (Correct)
  • http://:8443/studio_repository/

Answer : https://:8443/studio_repository/

Which of the following are functions of the DB trigger within SAP Landscape Transformation (SLT)? (Choose two)


Options are :

  • Record relevant changes in logging tables. (Correct)
  • Decluster table classes into a transparent format.
  • Include only relevant tables for DB recording. (Correct)
  • Ensure that replicated changes are kept within the logging tables

Answer : Record relevant changes in logging tables. Include only relevant tables for DB recording.

When you try to stop SAP HANA using the sapcontrol command, you receive the error messagE. "Command not found". What is the reason for the error?


Options are :

  • The SAP HANA database is not installed.
  • SAP SUM is not installed.
  • The SAP HANA client is not installed.
  • The host agent is not installed. (Correct)

Answer : The host agent is not installed.

What type of data is transferred between the SAP HANA database and end user clients?


Options are :

  • Configuration models
  • Application data (Correct)
  • Configuration data
  • Data models

Answer : Application data

Which driver is required for the connection between SAP HANA and SAP BusinessObjects Explorer?


Options are :

  • JDBC (Correct)
  • BICS
  • ODBO
  • ODBC

Answer : JDBC

Which of the following source data sizes should you use to size SAP HANA memory?


Options are :

  • Total compressed size of source database
  • Total uncompressed size of source database
  • Total uncompressed size of tables required for queries (Correct)
  • Total uncompressed size of tables and indexes required for queries

Answer : Total uncompressed size of tables required for queries

Which security settings can you apply in analytic privileges? (Choose two)


Options are :

  • Restrict access within an analytic view using measure values.
  • Restrict access to hierarchies.
  • Grant access to analytic views. (Correct)
  • Restrict access within an analytic view using attribute values (Correct)

Answer : Grant access to analytic views. Restrict access within an analytic view using attribute values

Which of the following can be imported into and exported from SAP HANA studio? (Choose three)


Options are :

  • SQL statements
  • Landscape (Correct)
  • Tables (Correct)
  • Models (Correct)

Answer : Landscape Tables Models

Which of the following is used to deploy SAP-delivered content in SAP HANA?


Options are :

  • SAP Transport Management System (STMS)
  • SAP NetWeaver Development Infrastructure (NWDI)
  • Server-side export/import (Correct)
  • Java Support Package Management (JSPM)

Answer : Server-side export/import

What must you configure in Data Services 4.0 to establish a connection to SAP ERP?


Options are :

  • A DB connection
  • An RFC connection
  • An InfoObject
  • A datastore (Correct)

Answer : A datastore

Your customer wants to implement an SAP product that:Provides near real-time replication to SAP HANA,Connects SAP HANA to a non-SAP source system and SAP BW, and Uses SAP BW extractors.What do you recommend?


Options are :

  • SAP Landscape Transformation (SLT
  • SAP Legacy System Migration Workbench (LSMW)
  • SAP BusinessObjects Data Services 4.0 (Correct)
  • Sybase Replication Server

Answer : SAP BusinessObjects Data Services 4.0

Which of the following components must be installed in SAP HANA to enable SAP Early Watch Alerts? (Choose two)


Options are :

  • Host agent (Correct)
  • CCMS agent
  • Collection script (Correct)
  • SMD agent

Answer : Host agent Collection script

In SAP HANA, what is the recommended memory size you must reserve for dynamic objects?


Options are :

  • The same size as the memory required for static data (Correct)
  • The same size as the uncompressed source data
  • The same size as the total size of the log files
  • The same size as the total size of the data files

Answer : The same size as the memory required for static data

In addition to the in-memory database, which of the following technologies are part of SAP HANA? (Choose two)


Options are :

  • Diskless data storage
  • Columnar store (Correct)
  • Massive parallel processing (Correct)
  • Asymmetric multi-processing

Answer : Columnar store Massive parallel processing

Which of the following files should be considered in your SAP HANA backup strategy? (Choose three)


Options are :

  • Dump files
  • Configuration files (Correct)
  • Data and log files (Correct)
  • Kernel files (Correct)

Answer : Configuration files Data and log files Kernel files

Of the databases that can be used for Data Services 4.0, which of the following is bundled with Information Platform Services (mini-BOE)?


Options are :

  • MySQL
  • SAP MaxDB
  • MS SQL Server Express (Correct)
  • SYBASE Adaptive Server Enterprise

Answer : MS SQL Server Express

Which of the following must be shared by SAP HANA nodes in a high availability scenario?


Options are :

  • Virtual host name
  • Shared memory
  • Storage (Correct)
  • Network

Answer : Storage

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions