SAP C_DS_42 Online Practice Questions and Exam Preparation

SAP C_DS_42 Online Questions & Answers

• Question 11:

  _________through which SAP Data Services connects to this SAP application server. Use the same user name used to create the SAP BW Source datastore.

  A. RFC program ID
  B. SAP application server name
  C. Client number
  D. User Name
  D. User Name

• Question 12:

  Which SAP Data Services transforms would you use in a dataflow to load a slowly changing dimension of type 2?

  A. Row_Generation
  B. Table_Comparison
  C. Key_Generation
  D. History_Preserving
  E. Effective_Date
  B. Table_Comparison
  C. Key_Generation
  D. History_Preserving

• Question 13:

  Contains repository names associated with the Job Server on which you run_______?

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

• Question 14:

  In the Omega project, How to create a new batch job Alpha_Product_Job with a new data flow, Alpha_Product_DF?

  A. In the Project menu, choose New Project
  B. In the Project area, right-click the project name and, in the context menu, choose New Batch Job
  C. Enter the job name, Alpha_Product_Job and, on your keyboard, press the Enter key. The job should open automatically. If it does not, open it by double-clicking.
  D. In the Alpha_Product_Job workspace, in the tool palette, choose the Data Flow icon.
  E. Click in the workspace where you want to add the data flow, and enter the name Alpha_Product_DF.
  B. In the Project area, right-click the project name and, in the context menu, choose New Batch Job
  C. Enter the job name, Alpha_Product_Job and, on your keyboard, press the Enter key. The job should open automatically. If it does not, open it by double-clicking.
  D. In the Alpha_Product_Job workspace, in the tool palette, choose the Data Flow icon.
  E. Click in the workspace where you want to add the data flow, and enter the name Alpha_Product_DF.

• Question 15:

  Your customer has rules requiring that each row in the source be tested for certain criteria in a specific order. When a row passes one criteria, it should NOT be tested for the next criteria. How should this be implemented using SAP Data Services transforms? Please choose the correct answer.

  A. Use multiple Query transforms with one WHERE? clause per rule. Connect all queries to the source.
  B. Use a Case transform with the Row Can Be True for One Case Only and Preserve Expression Order options enabled.
  C. se a Case transform with the Produce Default Output with Label option enabled, and enable the Preserve Expression Order checkbox.
  D. Use a Validation transform and add the rules in the proper order for each single column.
  B. Use a Case transform with the Row Can Be True for One Case Only and Preserve Expression Order options enabled.

• Question 16:

  You want to restore an older version of an object found in a shared object library. Where do you find this version of the object in SAP Data Services?

  A. O In the Central repository
  B. O In the Local repository
  C. O In the Profiler repository
  D. O In the Auditing repository
  A. O In the Central repository

• Question 17:

  Management Console is written in which language?

  A. XML
  B. .net
  C. Html
  D. Java
  D. Java

• Question 18:

  How to Save and execute the Alpha_NACustomer_Job?

  A. In the main menu, choose Project Save All and To save all changes, choose OK
  B. In the Project Area , right click the Alpha_NACustomer_Job and choose Execute and To accept the default execution properties, choose OK
  C. To return to the Job workspace, in the tool bar, choose the Back icon and To return to the Data Flow workplace, double click the Data Flow.
  D. In the Query editor, choose the WHERE tab
  A. In the main menu, choose Project Save All and To save all changes, choose OK
  B. In the Project Area , right click the Alpha_NACustomer_Job and choose Execute and To accept the default execution properties, choose OK
  C. To return to the Job workspace, in the tool bar, choose the Back icon and To return to the Data Flow workplace, double click the Data Flow.

• Question 19:

  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.

  A. Right click the target table and choose View data .
  B. Confirm that order 11146 has 204000.00 as a total value.
  C. In the Local Object Library, create a new customer function called CF_MarketingOffer.
  D. Create a new batch job and data flow, called Alpha_Marketing_Offer_Job and Alpha_Marketing_Offer_DF respectively, and a new global variable $G_Num_to_Qual.
  E. In the job workspace, define a script to define the global variable and attach the script to the data flow.
  C. In the Local Object Library, create a new customer function called CF_MarketingOffer.
  D. Create a new batch job and data flow, called Alpha_Marketing_Offer_Job and Alpha_Marketing_Offer_DF respectively, and a new global variable $G_Num_to_Qual.
  E. In the job workspace, define a script to define the global variable and attach the script to the data flow.

• Question 20:

  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. In the Query Editor , in the Mapping tab, choose Functions.
  C. In the Select Function dialog box, choose String Functions .
  D. From the list of function names, select search_replace and choose Next .
  B. In the Query Editor , in the Mapping tab, choose Functions.
  C. In the Select Function dialog box, choose String Functions .
  D. From the list of function names, select search_replace and choose Next .