SAP C-DS-43認定試験問題集には82練習テスト問題があります
最新C-DS-43試験問題集には高得点で一発合格
SAP C-DS-43 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
質問 # 20
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:<blank> skip row headen: yes
- C. Type: Fixed column length:4,2 and 6 skip row headen: yes
- D. Type: Delimited column delimiter:; skip row headen: yes
正解：D
質問 # 21
You executed a job in development environment and it raised primary key violation error in SAP Data Services. Which feature do you enable to identify which primary key values caused the errors?
- A. Drop and re-created target table
- B. Auto correct load
- C. Use overflow file
- D. delete data before loading
正解：C
質問 # 22
Which type of SAP Data Services object can a project, job, dataflow or workflow contain? 3 correct answers
- A. A job can contain a workflow
- B. A dataflow can contain a workflow
- C. A workflow can contain a workflow
- D. A job can contain a job
- E. A Project can contain a job
正解：B、D、E
質問 # 23
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. add a try block before each dataflow and a Catch block after each dataflow
- B. Merge the dataflows from the job and rerun it.
- C. Design the dataflow to ensure a second run does not result in duplicate
- D. Run the nightly job with the enable recovery flag turned on.
正解：A、C
質問 # 24
You are instructed to calculate the maximum value in the SALARY column of an EMPLOYEE table.
How can you achieve this in SAP Data Services?
- A. Call max(SALARY) from a Custom function
- B. Use max (SALARY) in a script.
- C. Use max(SALARY) in a conditional
- D. Enter max (SALARY) in the query transform
正解：D
質問 # 25
You created and saved a database datastore in SAP Data Services. Which properties can you change in the Edit Datastore dialog box?
- A. database name
- B. database version
- C. Datastore name
- D. database server name
- E. user name and password
正解：E
質問 # 26
You define audit rules for critical data flow to confirm that you SAP Data Services batch job loaded only correct dat a. Which audit functions are available to define these rules for columns? Note: There are 3 correct answers
- A. Min
- B. sum
- C. Average
- D. Count distinct
- E. Checksum
正解：B、C、E
解説：
There are four Audit Functions available in BODS.
* COUNT function helps to get the audit information on a table or output schema. The default datatype is INTEGER.
* SUM function helps to generate audit information like summation of measure type columns. E.g. Revenue. Accepted datatypes are INTEGER, DECIMAL, DOUBLE, REAL.
* AVERAGE function helps to generate audit information like average of measure type columns. E.g. Profit Margin. Accepted datatypes are INTEGER, DECIMAL, DOUBLE, REAL.
* CHECKSUM function helps to audit based on the hash values generated for VARCHAR datatype columns. The order of rows is important for the result of CHECKSUM function.
https://blogs.sap.com/2013/09/18/auditing-in-sap-data-services/
質問 # 27
In SAP Data Services why would you select the produce default output checkbox in the Case transform?
- A. to output all rows that do match exactly one case expression
- B. To output all rows that match the case statement
- C. To output all rows to the default path regardless if the they match the case expressions.
- D. To output all rows that do not match any case expression to the default path
正解：D
質問 # 28
What is the relationship between local variables and parameters in SAP Data Services? 2 correct answers
- A. 3 local variable in a job sets the value of an a parameter in a workflow
- B. a parameter in a job set the value of a local variable in a dataflow
- C. a parameter in a workflow sets the value of a local variable in a dataflow
- D. a local variable in a workflow sets the value of an a parameter in a dataflow.
正解：A、D
質問 # 29
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. Connect the two dataflows with line
- B. Embed the first dataflow in a try-catch
- C. Add a script between the dataflows using the error_number() function
- D. Use a conditional for the second dataflow
正解：A
質問 # 30
Which features are supported by the SAP Data Services interactive debugger?
3 correct answers
- A. Show sample rows of each step
- B. Set breakpoint
- C. Define additional filters
- D. Show performance-related statistics
- E. Show the optimized execution plan
正解：A、B、C
質問 # 31
Which feature in the SAP Data Services Management Console allows you to see the trend of the execution time for any given job?
- A. monitor log
- B. data quality reports
- C. Operational dashboard
- D. trace log
正解：C
質問 # 32
In SAP data services what does the date generation transform allow you to generate?
- A. the valid from date based on a dataset the contains valid to information only
- B. The current date for a column to see when each row was loaded.
- C. The rows for a given date range
- D. the valid to date based on a dataset the contains valid to information only
正解：C
質問 # 33
You want to display the description of an object in the Designer workspace-Which task must you perform to accomplish this in SAP Data services?
3 correct answers
- A. Click the view enabled descriptions button on the toolbar.
- B. Enter a description in the properties of the object.
- C. right-click the object then choose enable description .
- D. disiable the hide non - executable elements setting in the difference viewer.
- E. Right - click on the job in the project hierarchy to enable all descriptions.
正解：A、C、D
質問 # 34
You built a delta load dataflow in SAP Data Services. This Dataflow is executed every night. The source table contains a CHANGE_DATE column which is populated by the database when the row is saved.
What can a timestamp based CDC aproach identify in the source based on this CHANGE_DATE column
- A. Inserted and updated rows but not delete rows
- B. Insert, updates and deletes for a specified time range.
- C. Every single change made to a row
- D. Update rows but NOT insert or deleted records.
正解：A
質問 # 35
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 control how the data is loaded.
- B. To ensure compatibility with subsequent transforms
- C. To push the data down for better performance
- D. To increase the speed that the database loads
正解：A、B
質問 # 36
You are reading a Sales Order table from the source and need to add the customer region information a from a customer table. The primary key of the customer table consists of the columns CUST_ID and VALID_FROM How would you desing the dataflow to get the region information that was valid at the ORDER_CREARTE_DATE?
- A. Use a regular lookup function
- B. Use a lookup_ext function
- C. Perform an outer join between both tables
- D. Join the two tables
正解：A
質問 # 37
Why would you use a memory datastore in your SAP Data Services dataflow design?
- A. To reduce the memory consumption in the source database.
- B. To define a connection to SAP HANA
- C. To reduce the memory consumption in the target database.
- D. To enhance processing performance of datadlows used in real time jobs.
正解：A
質問 # 38
What are advantages of using the validation transform in SAP Data services? There are 3 correct answers to this question
- A. You can see which rules were violated in one output
- B. You can call a recovery dataflow
- C. You can have multiple rules on a single column.
- D. You can set different failed paths for each rule
- E. You can produce statistics
正解：A、C、D
質問 # 39
How do you view the data between transforms in SAP Data Services dataflow?
- A. By setting the SQL Transforms on job execution trace option
- B. By using the interactive debugger
- C. By adding audit points in the dataflow
- D. By setting the Audit Data On job execution trace option
正解：B
質問 # 40
What requirement must you meet when mapping an output column on the SAP Data Services query transform mapping tab?
- A. Each column in the output schema must be mapped to one or more columns in the input schema
- B. Every column of the output schema must have a mapping
- C. All columns of the input schema must be mapped to the output schema
- D. Primary keys in the input schema must be mapped to only one column in the output schema
正解：A
質問 # 41
What are standard component of SAP Dataservices? There are 3 correct answers
- A. Access server
- B. Real time services
- C. Secure local repository
- D. Job server
- E. Design studio
正解：A、C、D
質問 # 42
You build a Data Warehouse with a date dimension in SAP Data Services. You decide to use the Date Generation transform to create this. What options are available to control the output form the transform?
- A. Increment
- B. end date
- C. Effective date column
- D. Julian format
正解：B
質問 # 43
You execute an SAP data services job with enable recovery activated. One of the dataflows in the jobs raises an exception that interrupts the execution. You run the job again with Recover from last failed execution enabled. What happens to the data flow that raised the exception during the first execution?
- A. Is is rerun with the first failed row.
- B. It is rerun from the beginning and the desing of the data flow must deal with partially loaded data.
- C. It is rerun from the beginning and the partially loaded data is always handled automanticaly.
- D. It is rerun only if the dataflow is part of a recovery unit.
正解：A
質問 # 44
......
無料提供中C-DS-43ブレーン問題集とC-DS-43リアル試験問題を試そう：https://jp.fast2test.com/C-DS-43-premium-file.html