Refer to the exhibit.

A data architect builds a simple data model to show the relationship between students and exams. The data is loaded. Every StudentID in the Exams table should be found in the Students table. Some students have NOT taken an exam.
The data architect selects the field "StudentID" from the Students table and sees the following:

A data architect needs to fix this anomaly.
What should the data architect do to ensure data integrity?

• A. Remove records from the Exams table where StudentID is null
• B. Update the Exams table and add 33.4% of the missing records
• C. Update the Students table and add 16.7% of the missing records
• D. In the LOAD script, add DISTINCT before the Students and Exams tables

A data architect needs to upload different data sources. To properly handle null values, the data architect decides to set all of these values to "Missing Value".
Which syntax should the data architect use?

• A. NullAsValue*;
  Set NullValue = 'Missing Value';
• B. NullasNull *;
  Set NullValues = 'Missing Value';
• C. NullasNull *;
  Set NullValue = 'Missing Value';
• D. NullAsValue*; Set NullValues = 'Missing Value';

Refer to the exhibit.

An app has been built to analyze salesperson performance by department. Salespeople often move between departments. There is a strict business rule which states 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 KPI showing the total sales shows the correct result.
How should the data architect modify the data model to correct the issue?

• A. Create a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship
• B. Join the Transactions and Salespeople tables to resolve the many-to-many relationship
• C. Create a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship
• D. Join the Departments and Salespeople tables to resolve the many-to-many relationship

A data architect builds a data model for a large user group. Some sheets will be published, and the app will allow users to create their own visualizations and analyze dat a. Some fields must NOT appear in any field list.
How should a data architect meet these requirements?

• A. Use HideField variable
• B. Use HidePrefix variable
• C. Use security rules
• D. Add fields to master items

Refer to the exhibit.

The data architect needs to build a model that contains Sales and Budget data for each customer. Some customers have Sales without a Budget, and other customers have a Budget with no Sales During loading, the data architect resolves a synthetic key by creating the composite key For validation, the data architect creates a table containing Customer, Month. Sales, and Budget columns.
What does the data architect see when selecting a month?

• A. Customer and Sales records for that month, but missing values for Budget
• B. All Customers, all Budget and all Sales records
• C. Customer and Budget records for that month, but missing values for Sales
• D. Customer, Sales, and Budget records for that month