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

Refer to the exhibit.

A data architect needs to modify the script to ONLY load rows from Table_B when Field_1 and Field_2 are the same as in Table_A.
(For example, only the row containing A, 1, 456 should be loaded from Table_B.)
Which script should the data architect use?

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

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.

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.Canonical calendar
• B.Generic load
• C.Multiple calendars
• D.Data island
• E.Link table

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 manager, split the Customers table, and associate both tables on CustomerlD field
• C.Open the data load editor and use JOIN instead of concatenate to combine Orders and Customers by CustomerlD
• D.Open the data manager, split the Customers table, and JOIN Orders and Customers on the CustomerlD field

A data architect needs to efficiently prepare a data model for a meeting in an hour.
The data source to be used contains five date fields The app needs to display sales trends and compare the current year to date (CYTD) to last year to date (LYTD) The app is NOT going to be published It will only be used for this meeting and a single user's ad-hoc analysis.
What should the data architect do to meet these requirements?

• A.Load a calendar island
• B.Create a canonical calendar
• C.Use the data manager
• D.Create five master calendars