QSDA2022 무료 덤프문제 온라인 액세스

A table is generated resulting from the following script

When the data architect selects a date, some, but NOT all, orders for that date are shown How should the data architect modify the script to show all orders for the selected date?
A)

B)

C)

D)

• A.Option B
• B.Option A
• C.Option D
• D.Option C

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?

• A.Create a Month field for each of the three dates in the fact table and use that in the chart
• B.Load the key field and the three date fields into a concatenated bridge table that contains KeyField and Date
• C.Left Join the three date fields onto one bridge table using the key field containing KeyField and Date

Refer to the exhibit.

A data architect is loading the tables and a synthetic key is generated.
How should the data architect resolve the synthetic key?

• A.Remove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field
• B.Remove the LineNo field from both tables and use the AutoNumber function on the OrderlD field
• C.Create a composite key using OrderlD and LineNo
• D.Create a composite key using OrderlD and LineNo, and remove OrderlD and LineNo from Shipments

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.ApplyMap with two parameters after the Mapping load
• B.Left Join between tables and Description xlsx in every Department table
• C.ApplyMap with three parameters after the Mapping load
• D.Enter "Missing description" in the blank rows for Description xlsx then Mapping Load

Refer to the exhibit.

The data architect needs to create a KPI that displays the average amount of orders per customer. This aggregated field should be added to the existing orders table Which script should the data architect use?
A)

B)

C)

D)

• A.Option B
• B.Option A
• C.Option D
• D.Option C