QUESTION: 17

Refer to the exhibit.

A data architect needs to analyze the number of orders by customer. The data is stored in two Excel files: Orders and Customers The data architect creates a bar chart, but the data is obviously incorrect.
What should the data architect do to resolve this issue?

Open the data manager, split the Customers table, and Concatenate Orders and Customers on the CustomerlD field
Open the data manager split the Customers table, and associate on CustomerlD
Open the data load editor, use CONCATENATE to concatenate Orders and Customers
Open the data load editor, rename the CustomerlD field, and concatenate Orders and Customers

Answer(s): A

Reveal Solution Next Question

QUESTION: 18

A data architect creates a collection of large QVD files that propagate data into their apps This solution works well.
However, a new app that uses a subset of the data in a QVD takes much longer than expected to reload The LOAD statement is

Which two changes should be made to improve load performance?

Answer(s): A,D

Reveal Solution Next Question

QUESTION: 19

Refer to the exhibit.

A company has different departments Executive and Sales should always be the first values in a Department filter pane Which script must the data architect use to meet this requirement^ A)

B)

C)

D)