[2024年06月16日]C-DS-43サンプルには正確で更新された問題 [Q41-Q61]

[2024年06月16日]C-DS-43サンプルには正確で更新された問題

C-DS-43試験情報と無料練習テスト

質問 # 41
What requirement must you meet when mapping an output column on the SAP Data Services query transform mapping tab?

A. All columns of the input schema must be mapped to the output schema
B. Each column in the output schema must be mapped to one or more columns in the input schema
C. Primary keys in the input schema must be mapped to only one column in the output schema
D. Every column of the output schema must have a mapping

正解：B

質問 # 42
You are joining tables using the query transform of SAP Data Services.

A. Left outer joins and inner joins
B. Only inner joins
C. Maximum of two tables
D. Only equal conditions

正解：A

質問 # 43
What can you use a workflow for in SAP Data Services?

A. To group jobs that you want to monitor
B. To transform source data into target data
C. to allow schedulling for dataflows
D. To group data flows that belong together

正解：D

質問 # 44
A SAP Data Services job contain logic to execute different dataflows depending on whether the job was successful or failed. Therefore the $NEEDS_RECOVERY variable should be set to either 'Yes' or 'No'. How do you assign the value to the $NEEDS_RECOVERY variable?

A. Use a dataflow to set the value via a template table
B. Use a global variable to persist the value across job executions
C. Use a script with an SQL function to read from status table
D. Use a catch block and set the variable to 'yes1

正解：D

質問 # 45
You are instructed to calculate the maximum value in the SALARY column of an EMPLOYEE table.
How can you achieve this in SAP Data Services?

A. Use max (SALARY) in a script.
B. Call max(SALARY) from a Custom function
C. Enter max (SALARY) in the query transform
D. Use max(SALARY) in a conditional

正解：C

質問 # 46
A Map operation transform in SAP Data Services was used to modify the operation code of data is being processed. Why do you perform this action?

A. To push the data down for better performance
B. To increase the speed that the database loads
C. To ensure compatibility with subsequent transforms
D. To control how the data is loaded.

正解：C、D

質問 # 47
Which type of SAP Data Services object can a project, job, dataflow or workflow contain? 3 correct answers

A. A job can contain a workflow
B. A workflow can contain a workflow
C. A job can contain a job
D. A Project can contain a job
E. A dataflow can contain a workflow

正解：C、D、E

質問 # 48
You developed a batch job using SAP Data Services and want yo start an execution. How can you execute the job?
2 correct answers

A. Use the scheduler in the Data Services Management Console
B. Use the debug option in the Data Services Management console
C. "Execute the job manually in the Data Services Designer."
D. Use the scheduler in the Data Services Designer

正解：C、D

質問 # 49
The SAP Data services merge transform is used to combine two datasets; the first has 3000 rows and the second has 2000 rows. What are characteristics of the Merge transform? Note: there are 2 correct answers to this question

A. The merge transform combines the dataset into 5000 or less output rows.
B. The merge transform joins the datasets using a full outer join
C. The merge transform combines the dataset into 5000 output rows
D. The merge transform require both dataset to have the same structure.

正解：D

質問 # 50
A new developer joined the project team. You already created a new SAP Data Services repository for this member.
Where do you manage the security setting for this new repository?

A. Repository database
B. Data Services Designer
C. Repository manager
D. Central Management console

正解：D

質問 # 51
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. Drag one column from the output schema to the input schema
B. Select an output column and enter the mapping manually.
C. Select one input column and enter the mapping manually
D. Drag one column from the input schema to the output schema

正解：C

質問 # 52
In SAP Data Services you have a Validation Transform with the following two rules Rule #1: Action on Failure is 'Send to Pas' Rules#2: Action on Failure is 'Send to Fail.
Where are the records that fail both rule #1 and rule #2 sent?

A. Only to the Rule Violation output
B. Only to the Pass output
C. To both the Pass and Fail output
D. Only to the Fail output

正解：D

質問 # 53
An SAP data services job was executed in the past.
Where can you see the order that the dataflows were executed in?
There are 2 correct answers to this question.

A. In the operational dashboard
B. In the job server log
C. In the job trace log.
D. In the impact and Lineage Analysis report

正解：C

質問 # 54
You need to import metadata and extract data from an SAP ERP system using SAP Data Services. Which type of datastore must you use?

A. Database datastore
B. Adapter datastore
C. Web Services datastore
D. Application datastore

正解：D

質問 # 55
A dataflow contain a pivot transform followed by a query transform that performs an aggregation. The Aggregation query should by pushed down to the database in SAP Data services.
Where would you place the Data_Transfer transform to do this?

A. After the query transform
B. Before the pivot transform
C. Before the pivot transform and after the query transform.
D. Between the pivot transform and the query transform

正解：D

質問 # 56
You created and saved a database datastore in SAP Data Services. Which properties can you change in the Edit Datastore dialog box?

A. Datastore name
B. user name and password
C. database server name
D. database version
E. database name

正解：B

質問 # 57
You modified an existing SAP data Services job. You notice that the run time is now longer then expected. Where in SAP Data Services can you observe the progress of row counts to determine the location of a bottleneck

A. In the monitor log
B. In the trace log
C. On the view data tab
D. In the impact and lineage analysis

正解：A

質問 # 58
What does the data services repository of SAP Data services contain?
There are 2 correct answers to this question

A. Target metadata
B. User security
C. Transformation rules
D. in flight data

正解：A、C

解説：
The SAP Data Services repository is a set of tables that hold user-created and predefined system objects, source and target metadata, and transformation rules. Set up repositories on an open client/server platform to facilitate sharing metadata with other enterprise tools.
https://blogs.sap.com/2015/12/27/sap-data-services-repositories-definition-and-configuration-part-1/#:~:text=The%20SAP%20Data%20Services%20repository,metadata%20with%20other%20enterprise%20tools.

質問 # 59
What are advantages of using the validation transform in SAP Data services? There are 3 correct answers to this question

A. You can set different failed paths for each rule
B. You can see which rules were violated in one output
C. You can call a recovery dataflow
D. You can have multiple rules on a single column.
E. You can produce statistics

正解：A、B、D

質問 # 60
You are reading a Sales Order table from the source and need to add the customer region information a from a customer table. The primary key of the customer table consists of the columns CUST_ID and VALID_FROM How would you desing the dataflow to get the region information that was valid at the ORDER_CREARTE_DATE?