[2024年01月14日] 完全版には更新されたのはSAP Certified Application Associate（C-DS-42）認定サンプル問題
最新のSAP C-DS-42リアル試験問題集PDF
質問 # 43
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 produce statistics
- D. You can have multiple rules on a single column.
- E. You can call a recovery dataflow
正解：B
質問 # 44
An SAP Data Services dataflow contains multiple transform objects. The target table contains some unexpected results for one column.
How can you review a sample of the data as it passes through each transform?
- A. Execute the job in debug mode with breakpoints set and enabled.
- B. Execute the job and review the monitor during execution.
- C. Execute the job and review the target table in SQL.
- D. Execute the job that enables the Trace Optimized Dataflow property.
正解：A
質問 # 45
Which repository types are used in SAP Data Services? 2 correct
- A. Profiler repository
- B. Data repository
- C. Remote Repository
- D. Central Repository
正解：A、D
質問 # 46
A target column named ZIP4 requires the input of the source columns: POSTCODE and EXTENSION. For example:
POSTECODE:99999
EXTENSION: 9999
Desired result is ZIP4:99999-9999
- A. POSTCODE +'-*+ EXTENSION
- B. POSTCODE AND '-' AND EXTENSION
- C. POSTCODE ||'-'|| EXTENSION
- D. rpad_ext(POSTCPDE,EXTENSION)
正解：C
質問 # 47
What can you use a workflow for in SAP Data Services?
- A. To group data flows that belong together
- B. To group jobs that you want to monitor
- C. to allow schedulling for dataflows
- D. To transform source data into target data
正解：A
質問 # 48
You SAP Data Services job desing 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 reruns all workflows and scripts. When using automatic recovery, only dataflows that ran successfully in the previous execution ^ are skipped.
- 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 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 executes the scripts if it is part of a workflow marked as a recovery unit, but only if an error was raised
正解：B
質問 # 49
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 Modify the data flow to send customers outside North America to a second template table, Alpha_Other_customer .
- A. Add a second Query transform to the data flow
- B. Choose OK .
- C. Click in the data flow workspace to add a new template table below the Alpha_NA_customer target table.
- D. Create the table in datastore Delta .
- E. Name the new template table Alpha_Other_customer .
- F. Choose Execute .
- G. In the Execution Properties dialog box, choose the Execution Options tab, and select the Enable auditing checkbox.
正解：A、B、C、D、E
質問 # 50
What application do you use to display the graphical representations of all Sap Data Services objects including their relationships and properties?
- A. Impact and lineage Analysis
- B. Autodocumentation
- C. Data quality reports
- D. Operational Dashborad
正解：B
質問 # 51
In SAP Data Services what do you use implement a target-based delta that deals with inserts, update and deletes in the source.
- A. The auto correct load
- B. A Map_Operation transform
- C. Table comparison transform
- D. A Map_CDC_Operation transform
正解：D
質問 # 52
You are designing an SAP Data Services process.
This process must execute ONLY if a defined expression is true.
Which object allows you to accomplish this task?
- A. Conditional
- B. Try/catch block
- C. Case transform
- D. Validation transform
正解：A
質問 # 53
In which parameter the number of seconds to sleep before the Data Profiler checks for completion of an invoked task. Invoked tasks run synchronously, and the Data Profiler must check for their completion?
- A. Inactive interval (minutes)
- B. Invoke sleep interval (seconds)
- C. Active Interval (Seconds)
- D. Submit sleep interval (seconds)
正解：B
質問 # 54
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 Save all changes and execute the job with auditing enabled and Trace Audit Data set to Yes
- A. In the Value field, using the drop down list, change the value to Yes.
- B. In the Execution Properties dialog box, in the Execution Options tab, select the Enable auditing checkbox.
- C. To remove the existing audit rule, choose Delete
- D. Choose Add and select Custom .
- E. In the Trace tab, choose Trace Audit Data .
- F. Right-click the Alpha_AuditCustomer_Job and choose Execute .
正解：A、B、E、F
質問 # 55
What do you call for that particular link of Clicking to open a dialog box for changing a variety of options depending on the selected application?
- A. Home
- B. Settings
- C. Logout
- D. Question mark icon
正解：B
質問 # 56
By which application you do Analyze the end-to-end impact and lineage for source and target objects used within the Data Services local repository?
- A. Operational Dashboard
- B. Auto Documentation
- C. Data Quality Reports
- D. Data Validation Dashboard
- E. Administrator
- F. Impact and Lineage Analysis
正解：F
質問 # 57
How to View the data for both tables. Verify that both tables have the same column names, and that the target table is empty?
- A. Click the View Data icon (magnifying glass) for the source table in the workspace
- B. Click the View Data icon (magnifying glass) for the target table in the workspace.
- C. Close both view data windows.
- D. Double click the target table.
正解：A、B、C
質問 # 58
which transform are typically used to implement a slowly changing dimension of type 2 in SAP Data services?
3 correct answers
- A. History_Preserving
- B. Key_Generation
- C. Table_comparison
- D. Map_CDC_Operation
- E. Data_Transfer
正解：C
質問 # 59
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
質問 # 60
What do you call for that particular link of Clicking to Click to open the Documentation Map, which lists the SAP Data Services technical documentation available to end users or administrators, and a link to the customer portal where you can find the latest versions of the documentation?
- A. Home
- B. Question mark icon
- C. Settings
- D. Logout
正解：B
質問 # 61
You have a workflow containing two dataflows. The second dataflow should only run if the first one finished successfully.
How would you achieve this in SAP Data Services.
- A. Embed the first dataflow in a try-catch
- B. Connect the two dataflows with line
- C. Use a conditional for the second dataflow
- D. Add a script between the dataflows using the error_number() function
正解：B
質問 # 62
How do you allow a new team member to view the SAP Data Services repository in read only mode?
- A. Use the central repository in the Desinger
- B. Copy the repository and view the copy in the repository manager.
- C. Export the repository's metadata to an XML file and open it in a browser.
- D. Use the Auto Documentation feature in the Management Console
正解：A
質問 # 63
How to Connect the source table to the target table?
- A. Click the right side of the source table.
- B. Hold the left mouse button down while dragging to the left side of the target table.
- C. Choose Execute
- D. To save changes, choose OK.
正解：A、B
質問 # 64
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 In the Alpha_NACustomer_DF workspace, delete an existing expression for the Country column in the Query transform.
- A. In the Mapping tab for the Country field, delete the existing expression.
- B. In the Select Function dialog box, choose Lookup Functions.
- C. the Alpha_NACustomer_DF workspace, to open the transform editor, double click the Query transform.
- D. In the Mapping tab, choose Functions.
- E. In the Query Editor, in the output schema, choose the field Country.
正解：A、C、E
質問 # 65
Your customer has rules requiring that each row in the source be tested for certain criteria in a specific order.
When a row passes one criteria, it should
NOT be tested for the next criteria.
How should this be implemented using SAP Data Services transforms?
Please choose the correct answer.
- A. Use multiple Query transforms with one WHERE? clause per rule.
Connect all queries to the source.
. Use a Case transform with the Row Can Be True for One Case
Only and Preserve Expression Order options enabled. - B. se a Case transform with the Produce Default Output with Label option enabled, and enable the Preserve Expression Order checkbox.
- C. Use a Validation transform and add the rules in the proper order for each single column.
正解：B
質問 # 66
......
SAP C-DS-42試験は、80の多肢選択問題から構成され、180分の試験時間があります。試験は、英語、日本語、韓国語の3つの言語で利用可能です。候補者は、合格するには、総合得点の60％以上を獲得する必要があります。試験料は500ドルで、候補者は、認定されたSAPトレーニングセンターで試験を受けることができます。
SAP C-DS-42問題集で一発合格を目指すならこれ！：https://www.jpntest.com/shiken/C-DS-42-mondaishu
C-DS-42練習テスト問題更新されたのは82問があります：https://drive.google.com/open?id=1PXC37BBSQRFXziQUdIuXAv4Gnwetq-3F