C_DS_42 Online Practice Questions and Answers

Management Console contains a collection of Web-based applications for administering the following Data Services features and objects.

A. Object relationship analysis

B. Job execution performance evaluation

C. Jobs and services executions

D. Data Processing

Which connection does Management Console use to repositories?

A. JDBC connection

B. Server Connection

C. Internet Connection

D. JDNC Connection

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. Settings

B. Home

C. Logout

D. Question mark icon

Contains repository names associated with the Job Server on which you run_______?

A. Batch

B. Real-Time

C. Adapters

D. Profiler

How to Use a WHERE clause to select only customers in North America (North American countries are United States, Canada, and Mexico which have COUNTRYID values of 1, 2,and 11)?

A. In the Query editor, choose the WHERE tab

B. Enter the where clause, customer.COUNTRYID in (1,2,11)

C. To save all changes, choose OK

D. Confirm that 22 records were loaded

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 an Audit label for the new target table and create a custom audit rule to verify the sum of the count of the two target tables is equal to the count of the source table.

A. In the Local Object Library Data Flow tab, right click the Alpha_AuditCustomer_DF data flow and choose Audit

B. On the Label tab of the Audit dialog, right click Alpha_Other_customer and choose Count .

C. Save all changes

D. In the Audit editor, choose the Rule tab.

When evaluating the customer data for Alpha Acquisitions, you discover a data entry error. The contact title of "Account Manager" has been entered as "Accounting Manager". You must correct these entries before it is moved to the data warehouse. How to Execute the Alpha_NACustomer_Job with the default execution properties after saving all of the objects that you have created.

A. In the Omega project, right click the Alpha_Customers_Job.

B. In the Replace value column, enter Account Manager .

C. Choose Finish .

D. Choose Execute.

E. To use the default execution properties, choose OK.

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 Query transform, create a new output column TOTAL_VALUE , which will hold the new calculation.

A. To map the ORDERID column from the input schema to the same field in the output schema, select ORDERID and drag to the output schema

B. In the output schema, right click ORDERID and choose New output column.

C. Choose the Where tab or the From tab.

D. Choose Insert Below.

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. Invoke sleep interval (seconds)

B. Submit sleep interval (seconds)

C. Inactive interval (minutes)

D. Active Interval (Seconds)

________for the user account through which SAP Data Services connects to this SAP application server.

A. SAP application server name

B. Client number

C. User Name

D. Password