E_HANNAW - Part 03

161 - Which JOIN types can be used in the definition of a Core Data Services (CDS) view? There are 2 correct answers to this question. CROSS JOIN. REFERENTIAL JOIN. LEFT OUTER JOIN. FULL OUTER JOIN. RIGHT OUTER JOIN.

162 - List down the elements involved in User Management and Security in SAP HANA? There are 3 correct answers to this question. Assign job security. Manage users. Assign security. Create users. Work management.

163 - According to the performance analysis recommendations; which steps are recommended after doing a database migration to SAP HANA? Please choose the correct answer. Perform regular performance scans on your ABAP custom coding as part of the development process. Activate your ABAP custom coding, which was deactivated before the database migration, using U transaction SFW5. Switch the storage type of you custom database tables to column store and use the database utility (SE14) to perform the database table conversion. Perform regular performance scans on the ABAP coding delivered by SAP as part of your development process.

164 - What is Core Data Services (CDS)? Please choose the correct answer. A collection of core features and services that provide data from the ABAP application server layer to the user interface. A collection of services for ABAP application programming that provide access to the core features of the SAP HANA database management system. A collection of services that provide information about the data volumes of the SAP HANA core tables. A collection of domain-specific languages and services for definition and consumption of semantically rich data models.

165 - You want to access SAP HANA view CA BOOKINGCOUNT in package ha400.primdb via a native SQL query. Which of the following are correct ways of specifying package path and object name in the FROM clause? There are 2 correct answers to this question. FROM SYS BIC."ha400.primdb/CA BOOKINGS COUNT". FROM "ha400.primdb/CA BOOKINGS COUNT". FROM SYS BIC."ha400.primdb::CA BOOKINGS COUNT". FROM "ha400.primdb::CA BOOKINGS COUNT".

166 - Explain how and when to create calculated columns - Using Graphical Modeling Tools? There are 3 correct answers to this question. The calculation could be an arithmetic or character manipulation. Calculated columns also support non-measure attributes as part of the calculation. It is possible to nest so that one calculated column, in turn, is based on other calculated columns. The calculation will be opened in a read-only mode. Time characteristics based calculation columns.

167 - What is the central goal of using SAP HANA? Please choose the correct answer. To set Priorities for system. Accelerate Performance. Positive Impact on Business. Monitor database for record keeping.

168 - How can you consume a Core Data Services (CDS) view? There are 2 correct answers for this question. Use the ABAP language statement WRITE and the CDS view name as the argument. Use the Data Preview in ABAP Development Tools for SAP NetWeaver. Use the CDS maintenance transaction (SCDSV). Use it as a data source in the FROM clause of an Open SQL query.

169 - In which of the following situations could a row store table be more suitable than a column store table? There are 2 correct answers to this question. The table contains mainly distinct values per column across rows. The table contains text that you want to search. The table contains data that you want to aggregate. The table contains only a small number of records.

170 - Why is a security concept in SAP HANA required? There are 2 correct answers to this question. Editing of SAP HANA data models should only be possible for “Users.” of the model. Need to have selected users in SAP HANA for Information Management. Access to ERP tables must be restricted. Database administration should be restricted to skilled.

171 - What is the scope of the AbapCatalog.Buffering annotation in a Core Data Services (CDS) view? Please choose the correct answer. The elements in the projection list of the CDS view. The entire CDS view. The CDS views used in the FROM clause. The set of key fields specified in the additional annotation AbapCatalog.buffering.numberOfKeyField.

172 - Which task does the ABAP Managed Database Procedure (AMDP) framework perform? Please choose the correct answer. Deploy a new version of the database procedure when the AMDP is first called. Deploy the database procedure whenever the AMDP is called. Deploy the database procedure when the AMDP is first activated. Deploy the database procedure whenever the AMDP is activated.

173 - What are the different types of Calculation View? There are 2 correct answers to this question. OLAP Calculation View. Graphical Calculation View. Scripted Calculation View. Text-Based Calculation.

174 - Which is not a Golden Rule for Open SQL? Please choose the correct answer. Reduce the Database Load. Minimize the Amount of Data Transferred. Keep the result set large. Minimize the Number of Database Accesses.

175 - The SAP HANA state-of-the-art search experience includes full-text search with advanced features like... There are 3 correct answers to this question. Isolation search. linguistic search. freestyle search. ACID search. Fuzzy search.

176 - What must you do when you define and implement an ABAP Managed Database Procedure (AMDP)? There are 3 correct answers to this question. Specify the database system and the language. Mark the AMDP method as a READ-ONLY database procedure. Use scalar types for all AMDP method parameters. Define all method parameters to be passed by value. List all ABAP Dictionary tables used in the procedure body in the USING clause.

