C_DS_42 by SAP Actual Free Exam Q&As

Question 1

You created and saved a database datastore in SAP Data Services. Which properties can you change in the Edit Datastore dialog box? There are 2 correct answers

A. database server name B. user name and password C. database name D. database version E. Datastore name

Discussion 0

Correct Answer: B,C Vote an answer

Question 2

In SAP data services what does the date generation transform allow you to generate?

A. The current date for a column to see when each row was loaded. B. The rows for a given date range C. the valid from date based on a dataset the contains valid to information only D. the valid to date based on a dataset the contains valid to information only

Discussion 0

Correct Answer: B Vote an answer

Question 3

What are advantages of using the validation transform in SAP Data services? There are 3 correct answers to this question

A. You can set different failed paths for each rule B. You can see which rules were violated in one output C. You can call a recovery dataflow D. You can produce statistics E. You can have multiple rules on a single column.

Discussion 0

Correct Answer: A,B,E Vote an answer

Question 4

What is the SAP Data services Dataflow auditing feature used for? Note: There are 2 correct answers to this question.

A. To view the data as it is processed by the dataflow in order to ensure its correctness B. to define rules that each record processed by the dataflow has to comply with C. To define rules based on the number of records processed overall once the dataflow is finished D. To count the number of rows processed at user defined points to collect runtime statistics

Discussion 0

Correct Answer: B,D Vote an answer

Question 5

You import a table from a database into a datastore.
Which information is added into the SAP Data Services repository?

A. The complete metadata information of the table B. The table name and all column names with their dataypes. C. Only the table name D. The whole table with all its source data

Discussion 0

Correct Answer: A Vote an answer

Question 6

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. Set a breakpoint on the line connected to the target table. C. Raise an exception in a Conditional connected to the target table. D. Use the raise_exception function in the validation transform.

Discussion 0

Correct Answer: A Vote an answer

Question 7

You have to load a file that contains the following first three lines:
YEAR; MONTH; PLAN_AMOUNT
2014;01;100.00
2014;02;110.00
What setting do you use when you created a file format for this?

A. Type: Delimited column delimiter:<blank> skip row headen: yes B. Type: Delimited column delimiter:; skip row headen: yes C. Type: Fixed column length:4,2 and 6 skip row headen: yes D. Type: Delimited column delimiter:; skip row headen: no

Discussion 0

Correct Answer: B Vote an answer

Question 8

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. Central Management console B. Repository manager C. Repository database D. Data Services Designer

Discussion 0

Correct Answer: A Vote an answer

SAP Certified Application Associate - Data Integration with SAP Data Services 4.2 - C_DS_42 Exam Practice Test