[Jan-2024] C_DS_42 Free Sample Questions to Practice One Year Update
Download C_DS_42 exam with SAP C_DS_42 Real Exam Questions
NEW QUESTION # 46
In addition to the main databases for source information, records for orders are stored in flat files. You need to extract data from these flat files, and so must create the appropriate file format for the extraction. Create a file format Orders_Format for an orders flat file so that you can use it as a source object for extraction. (Validate the correct statement).
- A. Enter Orders_Format as the format name.
- B. Right click your new file format Orders_Format and choose View Data .
- C. Right click the Flat Files node and choose New.
- D. In the Local Objects Library, choose Formats tab.
Answer: A,C,D
NEW QUESTION # 47
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 Construct an audit rule that an exception must be entered into the log if the count from both tables is not the same.
- A. On the Label tab, right click the target table, Alpha_NA_customer , and choose Count .
- B. Choose Close .
- C. In the right drop down list, choose the audit label $count_Alpha_NA_customer for the target table.
- D. In the Rule tab, under Auditing Rules , choose Add .
- E. In the operator drop down list, choose the operator equal (=).
- F. Under Action on failure, select the Raise exception checkbox.
Answer: B,C,D,E,F
NEW QUESTION # 48
By which application you do View, analyze, and print graphical representations of all objects as depicted in the Designer including their relationships, properties, and more?
- A. Data Validation Dashboard
- B. Operational Dashboard
- C. Impact and Lineage Analysis
- D. Data Quality Reports
- E. Administrator
- F. Auto Documentation
Answer: F
NEW QUESTION # 49
Which syntax rules must you follow in the SAP
Data Services scripting language?
- A. A statement ends with a dot sign (.).
- B. A variable starts with a percent sign (%).
- C. A comment starts with a hash (#).
- D. A variable starts with a dollar sign ($).
Answer: C,D
NEW QUESTION # 50
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. Update rows but NOT insert or deleted records.
- B. Insert, updates and deletes for a specified time range.
- C. Inserted and updated rows but not delete rows
- D. Every single change made to a row
Answer: C
NEW QUESTION # 51
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
Answer: D
NEW QUESTION # 52
In SAP Data Services why would you select the produce default output checkbox in the Case transform?
- A. To output all rows that match the case statement
- B. To output all rows to the default path regardless if the they match the case expressions.
- C. To output all rows that do not match any case expression to the default path
- D. to output all rows that do match exactly one case expression
Answer: C
NEW QUESTION # 53
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. Choose New Batch Job
- B. Alpha_NACustomer_DF data flow and choose Replicate .
- C. Rename the copied data flow Alpha_AuditCustomer_DF.
- D. Right click the Omega project in the Project Area.
- E. In the Local Object Library Data Flow tab right click the
- F. Name the new job Alpha_AuditCustomer_Job .
Answer: A,C,D
NEW QUESTION # 54
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. Desing the dataflow to ensure a second run does not result in duplicate
- C. Merge the dataflows from the job and rerun it.
- D. Run the nightly job with the enable recovery flag turned on.
Answer: B
NEW QUESTION # 55
Which repository types are used in SAP Data Services? 2 correct
- A. Central Repository
- B. Remote Repository
- C. Data repository
- D. Profiler repository
Answer: D
NEW QUESTION # 56
What errors can you handle in SAP Services when you use a file format target?
- A. Semantic error
- B. Data type conversion error
- C. File type error
- D. Row- format error
Answer: D
NEW QUESTION # 57
An SAP Data Services dataflow adds the changed data (insert and update) into a target table every day.
How do you desing the dataflow to ensure that a partially executed dataflow recovers automatically the next time it is executed?
2 correct answers
- A. Enable the Delete data before load target table loader option
- B. Add lookup function in the where? clause to filter out existing rows.
- C. Use the table comparison transform before the table loader
- D. Set the autocorrect load option in the target table loader option
Answer: C
NEW QUESTION # 58
In which situation is it appropriate to use a time - based CDC to capture changes in source data with SAP Data services
- A. When there are large tables with few changes
- B. when you need to capture physical deletes from source
- C. When almost all of the rows have changes
- D. When you need to capture intermediate changes
Answer: A
NEW QUESTION # 59
What is the relationship between local variables and parameters in SAP Data Services? 2 correct answers
- A. a parameter in a workflow sets the value of a local variable in a dataflow
- B. 3 local variable in a job sets the value of an a parameter in a workflow
- C. a local variable in a workflow sets the value of an a parameter in a dataflow.
- D. a parameter in a job set the value of a local variable in a dataflow
Answer: C
NEW QUESTION # 60
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. Checksum
- B. Min
- C. sum
- D. Count distinct
- E. Average
Answer: A,C,E
Explanation:
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/
NEW QUESTION # 61
In SAP data services what does the data generation transform allow you to generate?
- A. The rows for a given data range
- B. the valid to date based on a dataset the contains valid to information only
- C. the valid from date based on a dataset the contains valid to information only
- D. The current date for a column to see when each row was loaded.
Answer: A
NEW QUESTION # 62
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. Batch
- B. Real-Time
- C. Profiler
- D. Adapters
Answer: A
NEW QUESTION # 63
Which features are supported by the SAP Data Services interactive debugger?
3 correct answers
- A. Show performance-related statistics
- B. Show the optimized execution plan
- C. Show sample rows of each step
- D. Define additional filters
- E. Set breakpoint
Answer: C,D,E
NEW QUESTION # 64
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. Right click the target table and choose View data .
- B. In the Local Object Library, create a new customer function called
CF_MarketingOffer. - C. Confirm that order 11146 has 204000.00 as a total value.
- D. In the job workspace, define a script to define the global variable and attach the script to the data flow.
- E. 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.
Answer: B,D,E
NEW QUESTION # 65
which transform are typically used to implement a slowly changing dimension of type 2 in SAP Data services?
3 correct answers
- A. Table_comparison
- B. Data_Transfer
- C. Map_CDC_Operation
- D. Key_Generation
- E. History_Preserving
Answer: A
NEW QUESTION # 66
An SAP data services job was executed in the past.
Where can you see the order that the dataflows were executed in?
There are 2 correct answers to this question.
- A. In the impact and Lineage Analysis report
- B. In the job server log
- C. In the operational dashboard
- D. In the job trace log.
Answer: D
NEW QUESTION # 67
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. Run the nightly job with the enable recovery flag turned on.
- D. Design the dataflow to ensure a second run does not result in duplicate
Answer: A,D
NEW QUESTION # 68
You decide to distribute the execution of a job across multiple job servers within a server group. What distribution levels are avaible?
3 answers correct
- A. workflow
- B. Embedded dataflow
- C. JOB
- D. Dataflow
- E. subdataflow
Answer: C
NEW QUESTION # 69
......
Real exam questions are provided for SAP Certified Application Associate tests, which can make sure you 100% pass: https://www.dumpstorrent.com/C_DS_42-exam-dumps-torrent.html
C_DS_42 Exam with Guarantee Updated 82 Questions: https://drive.google.com/open?id=1_iH5cgwENW7BrZe_bOsce9NXp0vbvHbv