177 - You developed an ABAP program using ABAP Development Tools for SAP NetWeaver. How can you execute it? There are 2 correct answers to this question. Call transaction SRUN_ADT and enter the name of the ABAP program. Open the ABAP program in the ABAP Development perspective and execute it using the shortcut FI. In the Project Explorer view, right-click the program and choose Run As - ABAP Application from the context menu. Open the ABAP program in the ABAP Development perspective and execute it using the shortcut F8. Use the Open Development Object dialog (CTRL+SHIFT+A) and enter <Program_Name>/Execute in the search field.

178 - SAP HANA: Delivers Across 5 Dimensions. These five dimensions lead to certain goals HANA has to meet. What are these goals? There are 2 correct answers to this question. Hybrid data and management system. Analytical DBMS features. High Performance and Scalability. Support for system tables.

179 - What all are the factors involved in Working with ADT? There are 3 correct answers to this question. ABAP Class. Module interface. ABAP interface. ABAP programs. Workbench programs.

180 - Which components can be a part of a calculation view? There are 3 correct answers to this question. Tables. Attribute View. BAPIs. Analytic View.

181 - What are the supported joins in CDS view? There are 2 correct answers to this question. Inner join. Operators joint. Left outer join. Upper join.

182 - What do you understand by The SAP HANA Software Optimization? Please choose the correct answer. Huge potential for hybrid database. Speed up the processing within the database. Bring logic to where the data is calculated first, then only move to results. Provide combinations of Objects and Partitioning.

183 - In addition to closing the result set, what does the CLOSE method of the CL_SQL_RESULT_SET class when using ABAP Database Connectivity (ADBC) do? Please choose the correct answer. Release resources. Update packages. Update resources. Release packages.

184 - You have created a CDS view and used alias names for some of its elements. In which of the following cases is the alias name mandatory? There are 3 correct answers to this question. SUM(revenue) AS total_revenue. CAST('USO' AS abap.cuky) AS currency_key. ASSOCIATION TO sflight AS _flights. crtdby AS created_by. CASE order type WHEN 'A' THEN 1 ELSE 0 END AS order_type.

185 - Which of the SQL performance rules become more important with SAP HANA? There are 2 correct answers to this question. Minimize search overhead. Keep unnecessary load away from DB. Keep the result set small. Minimize number of database accesses. Minimize amount of transferred data.

186 - You analyze SQL Monitor data in transaction SQLMD. You know that program X accesses database table Y. You made sure that program X was executed while the SQL Monitor collected its data. But the relevant database access is NOT listed in SQLMD. What could be the reason? There are 3 correct answers to this question. The data has NOT yet been transferred to the SQL Monitor database tables. Program X was executed in the background. SQL Monitor was activated with a fitter that excludes database table Y. Database table Y is a buffered table. SQL Monitor was activated for a specific application server.

187 - You implement an ABAP-managed database procedure (AMDP). Within this AMDP, you want to query data from calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400.primdb. How can you address the calculation view? There are 2 correct answers to this question. "ha400.primdb::CA_BOOKINGS_COUNT". "ha400.pr mdb/CA_BOOKINGS_COUNT". _SYS_ BIC."ha400.prirndb/CA_BOOKINGS_COUNT". _SYS_ BIC."ha400.primdb::CA_BOOKINGS_COUNT".

188 - In ADT which setting below to a specific project rather than the entire workbench? Please choose the correct answer. Editor shortcut options. Statement Template options. Code completion option. Code formatting option.

189 - What are the two different kinds of Identifiers used to represent names used in SQL statement? There are 2 correct answers to this question. Limited identifiers. Undelimited Identifiers. Numeric identifiers. Delimited identifiers.

190 - What is the Limitations of ALV for SAP HANA? There are 3 correct answers to this question. Without currency / unit consideration. Restricted to 5000 records / unit. Restricted to 10,000 records. All unit / currency restricted to 10,00,00 records. No unit / currency split if aggregating amounts / currency values.

191 - What is the main purpose of Analytic Privilege? Please choose the correct answer. Restrict row level access so that user will be able to see only certain portion of the data. Restrict users to access database tables. Restrict user to access modeling view.

192 - In an ABAP Core Data Services (CDS) view, what must you do to expose an association for use in another CDS view? Please choose the correct answer. Include all fields used in the ON condition in the project on list. Specify an alias for the target entity. Define the cardinality for the target entity. Specify the other views in which the association can be used.

193 - What is the main function of Static Code Analysis? Please choose the correct answer. Integrates with SAP Solution Manager. Integrated into ABAP Development Tools and ABAP Workbench. ABAP source code with performance optimization potential. To detect code that would lead to functional or performance issues When migrating to SAP HANA.

194 - You want to implement business logic on the database layer. Which approach do you follow when implementing an ABAP Managed Database Procedure? Please choose the correct answer. The Left-Right approach. The Inside-Out approach. The Near-Far approach. The Top-Down approach.

