Online Access Free QSDA2019 Practice Test

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?

• A.Open the data load editor, rename the CustomerlD field, and concatenate Orders and Customers
• B.Open the data manager, split the Customers table, and Concatenate Orders and Customers on the CustomerlD field
• C.Open the data load editor, use CONCATENATE to concatenate Orders and Customers
• D.Open the data manager split the Customers table, and associate on CustomerlD

Refer to the exhibit.

• A.* The UserAccess Table contains seven fields: Year, Month. Hour. AccessID, AccessDate. UserlD, and Duration (minutes)
  * The table is linked to the Access table with the AccessID field and linked to Users on the UserlD field
• B.* The UserAccess table contains seven fields AccessYear. AccessMonth. Hour. AccesslD, AccessDate. UserlD. and Duration (minutes)
  * The table is linked to the Access table on the AccesslD field and linked to Users on the UserlD field
• C.* The UserAccess table contains seven fields Year Month, Hourr AccesslD. AccessDate. UserlD, and Duration (minutes)
  * The table is only linked to Users on the UserlD field
• D.* The UserAccess table contains seven fields AccessYear, AccessMonth, Hour AccesslD, AccessDate, UserlD, and Duration (minutes)
  * The table is only linked to Users on the UserlD field

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)

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

A data architect needs to create an app that combines employee data from the Sales system and the Human Resources (HR) system.
These systems identify employees differently. Employees in the HR system are identified with an alpha-numeric key. Employees in the Sales system are identified using an integer key The Human Resources manager creates a table which maps these keys to one another, called Associations.
The resultant data model must meet the following requirements:
* Associations must be valid
* The model must be optimized for performance
* The option must support multiple tables added from both systems now and in the future Which function should the data architect use to meet these requirements?

• A.MapSubString('Associations', EmployeeKey) AS EmployeeKey;
• B.RENAME FIELDS USING Associations;
• C.APPLYMAP { 'Associations' , EmployeeKey) AS EmployeeKey;
• D.MAP EmployeeKey USING Associations;

A customer has a dataset that contains latitude and longitude data for service points around the country. The data is retrieved using the following statement:

It must be clear to the end user that this is geographic dat
a. Drag and drop, map-based visualization of this data is required. Which two steps should the data architect take to support this data? (Select two.)

• A.Add the following to the end of the script:
  TAG FIELD LocationName With 'Sgeoname', *@relates_Pt';
  TAG FIELD Point With 'Sgeopoint*f 'Srelates Location', '$hidden';
• B.Add the following to the end of the script:
  TAG FIELD LocationName With 'Sgeodata1, 'Srelated'; TAG FIELD Point With 'Sgeodata', 'Srelated1;
• C.Add GeoProject{' Point' , Lat&Long) AS Point to the preceding load
• D.Define Location as a master item, and set the tag to Sgeodata
• E.Add GeoKakePoint (Lat, Long} as Point to Location's preceding load