PABA2

40. You select a field flight_date with type DATS in the field list of a CDS view. Which of the following expressions returns the 2-digit month from the field? Note: There are 2 correct answers to this question. left(right( flight_date, 6), 2). substring( flight_date, 5, 2). right(left( flight_date, 6), 2). substring( flight_date, 4, 2).

41.Which of the following is a technique for defining access controls?. Casting. Redefiniton. Singleton. Inheritance.

42. Given the following code excerpt that defines an SAP HANA database table: Which field is defined incorrectly? define table demo_table { key field1 : REFERENCE to abap.clnt(3); key field2 : abap.char(1332); @semantics.quantity.unitOfmeasure : 'demo_table.field4' field3 : abap.quan(2); field4: abap.unit(2); }. field2. field4. field3. field1.

43. Given the following Core Data Services View Entity Data 1. Definition, DEFINE VIEW ENTITY demo_cds_view_entity 2. AS SELECT FROM spfli 3. { 4. cityfrom, 5. cityto, 6. carrid, 7. connid 8. } when you attempt to activate the definition, what will be the response?. Activation error due to missing annotation "@AbapCatalog.sqlViewName". Activation error due to missing annotation "@AccessControl.authorizationCheck". Activation will be successful. Activation error due to no key defined.

44.Which of the following actions cause an indirect change to a database table requiring a table conversion? Note: There are 2 correct answers to this question. Changing the field labels of a data element that is used in the table definition. Shortening the length of a domain used in a data element that is used in the table definition. Deleting a field from a structure that is included in the table definition. Renaming a field in a structure that is included in the table definition.

45.In CDS views, what do joins and associations have in common? Note: There are 2 correct answers to this question. The data sources are linked using an ON clause. The field list can include fields of the linked table without specifying the name of the corresponding data source. They can expose an entire data source without listing individual fields. An alias can be assigned to the data sources and to the fields in the field list.

46.You want to define the following CDS view entity with an input parameter: • define view entity Z_CONVERT • with parameters i_currency : ??? Which of the following can you use to replace "???"? Note: There are 2 correct answers to this question. A built-in ABAP type. A built-in ABAP Dictionary type. A data element. A component of an ABAP Dictionary structure.

47.Which of the following Core Data Services built-in functions returns a result of type INT4? Note: There are 2 correct answers to this question. dats_days_between. dats_is_valid. dats_add_months. dats_add_days.

48.Which of the following types of Core Data Services Views can be used at the consumption layer? Note: There are 3 correct answers to this question. Table Function. Analytical Query. Transactional Interface. Transactional Query. Hierarchy.

49.In class ZCL_CLASS_A, you use the statement DATA var TYPE *** What may stand in place of ***? Note: There are 2 correct answers to this question. The name of a domain from the ABAP Dictionary. The name of a type defined privately in class ZCL_CLASS_A. The name of a data element from the ABAP Dictionary. The name of a type defined privately in another class.

50.Given the following Core Data Service View Entity Data Definition, when you attempt to activate the definition , what will be response ?. Activation error because the key fields of the union do not match. Activation error because the field types of the union do not match. Activation successful. Activation error because the field names of the union do not match.

51.What is the purpose of a foreign key relationship between two tables in the ABAP Dictionary?. To document the relationship between the two tables. To create a corresponding foreign key relationship in the database. To ensure the integrity of data in the corresponding database tables.

