最新SAP C-DS-42一発合格！試験リアル問題集最新の[2023年12月]
良質なC-DS-42問題集はここPassTest問題はあなたの合格させて見せます。明るい未来はクリックから始まる！
質問 # 21
In SAP Data Services why would you select the produce default output checkbox in the Case transform?
- A. To output all rows that do not match any case expression to the default path
- B. To output all rows to the default path regardless if the they match the case expressions.
- C. to output all rows that do match exactly one case expression
- D. To output all rows that match the case statement
正解：A
質問 # 22
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
質問 # 23
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 increase the speed that the database loads
- B. To control how the data is loaded.
- C. To push the data down for better performance
- D. To ensure compatibility with subsequent transforms
正解：C
質問 # 24
What are task's of data Services uses the SAP RFC Server Interface?
- A. Reading from SAP Open Hub destinations
- B. None of above
- C. Scheduling SAP jobs
- D. Loading SAP NetWeaver BW
- E. Viewing Data Services logs from SAP NetWeaver BW
正解：A、C、D、E
質問 # 25
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
質問 # 26
Which SAP Data Services transforms would you use in a dataflow to load a slowly changing dimension of type 2?
- A. Effective_Date
- B. History_Preserving
- C. Table_Comparison
- D. Row_Generation
- E. Key_Generation
正解：B、C、E
質問 # 27
How to Save and execute the job, Alpha_Product_Job?
- A. In the main menu, choose Project Save All
- B. In the Project Area, right click the Alpha_Product_Job.
- C. To save changes, choose OK .
- D. To accept the default execution properties, choose OK
- E. Choose New Batch Job
- F. Choose Execute.s
正解：A、B、C、F
質問 # 28
What does the expression SUBSTR(FIRST NAME, 1,3) return?
- A. IRS
- B. U
- C. FIR
- D. M
正解：C
質問 # 29
Install the Management Console on a separate computer from other Data Services components. Where does management Console runs?
- A. On your application server
- B. On your Data Validation Dashboard
- C. On your Web application server
- D. On your Operational Dashboard
正解：C
質問 # 30
From the account table you want to know how many accounts you have per account type. The ACCOUNT_TYPE is output along with an additional column COUNTER. The group by tab of the query transform is used with ACCOUNT_TYPE. Which mapping would you use for the COUNTER column in SAP Data Services?
- A. count(Account_type)
- B. Count(*)
- C. Gen_Row_Num()
- D. count_distinct(Account_TYPE)
正解：A
質問 # 31
In which situation is it appropriate to use a time - based CDC to capture changes in source data with SAP Data services
- A. When almost all of the rows have changes
- B. when you need to capture physical deletes from source
- C. When there are large tables with few changes
- D. When you need to capture intermediate changes
正解：C
質問 # 32
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 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.
- B. the job starts with the flow that caused the error. If this flow is after the initialization script the initialization script is skipped.
- C. The job reruns all workflows and scripts. When using automatic recovery, only dataflows that ran successfully in the previous execution ^ are skipped.
- D. The job executes the scripts if it is part of a workflow marked as a recovery unit, but only if an error was raised
正解：B、D
質問 # 33
How to Save and execute the Alpha_NACustomer_Job?
- A. In the Project Area , right click the Alpha_NACustomer_Job and choose Execute & To accept the default execution properties, choose OK
- B. In the main menu, choose Project Save All & To save all changes, choose OK
- C. In the Query editor, choose the WHERE tab
- D. To return to the Job workspace, in the tool bar, choose the Back icon & To return to the Data Flow workplace, double click the Data Flow.
正解：A、B、D
質問 # 34
The performance of a dataflow is slow in SAP Data Services.
How can you see which part of the operations is pushed down to the source database? Note: the are 2 correct answers to this question.
- A. By enabling corresponding trace options in the job execution dialog.
- B. by opening the auto documentation page in the Data Services Management Console
- C. By starting the job in debubg mode.
- D. By opening the dataflow and using the view optimized SQL feature.
正解：A、D
質問 # 35
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 job can contain a workflow
- D. A workflow can contain a workflow
- E. A dataflow can contain a workflo
正解：A
質問 # 36
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 sources that are on the same database servers
- D. join operations between a file and a database table
正解：C
質問 # 37
The performance of a dataflow is slow in SAP Data Services.
How can you see which part of the operations is pushed down to the source database? Note: the are 2 correct answers to this question.
- A. By enabling corresponding trace options in the job execution dialog.
- B. by opening the auto documentation page in the Data Services Management Console
- C. By starting the job in debubg mode.
- D. By opening the dataflow and using the view optimized SQL feature.
正解：A
質問 # 38
Management Console contains a collection of Web-based applications for administering the following Data Services features and objects.
- A. Job execution performance evaluation
- B. Object relationship analysis
- C. Jobs and services executions
- D. Data Processing
正解：A、B、C
質問 # 39
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 accros 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
質問 # 40
Contains Access Server names associated with the which type of service. Which is the actual option to see jobs status?
- A. Profiler
- B. Batch
- C. Adapters
- D. Real-Time
正解：C
質問 # 41
You must ensure that all records from the Customer table in the Alpha database are being moved to the Delta staging database using the audit logs.
In the Local Object Library, replicate the Alpha_NACustomer_DF data flow. Name the replicated data flow Alpha_AuditCustomer_DF . Add the replicated data flow to a new job, Alpha_AuditCustomer_Job . Set up auditing on the data flow Alpha_AuditCustomer_DF by adding an audit rule to compare the total number of records in the source and target tables.
How to Construct an audit rule that an exception must be entered into the log if the count from both tables is not the same.
- A. In the Rule tab, under Auditing Rules , choose Add .
- B. Under Action on failure, select the Raise exception checkbox.
- C. In the operator drop down list, choose the operator equal (=).
- D. On the Label tab, right click the target table, Alpha_NA_customer , and choose Count .
- E. In the right drop down list, choose the audit label $count_Alpha_NA_customer for the target table.
- F. Choose Close .
正解：A、B、C、E、F
質問 # 42
......
SAP練習テストエンジンC-DS-42問題：https://drive.google.com/open?id=1NBwIb0PMrczdN0PwMzWzoVUlbxYMCsh8
試験合格保証有効なSAP C-DS-42問題集：https://www.passtest.jp/SAP/C-DS-42-shiken.html