Updated Mar-2024 C_DS_42 Free Exam Files Downloaded Instantly
Practice Exams and Training Solutions for Certifications
NEW QUESTION # 30
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?
- A. Execute the job and review the target table in SQL.
- B. Execute the job and review the monitor during execution.
- C. Execute the job that enables the Trace Optimized Dataflow property.
- D. Execute the job in debug mode with breakpoints set and enabled.
Answer: D
NEW QUESTION # 31
In addition to the main databases for source information, records for orders are stored in flat files. You need to extract data from these flat files, and so must create the appropriate file format for the extraction. Create a file format Orders_Format for an orders flat file so that you can use it as a source object for extraction. (Validate the correct statement).
- A. In the Local Objects Library, choose Formats tab.
- B. Enter Orders_Format as the format name.
- C. Right click your new file format Orders_Format and choose View Data .
- D. Right click the Flat Files node and choose New.
Answer: A,B,D
NEW QUESTION # 32
In SAP Data Services which basic operations can you perform with a Query transform?
- A. Flag rows for update
- B. Map Columns from an input schema to an output schema"
- C. "Apply functions to columns"
- D. "Join data from several sources"
- E. Set a global variable to a value
Answer: C
NEW QUESTION # 33
Where is an SAP Data Services job executed?
- A. Designer application
- B. Access server
- C. Job server
- D. Management console
Answer: C
NEW QUESTION # 34
Which type of SAP Data Services object can a project, job, dataflow or workflow contain? 3 correct answers
- A. A dataflow can contain a workflow
- B. A job can contain a job
- C. A workflow can contain a workflow
- D. A Project can contain a job
- E. A job can contain a workflow
Answer: A,B,D
NEW QUESTION # 35
What does the data services repository os SAP Data services contain?
There are 2 correct answers to this question
- A. in flight data
- B. User security
- C. Transformation rules
- D. Target metadata
Answer: C
NEW QUESTION # 36
You must ensure that all records from the Customer table in the Alpha database are being moved to the Delta staging database using the audit logs.
In the Local Object Library, replicate the Alpha_NACustomer_DF data flow.
Name the replicated data flow Alpha_AuditCustomer_DF . Add the replicated data flow to a new job, Alpha_AuditCustomer_Job . Set up auditing on the data flow Alpha_AuditCustomer_DF by adding an audit rule to compare the total number of records in the source and target tables.
How to Save all changes and execute the job with auditing enabled and Trace Audit Data set to Yes
- A. In the Trace tab, choose Trace Audit Data .
- B. In the Execution Properties dialog box, in the Execution Options tab, select the Enable auditing checkbox.
- C. In the Value field, using the drop down list, change the value to Yes.
- D. To remove the existing audit rule, choose Delete
- E. Right-click the Alpha_AuditCustomer_Job and choose Execute .
- F. Choose Add and select Custom .
Answer: A,B,C,E
NEW QUESTION # 37
You created and saved a database datastore in SAP Data Services. Which properties can you change in the Edit Datastore dialog box?
- A. user name and password
- B. database name
- C. database version
- D. Datastore name
- E. database server name
Answer: A
NEW QUESTION # 38
You are asked to perform either the initial load or delta load based on the value of a variable that is set at job execution How do you desing this requirement in SAP Data services.
- A. Use a job containing a script with the if thenelse () function to test the variable value. Connect this script to the initial and delta u dataflow.
- B. Use a job containing a Case transform testing for the two possible conditions. Connect one case output to the initial dataflow and the other to the delta dataflow Use a job container the delta dataflow
- C. Set the job to call the initial and delta dataflow in parallel. Each dataflow should hace a filter testing for the variable value.
- D. Use a job containing a Conditional objet that test the value of the variable. In the IF part, call the initial dataflow in the ELSE part call
Answer: D
NEW QUESTION # 39
Which SAP Data Services transforms would you use in a dataflow to load a slowly changing dimension of type 2?
- A. Effective_Date
- B. Table_Comparison
- C. Row_Generation
- D. Key_Generation
- E. History_Preserving
Answer: B,D,E
NEW QUESTION # 40
What are task's of data Services uses the SAP RFC Server Interface?
- A. Scheduling SAP jobs
- B. None of above
- C. Reading from SAP Open Hub destinations
- D. Viewing Data Services logs from SAP NetWeaver BW
- E. Loading SAP NetWeaver BW
Answer: A,C,D,E
NEW QUESTION # 41
By which application you do Evaluate the reliability of your target data based on the validation rules you created in your batch jobs. Quickly review, assess, and identify potential inconsistencies or errors in source data?
- A. Operational Dashboard
- B. Administrator
- C. Impact and Lineage Analysis
- D. Auto Documentation
- E. Data Quality Reports
- F. Data Validation Dashboard
Answer: F
NEW QUESTION # 42
Which connection does Management Console use to repositories?
- A. Internet Connection
- B. Server Connection
- C. JDNC Connection
- D. JDBC connection
Answer: D
NEW QUESTION # 43
You are loading a database table using SAP Data Services. Which loading options are valid?
- A. Data transfer method
- B. Rows per commit
- C. Include in transaction
- D. Abap execution option
- E. Number of loader
Answer: B
NEW QUESTION # 44
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?
Please choose the correct answer.
- A. Use multiple Query transforms with one WHERE? clause per rule.
Connect all queries to the source.
. Use a Case transform with the Row Can Be True for One Case
Only and Preserve Expression Order options enabled. - B. se a Case transform with the Produce Default Output with Label option enabled, and enable the Preserve Expression Order checkbox.
- C. Use a Validation transform and add the rules in the proper order for each single column.
Answer: B
NEW QUESTION # 45
You have a map operation transform immediately before the target in a data flow in Sap Data Services. What happens if all operation codes are mapped to Discard in the transform?
- A. They are flagged for later deletion
- B. They are filtered by the transform
- C. They are deleted from the target
- D. They are added to the overflow file
Answer: B
NEW QUESTION # 46
You define audit rules for critical data flow to confirm that you SAP Data Services batch job loaded only correct dat a. Which audit functions are available to define these rules for columns? Note: There are 3 correct answers
- A. Count distinct
- B. Min
- C. Average
- D. sum
- E. Checksum
Answer: C,D,E
Explanation:
There are four Audit Functions available in BODS.
* COUNT function helps to get the audit information on a table or output schema. The default datatype is INTEGER.
* SUM function helps to generate audit information like summation of measure type columns. E.g. Revenue. Accepted datatypes are INTEGER, DECIMAL, DOUBLE, REAL.
* AVERAGE function helps to generate audit information like average of measure type columns. E.g. Profit Margin. Accepted datatypes are INTEGER, DECIMAL, DOUBLE, REAL.
* CHECKSUM function helps to audit based on the hash values generated for VARCHAR datatype columns. The order of rows is important for the result of CHECKSUM function.
https://blogs.sap.com/2013/09/18/auditing-in-sap-data-services/
NEW QUESTION # 47
What task can you perform in the SAP Data Services Management Console? Note: There are 3 correct answers to this question
- A. Display trace and monitor and error logs.
- B. Schedule a job for daily execution
- C. View the rows and the values being loaded
- D. Debug a dataflow to find data issues
- E. Display the optional Validation Transform statistics
Answer: B,D,E
NEW QUESTION # 48
What is the relationship between local variables and parameters in SAP Data Services? 2 correct answers
- A. a parameter in a job set the value of a local variable in a dataflow
- B. a local variable in a workflow sets the value of an a parameter in a dataflow.
- C. a parameter in a workflow sets the value of a local variable in a dataflow
- D. 3 local variable in a job sets the value of an a parameter in a workflow
Answer: B
NEW QUESTION # 49
......
Q&As with Explanations Verified & Correct Answers: https://www.testkingfree.com/SAP/C_DS_42-practice-exam-dumps.html
Dumps Free Test Engine Player Verified Answers: https://drive.google.com/open?id=1MA9T_9cs3gpKwCIC-hlQOpsxjaeHluaN