QSDA2018 Online Practice Questions and Answers

Refer to the exhibits.

Which corrective action should be taken to achieve the expected view?

A. Alias one of the fields in the Orders table.

B. Use distinct in the LOAD statement.

C. Use Upper () to align the SalesPerson fields.

D. Add a link table.

Refer to the exhibit.

The data model shown has a synthetic key for information that contains actual sales and budget sales for a multi-national company. As a business requirement, users must be able to drill down by department and country. Data must not be lost. Due to data quality issues, some departments are NOT included in the Sales and Budget tables. The data architect needs a method to eliminate synthetic keys that generates the fastest performing data model.

Which method should the data architect use?

A. A link table to associate the two tables.

B. A forced concatenation statement.

C. Field aliases or comment out redundant fields.

D. A Left Join statement in the script.

Refer to the exhibit.

A data architect needs to transform the values for SalesYear from `Sales 2016' to display only the year values `2016' and `2017' in the table.

Which two functions can the data architect use to accomplish this in the script? (Choose two.)

A. Right(`$(vSalesSheet)' as SalesYear

B. Left($(vSalesSheet)' 4) as SalesYear

C. SubField($(vSalesSheet)',' `,2) as SalesYear

D. LTrim(`$(vSalesSheet)') as SalesYear

E. SubField($(vSalesSheet)',' `,1 ) as SalesYear

Refer to the exhibit.

A data architect is reviewing an app that is under development. The app as NOT been published. All data has been validated in all charts and KPIs. The data architect notices that the data model has two fact tables with common field names that cause a synthetic join.

Which step should the data architect take to correct the data model without affecting the app?

A. Concatenate LOAD the data from the Sales and Budget tables to combine into a single table.

B. Create a composite key in the Sales and Budget tables that consists of the Year, EmployeeID, and ProductID

C. Perform a composite key in the Sales and Budget tables instead of loading Year, EmployeeID, and ProductID

D. Perform a mapping load for the Employees table and use ApplyMap in the Sales and Budget tables.

Refer to the exhibit.

A QlikView app was converted to a Qlik Sense app using the Dev Hub converter.

The new Qlik Sense app was reloaded without editing the script or the server settings, which created a

script error.

What should a data architect do to resolve the issue?

A. Delete the Qualify statement

B. Add fields to the Qualify statement

C. Use a folder connection

D. Check the QVDs

A data architect has a QVD file that contains data from many countries. The data architect must write a script that loads only data from France, and make sure the reload occurs as fast as possible.

Which script should the data architect use to meet these requirements?

A. B. C.

D.

Refer to the exhibit.

A global company recently released an app that uses mush more memory than similar apps have used. When reviewing data in the data manager, the data architect observes that several fields use Globally Unique Identifiers (GUIDs).

There is one key field. other fields are used to different KPIs to count the number records. The data architect must reduce the memory used as much as possible.

Which steps should a data architect take to meet these requirements?

A. 1. Use the AutoNumber function to convert the linking GUIDs to numbers

2. Replace the non-key GUID fields with a flag, and use them to get a unique count for KPIs

B. 1. Replace the non-key field GUIDs with RowNo() to maintain a field that can be used to get a unique count

2. Split the linking GUID fields into five sections using the SubField function to reduce the uniqueness.

C. 1. Use the AutoNumber function to convert the linking GUIDs to numbers

2. Use Indexing for non-key GUID fields to create an Index field and use to get a unique count for KPIs

D. 1. Use the IterNo() function to convert the linking GUIDs to numbers

2. Replace the non-linking GUID fields with RowNo() to create an Index field and use to get a unique count for KPI

Refer to the exhibit.

A fashion retail company needs to analyze data product inventory. The company needs to filter by attributes by such as color, material, and size.

Which strategy should a data architect use to meet these requirements?

A. Turn data rows into fields by using a generic load

B. Use the hierarchy load statement to expand hierarchy levels

C. Use crosstable in the load statement to unpivot

D. Loop through the table to transpose fields

Refer to the exhibits.

The two tables have been loaded by the script shown. This script creates a synthetic key, which is not desired. The Dept code in the Employee table is incorrect for EmpID=3. The data architect must change line 27 to create a single table in the data model that is accurate.

Which LOAD statement should the data architect use?

A. JOIN LOAD EmpID, ManagerID, Level

B. KEEP LOAD EmpID, ManagerID, Level

C. JOIN LOAD *

D. CONCATENATE LOAD EmpID, ManagerID, Level

A data architect needs to develop three separate apps (Sales, Finance, and Operations). The three apps share numerous identical calculation expressions. The data architect wants to reduce duplicate script and stores it on a file server that Qlik Sense can access.

How should the data architect complete requirements?

A. Call batch file

B. Macro on server

C. Execute server script

D. Include script function