Practice Free C_DS_43 Exam Online Questions
You modified an existing SAP data Services job. You notice that the run time is now longer then expected. Where in SAP Data Services can you observe the progress of row counts to determine the location of a bottleneck
- A . On the view data tab
- B . In the impact and lineage analysis
- C . In the monitor log
- D . In the trace log
You built a delta load dataflow in SAP Data Services. This Dataflow is executed every night. The source table contains a CHANGE_DATE column which is populated by the database when the row is saved.
What can a timestamp based CDC aproach identify in the source based on this CHANGE_DATE column
- A . Inserted and updated rows but not delete rows
- B . Insert, updates and deletes for a specified time range.
- C . Update rows but NOT insert or deleted records.
- D . Every single change made to a row
Which repository types are used in SAP Data Services? 2 correct
- A . Central Repository
- B . Data repository
- C . Profiler repository
- D . Remote Repository
A new developer joined the project team. You already created a new SAP Data Services repository for this member.
Where do you manage the security setting for this new repository?
- A . Data Services Designer
- B . Central Management console
- C . Repository manager
- D . Repository database
You want to load data from an input table to an output table using the SAP Data Services Query transform.
How do you define the mapping of the columns within a Query transform?
- A . Drag one column from the input schema to the output schema
- B . Select an output column and enter the mapping manually.
- C . Drag one column from the output schema to the input schema
- D . Select one input column and enter the mapping manually
What operation can you push down to the database using a data transfer transform in SAP Data Services? 3 answers correct
- A . Custom function
- B . XML function
- C . Join
- D . Ordering
- E . Distinct
An SAP Data Services Validation transform outputs all invalid rows. If more than ten rows are invalid, the data is considered to be failed.
How do you implement this?
- A . Create an auditing rule that raises an exception
- B . Raise an exception in a Conditional connected to the target table.
- C . Set a breakpoint on the line connected to the target table.
- D . Use the raise_exception function in the validation transform.
What are standard component of SAP Data services? There are 3 correct answers
- A . Job server
- B . Design studio
- C . Secure local repository
- D . Access server
- E . Real time services
In SAP Data Services which basic operations can you perform with a Query transform?
- A . "Join data from several sources"
- B . "Apply functions to columns"
- C . Map Columns from an input schema to an output schema"
- D . Flag rows for update
- E . Set a global variable to a value
A Map operation transform in SAP Data Services was used to modify the operation code of data is being processed.
Why do you perform this action?
- A . To ensure compatibility with subsequent transforms
- B . To push the data down for better performance
- C . To increase the speed that the database loads
- D . To control how the data is loaded.