Refer to the exhibit.

Refer to the exhibits.
The first table shows the source table (Original table).
This data represents the stocks stored every month for each product:
* The relevant fields are productid, qty, and date.
* The date field represents the calendar months using
* The qty field shows the product stock fluctuation from the current month versus the previous month. If there is no fluctuation between months, there are no new entries in the table.
The second table shows a Pivot table visualization the data analyst needs to create in the app displaying per each product the monthly trend of available stock.
For performance reasons, the data analyst requests the data architect to calculate the running stock quantity of each product for every month in the script.
Which approach should the data architect use?

• A. 1. Generate a Calendar table with all dates between the minimum and maximum date values in an Original table
  2. RIGHT JOIN the Calendar table back to the Original table to populate the missing qty values
  3. Use PEEK() and RANGECOUNTO functions to create the running quantity totals for each product for every month
• B. 1 Generate a Calendar table with all dates between the minimum and maximum date values in an Original table
  2. LEFT JOIN the Calendar table back to the Original table to populate the missing qty values
• C. 1 Generate a Cartesian JOIN between productid and date in a Combined table
  2 RIGHT JOIN the Combined table with the Original table to populate the missing qty values
  3. Use PREVIOUS() and RANGESUMQ functions to create the running quantity totals for each product for every month
• D. 1. Generate a Cartesian JOIN between productid and date in a Combined table
  2. LEFT JOIN the Combined table with the Original table to populate the missing qty values
  3. Use PREVIOUSO and SUM() functions to create the running quantity totals for each product for every month

Refer to the exhibit.

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?

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

A data architect needs to arrange data to create an app with a map where multiple location points consolidate into hexagonal areas based on postal codes The areas will be color coded based on the number of vendors in the location.
Which GeoAnalytics operation should the data architect use?

• A. AddressLookup
• B. Intersect
• C. Binning
• D. Simplify

Refer to the exhibits.

While debugging an app, a developer loads data from an application layer QVD file.
In the process of separating a concatenated key into two parts, some split results are missing data What should the data architect do?
1. Utilize a combination of LEFT(), MID(), and RIGHT() functions to capture the key components
2. In the SUBFIELD function, replace the '_' with a '|' or '_' character.
While debugging an app, a developer loads data from an application layer QVD file.
In the process of separating a concatenated key into two parts, some split results are missing data What should the data architect do?

• A. Wrap an IF() function around the SUBFIELD() functions to check and adapt to null values
• B. Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field
• C. Wrap an IF() function around the SUBFIELDQ functions to check and adapt to null values character
• D. In the SUBFIELD function, replace the '- with a '|' or '-' character
• E. Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field
• F. Utilize a combination of LEFT(), MID(), and RIGHTO functions to capture the key components