SAP C_DS_42 Online Practice Questions and Exam Preparation

SAP C_DS_42 Online Questions & Answers

• Question 71:

  Where is an SAP Data Services job executed?

  A. Access server
  B. Job server
  C. Designer application
  D. Management console
  B. Job server

• Question 72:

  Which syntax rules must you follow in the SAP Data Services scripting language?

  A. A statement ends with a dot sign (.).
  B. A variable starts with a percent sign (%).
  C. A comment starts with a hash (#).
  D. A variable starts with a dollar sign ($).
  C. A comment starts with a hash (#).
  D. A variable starts with a dollar sign ($).

• Question 73:

  How to Connect the source table to the target table?

  A. Click the right side of the source table.
  B. Hold the left mouse button down while dragging to the left side of the target table.
  C. To save changes, choose OK.
  D. Choose Execute
  A. Click the right side of the source table.
  B. Hold the left mouse button down while dragging to the left side of the target table.

• Question 74:

  Contains repository names that are associated with the Job Server on which you run your jobs. Which is the actual option to see jobs status?

  A. Batch
  B. Real-Time
  C. Adapters
  D. Profiler
  A. Batch

• Question 75:

  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. Submit sleep interval (seconds)
  C. Inactive interval (minutes)
  D. Active Interval (Seconds)
  A. Invoke sleep interval (seconds)

• Question 76:

  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. Adjust the data types for the

  columns proposed by the Designer based on their content.

  (Validate the correct statement).

  A. In the Local Objects Library, choose Formats tab.
  B. Right click the Flat Files node and choose New.
  C. Enter Orders_Format as the format name.
  D. In the Column Attributes pane, change the field datatypes to the datatypes in the Column Attributes Values table.
  E. In the ORDERDATE field, to change the format of the date, enter dd-mon-yyyy .
  F. Choose Save and close .
  D. In the Column Attributes pane, change the field datatypes to the datatypes in the Column Attributes Values table.
  E. In the ORDERDATE field, to change the format of the date, enter dd-mon-yyyy .
  F. Choose Save and close .

• Question 77:

  ________for the user account through which SAP Data Services connects to this SAP application server.

  A. SAP application server name
  B. Client number
  C. User Name
  D. Password
  D. Password

• Question 78:

  You are designing an SAP Data Services process.

  This process must execute ONLY if a defined expression is true.

  Which object allows you to accomplish this task?

  A. Validation transform
  B. Try/catch block
  C. Conditional
  D. Case transform
  C. Conditional

• Question 79:

  What do you call for that particular link of Clicking to open a dialog box for changing a variety of options depending on the selected application?

  A. Settings
  B. Home
  C. Logout
  D. Question mark icon
  A. Settings

• Question 80:

  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 Smart Editor, choose the Variables tab.
  B. Right click Parameters and choose Insert.
  C. In the project area, right click the Omega project and choose New batch job
  D. Enter the name Alpha_Marketing_Offer_Job.
  E. In the tool palette, select the Data Flow icon and click in the workspace.
  F. Enter the name Alpha_Marketing_Offer_DF.
  C. In the project area, right click the Omega project and choose New batch job
  D. Enter the name Alpha_Marketing_Offer_Job.
  E. In the tool palette, select the Data Flow icon and click in the workspace.
  F. Enter the name Alpha_Marketing_Offer_DF.