Updated May-2023 Exam Engine for C-DS-42 Exam Free Demo & 365 Day Updates
Exam Passing Guarantee C-DS-42 Exam with Accurate Quastions!
NEW QUESTION # 10
The performance of a dataflow is slow in SAP Data Services.
How can you see which part of the operations is pushed down to the source database? Note: the are 2 correct answers to this question.
- A. By opening the dataflow and using the view optimized SQL feature.
- B. By starting the job in debubg mode.
- C. by opening the auto documentation page in the Data Services Management Console
- D. By enabling corresponding trace options in the job execution dialog.
Answer: D
NEW QUESTION # 11
Why would you specify Recover as a Unit in the property of a workflow in SAP Data Services?
- A. To ensure that each dataflow is recovered as a separate unit during the recovery execution
- B. To ensure that all objects of the workflow are executed during recovery including the steps that were executed successfully in the prior run
- C. To ensure that the workflow is skipped during recovery if the workflow was executed successfully in the prior run.
- D. To ensure that all dataflow of the workflow are executed in one single transaction during recovery
Answer: B
NEW QUESTION # 12
Which syntax rules must you follow in the SAP
Data Services scripting language?
- A. A statement ends with a dot sign (.).
- B. A comment starts with a hash (#).
- C. A variable starts with a dollar sign ($).
- D. A variable starts with a percent sign (%).
Answer: B,C
NEW QUESTION # 13
In SAP data services what does the date generation transform allow you to generate?
- A. The rows for a given date range
- B. the valid from date based on a dataset the contains valid to information only
- C. The current date for a column to see when each row was loaded.
- D. the valid to date based on a dataset the contains valid to information only
Answer: A
NEW QUESTION # 14
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. Enter Orders_Format as the format name.
- B. In the Local Objects Library, choose Formats tab.
- C. Right click the Flat Files node and choose New.
- D. Right click your new file format Orders_Format and choose View Data .
Answer: A,B,C
NEW QUESTION # 15
In which parameter the number of seconds to sleep before the Data Profiler checks for completion of an invoked task. Invoked tasks run synchronously, and the Data Profiler must check for their completion?
- A. Invoke sleep interval (seconds)
- B. Inactive interval (minutes)
- C. Submit sleep interval (seconds)
- D. Active Interval (Seconds)
Answer: A
NEW QUESTION # 16
You executed a job in development enviroment and it raised primary key violation error in SAP Data Services.
Which feature do you enable to identify wich primary key values caused the errors?
- A. Auto correct load
- B. Drop and re-created target table
- C. delete data before loading
- D. Use overflow file
Answer: D
NEW QUESTION # 17
What do you call for that particular link of Clicking to exit the Management Console application and Data Services software, and display the log in page?
- A. Question mark icon
- B. Settings
- C. Home
- D. Logout
Answer: D
NEW QUESTION # 18
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 Enable auditing for the execution of the Alpha_AuditCustomer_Job .
- A. Under Action on failure, select the Raise exception checkbox.
- B. Right-click the Alpha_AuditCustomer_Job .
- C. Choose Execute .
- D. In the Execution Properties dialog box, choose the Execution Options tab, and select the Enable auditing checkbox.
- E. Choose the Trace tab and choose Trace Audit Data .
Answer: B,C,D,E
NEW QUESTION # 19
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. Sum(Account_type)
- C. Gen_Row_Num()
- D. Count(*)
Answer: B
NEW QUESTION # 20
What is the relationship between local variables and parameters in SAP Data Services? 2 correct answers
- A. a parameter in a workflow sets 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. 3 local variable in a job sets the value of an a parameter in a workflow
- D. a parameter in a job set the value of a local variable in a dataflow
Answer: B
NEW QUESTION # 21
How to Use a WHERE clause to select only customers in North America
(North American countries are United States, Canada, and Mexico which have COUNTRYID values of 1, 2,and 11)?
- A. Enter the where clause, customer.COUNTRYID in (1,2,11)
- B. In the Query editor, choose the WHERE tab
- C. Confirm that 22 records were loaded
- D. To save all changes, choose OK
Answer: A,B
NEW QUESTION # 22
The value of the DEPT ID is null
What is the output of this SAP Data Services function?
- A. CA
- B. ?
- C. IS
- D. null
Answer: B
NEW QUESTION # 23
Where is an SAP Data Services job executed?
- A. Access server
- B. Job server
- C. Management console
- D. Designer application
Answer: B
NEW QUESTION # 24
You want to load data from an input table to an output table using the SAP Data Services Query transform. How do you define the mapping of the columns within a Query transform?
- A. Select an output column and enter the mapping manually.
- B. Drag one column from the output schema to the input schema
- C. Drag one column from the input schema to the output schema
- D. Select one input column and enter the mapping manually
Answer: D
NEW QUESTION # 25
What does the expression SUBSTR(FIRST NAME, 1,3) return?
- A. U
- B. IRS
- C. M
- D. FIR
Answer: D
NEW QUESTION # 26
________for the user account through which SAP
Data Services connects to this SAP application server.
- A. Password
- B. User Name
- C. SAP application server name
- D. Client number
Answer: A
NEW QUESTION # 27
In which parameter the number of minutes a profiling task can be inactive before the Data Profiler cancels it?
- A. Inactive interval (minutes)
- B. Submit sleep interval (seconds)
- C. Active Interval (Seconds)
- D. Invoke sleep interval (seconds)
Answer: A
NEW QUESTION # 28
You built a delta load dataflow in SAP Data Services. This Dataflow is executed every night. The source table contains a CHANGE_DATE column which is populated by the database when the row is saved.
What can a timestamp based CDC aproach identify in the source based on this CHANGE_DATE column
- A. Insert, updates and deletes for a specified time range.
- B. Update rows but NOT insert or deleted records.
- C. Every single change made to a row
- D. Inserted and updated rows but not delete rows
Answer: D
NEW QUESTION # 29
You decide to distribute the execution of a job across multiple job servers within a server group. What distribution levels are avaible?
3 answers correct
- A. Embedded dataflow
- B. subdataflow
- C. Dataflow
- D. workflow
- E. JOB
Answer: E
NEW QUESTION # 30
You want to use on SAP data services transform to split your source vendor data into three branches, based on the country code.
Which transform do you use?
- A. Map_Operation transform
- B. Country ID transform
- C. Validation transform
- D. Case transform
Answer: D
NEW QUESTION # 31
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: Fixed column length:4,2 and 6 skip row headen: yes
- B. ype: Delimited column delimiter:; skip row headen: no
- C. Type: Delimited column delimiter:<blank> skip row headen: yes
- D. Type: Delimited column delimiter:; skip row headen: yes
Answer: D
NEW QUESTION # 32
What are SAP data services scripts used for? There are 2 correct answers to this question
- A. To perform job initialization tasks to print the job variable values into the trace log using the print() function.
- B. To execute single SQL commands using the sql() function to select a value from a status table for the variable.
- C. To set the desired properties, for example, trace options, monitor sample rate, and the use statistics for optimization flag.
- D. To write complex transformation logic using the flexibility of the scripting language.
Answer: B,D
NEW QUESTION # 33
What does the data services repository os SAP Data services contain?
There are 2 correct answers to this question
- A. in flight data
- B. Transformation rules
- C. User security
- D. Target metadata
Answer: B
NEW QUESTION # 34
......
Exam Questions for C-DS-42 Updated Versions With Test Engine: https://www.actualpdf.com/C-DS-42_exam-dumps.html
Test Engine to Practice Test for C-DS-42 Valid and Updated Dumps: https://drive.google.com/open?id=1K7B5873ILb0na2V_9SLmr6Xw12-FNvVE
