SAP C-DS-42認定試験問題集には82練習テスト問題があります
最新C-DS-42試験問題集には高得点で一発合格
質問 # 44
Which repository types are used in SAP Data Services? 2 correct
- A. Data repository
- B. Central Repository
- C. Remote Repository
- D. Profiler repository
正解：D
質問 # 45
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 valid from date based on a dataset the contains valid to information only
- C. the valid to date based on a dataset the contains valid to information only
- D. The rows for a given date range
正解：D
質問 # 46
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 Add the Alpha_AuditCustomer_DF to the Alpha_AuditCustomer_Job .
- A. Alpha_AuditCustomer_Job workspace.
- B. Drag the Alpha_AuditCustomer_DF from the Local Object Library to the
- C. Right click the Omega project in the Project Area.
- D. Choose New Batch Job
- E. Name the new job Alpha_AuditCustomer_Job .
正解：B
質問 # 47
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 Now that the expression can calculate the total of the order values, make it possible for the Query to begin at the first order through the end of the records in the table by using the Group By tab.
- A. In the Schema In column, select the ORDERID field from the ORDER_DETAILS table and drag it to the Group By tab.
- B. Close the Editor.
- C. In the Query Editor , select the Group By tab.
- D. On the Mapping tab of the TOTAL_VALUE column, enter the expression:
正解：A、B、C
質問 # 48
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
質問 # 49
You want to set up a new SAP Data Services landscape. You must also create new repositories. Which repository types can you create?
- A. Backup repository
- B. Central repository
- C. Standy repository
- D. Local repository
- E. Profiler repository
正解：E
質問 # 50
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 global variable to persist the value accros job executions
- D. Use a dataflow to set the value via a template table
正解：A
質問 # 51
Contains Access Server names associated with the which type of service. Which is the actual option to see jobs status?
- A. Profiler
- B. Real-Time
- C. Adapters
- D. Batch
正解：C
質問 # 52
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. Gen_Row_Num()
- B. count_distinct(Account_TYPE)
- C. Count(*)
- D. Sum(Account_type)
正解：D
質問 # 53
Which features are supported by the SAP Data Services interactive debugger?
3 correct answers
- A. Define additional filters
- B. Show sample rows of each step
- C. Show performance-related statistics
- D. Set breakpoint
- E. Show the optimized execution plan
正解：A、B、D
質問 # 54
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 Web application server
- C. On your Data Validation Dashboard
- D. On your Operational Dashboard
正解：B
質問 # 55
An SAP Data Services job contains a lot of dataflows and runs for several hours every night. If a job execution fails, you want to skip all successful dataflows and start with the failed dataflow. How do you accomplish this?
There are 2 correct answer
- A. Design the dataflow to ensure a second run does not result in duplicate
- B. add a try block before each dataflow and a Catch block after each dataflow
- C. Merge the dataflows from the job and rerun it.
- D. Run the nightly job with the enable recovery flag turned on.
正解：A、B
質問 # 56
You are loading a database table using SAP Data Services. Which loading options are valid? Note: There are 3 correct answers to this question.
- A. Number of loader
- B. Abap execution option
- C. Rows per commit
- D. Data transfer method
- E. Include in transaction
正解：A、C、E
質問 # 57
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 Create a new batch job Alpha_AuditCustomer_Job .
- A. Right click the Omega project in the Project Area.
- B. Rename the copied data flow Alpha_AuditCustomer_DF.
- C. Alpha_NACustomer_DF data flow and choose Replicate .
- D. In the Local Object Library Data Flow tab right click the
- E. Choose New Batch Job
- F. Name the new job Alpha_AuditCustomer_Job .
正解：A、B、E
質問 # 58
To ensure that your job is processing the data correctly, you wan to run the job in debug mode. To minimize the data you have to review in the interactive debugger, you set the debug option process to show only records from an individual CountryID field value.
In the Cloud/WTS environment, the Designer will not allow multiple users to share the interactive debugger port. Change the interactive debugger port in Designer options.
- A. In the Interactive Debugger field, enter port number 60XX . A dialog box with the message
"Overwrite job server option parameters (BODI1260099)" opens. To continue, choose Yes & click ok - B. In the Filter window, select the Set checkbox
- C. From the Designer options, choose Environment
- D. From the main menu, choose Tools Options
正解：A、C、D
質問 # 59
_________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. User Name
- B. Client number
- C. RFC program ID
- D. SAP application server name
正解：A
質問 # 60
The Marketing department would like to send special offers to customers who have placed a specified number of orders. This can be done by creating a custom function that must be called when a customer order is placed.
You want to create a custom function to accept the input parameters of the Customer ID, and the number of orders required to receive a special order, check the Orders table, and then create an initial list of eligible customers.
- A. In the job workspace, define a script to define the global variable and attach the script to the data flow.
- B. In the Local Object Library, create a new customer function called
CF_MarketingOffer. - C. Create a new batch job and data flow, called Alpha_Marketing_Offer_Job and Alpha_Marketing_Offer_DF respectively, and a new global variable
$G_Num_to_Qual. - D. Confirm that order 11146 has 204000.00 as a total value.
- E. Right click the target table and choose View data .
正解：A、B、C
質問 # 61
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. the Alpha_NACustomer_DF workspace, to open the transform editor, double click the Query transform.
- B. In the Select Function dialog box, choose Lookup Functions.
- C. In the Mapping tab for the Country field, delete the existing expression.
- D. In the Mapping tab, choose Functions.
- E. In the Query Editor, in the output schema, choose the field Country.
正解：A、C、E
質問 # 62
In which parameter the number of seconds to sleep before the
Data Profiler attempts to start pending tasks. Pending tasks have not yet started because the maximum number of concurrent tasks was reached?
- A. Inactive interval (minutes)
- B. Invoke sleep interval (seconds)
- C. Submit sleep interval (seconds)
- D. Active Interval (Seconds)
正解：C
質問 # 63
What can you use a workflow for in SAP Data Services?
- A. to allow schedulling for dataflows
- B. To transform source data into target data
- C. To group jobs that you want to monitor
- D. To group data flows that belong together
正解：D
質問 # 64
......
無料提供中C-DS-42ブレーン問題集とC-DS-42リアル試験問題を試そう：https://www.passtest.jp/SAP/C-DS-42-shiken.html
SAP C-DS-42実際の問題とブレーン問題集：https://drive.google.com/open?id=1NBwIb0PMrczdN0PwMzWzoVUlbxYMCsh8