
更新された2023年11月合格させるC-DS-42試験リアル練習テスト問題
無料ダウンロードSAP C-DS-42リアル試験問題
質問 # 13
By which application you do Evaluate the reliability of your target data based on the validation rules you created in your batch jobs. Quickly review, assess, and identify potential inconsistencies or errors in source data?
- A. Auto Documentation
- B. Operational Dashboard
- C. Impact and Lineage Analysis
- D. Administrator
- E. Data Quality Reports
- F. Data Validation Dashboard
正解:F
質問 # 14
You want to execute two dataflows in parallel in SAP Data Services. How can you achieve this?
- A. Create a workflow containing two dataflows and set a degree of parallelism to 2.
- B. Create a workflow containg two dataflows and deselect the execute Only once property of the workflow.
- C. Create a workflow containing two dataflows and connect them with a line.
- D. Create a workflow containing two dataflows without connecting them with a line.
正解:D
質問 # 15
Execute the Alpha_NACustomer_Job in debug mode with a subset of records. In the workspace for the Alpha_NACustomer_Job , add a filter between the source and the Query transform to filter the records, so that only customers from the USA are included in the debug session?
- A. In the Breakpoint window, select the Set checkbox
- B. Right click the connection between the source table and the Query transform, and choose Set Filter/Breakpoint
- C. In the Filter window, select the Set checkbox
- D. Open the workspace for the Alpha_NACustomer_DF & Right click the connection between the source table and the Query Transform and choose Set Filter/Breakpoint
- E. In the workspace for the Alpha_NACustomer_DF , right click the connection between the source table and the Query transform, and choose Remove Filter
正解:C、D
質問 # 16
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. Select an output column and enter the mapping manually.
- C. Drag one column from the input schema to the output schema
- D. Drag one column from the output schema to the input schema
正解:A
質問 # 17
What does the data services repository of SAP Data services contain?
There are 2 correct answers to this question
- A. Target metadata
- B. in flight data
- C. User security
- D. Transformation rules
正解:A、D
解説:
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.
質問 # 18
What does the data services repository os SAP Data services contain?
There are 2 correct answers to this question
- A. in flight data
- B. User security
- C. Target metadata
- D. Transformation rules
正解:D
質問 # 19
You create a file format in SAP Data Services
What properties can you set for a column?
Note: There are 3 correct answers to this question.
- A. default value
- B. data type
- C. Format information
- D. field size
- E. comment
正解:C
質問 # 20
What operations can be pushed down in SAP Data Services?
- A. join operations between a file and a database table
- B. Join operations between sources that are on the same database servers
- C. Aggregation operations used with a group by statement
- D. Load operations that contain trigger
正解:B
質問 # 21
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. Enter max (SALARY) in the query transform
- C. Call max(SALARY) from a Custom function
- D. Use max (SALARY) in a script.
正解:B
質問 # 22
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 debug option in the Data Services Management console
- B. "Execute the job manually in the Data Services Designer."
- C. Use the scheduler in the Data Services Management Console
- D. Use the scheduler in the Data Services Designer
正解:B
質問 # 23
Which feature in the SAP Data Services Management Console allows you to see the trend of the execution time for any given job?
- A. Operational dashboard
- B. data quality reports
- C. trace log
- D. monitor log
正解:A
質問 # 24
You decide to distribute the execution of a job across multiple job servers within a server group. What distribution levels are available? 3 answers correct
- A. workflow
- B. JOB
- C. Embedded dataflow
- D. subdataflow
- E. Dataflow
正解:B、D、E
解説:
Select the level within a job that you want to distribute to multiple Job Servers for processing:
Job: The whole job will execute on an available Job Server.
Data flow: Each data flow within the job can execute on an available Job Server.
Sub data flow: Each sub data flow (can be a separate transform or function) within a data flow can execute on an available Job Server.
For more information, see "Using grid computing to distribute data flows execution" in the Performance Optimization Guide.
質問 # 25
In SAP data services what does the date generation transform allow you to generate?
- A. The current date for a column to see when each row was loaded.
- B. The rows for a given date range
- C. the valid to date based on a dataset the contains valid to information only
- D. the valid from date based on a dataset the contains valid to information only
正解:B
質問 # 26
You source table has a revenue column and a quantity column for each month. You want to transform this data to get a table containing twelve rows whit two columns.
What is the best way to achieve this in SAP Data services?
- A. Use the query transform with multiple IFTHENELSE() functions.
- B. Use twelve query transform to create the desired output. Then combine these transforms.
- C. Use the pivot transform with two pivot sets.
- D. Use the merge transform that is connected to the source
正解:C
質問 # 27
You define audit rules for critical data flow to confirm that you SAP Data Services batch job loaded only correct data. Which audit functions are available to define these rules for columns? Note: There are 3 correct answers
- A. Min
- B. Average
- C. Count distinct
- D. sum
- E. Checksum
正解:D
質問 # 28
When you log in to the Management Console, Where you must log in as a user defined?
- A. Central Management Server (CMS)
- B. Management Console navigation
- C. Data Services Management Console
- D. Management Console
正解:A
質問 # 29
......
C-DS-42問題集100パー合格保証には最新のサンプル:https://jp.fast2test.com/C-DS-42-premium-file.html
あなたを合格させる試験には100%確認済みC-DS-42試験問題:https://drive.google.com/open?id=1SntFPX6amMcaySDrnwGuhxWYH1AhgBXi