SAP SAP Certifications C_DS_42 Questions & Answers

• Question 51:

  How to Save and execute the job, Alpha_Product_Job?

  A. In the main menu, choose Project Save All

  B. To save changes, choose OK .

  C. In the Project Area, right click the Alpha_Product_Job.

  D. Choose Execute.s

  E. To accept the default execution properties, choose OK

  F. Choose New Batch Job

  Correct Answer: ABCD

• Question 52:

  How to Open the target table editor to view the Schema In and Schema Out?

  A. Double click the target table.

  B. Click the View Data icon (magnifying glass) for the target table in the workspace.

  C. Close both view data windows.

  D. Double click the target table

  Correct Answer: A

• Question 53:

  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

  Correct Answer: AB

• Question 54:

  How to View the data for both tables. Verify that both tables have the same column names, and that the target table is empty?

  A. Click the View Data icon (magnifying glass) for the source table in the workspace

  B. Click the View Data icon (magnifying glass) for the target table in the workspace.

  C. Close both view data windows.

  D. Double click the target table.

  Correct Answer: ABC

• Question 55:

  In the workspace for Alpha_Product_DF, How to add the product table from the Alpha datastore as the source object?

  A. In the Project area, right-click the project name and, in the context menu, choose New Batch Job .

  B. In the Local Object Library , choose the Datastores tab.

  C. Select the product table from the Alpha datastore.

  D. Drag the table to the data flow workspace and choose Make Source.

  Correct Answer: BCD

• Question 56:

  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.

  Correct Answer: BCDE

• Question 57:

  You are an ETL developer working on a data warehousing project. You need to load data from the product

  table and create a table for North American customers.

  How to Create a new project called Omega?

  A. In the Project menu, choose New Project.

  B. In the Project New dialog box, in the Project name field, enter Omega.

  C. Choose Create .The new project appears in the Project area.

  D. In the Project area, right-click the project name and, in the context menu, choose New Batch Job.

  Correct Answer: ABC

• Question 58:

  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 .

  Correct Answer: DEF

• Question 59:

  Contains the repository name associated with the ________ Server?

  A. Batch

  B. Real-Time

  C. Adapters

  D. Profiler

  Correct Answer: D

• Question 60:

  You are working as an ETL developer using SAP Data Services Designer. To whom You will create Datastores?

  A. For the source

  B. For the Target

  C. For the staging databases

  D. None of the above

  Correct Answer: ABC