2023年最新の更新のSAP Certified Application Associateが有効なC-DS-42問題集を無料提供しています
最新のPassTest C-DS-42PDF問題集をダウンロードしちゃおう：https://www.passtest.jp/SAP/C-DS-42-shiken.html（82問題と解答)
質問 # 40
In which situation is it appropriate to use a time - based CDC to capture changes in source data with SAP Data services
- A. When you need to capture intermediate changes
- B. when you need to capture physical deletes from source
- C. When almost all of the rows have changes
- D. When there are large tables with few changes
正解：D
質問 # 41
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 catch block and set the variable to 'yes1
- 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 dataflow to set the value via a template table
正解：A
質問 # 42
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
正解：D
質問 # 43
Where can you set up breakpoints for the SAP Data services interactive debugger?
- A. In a script
- B. In a workflow
- C. In a dataflow
- D. In a job
正解：C
質問 # 44
You SAP Data Services job design includes an initialization script that truncates rows in the target prior to loading, the job uses automatic recovery How would you expect the system to behave when you run the job in recovery mode?
Note: There are 2 correct answers to this question
- A. the job starts with the flow that caused the error. If this flow is after the initialization script the initialization script is skipped.
- B. The job executes the scripts if it is part of a workflow marked as a recovery unit, but only if an error was raised
- C. The job executes the scripts if it is part of a workflow marked as a recovery unit irrespective of where the error ocurred in the job flow.
- D. The job reruns all workflows and scripts. When using automatic recovery, only dataflows that ran successfully in the previous execution ^ are skipped.
正解：A、B
質問 # 45
What are SAP data services scripts used for? There are 2 correct answers to this question
- A. To perform job initialization tasks to print the job variable values into the trace log using the print() function.
- B. To execute single SQL commands using the sql() function to select a value from a status table for the variable.
- C. To set the desired properties, for example, trace options, monitor sample rate, and the use statistics for optimization flag.
- D. To write complex transformation logic using the flexibility of the scripting language.
正解：B
質問 # 46
In which parameter the number of minutes a profiling task can be inactive before the Data Profiler cancels it?
- A. Inactive interval (minutes)
- B. Invoke sleep interval (seconds)
- C. Active Interval (Seconds)
- D. Submit sleep interval (seconds)
正解：A
質問 # 47
You have a map operation transform immediately before the target in a data flow in Sap Data Services. What happens if all operation codes are mapped to Discard in the transform?
- A. They are filtered by the transform
- B. They are deleted from the target
- C. They are flagged for later deletion
- D. They are added to the overflow file
正解：A
質問 # 48
Contains repository names associated with the Job Server on which you run_______?
- A. Adapters
- B. Real-Time
- C. Batch
- D. Profiler
正解：D
質問 # 49
You decide to distribute the execution of a job across multiple job servers within a server group. What distribution levels are avaible?
3 answers correct
- A. Dataflow
- B. subdataflow
- C. workflow
- D. Embedded dataflow
- E. JOB
正解：E
質問 # 50
An SAP Data Services job contains a lot of dataflows and runs for several hours every night. If a job execution fails, you want to skip all successful dataflows and start with the failed dataflow. How do you accomplish this?
There are 2 correct answer
- A. Run the nightly job with the enable recovery flag turned on.
- B. Merge the dataflows from the job and rerun it.
- C. add a try block before each dataflow and a Catch block after each dataflow
- D. Design the dataflow to ensure a second run does not result in duplicate
正解：C、D
質問 # 51
By which application you do Manage your production environment including batch job execution, real-time services, web services, adapter instances, server groups, central repositories, profiler repositories, and more?
- A. Data Validation Dashboard
- B. Operational Dashboard
- C. Administrator
- D. Data Quality Reports
- E. Impact and Lineage Analysis
- F. Auto Documentation
正解：C
質問 # 52
Which feature in the SAP Data Services Management Console allows you to see the trend of the execution time for any given job?
- A. data quality reports
- B. trace log
- C. monitor log
- D. Operational dashboard
正解：D
質問 # 53
You have a Salary table containing departments (DEPARTMENT column) and salaries (SALARY column).
How do you calculate the average salaries for each department in the Query transform in SAP Data Services?
- A. Enter avg(SALARY) on the SELECT tab.
- B. Specify the DEPARTMENT column on the GROUP BY tab.
- C. Specify the DEPARTMENT code on the WHERE tab.
- D. Enter avg(SALARY) on the Mapping tab.
正解：B、D
質問 # 54
You want to display the description of an object in the Designer workspace-Which task must you perform to accomplish this in SAP Data services?
3 correct answers
- A. disiable the hide non - executable elements setting in the difference viewer.
- B. Enter a description in the properties of the object.
- C. right-click the object then choose enable description .
- D. Click the view enabled descriptions button on the toolbar.
- E. Right - click on the job in the project hierarchy to enable all descriptions.
正解：A、C、D
質問 # 55
An SAP Data Services dataflow adds the changed data (insert and update) into a target table every day.
How do you desing the dataflow to ensure that a partially executed dataflow recovers automatically the next time it is executed?
2 correct answers
- A. Use the table comparison transform before the table loader
- B. Set the autocorrect load option in the target table loader option
- C. Enable the Delete data before load target table loader option
- D. Add lookup function in the where? clause to filter out existing rows.
正解：A
質問 # 56
How to Open the target table editor to view the Schema In and Schema Out?
- A. Double click the target table
- B. Close both view data windows.
- C. Click the View Data icon (magnifying glass) for the target table in the workspace.
- D. Double click the target table.
正解：D
質問 # 57
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 conditional
- B. Call max(SALARY) from a Custom function
- C. Enter max (SALARY) in the query transform
- D. Use max (SALARY) in a script.
正解：C
質問 # 58
In SAP Data Services which basic operations can you perform with a Query transform?
- A. "Join data from several sources"
- B. Set a global variable to a value
- C. Map Columns from an input schema to an output schema"
- D. Flag rows for update
- E. "Apply functions to columns"
正解：E
質問 # 59
What is the SAP Data services Dataflow auditing feature used for?
- A. To count the number of rows processed at user defined points to collect runtime statistics
- B. To define rules based on the number of records processed overall once the dataflow is finished
- C. To view the data as it is processed by the dataflow in order to ensure its correctness
- D. to define rules that each record processed by the dataflow has to comply with
正解：A
質問 # 60
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 impact and lineage analysis
- B. On the view data tab
- C. In the trace log
- D. In the monitor log
正解：D
質問 # 61
Contains Access Server names associated with the which type of service. Which is the actual option to see jobs status?
- A. Adapters
- B. Real-Time
- C. Profiler
- D. Batch
正解：A
質問 # 62
In the Alpha Acquisitions database, the country for a customer is stored in a separate table and referenced with a code. To speed up access to information in the data warehouse, this lookup should be eliminated.
Use the lookup_ext function to exchange the ID for the country name in the customers table for Alpha with the actual value from the country table.
How to Execute the Alpha_NACustomer_Job with the default execution properties after saving all objects you have created.
- A. To use the default execution properties, choose OK.
- B. In the Mapping tab, choose Functions.
- C. To return to the job workspace, on the toolbar, choose the Back icon.
- D. Right click the target table and choose View Data.
- E. To open the data flow workspace, double click the data flow.
正解：A、C、D、E
質問 # 63
......
実験された試験材料はC-DS-42：https://www.passtest.jp/SAP/C-DS-42-shiken.html
最新C-DS-42リアル試験問題をフォローせよ！：https://drive.google.com/open?id=1usraxoyA9f327VWnnXVPJYgAGs6646lU