Refer to the exhibit.
Refer to the exhibit
A data architect is working on an app that contains orders, invoices, and shipping dat a. 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?
A. Create a Month field for each of the three dates in the fact table and use that in the chart
B. Left Join the three date fields onto one bridge table using the key field containing KeyField and Date
C. Load the key field and the three date fields into a concatenated bridge table that contains KeyField and Date
正解:C
質問 2:
Refer to the exhibit.
Refer to the exhibits.
An app is built to analyze salesperson performance by department. Departments are unique within the Departments table, but Salespeople often move between departments. A strict business rule states that a salesperson must be associated with ONLY one department at all times.
The data architect creates a summary of department performance and notices the values are incorrect. The total sales KPI shows the correct result.
How should the data architect modify the data model to correct this issue?
A. Join the Departments and Salespeople tables to resolve the many-to-many relationship
B. Create a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship
C. Join the Transactions and Salespeople tables to resolve the many-to-many relationship
D. Create a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship
正解:D
質問 3:
Refer to the exhibits.
Some business users created an app by using the Add data functionality and loading two Excel files Orders and Customers.
The app is used to analyze the number of orders by customer. When the users create a bar chart to review the figures, the data shown is incorrect.
What should the data architect do to resolve this issue?
A. Open the data load editor and apply a NOCONCATENATE function in the LOAD statement on the Orders table
B. Open the data load editor and use JOIN instead of concatenate to combine Orders and Customers by CustomerlD
C. Open the data manager, split the Customers table, and JOIN Orders and Customers on the CustomerlD field
D. Open the data manager, split the Customers table, and associate both tables on CustomerlD field
正解:B
質問 4:
A data architect wants to combine data on present and historic sales performance. The historic data is stored in a de-normalized archive, and the present data is maintained in a database. The output must be contained in a single table.
Which script should the data architect use?
A)
B)
C)
D)
A. Option C
B. Option A
C. Option D
D. Option B
正解:A
質問 5:
Refer to the exhibit.
A data architect is loading two tables into a data model from a SQL database These tables are related on key fields CustomerlD and CustomerKey.
Which script is valid to load the tables and maintain the correct association?
A)
B)
C)
D)
A. Option C
B. Option A
C. Option D
D. Option B
正解:A
黒沢** -
超効率的な勉強法ですね!つまずくことなく、このQSDA2021の本と過去問で1週間で合格できた。