Valid QSDA2022 Dumps shared by ExamDiscuss.com for Helping Passing QSDA2022 Exam! ExamDiscuss.com now offer the newest QSDA2022 exam dumps, the ExamDiscuss.com QSDA2022 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com QSDA2022 dumps with Test Engine here:
A data architect needs to create an app that combines employee data from the Sales system and the Human Resources (HR) system. These systems identify employees differently Employees in the HR system are identified with an alpha-numeric key Employees in the Sales system are identified using an integer key. The Human Resources manager creates a table that maps these keys to another, called Associations. The resultant data model must meet the following requirements: * Associations must be valid * The model must be optimized for performance * The option must support multiple tables added Which solution should the data architect use to meet these requirements?
Correct Answer: C
Explanation The MAP function maps the EmployeeKey in the Sales system to the EmployeeKey in the HR system using the Associations table. This allows the data architect to join the data from the Sales system and the HR system using the same key, ensuring that the associations are valid. Using the MAP function also optimizes the performance of the data model as it eliminates the need for multiple joins between the data from the Sales and HR systems. This solution also supports multiple tables added, as the MAP function can be applied to any table that needs to be joined with the HR system data.
