SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
 Apps
X
HANA App
>>>
Hadoop App
>>>
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Apps
HANA App
Hadoop App
';
Search
Stay Connected
Search Topics
Topic Index
+
-
Process and Overview
+
-
HANA Admin Certification
+
-
HANA Modeling Certification
+
-
ABAP for HANA Certifications
+
-
BW on HANA Certifications
+
-
SAPUI5/Fiori Certifications
+
-
SAP Cloud Certifications
+
-
S4HANA Certifications
+
-
SAP BW/4HANA Certifications
+
-
Expired Certifications

SAP Certified Application Associate - Data Integration with SAP Data Services 4.2 - Questions and Answers

In our previous article All about SAP HANA Certifications we provided the list of all SAP HANA certifications and their details. We also provided basic details of the certification C_DS_42 at C_DS_42 Overview.
Now let us see what kind of questions you can expect in this certification.

Note: We highly recommend you to also check below articles:
  1. How to book SAP Certification - Prerequisites, Eligibility and Cost
  2. C_DS_42 Practice Quiz

Certification C_DS_42 - Questions and Answers

Question 1: Your customer has rules requiring that each row in the source be tested for certain criteria in a specific order. When a row passes one criteria, it should NOT be tested for the next criteria. How should this be implemented using SAP Data Services transforms?
  1. Use multiple Query transforms with one WHERE? clause per rule. Connect all queries to the source.
  2. Use a Case transform with the Row Can Be True for One Case Only and Preserve Expression Order options enabled.
  3. Use a Case transform with the Produce Default Output with Label option enabled, and enable the Preserve Expression Order checkbox.
  4. Use a Validation transform and add the rules in the proper order for each single column.
Answer B
Question 2: You want to restore an older version of an object found in a shared object library. Where do you find this version of the object in SAP Data Services?
  1. In the Central repository
  2. In the Local repository
  3. In the Profiler repository
  4. In the Auditing repository
Answer A
Question 3: An SAP Data Services dataflow contains multiple transform objects. The target table contains some unexpected results for one column. How can you review a sample of the data as it passes through each transform?
  1. Execute the job and review the target table in SQL.
  2. Execute the job in debug mode with breakpoints set and enabled
  3. Execute the job that enables the Trace Optimized Dataflow property
  4. Execute the job and review the monitor during execution.
Answer B
Question 4: You have a Salary table containing departments (DEPARTMENT column) and salaries (SALARY column). How do you calculate the average salaries for each department in the Query transform in SAP Data Services? Note: There are 2 correct answers to this question.
  1. Specify the DEPARTMENT column on the GROUP BY tab.
  2. Enter avg(SALARY) on the Mapping tab.
  3. Enter avg(SALARY) on the SELECT tab.
  4. Specify the DEPARTMENT code on the WHERE tab.
Answer A,B
Question 5: You are designing an SAP Data Services process. This process must execute ONLY if a defined expression is true. Which object allows you to accomplish this task?
  1. Validation transform
  2. Try/catch block
  3. Conditional
  4. Case transform
Answer C
Question 6: What are characteristics of SAP Data Services workflows? Note: There are 2 correct answers to this question.
  1. A workflow can call other workflows.
  2. A workflow can contain a conditional object.
  3. A job needs to have at least one workflow.
  4. A workflow must contain a dataflow.
Answer A,B
Question 7: Which syntax rules must you follow in the SAP Data Services scripting language? Note: There are 2 correct answers to this question.
  1. A statement ends with a dot sign (.).
  2. A variable starts with a percent sign (%)
  3. A comment starts with a hash (#)
  4. A variable starts with a dollar sign ($).
Answer C,D
Question 8: Which SAP Data Services transforms would you use in a dataflow to load a slowly changing dimension of type 2? Note: There are 3 correct answers to this question.
  1. Row_Generation
  2. Table_Comparison
  3. Key_Generation
  4. History_Preserving
Answer B,C,D
Question 9: During development of a SAP Data Services dataflow, you find that the source system contains data inconsistencies. What transform allows you to define rules and monitor the conformance of the data for every load?
  1. Validation transform
  2. Query transform
  3. SQL transform
  4. Case transform
Answer A
Question 10: Where is an SAP Data Services job executed?
  1. Access server
  2. Job server
  3. Designer application
  4. Management console
Answer A





Have you got some more sample questions for this certification? Share those in comment section and help others!

What’s Next?


Challenge yourself! Check how much you can score in the exam - C_DS_42 Practice Quiz


Support us by sharing this article.



Explore More
Close X
Close X

Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *

 © 2017 : saphanatutorial.com, All rights reserved.  Privacy Policy