52.Give the following Core Data Service view entity data definition: ...SELECT * FROM demo_cds_param_view_entity( p_date = '20230101’) .... SELECT FROM demo_cds_param_view_entity( p_date: 20230101’) ... ...select from demo_cds_param_view_entity( p_date = @( i_abap_context_info=>get_system_date())... SELECT FROM demo_cds_param_view_entity( p_date: $session.system_ date) ....

53. you have attached a system field to an input parameter of a cds view entity as follows: • define view entity Z_ENTITY with parameters • @Environment.SystemField: #SYSTEM_LANGUAGE • language :spras... What are the effects of this annotation? Note: There are 2 correct answers to this question. It is no longer possible to pass your own value to the parameter. The value of sy-langu will be passed to the CDS view automatically both when you use the CDS view in ABAP and in another CDS view entity (view on view). The value of sy-langu will be passed to the CDS view automatically when you use the CDS view in ABAP but not when you use it in another view entity. You can still override the default value with a value of your own.

54.Which of the following are reasons that SAP recommends developing Core Data Services view entities as opposed to classic Core Data Services DDIC-based views? Note: There are 2 correct answers to this question. Simpler and stricter syntax. Simplified syntax check. Automated client handling. Elimination of the need for a database view.

55.To which of the following rules must extensions in SAP S/4HANA, public cloud edition adheres? Note: There are 2 correct answers to this question. Use CI/CD pipelines. Use predefined extension points. Use released APIs. Build at the UX layer.

56.Which of the following integration frameworks have been released for ABAP cloud development? Note: There are 3 correct answers to this question. CDS Views. Business Add-ins (BAdls). SOAP consumption. Business events. OData services.

57.Which of the following are reasons to use the side-by-side extensibility pattern? Note: There are 3 correct answers to this question. An extension enhances an existing SAP Fiori UI. An extension is managed independently from SAP S/4HANA. An extension uses its own data model with occasional consumption of data in SAP S/4HANA. An extension implements reactive (event based) process extensions. An extension runs in the same logical unit of work (LUW) as an SAP S/4HANA application.

58.Which of the following are personas under the SAP S/4HANA Cloud Extensibility Framework? Note: There are 2 correct answers to this question. Workflow Administrator. Citizen Developer. Report Writer. Business Expert.

Which of the following custom code use cases falls under Tier 1 extensibility guidelines?. Apply an SAP note with manual corrections, for example a DDIC object from SAP Basis. Create a wrapper class around SAP objects that have not been released yet. Create a custom field on a DB table or CDS view via a released extension include. Implement a user or customer exits, for example SAPMV45A.

60. Which of the following are rules that extensions in SAP S/4HANA Cloud, public edition must adhere to? Note: There are 3 correct answers to this question. Use tier 2 wrappers to enable access to non-released SAP APIs. Use released remote or local SAP APIs. Use cloud-enabled and released technologies. Modify SAP objects in exceptional cases only. Extend SAP objects through predefined extension points.

61.What can you do in SAP S/4HANA Cloud, public edition? Note: There are 2 correct answers to this question. Use Web Dynpros. Use ABAP Development Tools in Eclipse (ADT). Modify SAP objects. Use SAP-released extension points.

62.Which of the following enforce ABAP Cloud rules? Note: There are 2 correct answers to this question. ABAP platform reuse services. ABAP compiler. ABAP runtime checks. ABAP release contracts.

63.Which of the following models must you use to develop artifacts that expose ABAP-based backend services based on semantic data models? Note: There are 2 correct answers to this question. ABAP Programming Model for SAP Fiori. Cloud Application Programming Model. ABAP RESTful application programming model. ABAP Cloud Development Model.

64.What are some features of ABAP SQL? Note: There are 2 correct answers to this question. It is integrated in the ABAP programming language. It is first processed by the Database Interface. It is only valid on the HANA database. It is directly executed on the HANA database.

65. Which of the following rules apply for dividing with ABAP SQL? Note: There are 3 correct answers to this question. Numeric function division( nominator, denominator, decimal places) accepts floating point input. • SELECT FROM TABLE dbtab1 • FIELDS f1, division( f2, f3, 2) ... The division operator "/" accepts decimal input. • SELECT FROM TABLE dbtabi • FIELDS f1, f2 / f3 ... The division operator "/" accepts floating point input. • SELECT FROM TABLE dbtab1 • FIELDS f1, f2f3... Numeric function div( nominator, denominator) expects only integer input. • SELECT FROM TABLE dbtab1 • FIELDS f1, div( f2, f3 ) ... Numeric function division( nominator, denominator, decimal places) accepts decimal input. • SELECT FROM TABLE dbtab1 • FIELDS f1, division( f2, f3,2) ...

66.Which of the following ABAP SQL aggregate functions accept an ABAP SQL expression (e.g. f1 +f2) as input? Note: There are 2 correct answers to this question. max(). avg(). sum(). count(*).

67. In a CDS view, where can a value help be defined?. In the SQL console. In a view definition. In an annotation. In an association.

You want to extract date information of a flight date (f_info) and format it like yyyy-dd-mm using the following code: Select from table dbtab1 FEILDS f1, extract_year( f_info ) && extract_month( f_info ) && '-' && extract_day( f_info ) ... For the extract_*functions to work, what can be the data dictionary types of f_info? Note: There are 3 correct answers to this question. TIMESTAMP. TIMN. UTCLONG. DATS. TIMS.

69.When you join two database tables, which of the following rules applies to the database fields you use in the join?. They must be compared with an ON condition. They must have the same name, e.g. col1 = col1. They must always have an alias name. They must be the same position in their table, for example left_table-col1 = right_table-col1.

70.Which of the following are valid ABAP SQL type conversions? Note: There are 3 correct answers to this question. CAST ('field_f1' as CHAR (8)) AS f_chars. CAST (29 as INT8) AS f_int8. CAST (field_f2 as N (8)) AS f_n8. CAST (34 as I) AS f_i34. CAST (field_f5 as DEC (15,2)) AS f_dec_15_2.

71.You want to join two database tables, T_CARRIER, and T_CONNECTIONS, to retrieve all carriers, whether they have corresponding connections or not. Which statements would achieve this? Note: There are 2 correct answers to this question. SELECT FROM carrier LEFT OUTER JOIN t_connectionsON... SELECT FROM carrier INNER JOIN t_connections ON... SELECT FROM connections RIGHT OUTER JOIN t_carrier ON... SELECT FROM carrier LEFT INNER JOIN t_connectionsON..

72.In a RESTful Application Programming object, where is the validation implementation code contained?. Function. Local class. Subroutine. Global class.

73.Which language is used to add or change data of a business object in RESTful Application Programming?. Entity manipulation language. RAP editing language. Data modification language. Data manipulation language.

74.In what order are objects created to generate a RESTful Application Programming application?. Projection view. A Data model view. Service Binding. A Database table. Service Definition.

75.Which RESTful Application Programming object can be used to organize the display of fields in an app?. Projection view. Metadata extension. Data model view. Service definition.

76.What RESTful Application Programming feature is used to ensure the uniqueness of a semantic key?. Action. Determination. Validation.

77.hat RESTful Application Programming object contains only the fields required for a particular app?. Projection view. Database view. Data model view. Metadata extension.

78.In RESTful Application Programming, a business object contains which parts? Note: There are 2 correct answers to this question. Authentication rules. Behavior definition. Process definition. CDS view.

79.After you created a database table in the RESTful Application Programming model, what do you create next?. A data model view. A service definition. A metadata extension. A projection views.

80.Setting a field to read-only in which object would make the field read-only in all applications of the RESTful Application Programming model?. Projection view. Behaviour definition. Service definition. Metadata extension.