QSDA2021 Sample Questions Answers

A data architect executes the following script:

What will be the result of Table A?

A)

B)

C)

D)

A company has different departments. Executive and Sales should always be the first values in aDepartment filter pane. Which script must the data architect use to meet this requirement?

A)

B)

C)

D)

A data architect needs to revise an existing app.

The number of data rows has grown rapidly recently. While the app is in production, users are becoming increasingly unhappy about the response times when they make selections

Which two methods should be used to improve performance? (Select two.)

ITALY IT001 HR

GERMANY DE002 HR

SPAIN SP03 FINANCE

FRANCE FRO04 SALES

Refer to the exhibit

A company stores the employee data within a key composed of Country UserlD, and Department. These fields are separated by a blank space. The UserlD field is composed of two characters that indicate the country followed by a unique code of two or three digits. A data architect wants to retrieve only that unique code.