C-DS-42試験問題を今すぐ試そう！最新の[2023年最新] 正解回答付き
練習できるC-DS-42には認定ガイド問題と解答とトレーニングを提供しています
SAP Certified Application Associate - Data Integration with SAP Data Services 4.2（C-DS-42）試験は、SAP Data Servicesを使用してデータ統合のキャリアを追求する個人を対象としています。この試験は、SAP Data Servicesを使用したデータ移行、データ品質、データ変換などのさまざまな領域で候補者の知識とスキルをテストします。
SAP C_DS_42試験は、80の多肢選択問題から構成され、180分の持続時間があります。この試験は、英語と日本語の両方で利用可能であり、世界中の認定テストセンターで受験できます。試験に受験資格を得るには、候補者はSAP Data Servicesを使用したデータ統合の経験が1年以上あり、データウェアハウジングの概念を基本的に理解している必要があります。
質問 # 39
You want to back up an SAP Data Services repository. How does the system store repositories?
- A. As tables in a relational database management system
- B. As an XML file on the data services job server
- C. As an XML file on the Data services Access Server
- D. As an binary file on the Data servives job server
正解：A
質問 # 40
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. Logout
- B. Home
- C. Question mark icon
- D. Settings
正解：D
質問 # 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 Save all changes and execute the job with auditing enabled and Trace Audit Data set to Yes
- A. Right-click the Alpha_AuditCustomer_Job and choose Execute .
- B. In the Value field, using the drop down list, change the value to Yes.
- C. In the Trace tab, choose Trace Audit Data .
- D. To remove the existing audit rule, choose Delete
- E. In the Execution Properties dialog box, in the Execution Options tab, select the Enable auditing checkbox.
- F. Choose Add and select Custom .
正解：A、B、C、E
質問 # 42
How to Add the Query transform to the workspace between the source and target?
- A. To open the Query Editor , in the data flow workspace, double click the Query transform.
- B. To connect the Query transform to the target template table, select the Query transform, hold down the left mouse button, drag the cursor to the target table, and release the mouse button.
- C. To connect the source table to the Query transform, select the source table, hold down the left mouse button, drag the cursor to the Query transform, and release the mouse button.
- D. To add a new Query template to the data flow, in the tool palette, choose the Query Transform icon, and click the workspace.
正解：B、C、D
質問 # 43
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. Double click the target table.
- D. Close both view data windows.
正解：A、B、D
質問 # 44
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 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
質問 # 45
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 script with an SQL function to read from status table
- C. Use a dataflow to set the value via a template table
- D. Use a global variable to persist the value accros job executions
正解：A
質問 # 46
You want to restore an older version of an object found in a shared object library.
Where do you find this version of the object in SAP Data Services?
- A. O In the Auditing repository
- B. O In the Central repository
- C. O In the Profiler repository
- D. O In the Local repository
正解：B
質問 # 47
Where does An administrator sets user permissions?
- A. Central Management Server (CMS)
- B. Data Services Management Console
- C. Management Console navigation
- D. Management Console
正解：A
質問 # 48
which transform are typically used to implement a slowly changing dimension of type 2 in SAP Data services?
3 correct answers
- A. Key_Generation
- B. Data_Transfer
- C. Table_comparison
- D. Map_CDC_Operation
- E. History_Preserving
正解：C
質問 # 49
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 scheduler in the Data Services Management Console
- B. Use the debug option in the Data Services Management console
- C. "Execute the job manually in the Data Services Designer."
- D. Use the scheduler in the Data Services Designer
正解：C、D
質問 # 50
In the workspace for Alpha_Product_DF, How to add the product table from the Alpha datastore as the source object?
- A. Drag the table to the data flow workspace and choose Make Source.
- B. Select the product table from the Alpha datastore.
- C. In the Local Object Library , choose the Datastores tab.
- D. In the Project area, right-click the project name and, in the context menu, choose New Batch Job .
正解：A、B、C
質問 # 51
During development of a SAP Data Services dataflow, you find that the source system contains data inconsistencies.
What transform allows you to define rules and monitor the conformance of the data for every load?
- A. Validation transform
- B. Query transform
- C. SQL transform
- D. Case transform
正解：A
質問 # 52
You must calculate the total value of all orders, including their discounts, for reporting purposes. Currently these details are found in different tables.
Use the sum function to calculate the total value of orders in the
Order_Details table.
How to In the transform editor for the Query transform, propose a join between the two source tables.
- A. Choose the Where tab or the From tab.
- B. To connect the Query Transform, select the Query Transform , hold down the mouse button, drag it to the order_sum table, and release the mouse button.
- C. the Propose Join button.
- D. To open the Query Editor double click the Query .
正解：A、C、D
質問 # 53
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. Define the column as varchar and use functions in subsequent Query transform to perform the checks and conversion
- B. Specify a date format of'????-??-??' to indicate the value might NOT be a valid date in the file format editor
- C. Place the dataflow between a Try/Catch block to catch all erroneous rows
- D. Use the error handling options for conversion error in the file format definition
正解：B、C
質問 # 54
What task can you perform in the SAP Data Services Management Console? Note: There are 3 correct answers to this question
- A. Schedule a job for daily execution
- B. Debug a dataflow to find data issues
- C. Display the optional Validation Transform statistics
- D. View the rows and the values being loaded
- E. Display trace and monitor and error logs.
正解：C
質問 # 55
An SAP Data Services dataflow adds the changed data (insert and update) into a target table every day.
How do you design the dataflow to ensure that a partially executed dataflow recovers automatically the next time it is executed?
2 correct answers
- A. Add lookup function in the where clause to filter out existing rows.
- B. Use the table comparison transform before the table loader
- C. Enable the Delete data before load target table loader option
- D. Set the autocorrect load option in the target table loader option
正解：A、B
質問 # 56
In which of the following objects can you use built-in- functions in SAP Data services? Note: There are 3 correct answers to this question
- A. Conditionals
- B. Scripts
- C. Map CDC transform
- D. Merge transform
- E. Query transform
正解：B、D、E
質問 # 57
In the transform editor for the Query transform, How to map all columns from the Schema In to the Schema Out?
- A. In the Query editor, choose the WHERE tab.
- B. To select all columns in the Schema In , choose the CUSTOMERID column, hold the shift key, and choose the PHONE column
- C. Drag all columns to the Schema Out
- D. To open the Query Editor , in the data flow workspace, double click the Query transform
正解：B、C、D
質問 # 58
You import a table from a database into a datastore.
Which information is added into the SAP Data Services repository?
- A. The complete metadata information of the table
- B. The whole table with all its source data
- C. Only the table name
- D. The table name and all column names with their dataypes.
正解：A
質問 # 59
Which SAP Data Services transforms would you use in a dataflow to load a slowly changing dimension of type 2?
- A. Table_Comparison
- B. Row_Generation
- C. Effective_Date
- D. History_Preserving
- E. Key_Generation
正解：A、D、E
質問 # 60
Contains the repository name associated with the ________ Server?
- A. Real-Time
- B. Profiler
- C. Adapters
- D. Batch
正解：B
質問 # 61
......
試験準備には欠かさない！トップクラスのSAP C-DS-42試験アプリ学習ガイド練習問題最新版：https://www.jpntest.com/shiken/C-DS-42-mondaishu
無料SAP C-DS-42テスト練習問題試験問題集：https://drive.google.com/open?id=1IYAmYZcrvjU_W0bmTbsR5B5DXNucpE7V