Exhibit.
A data architect must load the two tables without creating a synthetic key. The data architect also must make sure expressions like Sum([Budgeted Sales]) are calculated correctly.
Which load script meets these requirements?
A)
B)
C)
D)
A data architect executes the following script:
Which values does the OrderDate field contain after executing the script?
Refer to the exhibit.
A data architect needs to build a dashboard that displays the aggregated sates for each sales representative. All aggregations on the data must be performed in the script.
Which script should the data architect use to meet these requirements?
A)
B)
C)
D)
Exhibit.
Refer to the exhibits.
The Orders table contains a list of orders and associated details. A data architect needs to replace the SupplierlD with the SupplierName using the second table as the source.
The output must be a single table.
Which script should the data architect use?
A)
B)
C)
D)
A data architect needs to load data from two different databases. Additional data will be added from a folder that contains QVDs, text files, and Excel files.
What is the minimum number of data connections required?
