SAP Exam C_DS_42 Topic 5 Question 11 Discussion

Actual exam question for SAP's C_DS_42 exam

Question #: 11
Topic #: 5

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.

AIn the Mapping tab, choose Functions.

BIn the Select Function dialog box, choose Lookup Functions.

Cthe Alpha_NACustomer_DF workspace, to open the transform editor, double click the Query transform.

DIn the Query Editor, in the output schema, choose the field Country.

EIn the Mapping tab for the Country field, delete the existing expression.

Show Suggested Answer

Suggested Answer: C, D, E

by Viola at May 03, 2022, 04:36 AM

Limited Time Offer

25%

Off

Get Premium C_DS_42 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!