Online Access Free QSDA2021 Practice Test

Refer to the exhibit.

Refer to the exhibit
A data architect is working on an app that contains orders, invoices, and shipping dat a. There are three different date fields within the data:
* OrderDate
* InvoiceDate
* ShippingDate
The business analyst needs to replicate the chart above to show Order and Shipping amounts on the same Month axis.
What should the data architect do?

• A.Left Join the three date fields onto one bridge table using the key field containing KeyField and Date
• B.Load the key field and the three date fields into a concatenated bridge table that contains KeyField and Date
• C.Create a Month field for each of the three dates in the fact table and use that in the chart

Refer to the exhibits.

While debugging an app, a developer loads data from an application layer QVD file.
In the process of separating a concatenated key into two parts, some split results are missing data What should the data architect do?
1. Utilize a combination of LEFT(), MID(), and RIGHT() functions to capture the key components
2. In the SUBFIELD function, replace the '_' with a '|' or '_' character.
While debugging an app, a developer loads data from an application layer QVD file.
In the process of separating a concatenated key into two parts, some split results are missing data What should the data architect do?

• A.Utilize a combination of LEFT(), MID(), and RIGHTO functions to capture the key components
• B.In the SUBFIELD function, replace the '- with a '|' or '-' character
• C.Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field
• D.Wrap an IF() function around the SUBFIELDQ functions to check and adapt to null values character
• E.Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field
• F.Wrap an IF() function around the SUBFIELD() functions to check and adapt to null values

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.Denormalize the schema
• B.Use flags in the data model to simplify set analysis
• C.Make sure any Ul variables are preceded by '='
• D.Use dynamic script generation with variables
• E.Create master items for all complex expressions

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 that maps these keys to 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
Which solution should the data architect use to meet these requirements?

• A.RENAME FIELDS USING Associations;
• B.APPLYMAP ( 'Associations , EmployeeKey ) as Employeekey;
• C.MAPSUBSTRING ( 'Associations' ,EMployeekey) As Employeekey;
• D.MAP EmloyeeKey USING Associations;

A company has a stream with multiple apps One of the apps is a multi-regional sales app.
A data architect must set up security for users to access the stream, enter the app, and view specific sheets and data.
Which features should the data architect use to meet these requirements?

• A.QMC security rules and custom properties
• B.QMC security rules and section access
• C.Section access and set analysis
• D.Section access and sheet properties