Summer Special Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 8w52ceb345

Refer to the exhibit.

Refer to the exhibit.

A data architect needs to create a data model for a new app. Users must be able to see:

• Total sales for each customer

• Total sales for a given state

• Customers that have not had any sales

• Names of salesperson and regional account managers

• Total number of sales by date

Which steps should the data architect perform to meet these requirements?

Which steps should the data architect perform to meet these requirements?

A.

1. Use a Mapping Load for the Employees table

2. Load the Sales table and use ApplyMap to get the names for SalesPersonID and RegionalAcctMgrlD

3. Use a Left Join Load to add the customer details for the Sales table

B.

1. Load the Customers table and alias the CustID field as CustomerlD

2. Use a Mapping Load for the Employees table

3. Load the Sales table and use ApplyMap to get the names for SalesPersonID and RegionalAcctMgrlD

C.

1. Load the Sales table

2. Load the Customers table

3. Load the Employees table twice; name it and alias the EmployeelD field appropriately each time

D.

1. Load the Customers table and alias the CustID field as CustomerlD

2. Load the Employees table

3. Load the Sales table and alias the SalesPersonID and RegionalAcctMgrlD fields as EmployeelD

QSDA2024 PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now QSDA2024 pdf
Get 60% Discount on All Products, Use Coupon: "8w52ceb345"
Next