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 customer needs to load forecast data from an Excel file.
Which preceding load statement should the data architect use to load the data?
A)
B)
C)
D)
A global retailer has a large database in which millions of sales transactions are added per hour.
Each regional sales manager should only see details for customers in their region.After filtering based on criteria such as region, gender, and income level, sales managers should be able to see the most current detailed transactions.
What should a data architect do to meet these requirements?
Adata architect needs to efficiently prepare a data model for a meeting in an hour.
The data source to be used contains five date fields The app needs to display sales trends and compare the current year to date (CYTD) to last year to date (LYTD) The app is NOT going to be published It will only be used for this meeting and a single user's ad-hoc analysis.
What should the data architect do to meet these requirements?
On executing a load script of an app, the country field needsto be normalized.The developer uses a mapping table to address the issue.
What should the data architect do?
