A Human Resources Director needs an app to analyze organizational structure. The Directory is particularly interested in the longest levels of line management.
Two table loads are required. Both use the same basic structure.
Which two table load prefixes are needed?
A data architect needs to add the UnitCost field from the ProductCost table in the Dim_Products Table.
Which script code should the data architect use?
A)
B)
C)
D)
A data architect is building a model to show trends in visualizations across seven date fields. The seven date fields reside in different tables. The data architect must efficiently build this data model.
Requirements:
• A single date selector
• Show all dates, even those with NO activity
• Minimize the impact on server resources and p
Which two solutions should the data architect use? (Select two.)
A data architect needs to upload data from ten different sources, but only if there are any changes after the last reload When data is updated, a new file is placed into a folder mapped to E A439926003 The data connection points to this folder.
The data architect plans a script which will:
1.Verify that the file exists
2. If the file exists, upload it Otherwise, skip to the next piece of code
The script will repeat this subroutine for each source. When the script ends, all uploaded files will be removed with a batch procedure.
Which option should the data architect use to meet these requirements?
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?
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)
Refer to the exhibit
A data architect is working on an app that contains orders, invoices, and shipping data. There are three different date fields within the data:
* OrderDate
* InvoiceDate
* ShippingDate
The business analyst needs to replicate the chart above to show Order and Shipping amounts on the same Month axis.
What should the data architect do?