Refer to the exhibit.
Which changes on the database will the script capture?
A data architect is developing an app that will generate QVDs for multiple business analysts. The field naming conventions on the source data are NOT business friendly. For every table loaded, multiple fields will require a name change.
An Excel file is maintained centrally that lists all source data field names and the appropriate names as they should appear in the QVDs
Which strategy should the data architect use to meet these requirements?
Refer to the exhibits.
A business analyst needs to see the currency conversion provided by a third party process, and only contains a record when the rate changes in a chart. The currency conversion rate data is
An existing master calendar exists in the data model that contains a full set of dates.
Which technique should the data architect use to meet this requirement?
A data architect completes development of a new app with two data sources Both data sources will also be used by other apps in the future The sources have different data refresh frequencies
• Source 1 Contains frequently updated data and must be refreshed hourly
• Source 2 Contains data that is transferred from a partner and must be refreshed weekly
Tasks must be created to load the data sources and make sure that the new app uses the most current data The data will be stored in two QVDs Which tasks should be created to meet these requirements'?
TESTED 19 Apr 2024
