Updated Dec 01, 2023 Verified Pass C-DS-42 Exam in First Attempt Guaranteed
Free C-DS-42 Sample Questions and 100% Cover Real Exam Questions (Updated 82 Questions)
NEW QUESTION # 13
You want to back up an SAP Data Services repository. How does the system store repositories?
- A. As tables in a relational database management system
- B. As an XML file on the data services job server
- C. As an binary file on the Data servives job server
- D. As an XML file on the Data services Access Server
Answer: A
NEW QUESTION # 14
Which connection does Management Console use to repositories?
- A. JDNC Connection
- B. Internet Connection
- C. JDBC connection
- D. Server Connection
Answer: C
NEW QUESTION # 15
What task can you perform in the SAP Data Services Management Console? Note: There are 3 correct answers to this question
- A. View the rows and the values being loaded
- B. Schedule a job for daily execution
- C. Display the optional Validation Transform statistics
- D. Display trace and monitor and error logs.
- E. Debug a dataflow to find data issues
Answer: C
NEW QUESTION # 16
You decide to distribute the execution of a job across multiple job servers within a server group. What distribution levels are available? 3 answers correct
- A. workflow
- B. JOB
- C. Embedded dataflow
- D. subdataflow
- E. Dataflow
Answer: B,D,E
Explanation:
Select the level within a job that you want to distribute to multiple Job Servers for processing:
Job: The whole job will execute on an available Job Server.
Data flow: Each data flow within the job can execute on an available Job Server.
Sub data flow: Each sub data flow (can be a separate transform or function) within a data flow can execute on an available Job Server.
For more information, see "Using grid computing to distribute data flows execution" in the Performance Optimization Guide.
NEW QUESTION # 17
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 one input column and enter the mapping manually
- B. Select an output column and enter the mapping manually.
- C. Drag one column from the input schema to the output schema
- D. Drag one column from the output schema to the input schema
Answer: A
NEW QUESTION # 18
In SAP Data Services which basic operations can you perform with a Query transform?
- A. Flag rows for update
- B. Set a global variable to a value
- C. "Join data from several sources"
- D. Map Columns from an input schema to an output schema"
- E. "Apply functions to columns"
Answer: E
NEW QUESTION # 19
How to Save and execute the Alpha_NACustomer_Job?
- A. In the Project Area , right click the Alpha_NACustomer_Job and choose Execute & To accept the default execution properties, choose OK
- B. In the Query editor, choose the WHERE tab
- C. In the main menu, choose Project Save All & To save all changes, choose OK
- D. To return to the Job workspace, in the tool bar, choose the Back icon & To return to the Data Flow workplace, double click the Data Flow.
Answer: A,C,D
NEW QUESTION # 20
Which repository types are used in SAP Data Services? 2 correct
- A. Profiler repository
- B. Remote Repository
- C. Data repository
- D. Central Repository
Answer: A
NEW QUESTION # 21
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. 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. Choose Add and select Custom .
- F. In the Trace tab, choose Trace Audit Data .
Answer: A,B,C,F
NEW QUESTION # 22
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 # 23
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 In the transform editor for the Query transform, propose a join between the two source tables.
- A. To open the Query Editor double click the Query .
- B. To connect the Query Transform, select the Query Transform , hold down the mouse button, drag it to the order_sum table, and release the mouse button.
- C. Choose the Where tab or the From tab.
- D. the Propose Join button.
Answer: A,C,D
NEW QUESTION # 24
What operations can be pushed down in SAP Data Services?
- A. join operations between a file and a database table
- B. Join operations between sources that are on the same database servers
- C. Aggregation operations used with a group by statement
- D. Load operations that contain trigger
Answer: B
NEW QUESTION # 25
In the Alpha Acquisitions database, the country for a customer is stored in a separate table and referenced with a code. To speed up access to information in the data warehouse, this lookup should be eliminated.
Use the lookup_ext function to exchange the ID for the country name in the customers table for Alpha with the actual value from the country table.
How to In the Alpha_NACustomer_DF workspace, delete an existing expression for the Country column in the Query transform.
- A. In the Mapping tab for the Country field, delete the existing expression.
- B. In the Select Function dialog box, choose Lookup Functions.
- C. In the Mapping tab, choose Functions.
- D. In the Query Editor, in the output schema, choose the field Country.
- E. the Alpha_NACustomer_DF workspace, to open the transform editor, double click the Query transform.
Answer: A,D,E
NEW QUESTION # 26
________for the user account through which SAP
Data Services connects to this SAP application server.
- A. Password
- B. Client number
- C. SAP application server name
- D. User Name
Answer: A
NEW QUESTION # 27
Where does An administrator sets user permissions?
- A. Central Management Server (CMS)
- B. Management Console navigation
- C. Data Services Management Console
- D. Management Console
Answer: A
NEW QUESTION # 28
An SAP Data Services dataflow adds the changed data (insert and update) into a target table every day.
How do you design the dataflow to ensure that a partially executed dataflow recovers automatically the next time it is executed?
2 correct answers
- A. Use the table comparison transform before the table loader
- B. Set the autocorrect load option in the target table loader option
- C. Enable the Delete data before load target table loader option
- D. Add lookup function in the where clause to filter out existing rows.
Answer: A,D
NEW QUESTION # 29
In which parameter the number of minutes a profiling task can be inactive before the Data Profiler cancels it?
- A. Active Interval (Seconds)
- B. Submit sleep interval (seconds)
- C. Invoke sleep interval (seconds)
- D. Inactive interval (minutes)
Answer: 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. Sum(Account_type)
- D. Count(*)
Answer: C
NEW QUESTION # 31
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. query
- B. History Preserving
- C. Key generation
- D. Map operation
Answer: B,D
NEW QUESTION # 32
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. Min
- B. Checksum
- C. Count distinct
- D. sum
- E. Average
Answer: B,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 # 33
What operation can you push down to the database using a data transfer transform in SAP Data Services? 3 answers correct
- A. Join
- B. XML function
- C. Ordering
- D. Distinct
- E. Custom function
Answer: A,C,D
NEW QUESTION # 34
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 Create a new batch job Alpha_AuditCustomer_Job .
- A. Rename the copied data flow Alpha_AuditCustomer_DF.
- B. Choose New Batch Job
- C. In the Local Object Library Data Flow tab right click the
- D. Name the new job Alpha_AuditCustomer_Job .
- E. Right click the Omega project in the Project Area.
- F. Alpha_NACustomer_DF data flow and choose Replicate .
Answer: A,B,E
NEW QUESTION # 35
An SAP Data Services dataflow has validation error.
What is the cause?
- A. The source data does NOT comply with the rules entered in the Validation transform
- B. The source data is incorrect and the dataflow therefore requires a validation transform.
- C. The dataflow has a syntax error that has to be correct before executing it.
- D. A conversion is missing
Answer: C
NEW QUESTION # 36
......
Download Real SAP C-DS-42 Exam Dumps Test Engine Exam Questions: https://passguide.dumpexams.com/C-DS-42-vce-torrent.html