195 - You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause? There are 3 correct answers to this question. CE function used in the procedure body. AMDP used in the procedure body. ABAP Dictionary table used in the procedure body. ABAP Dictionary views used in the procedure body. SAP HANA views used in the procedure body.

196 - How many result sets are returned when an SAP HANA database procedure is called using the CALL. WITH OVERVIEW statement? Please choose the correct answer. Two result sets. As many result sets as there are input parameters in the procedure. One result set. As many result sets as there are table output parameters in the procedure.

197 - Which recent software innovations are applied in SAP HANA? There are 3 correct answers for this question. Insert Only approach. Automated de-installation at system shutdown. Random Undefined Multi-Memory Swapping (RUMMS). Columnar data storage. Improved data compression algorithms.

198 - Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA? There are 2 correct answers to this question. Parallel processing. Database table compression. Partitioning. Columnar data storage.

199 - Name the views that are available to administer and monitor one or several SAP HANA systems? There are 2 correct answers to this question. The Security view. The System Monitor view. The Landscape view. The Administration view.

200 - In order to get language-specific data, which join is used in SAP HANA? Please choose the correct answer. It is not possible to fetch language-specific data in HANA. Text Join. Language Join. Referential Join.

201 - You import an ABAP workbench request into an SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package ZHA400_00. WHICH PREREQISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database? There are 2 correct answers to this question. Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK. PACKAGE ZHA400_00 HAS deployment Mode A. SYSTEM P81 has SAP HANA as primary database. View CA_CUSTOMER has deployment mode A.

202 - What can you include in the projection list of a Core Data Services (CDS) view? There are 3 correct answers to this question. Aggregation functions over fields of ABAP Dictionary tables used in the FROM clause. A field from the structural output of an ABAP Managed Database Procedure used in the FROM clause. ABAP system fields such as sy-langu or sy-mandt / CI String constants and literal values. A field from the projection list of another CDS view used in the FROM clause.

203 - You changed an SAP HANA object that you transported using an SAP HANA Transport container. You want to release the transport request with your changes. In which sequence do you perform activities in the ABAP development system immediately before the release? Please choose the correct answer. Open the package Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container. Open the ABAP transport request Select take snapshot and Save Activate the SAP HANA transport container. Open the SAP HANA delivery unit Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container. Open the SAP HANA transport container Select take snapshot and Save Activate the SAP HANA Transport Container.

204 - What are the ABAP development guidelines? There are 2 correct answers to this question. Improved hybrid components for SAP HANA. Extensions to ABAP Language. Improved tools for performance analysis. Consuming Only ABAP contents for SAP HANA.

205 - What is the purpose of an ABAP project in ABAP Development tools for eclipse? There are 2 correct answers to this question. It represents the connection to the SAP HANA server. It represents the connection to an ABAP system. It provides access to all ABAP repository objects in an ABAP system. It is used to transport ABAP repository objects.

206 - How SAP HANA supports SQL? There are 3 correct answers to this question. As a Data Calculator. As a means to define. Transferring data. Manipulate data. Read.

207 - What is the operating system supported by HANA? There are 2 correct answers to this question. Red Hat Enterprise Linux (RHEL). SUSE Linux Enterprise Server. Only Windows 8. Both Linux and Window 8.

208 - What are the principles of Using HANA Transport Containers properly? There are 3 correct answers to this question. To create Transport container of delivery unit. Takes a ‘snapshot’ of all SAP HANA objects of delivery unit. Release of Transport request. Automatic update for all export methods. Import of Transport Request.

209 - An Analytic Privilege consists of several restrictions. What are they? There are 3 correct answers to this question. Validity restrictions. Cube restrictions. Analytic restrictions. View restrictions. Activity restrictions.

210 - Which of the following are performance recommendations when using SAP HANA? There are 2 correct answers to this question. Move data-intensive calculations from the database to an application server. Filter data in lower layers. Avoid transferring large result sets between database and client applications. Define indexes on the columns that are used in calculations.

211 - What are the two types of editors available in ADT? There are 2 correct answers to this question. Client (native). Eclipse (native). SAP (GUI). ABAP (native).

212 - What are the Performance Rules and Guidelines for ABAP on SAP HANA? There are 2 correct answers to this question. It is beneficial to move data-intensive calculations into the database. To Keep all the loads away from the DB. It is beneficial for maximizing your search into database. To reduce main memory consumption and to improve insert performance.

213 - Explain The Authorization Concept and the types of privileges associated with it? There are 3 correct answers to this question. Analytic privileges. Object privileges. System privileges. Delta privileges. Application privileges.

214 - What are the elements of ABAP Database Integration? There are 3 correct answers to this question. Other DB. DB client-server. Application server. DB For ABAP. Client database handling.

215 - Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in the Classical ABAP workbench? There are 3 correct answers to this question. External view. ABAP program containing new Open SQL. Full-text index. Core Data service (CDS) view. Database procedure proxy.