
試験準備には欠かさない!C-DS-42問題解答でC-DS-42試験問題集
リアルSAP C-DS-42試験問題 [更新されたのは2023年]
質問 # 13
What errors can you handle in SAP Services when you use a file format target?
- A. Data type conversion error
- B. File type error
- C. Row- format error
- D. Semantic error
正解:C
質問 # 14
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
質問 # 15
A dataflow contain a pivot transform followed by a query transform that performs an aggregation. The Aggregation query should by pushed down to the database in SAP Data services.
Where would you place the Data_Transfer transform to do this?
- A. Between the pivot transform and the query transform
- B. After the query transform
- C. Before the pivot transform
- D. Before the pivot transform and after the query transform.
正解:A
質問 # 16
Where does An administrator sets user permissions?
- A. Central Management Server (CMS)
- B. Management Console navigation
- C. Data Services Management Console
- D. Management Console
正解:A
質問 # 17
Contains repository names associated with the Job Server on which you run_______?
- A. Batch
- B. Profiler
- C. Real-Time
- D. Adapters
正解:B
質問 # 18
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. Use the scheduler in the Data Services Designer
- C. "Execute the job manually in the Data Services Designer."
- D. Use the scheduler in the Data Services Management Console
正解:B、C
質問 # 19
Contains repository names that are associated with the Job Server on which you run your jobs. Which is the actual option to see jobs status?
- A. Profiler
- B. Real-Time
- C. Adapters
- D. Batch
正解:D
質問 # 20
In SAP Data Services which basic operations can you perform with a Query transform?
- A. Flag rows for update
- B. Set a global variable to a value
- C. "Join data from several sources"
- D. Map Columns from an input schema to an output schema"
- E. "Apply functions to columns"
正解:E
質問 # 21
You have to load a file that contains the following first three lines:
YEAR; MONTH; PLAN_AMOUNT
2014;01;100.00
2014;02;110.00
What setting do you use when you created a file format for this?
- A. Type: Delimited column delimiter:; skip row headen: no
- B. Type: Delimited column delimiter:; skip row headen: yes
- C. Type: Fixed column length:4,2 and 6 skip row headen: yes
- D. Type: Delimited column delimiter:<blank> skip row headen: yes
正解:B
質問 # 22
_________through which SAP Data Services connects to this
SAP application server. Use the same user name used to create the SAP BW Source datastore.
- A. Client number
- B. RFC program ID
- C. User Name
- D. SAP application server name
正解:C
質問 # 23
What are task's of data Services uses the SAP RFC Server Interface?
- A. None of above
- B. Reading from SAP Open Hub destinations
- C. Viewing Data Services logs from SAP NetWeaver BW
- D. Loading SAP NetWeaver BW
- E. Scheduling SAP jobs
正解:B、C、D、E
質問 # 24
Which features are supported by the SAP Data Services interactive dubbuger?
3 correct answers
- A. Show performance-related statistics
- B. Define additional filters
- C. Show the optimized execution plan
- D. Show sample rows of each step
- E. Set breakpoint
正解:D
質問 # 25
An SAP Data Services Validation transform outputs all invalid rows. If more than ten rows are invalid, the data is considered to be failed. How do you implement this?
- A. Create an auditing rule that raises an exception
- B. Use the raise_exception function in the validation transform.
- C. Raise an exception in a Conditional connected to the target table.
- D. Set a breakpoint on the line connected to the target table.
正解:A
質問 # 26
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. Question mark icon
- B. Settings
- C. Logout
- D. Home
正解:B
質問 # 27
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 produce statistics
- C. You can see which rules were violated in one output
- D. You can call a recovery dataflow
- E. You can have multiple rules on a single column.
正解:A、C、E
質問 # 28
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. Try/catch block
- B. Validation transform
- C. Conditional
- D. Case transform
正解:C
質問 # 29
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_distinct(Account_TYPE)
- B. Gen_Row_Num()
- C. Sum(Account_type)
- D. Count(*)
正解:C
質問 # 30
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. To open the Query Editor double click the Query .
- 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. Choose the Where tab or the From tab.
- D. the Propose Join button.
正解:A、C、D
質問 # 31
What do you call for that particular link of Clicking to return to the Management Console home page where you can select another application, for example?
- A. Question mark icon
- B. Home
- C. Logout
- D. Settings
正解:B
質問 # 32
What are estandar component os SAP Dataservices? There are 3 correct answers
- A. Real time services
- B. Secure local repository
- C. Desing studio
- D. Access server
- E. Job server
正解:E
質問 # 33
The SAP Data services merge transform is used to combine two datasets; the first has 3000 rows and the second has 2000 rows. What are characteristics of the Merge transform? Note: there are 2 correct answers to this question
- A. The merge transform combines the dataset into 5000 output rows
- B. The merge transform combines the dataset into 5000 or less output rows.
- C. The merge transform joins the datasets using a full outer join
- D. The merge transform require both dataset to have the same structure.
正解:D
質問 # 34
......
C-DS-42合格させる試験問題集には更新されたのは2023年:https://jp.fast2test.com/C-DS-42-premium-file.html
無料C-DS-42試験問題集でお手軽に試験合格させる:https://drive.google.com/open?id=1SntFPX6amMcaySDrnwGuhxWYH1AhgBXi