Pass Your SAP Certified Application Associate C_DS_42 Exam on Oct 11, 2023 with 82 Questions
C_DS_42 Free Exam Study Guide! (Updated 82 Questions)
NEW QUESTION # 29
The Marketing department would like to send special offers to customers who have placed a specified number of orders. This can be done by creating a custom function that must be called when a customer order is placed.
You want to create a custom function to accept the input parameters of the Customer ID, and the number of orders required to receive a special order, check the Orders table, and then create an initial list of eligible customers.
How to In the Local Object Library, create a new customer function called CF_MarketingOffer.
- A. Enter the name CF_MarketingOffer, and choose Next.
- B. the Smart Editor, choose the Variables tab.
- C. Enter the name Alpha_Marketing_Offer_Job.
- D. In the Local Object Library, choose the Custom Functions tab.
- E. In the tool palette, select the Data Flow icon and click in the workspace.
Answer: A,B,D
NEW QUESTION # 30
From the account table you want to know how many accounts you have per account type. The ACCOUNT_TYPE is output along with an additional column COUNTER. The group by tab of the query transform is used with ACCOUNT_TYPE. Which mapping would you use for the COUNTER column in SAP Data Services?
- A. count_distinct(Account_TYPE)
- B. Gen_Row_Num()
- C. Count(*)
- D. count(Account_type)
Answer: D
NEW QUESTION # 31
When evaluating the customer data for Alpha Acquisitions, you discover a data entry error.
The contact title of "Account Manager" has been entered as "Accounting Manager". You must correct these entries before it is moved to the data warehouse.
How to Using the Function wizard, create a new expression for the column using the search_replace function found under the category of
"String" functions.
- A. To delete existing expression, in the Mapping tab highlight the expression and press the Delete button on your keyboard.
- B. From the list of function names, select search_replace and choose Next .
- C. In the Select Function dialog box, choose String Functions .
- D. In the Query Editor , in the Mapping tab, choose Functions.
Answer: B,C,D
NEW QUESTION # 32
You are loading a database table using SAP Data Services. Which loading options are valid?
- A. Number of loader
- B. Data transfer method
- C. Include in transaction
- D. Rows per commit
- E. Abap execution option
Answer: D
NEW QUESTION # 33
___________in the SAP RFC destination to which this RFC
Server will connect?
- A. System number
- B. RFC program ID
- C. SAP application server name
- D. Client number
Answer: B
NEW QUESTION # 34
An SAP data services file format has a date column, but occasionally the file contains an invalid value in one row. This causes the dataflow to terminate with an error.
What can you do to completely load such erroneous files?
Note: There are 2 correct answer
- A. Place the dataflow between a Try/Catch block to catch all erroneous rows
- B. Use the error handling options for conversion error in the file format definition
- C. Define the column as varchar and use functions in subsequent Query transform to perform the checks and conversion
- D. Specify a date format of'????-??-??' to indicate the value might NOT be a valid date in the file format editor
Answer: A,D
NEW QUESTION # 35
In SAP Data Services you have a Validation Transform with the following two rules Rule #1: Action on Failure is 'Send to Pas' Rules#2: Action on Failure is 'Send to Fail.
Where are the records that fail both rule #1 and rule #2 sent?
- A. To both the Pass and Fail output
- B. Only to the Fail output
- C. Only to the Pass output
- D. Only to the Rule Violation output
Answer: B
NEW QUESTION # 36
An SAP Data Services dataflow has validation error.
What is the cause?
- A. A conversion is missing
- B. The dataflow has a syntax error that has to be correct before executing it.
- C. The source data is incorrect and the dataflow therefore requires a validation transform.
- D. The source data does NOT comply with the rules entered in the Validation transform
Answer: B
NEW QUESTION # 37
How to Create a new template table alpha_NA_customer
in the Delta datastore as the target object?
- A. In the Create Template dialog box, in the Table name field, enter alpha_NA_customer
- B. Select the customer table from the Alpha datastore.
- C. To add a new template table to the workspace, in the tool palette, choose the Template Table icon, and click the workspace
- D. In the In datastore field, choose Delta from the dropdown list
Answer: A,C,D
NEW QUESTION # 38
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:; skip row headen: yes
- B. Type: Fixed column length:4,2 and 6 skip row headen: yes
- C. Type: Delimited column delimiter:<blank> skip row headen: yes
- D. ype: Delimited column delimiter:; skip row headen: no
Answer: A
NEW QUESTION # 39
You want to execute two dataflows in parallel in SAP Data Services. How can you achieve this?
- A. Create a workflow containing two dataflows and set a degree of parallelism to 2.
- B. Create a workflow containg two dataflows and deselect the execute Only once property of the workflow.
- C. Create a workflow containing two dataflows and connect them with a line.
- D. Create a workflow containing two dataflows without connecting them with a line.
Answer: D
NEW QUESTION # 40
You must calculate the total value of all orders, including their discounts, for reporting purposes. Currently these details are found in different tables.
Use the sum function to calculate the total value of orders in the Order_Details table.
How to create a new batch job called Alpha_Order_Sum_Job with a data flow Alpha_Order_Sum_DF .
- A. Enter the job name Alpha_Order_Sum_Job .
- B. In the Alpha_Order_Sum_Job workspace, from the toolbar, choose the Data Flow icon.
- C. the Project area , right click your Omega project and choose New batch job.
- D. Choose the Where tab or the From tab.
- E. Choose the Propose Join button.
Answer: A,B,C
NEW QUESTION # 41
An SAP Data Services job contains a lot of dataflows and runs for several hours every night. If a job execution fails, you want to skip all successful dataflows and start with the failed dataflow. How do you accomplish this?
There are 2 correct answer
- A. add a try block before each dataflow and a Catch block after each dataflow
- B. Desing the dataflow to ensure a second run does not result in duplicate
- C. Merge the dataflows from the job and rerun it.
- D. Run the nightly job with the enable recovery flag turned on.
Answer: B
NEW QUESTION # 42
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. Set a breakpoint on the line connected to the target table.
- B. Raise an exception in a Conditional connected to the target table.
- C. Create an auditing rule that raises an exception
- D. Use the raise_exception function in the validation transform.
Answer: C
NEW QUESTION # 43
In SAP Data services which function delivers the same results an nested 1FTHENELSE functions?
- A. Match_regex
- B. Decode
- C. Match_Pattern
- D. Literal
Answer: B
NEW QUESTION # 44
......
C_DS_42 Dumps for SAP Certified Application Associate Certified Exam Questions and Answer: https://www.actual4dumps.com/C_DS_42-study-material.html
Realistic Verified C_DS_42 exam dumps Q&As - C_DS_42 Free Update: https://drive.google.com/open?id=1xZtHQry3u0lCpX1GB8y068S-KY_7d-iX