A company generates 1 GB of ticketing data daily. The data is stored in multiple tables Business users need to see trends of tickets processed for the past two years. Users very rarely access the transaction-level data for a specific date. Only the past two years of data must be loaded which is 720 GB of data
Which method should a data architect use to meet these requirements?
Refer to the exhibit.
The data architect needs to create a KPI that displays the average amount of orders per customer. This aggregated field should be added to the existing orders table Which script should the data architect use?
A)
B)
C)
D)
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 scripts should be used to load the data while maintaining the correct associations?
A)
B)
C)
D)
A data architect executes the following script:
What will be the result of Table_A?
A)
B)
C)
D)
Refer to the exhibit.
A data architect has a data model that includes historical order fulfillment centers. The order fulfillment centers occasionally changed location. The history of order fulfillment must be tracked on a per center, per location basis.
Which scripting function should the data architect use to meet this data modeling requirement?
Currently there are no comments in this discussion, be the first to comment!