Users of a published app report incomplete visualizations. The data architect checks the app multiple times and cannot replicate the error. The error affects only one team.
What is the most likely cause?
A data architect needs to write the expression for a measure on a KPI to show the sales person with the highest sales The sort order of the values of the fields is unknown When two or more sales people have sold the same amount, the expression should return all of those sales people
Which expression should the data architect use?
Refer to the exhibits.
Some business users created an app by using the Add data functionality and loading two Excel files Orders and Customers.
The app is used to analyze the number of orders by customer. When the users create a bar chart to review the figures, the data shown is incorrect.
What should the data architect do to resolve this issue?
A data architect needs to load Table_A from an Excel file and sort the data by Field_2.
Which script should the data architect use?
A)
B)
C)
D)
Multiple department fields in a dataset require a description
A data architect needs to add the department descriptions or a default value when the department does NOT have a description
Which strategy should the data architect use to meet these requirements?
A data architect executes the following script:
What will be the result of Table A?
A)
B)
C)
D)
A data architect wants to combine data on presentand historic sales performance.The historic data is stored in a de-normalized archive, and the present data is maintained in a database. The output must be contained in a single table.
Which script should the data architect use?
A)
B)
C)
D)
Refer to the exhibit.
A data architect is loading two tables into a data model from a SQL database These tables are related on key fields CustomerlD and CustomerKey.
Which script is valid to load the tables and maintain the correct association?
A)
B)
C)
D)
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?
A company has different departments. Executive and Sales should always be the first values in aDepartment filter pane. Which script must the data architect use to meet this requirement?
A)
B)
C)
D)
TESTED 16 Oct 2025