QUESTION NO: 1
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?
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?
Correct Answer: A
Vote an answer
QUESTION NO: 2
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?
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?
Correct Answer: C
Vote an answer
QUESTION NO: 3
You source table has a revenue column and a quantity column for each month. You want to transform this data to get a table containing twelve rows whit two columns.
What is the best way to achieve this in SAP Data services?
You source table has a revenue column and a quantity column for each month. You want to transform this data to get a table containing twelve rows whit two columns.
What is the best way to achieve this in SAP Data services?
Correct Answer: C
Vote an answer
QUESTION NO: 4
You need to import metadata and extract data from an SAP ERP system using SAP Data Services. Which type of datastore must you use?
You need to import metadata and extract data from an SAP ERP system using SAP Data Services. Which type of datastore must you use?
Correct Answer: B
Vote an answer
QUESTION NO: 5
You want to set up a new SAP Data Services landscape. You must also create new repositories. Which repository types can you create?
You want to set up a new SAP Data Services landscape. You must also create new repositories. Which repository types can you create?
Correct Answer: A
Vote an answer
QUESTION NO: 6
You want to display the description of an object in the Designer workspace-Which task must you perform to accomplish this in SAP Data services?
3 correct answers
You want to display the description of an object in the Designer workspace-Which task must you perform to accomplish this in SAP Data services?
3 correct answers
Correct Answer: B,D,E
Vote an answer
QUESTION NO: 7
You create a file format in SAP Data Services
What properties can you set for a column?
Note: There are 3 correct answers to this question.
You create a file format in SAP Data Services
What properties can you set for a column?
Note: There are 3 correct answers to this question.
Correct Answer: B,D,E
Vote an answer
QUESTION NO: 8
How do you desing a data load that has good performance and deals with interrupted loads in SAP Data services?
How do you desing a data load that has good performance and deals with interrupted loads in SAP Data services?
Correct Answer: A
Vote an answer
QUESTION NO: 9
How would you use the View Optimized SQL feature to optimize the SQL feature to optimize the performance of the dataflow?
How would you use the View Optimized SQL feature to optimize the SQL feature to optimize the performance of the dataflow?
Correct Answer: A
Vote an answer