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'?
A. 1. Schedule Task 1 to run hourly and refresh data from Source 1
2 Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2
3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs
B. 1 Schedule Task 1 to run hourly and refresh data from Source 1
2 Schedule Task 2 to run weekly and refresh data from Source 2
3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs
C. 1. Schedule Task 1 to run hourly and refresh data from Source 1
2 Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2
3 Schedule a task for the app that is dependent on completion of Tasks 1 and 2 that loads the two QVDs
D. 1 Schedule Task 1 to run hourly and refresh data from Source 1
2 Schedule Task 2 to run weekly and refresh data from Source 2
3. Schedule a task for the app that is dependent on completion of Tasks 1 or 2 that loads the two QVDs
正解:B
質問 2:
Multiple department fields in a dataset require a description.
A data architect needs to add the department descriptions or a default value when the department does NOT have a description.
Which strategy should the data architect use to meet these requirements?
A. Enter "Missing description" in the blank rows for Description.xlsx, then use Mapping Load
B. ApplyMap with three parameters after the Mapping load
C. Left Join between tables and Description.xlsx in every Department table
D. ApplyMap with two parameters after the Mapping load
正解:D
質問 3:
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?
A. NullasNull *;
Set NullValues = 'Missing Value';
B. NullAsValue*;
Set NullValue = 'Missing Value';
C. NullasNull *;
Set NullValue = 'Missing Value';
D. NullAsValue*; Set NullValues = 'Missing Value';
正解:C
質問 4:
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?
A. ApplyMap
B. Peek
C. IntervalMatch
D. Inner Join
正解:C
質問 5:
A data 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?
A. Use the data manager
B. Load a calendar island
C. Create five master calendars
D. Create a canonical calendar
正解:A
1294 お客様のコメント





黒石** -
コンパクトにまとまっていますから好きです。なんとか内定を頂くことができました! とっても嬉しいです!