QUESTION: 33

Refer to the exhibits.
An app is built to analyze salesperson performance by department. Departments are unique within the Departments table, but Salespeople often move between departments. A strict business rule states that a salesperson must be associated with ONLY one department at all times. The data architect creates a summary of department performance and notices the values are incorrect. The total sales KPI shows the correct result. How should the data architect modify the data model to correct this issue?

Create a bridge table between the Departments and Salespeople tables to resolve the many-to- many relationship
Create a bridge table between the Transactions and Salespeople tables to resolve the many-to- many relationship
Join the Departments and Salespeople tables to resolve the many-to-many relationship
Join the Transactions and Salespeople tables to resolve the many-to-many relationship

Answer(s): A

Explanation:

Reveal Solution Next Question

QUESTION: 34

A data architect needs to upload data from ten different sources, but only if there are any changes after the last reload When data is updated, a new file is placed into a folder mapped to E A439926003 The data connection points to this folder.
The data architect plans a script which will:
1. Verify that the file exists
2. If the file exists, upload it Otherwise, skip to the next piece of code

The script will repeat this subroutine for each source.
When the script ends, all uploaded files will be removed with a batch procedure.
Which option should the data architect use to meet these requirements?

FileSize, IF, THEN, END IF
FilePath, IF, THEN. Drop
FileExists, FOR EACH, IF
FilePath, FOR EACH, Peek, Drop

Answer(s): A

Explanation:

Reveal Solution Next Question

QUESTION: 35

On executing a load script of an app, the country field needs to be normalized. The developer uses a mapping table to address the issue.
What should the data architect do?