SAP C_DS_42 Quiz 8 Topic 5 Questions 36-40

Question: 1

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

AIn the Project menu, choose New Project

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

CEnter 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.

DIn the Alpha_Product_Job workspace, in the tool palette, choose the Data Flow icon.

EClick in the workspace where you want to add the data flow, and enter the name Alpha_Product_DF.

Show Answer

Question: 2

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?

AIn the Project menu, choose New Project.

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

CChoose Create .The new project appears in the Project area.

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

Show Answer

Question: 3

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).

AIn the Local Objects Library, choose Formats tab.

BRight click the Flat Files node and choose New.

CEnter Orders_Format as the format name.

DIn the Column Attributes pane, change the field datatypes to the datatypes in the
Column Attributes Values table.

EIn the ORDERDATE field, to change the format of the date, enter dd-mon-yyyy .

FChoose Save and close .

Show Answer

Question: 4

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).

AIn the Local Objects Library, choose Formats tab.

BRight click the Flat Files node and choose New.

CEnter Orders_Format as the format name.

DRight click your new file format Orders_Format and choose View Data .

Show Answer

Question: 5

Contains the repository name associated with the ________ Server?

ABatch

BReal-Time

CAdapters

DProfiler

Show Answer

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

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?

Contains the repository name associated with the ________ Server?

SAP C_DS_42 Quiz:8 Topic:5 Questions:36-40

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?