C-DS-42 Free Exam Study Guide! (Updated 80 Questions)
C-DS-42 Dumps for SAP Certified Application Associate Certified Exam Questions and Answer
NEW QUESTION 29
You build a Data Warehouse with a date dimension in SAP Data Services. You decide to use the Date Generation transform to create this. What options are available to control the output form the transform?
- A. Effective date column
- B. Julian format
- C. end date
- D. Increment
Answer: C
NEW QUESTION 30
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?
- A. Use twelve query transform to create the desired output. Then combine these transforms.
- B. Use the merge transform that is connected to the source
- C. Use the pivot transform with two pivot sets.
- D. Use the query transform with multiple IFTHENELSE() functions.
Answer: C
NEW QUESTION 31
You executed a job in development environment and it raised primary key violation error in SAP Data Services. Which feature do you enable to identify which primary key values caused the errors?
- A. Use overflow file
- B. Drop and re-created target table
- C. Auto correct load
- D. delete data before loading
Answer: A
NEW QUESTION 32
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 Create a new batch job and data flow, called
Alpha_Marketing_Offer_Job and _Marketing_Offer_DF respectively, and a new global variable
$G_Num_to_Qual.
- A. In the project area, right click the Omega project and choose New batch job
- B. In the tool palette, select the Data Flow icon and click in the workspace.
- C. Enter the name Alpha_Marketing_Offer_DF.
- D. Enter the name Alpha_Marketing_Offer_Job.
- E. In the Smart Editor, choose the Variables tab.
- F. Right click Parameters and choose Insert.
Answer: A,B,C,D
NEW QUESTION 33
An SAP data services job was executed in the past.
Where can you see the order that the dataflows were executed in?
There are 2 correct answers to this question.
- A. In the job server log
- B. In the impact and Lineage Analysis report
- C. In the job trace log.
- D. In the operational dashboard
Answer: C
NEW QUESTION 34
Which SAP Data Services transforms would you use in a dataflow to load a slowly changing dimension of type 2?
- A. Row_Generation
- B. Effective_Date
- C. History_Preserving
- D. Key_Generation
- E. Table_Comparison
Answer: C,D,E
NEW QUESTION 35
The value of the DEPT ID is null
What is the output of this SAP Data Services function?
- A. null
- B. IS
- C. ?
- D. CA
Answer: C
NEW QUESTION 36
Management Console is written in which language?
- A. Html
- B. Java
- C. XML
- D. .net
Answer: B
NEW QUESTION 37
How to Save and execute the job, Alpha_Product_Job?
- A. In the main menu, choose Project Save All
- B. In the Project Area, right click the Alpha_Product_Job.
- C. To save changes, choose OK .
- D. Choose New Batch Job
- E. Choose Execute.s
- F. To accept the default execution properties, choose OK
Answer: A,B,C,E
NEW QUESTION 38
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. Define the column as varchar and use functions in subsequent Query transform to perform the checks and conversion
- B. Use the error handling options for conversion error in the file format definition
- C. Place the dataflow between a Try/Catch block to catch all erroneous rows
- D. Specify a date format of'????-??-??' to indicate the value might NOT be a valid date in the file format editor
Answer: C
NEW QUESTION 39
By which application you do Manage your production environment including batch job execution, real-time services, web services, adapter instances, server groups, central repositories, profiler repositories, and more?
- A. Data Quality Reports
- B. Data Validation Dashboard
- C. Administrator
- D. Impact and Lineage Analysis
- E. Auto Documentation
- F. Operational Dashboard
Answer: C
NEW QUESTION 40
What transform can you use to change the operation code from UPDATE to INSERT in SAP Data Services?
Note: There are 2 correct answers to this question
- A. Map operation
- B. History Preserving
- C. Key generation
- D. query
Answer: B
NEW QUESTION 41
In which parameter the number of seconds to sleep before the
Data Profiler attempts to start pending tasks. Pending tasks have not yet started because the maximum number of concurrent tasks was reached?
- A. Submit sleep interval (seconds)
- B. Active Interval (Seconds)
- C. Inactive interval (minutes)
- D. Invoke sleep interval (seconds)
Answer: A
NEW QUESTION 42
In SAP Data Services which basic operations can you perform with a Query transform?
- A. Map Columns from an input schema to an output schema"
- B. "Join data from several sources"
- C. Flag rows for update
- D. Set a global variable to a value
- E. "Apply functions to columns"
Answer: E
NEW QUESTION 43
Which syntax rules must you follow in the SAP
Data Services scripting language?
- A. A variable starts with a percent sign (%).
- B. A variable starts with a dollar sign ($).
- C. A statement ends with a dot sign (.).
- D. A comment starts with a hash (#).
Answer: B,D
NEW QUESTION 44
To ensure that your job is processing the data correctly, you wan to run the job in debug mode. To minimize the data you have to review in the interactive debugger, you set the debug option process to show only records from an individual CountryID field value.
In the Cloud/WTS environment, the Designer will not allow multiple users to share the interactive debugger port. Change the interactive debugger port in Designer options.
- A. From the Designer options, choose Environment
- B. In the Interactive Debugger field, enter port number 60XX . A dialog box with the message
"Overwrite job server option parameters (BODI1260099)" opens. To continue, choose Yes & click ok - C. From the main menu, choose Tools Options
- D. In the Filter window, select the Set checkbox
Answer: A,B,C
NEW QUESTION 45
A Map operation transform in SAP Data Services was used to modify the operation code of data is being processed. Why do you perform this action?
- A. To control how the data is loaded.
- B. To ensure compatibility with subsequent transforms
- C. To push the data down for better performance
- D. To increase the speed that the database loads
Answer: C
NEW QUESTION 46
What operation can you push down to the database using a data transfer transform in SAP Data Services? 3 answers correct
- A. Distinct
- B. Join
- C. Custom function
- D. XML function
- E. Ordering
Answer: B
NEW QUESTION 47
What is the relationship between local variables and parameters in SAP Data Services? 2 correct answers
- A. a local variable in a workflow sets the value of an a parameter in a dataflow.
- B. a parameter in a job set the value of a local variable 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: A,D
NEW QUESTION 48
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. Right-click the Alpha_AuditCustomer_Job and choose Execute .
- B. Choose Add and select Custom .
- C. In the Trace tab, choose Trace Audit Data .
- D. To remove the existing audit rule, choose Delete
- E. In the Value field, using the drop down list, change the value to Yes.
- F. In the Execution Properties dialog box, in the Execution Options tab, select the Enable auditing checkbox.
Answer: A,C,E,F
NEW QUESTION 49
What requirement must you meet when mapping an output column on the SAP Data Services query transform mapping tab?
- A. All columns of the input schema must be mapped to the output schema
- B. Primary keys in the input schema must be mapped to only one column in the output schema
- C. Each column in the output schema must be mapped to one or more columns in the input schema
- D. Every column of the output schema must have a mapping
Answer: C
NEW QUESTION 50
Which connection does Management Console use to repositories?
- A. Server Connection
- B. JDNC Connection
- C. Internet Connection
- D. JDBC connection
Answer: D
NEW QUESTION 51
What are standard component of SAP Dataservices? There are 3 correct answers
- A. Secure local repository
- B. Design studio
- C. Job server
- D. Access server
- E. Real time services
Answer: A,C,D
NEW QUESTION 52
You want to set up a new SAP Data Services landscape. You must also create new repositories. Which repository types can you create?
- A. Backup repository
- B. Central repository
- C. Standy repository
- D. Profiler repository
- E. Local repository
Answer: D
NEW QUESTION 53
......
Use Real C-DS-42 Dumps - 100% Free C-DS-42 Exam Dumps: https://troytec.itpassleader.com/SAP/C-DS-42-dumps-pass-exam.html