SAP C-ABAPD-2507 real exam prep : SAP Certified Associate - Back-End Developer - ABAP Cloud

Given the following Core Data Service view entity data definition:
@AccessControl.authorizationCheck: #NOT_REQUIRED
DEFINE VIEW ENTITY demo_cds_param_view_entity
WITH PARAMETERS
p_date : abap.dats
AS SELECT FROM sflight
{
key carrid,
key connid,
key fldate,
price,
seatsmax,
seatsocc
}
WHERE fldate >= $parameters.p_date;
Which of the following ABAP SQL snippets are syntactically correct ways to provide a value for the parameter on line #4?
Note: There are 2 correct answers to this question.

• A. SELECT * FROM demo_cds_param_view_entity( p_date = @(
  cl_abap_context_info=>get_system_date( ) ) ) ...
• B. SELECT * FROM demo_cds_param_view_entity( p_date = `20230101` ) ...
• C. SELECT * FROM demo_cds_param_view_entity( p_date = :$session.system_date ) ...
• D. SELECT * FROM demo_cds_param_view_entity( p_date = '20230101' ) ...

Given the following ABAP SQL statement excerpt from an ABAP program:
SELECT SINGLE *
FROM spfli
WHERE carrid = 'LH' AND connid = '0400'
INTO @DATA(wa).
You are given the following information:
* The data source spfli on line #2 is an SAP HANA database table.
* spfli will be a large table with over one million rows.
* This program is the only one in the system that accesses the table.
* This program will run rarely.
Based on this information, which of the following general settings should you set for the spfli database table?
Note: There are 2 correct answers to this question.

• A. "Storage Type" to "Column Store"
• B. "Storage Type" to "Row Store"
• C. "Load Unit" to "Page Loadable"
• D. "Load Unit" to "Column Loadable"

In a booking record, how can you calculate the difference in days between the order date (type D) and the flight date (type D) of a flight?

• A. data(gv_diff_days) = gs_booking-flight_date - gs_booking-order_date.
• B. data(gv_diff_days) = conv d( gs_booking-order_date - gs_booking-flight_date ).
• C. data(gv_diff_days) = conv d( gs_booking-flight_date - gs_booking-order_date ).
• D. data(gv_diff_days) = gs_booking-order_date - gs_booking-flight_date.

When you join two database tables, which of the following rules applies to the database fields you use in the join?

• A. They must always have an alias name.
• B. They must have the same name, e.g. col1 = col1.
• C. They must be compared with an ON condition.
• D. They must be at the same position in their table, for example left_table-col1 = right_table-col1.

In CDS views, what do joins and associations have in common?
(Select 2 correct answers)

• A. An alias can be assigned to the data sources and to the fields in the field list.
• B. The field list can include fields of the linked table without specifying the name of the corresponding data source.
• C. The data sources are linked using an ON clause.
• D. They can expose an entire data source without listing individual fields.