The Marketing department is using some similar KPIs in different apps that need to be modified frequently according to the business needs. The KPIs are created using master items with the same expression.
Which method should the data architect use to manage the modifications in all apps?
Refer to the exhibit
A data architect develops an app for Coffee4all, a coffee company with stores located throughout Europe
The script runs successfully, but the Stores table does not have any values.
What should the data architect do?
A data architect executes the following script:
What will Field_1 contain after this script is executed?
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 company has different departments. Executive and Sales should always be the first values in a Department filter pane. Which script must the data architect use to meet this requirement?
A)
B)
C)
D)
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?