C_DS_42 Exam Dumps - SAP Certified Application Associate Questions and Answers

Create an auditing rule that raises an exception

Raise an exception in a Conditional connected to the target table.

Set a breakpoint on the line connected to the target table.

Use the raise_exception function in the validation transform.

Job server

Design studio

Secure local repository

Access server

Real time services

Match_Pattern

Decode

Literal

Match_regex

To output all rows that match the case statement

to output all rows that do match exactly one case expression

To output all rows to the default path regardless if the they match the case expressions.

To output all rows that do not match any case expression to the default path

The merge transform combines the dataset into 5000 or less output rows.

The merge transform combines the dataset into 5000 output rows

The merge transform joins the datasets using a full outer join

The merge transform require both dataset to have the same structure.

Map_Operation transform

Validation transform

Case transform

Country ID transform

Maximum of two tables

Left outer joins and inner joins

Only equal conditions

Only inner joins

A Project can contain a job

A job can contain a job

A dataflow can contain a workflow

A job can contain a workflow

A workflow can contain a workflow

The rows for a given date range

The current date for a column to see when each row was loaded.

the valid from date based on a dataset the contains valid to information only

the valid to date based on a dataset the contains valid to information only

Enable the Delete data before load target table loader option

Add lookup function in the where clause to filter out existing rows.

Set the autocorrect load option in the target table loader option

Use the table comparison transform before the table loader