A data architect needs to retrieve data from a REST API. The data architect needs to loop over a series of items that are being read using the REST connection.What should the data architect do?
Refer to the exhibit.What does the expression SUM([OrderNetAmount]) return when all values in LineNo are selected?
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 exhibit.A data architect must load the two tables without creating a synthetic key. The data architect also must make sure expressions like Sum([Budgeted Sales]) are calculated correctly.Which load script meets these requirements?
Refer to the exhibit.A data architect is provided with five tables. One table has Sales Information. The other four tables provide attributes that the end user will group and filter by.There is only one Sales Person in each Region and only one Region per Customer.Which data model is the most optimal for use in this situation?
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?
