QUESTION NO: 1
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)
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)
Correct Answer: D
Vote an answer
QUESTION NO: 2
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)
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)
Correct Answer: A
Vote an answer
QUESTION NO: 3
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.)
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.)
Correct Answer: B,D
Vote an answer
QUESTION NO: 4
A data architect needs to load Table_A from an Excel file and sort the data by Field_2.
Which script should the data architect use?
A)
B)
C)
D)
A data architect needs to load Table_A from an Excel file and sort the data by Field_2.
Which script should the data architect use?
A)
B)
C)
D)
Correct Answer: D
Vote an answer
QUESTION NO: 5
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.
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.
Correct Answer: D
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).