C-DS-43試験問題でリアルに更新された問題PDF
合格させる無料保証付きクイズ2024年最新の実際に出ると確認されたSAP
質問 # 46
What does the expression SUBSTR(FIRST NAME, 1,3) return?
- A. M
- B. IRS
- C. U
- D. FIR
正解：D
質問 # 47
You created and saved a database datastore in SAP Data Services. Which properties can you change in the Edit Datastore dialog box?
- A. database name
- B. Datastore name
- C. database version
- D. user name and password
- E. database server name
正解：D
質問 # 48
How do you desing a data load that has good performance and deals with interrupted loads in SAP Data services?
- A. by setting the target table loader with bulk load enabled
- B. By creating two dataflows and executing the Auto Correct Load version when reired
- C. By using the table comparison transform
- D. by setting the target table loader with Bulk Load and Auto Correct Load enabled.
正解：B
質問 # 49
In SAP data services what does the date generation transform allow you to generate?
- A. the valid to date based on a dataset the contains valid to information only
- B. The rows for a given date range
- C. the valid from date based on a dataset the contains valid to information only
- D. The current date for a column to see when each row was loaded.
正解：B
質問 # 50
In SAP Data Services which basic operations can you perform with a Query transform?
- A. Set a global variable to a value
- B. Flag rows for update
- C. "Join data from several sources"
- D. "Apply functions to columns"
- E. Map Columns from an input schema to an output schema"
正解：D
質問 # 51
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. Before the pivot transform
- B. After the query transform
- C. Between the pivot transform and the query transform
- D. Before the pivot transform and after the query transform.
正解：C
質問 # 52
The value of the DEPT ID is null
What is the output of this SAP Data Services function?
- A. IS
- B. null
- C. ?
- D. CA
正解：C
質問 # 53
Why would you specify Recover as a Unit in the property of a workflow in SAP Data Services?
- A. To ensure that the workflow is skipped during recovery if the workflow was executed successfully in the prior run.
- B. To ensure that each dataflow is recovered as a separate unit during the recovery execution
- C. To ensure that all dataflow of the workflow are executed in one single transaction during recovery
- D. To ensure that all objects of the workflow are executed during recovery including the steps that were executed successfully in the prior run
正解：D
質問 # 54
You want to execute two dataflows in parallel in SAP Data Services. How can you achieve this?
- A. Create a workflow containing two dataflows without connecting them with a line.
- B. Create a workflow containing two dataflows and connect them with a line.
- C. Create a workflow containing two dataflows and set a degree of parallelism to 2.
- D. Create a workflow containg two dataflows and deselect the execute Only once property of the workflow.
正解：A
質問 # 55
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. On the view data tab
- B. In the impact and lineage analysis
- C. In the monitor log
- D. In the trace log
正解：C
質問 # 56
What operations can be pushed down in SAP Data Services?
- A. Load operations that contain trigger
- B. Aggregation operations used with a group by statement
- C. join operations between a file and a database table
- D. Join operations between sources that are on the same database servers
正解：D
質問 # 57
How do you view the data between transforms in SAP Data Services dataflow?
- A. By adding audit points in the dataflow
- B. By setting the SQL Transforms on job execution trace option
- C. By setting the Audit Data On job execution trace option
- D. By using the interactive debugger
正解：D
質問 # 58
What is the SAP Data services Dataflow auditing feature used for? Note: There are 2 correct answers to this question.
- A. To view the data as it is processed by the dataflow in order to ensure its correctness
- B. To define rules based on the number of records processed overall once the dataflow is finished
- C. To count the number of rows processed at user defined points to collect runtime statistics
- D. to define rules that each record processed by the dataflow has to comply with
正解：C、D
質問 # 59
Which type of SAP Data Services object can a project, job, dataflow or workflow contain? 3 correct answers
- A. A Project can contain a job
- B. A job can contain a job
- C. A dataflow can contain a workflow
- D. A workflow can contain a workflow
- E. A job can contain a workflow
正解：A、B、C
質問 # 60
You execute an SAP data services job with enable recovery activated. One of the dataflows in the jobs raises an exception that interrupts the execution. You run the job again with Recover from last failed execution enabled. What happens to the data flow that raised the exception during the first execution?
- A. It is rerun from the beginning and the partially loaded data is always handled automanticaly.
- B. It is rerun from the beginning and the desing of the data flow must deal with partially loaded data.
- C. It is rerun only if the dataflow is part of a recovery unit.
- D. Is is rerun with the first failed row.
正解：D
質問 # 61
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. Select one input column and enter the mapping manually
- B. Drag one column from the output schema to the input schema
- C. Drag one column from the input schema to the output schema
- D. Select an output column and enter the mapping manually.
正解：A
質問 # 62
Which features are supported by the SAP Data Services interactive debugger?
3 correct answers
- A. Define additional filters
- B. Set breakpoint
- C. Show sample rows of each step
- D. Show the optimized execution plan
- E. Show performance-related statistics
正解：A、B、C
質問 # 63
What are standard component of SAP Dataservices? There are 3 correct answers
- A. Design studio
- B. Job server
- C. Secure local repository
- D. Access server
- E. Real time services
正解：B、C、D
質問 # 64
An SAP data services file format has a date column, but occasionally the file contains an invalid value in one row. This causes the dataflow to terminate with an error.
What can you do to completely load such erroneous files?
Note: There are 2 correct answer
- A. Specify a date format of'????-??-??' to indicate the value might NOT be a valid date in the file format editor
- B. Define the column as varchar and use functions in subsequent Query transform to perform the checks and conversion
- C. Use the error handling options for conversion error in the file format definition
- D. Place the dataflow between a Try/Catch block to catch all erroneous rows
正解：A、D
質問 # 65
What requirement must you meet when mapping an output column on the SAP Data Services query transform mapping tab?
- A. Each column in the output schema must be mapped to one or more columns in the input schema
- B. Every column of the output schema must have a mapping
- C. All columns of the input schema must be mapped to the output schema
- D. Primary keys in the input schema must be mapped to only one column in the output schema
正解：A
質問 # 66
......
トップクラスのC-DS-43練習試験問題：https://jp.fast2test.com/C-DS-43-premium-file.html