Online Access Free QSDA2021 Practice Test

A data architect executes the following script:

What will be the result of Table A?
A)

B)

C)

D)

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

A company generates 1 GB of ticketing data daily. The data is stored in multiple tables Business users need to see trends of tickets processed for the past. 2 years Users very rarely access the transaction-level data for a specific date. Only the past 2 years of data must be loaded which is 720 GB of data Which method should a data architect use to meet these requirements?

• A.Load only aggregated data for 2 years and use On-Demand App Generation (ODAG) for transaction data
• B.Load only 2 years of data in an aggregated app and create a separate transaction app for occasional use
• C.Load only 2 years of data and use best practices in scripting and visualization to calculate and display aggregated data
• D.Load only aggregated data for 2 years and apply filters on a sheet for transaction data

A data architect executes the following script.

Which values does the OrderDate field contain after executing the script?

• A.20210131, 2020/01/31, 31/01/2019, 9999
• B.20210131,2020/01/31,31/01/2019
• C.20210131, 2020/01/31, 31/01/2019, 31/12/20
• D.20210131, 2020/01/31, 31/01/2019, 0

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.

• A.LTRIM (SUBFIELD (Key, ' ', 2), 2)
• B.RIGHT(SUBFIELD (Key,' ', 2), 3)
• C.LEFT(SUBFIELD(Key, ' ', 2), 2)
• D.MID ( SUBFIELD (Key , ' ', 2), 3)

Refer to the exhibit.

A Human Resources Director needs an app to analyze organizational structure. The Directory is particularly interested in the longest levels of line management.
Two table loads are required. Both use the same basic structure.

Which two table load prefixes are needed?

• A.* HierarchyBelongs.To(EmployeeID, ManagerlD, Name ManagerlD, Manager, Depth)
• B.* Hierarchy(EmployeelD. ManagerlD Name, Manager Name, Structure V, Depth)
  * HierarchyLevelEmployeelD, ManagerlD, Name, Manager, Name, Structure, Depth '/')
• C.* HierarchyLevel(EmployeelD, ManagerlD Name Level, '/', Structure)
  * HierarchyBelongsTo(EmployeelD, ManagerlD, Name ManagerlD, Manager, Depth)
• D.* HierarchyBelongsTo(ManagerlD, Manager, ManagerlD, ManagerlD, Manager Level)
  * Hierarchy(EmployeelD, ManagerlD, Name. Manager Name, Structure '/' Depth)