A financial services company is building a calculation view to analyze loan application data. A key requirement is to dynamically filter the view by `Loan_Type` at runtime. The list of loan types is stored in a master data table, `T_LOAN_TYPES`, and should be presented to the user as a value help dialog. Which type of input parameter should be configured to meet this requirement?
A data engineer is designing a data provisioning strategy for an SAP HANA Cloud system. The source is a non-SAP OLTP database that requires real-time, trigger-based change data capture (CDC). The data must be physically stored in SAP HANA Cloud and undergo transformations before being consumed by analytical models. Which technologies and components are required to implement this solution? (Select TWO)
During a performance review of a calculation view, an architect notices that a filter on the `Transaction_Year` column is being applied very late in the data flow, after a costly join between a 20-billion-row fact table and several dimension tables. The fact table is partitioned by range on `Transaction_Year`. What is the most effective technique to ensure the filter is applied as early as possible to leverage partition pruning?
True or False: In an SAP HANA calculation view, a calculated column defined within an aggregation node is computed *before* the aggregation function (e.g., SUM, COUNT) is applied.
A data modeler needs to build a calculation view that displays the Top 5 salespersons by revenue for each sales region. Which calculation view node is specifically designed to handle this type of partitioned ranking requirement?
An administrator is setting up security for a human resources data model. A requirement states that managers can only see employee data for individuals within their own department. The user-to-department mapping is stored in a separate authorization table. Which security object in SAP HANA is designed to enforce this type of dynamic, attribute-based row-level security?
A developer is building a project in the SAP Web IDE for SAP HANA. After completing the development of several calculation views, they need to make them available in the target HANA database schema. What is the standard process in the SAP Web IDE to deploy the design-time artifacts from the project to create runtime objects in the database?
A developer needs to create a calculation view that combines sales data from two different regions, North America and Europe. The data for each region is stored in separate tables (`SALES_NA`, `SALES_EU`) with identical structures. Which node should be used to combine these two tables into a single dataset?
A data engineer is using a SQLScript table function as a data source in a calculation view. The table function contains complex, imperative logic with loops and conditional statements. During performance testing, this calculation view is identified as a major bottleneck. What are the likely reasons for the poor performance? (Select TWO)
A business analyst needs to see sales data for the current year-to-date (YTD) and the previous year-to-date (PYTD) side-by-side. A data engineer is tasked with creating this logic in a calculation view. Which SQL feature is best suited for fetching a value (like sales amount) from a previous row based on a specific ordering and partitioning?