Question No. 1

Refer to the exhibit.

A data architect is working with an app and creates some visualizations to check the dat

a. Some visualizations show issues in the data set.

* The Sales by Country table shows a total OrderValue of 18,300 sales while the KPI shows a total OrderValue of 20,600.

* The Sales monthly trend bar chart does not work with the Month field.

Which two data issues should the data architect fix in the app? (Select two.)

AThe Month field does not exist in the Orders table and needs to be incorporated in the table using he Calendar table.

BIn the Orders table, some CustomerlD values are null because there are orders with no customer.
and needs to be incorporated in the table using the Calendar table, null because there are orders with no customer

CIn the Orders table, some values in the CustomerlD field do not exist in the Customers table.

DThe OrderDate field values in the Calendar table do not match with the values in the OrderDate field from the Orders table

Show Answer

Correct Answer: C, D

Question No. 2

A data architect needs to develop a script to export tables from a model based upon rules from an independent file. The structure of the text file with the export rules is as follows:

These rules govern which table in the model to export, what the target root filename should be, and the number of copies to export.

The TableToExport values are already verified to exist in the model.

In addition, the format will always be QVD, and the copies will be incrementally numbered.

For example, the Customer table would be exported as:

What is the minimum set of scripting strategies the data architect must use?

ATwo loops without any conditional statement

BOne loop and two IF statements

CTwo loops and one IF statement

DOne loop and one SELECT CASE statement

Show Answer

Correct Answer: D

The data architect will need to use a single loop to iterate through the rows of the independent file containing the export rules. Within the loop, they will need to use a SELECT CASE statement to determine which table in the model to export based on the TableToExport value in the current row of the independent file. They can then use the StoreAsFilename value to determine the target root filename, and the NumberOfCopies value to determine the number of copies to export.

This approach makes use of a single loop to iterate through the rows of the independent file, and a SELECT CASE statement to determine which table to export based on the TableToExport value in the current row. It is the most efficient way to accomplish the task with minimal scripting.

You can find the Qlik scripting documentation for Store statement here: https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Scripting/ScriptPrefixes/Store.htm and SELECT CASE statement here: https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Scripting/ScriptStatements/Select.htm

Question No. 3

A data architect is building a model to show trends in visualizations across seven date fields. The seven date fields reside in different tables. The data architect must efficiently build this data model.

Requirements:

* A single date selector

* Show all dates, even those with NO activity

* Minimize the impact on server resources and p

Which two solutions should the data architect use? (Select two.)

ACanonical calendar

BGeneric load

CData island

DMultiple calendars

ELink table

Show Answer

Correct Answer: A, E

A canonical calendar should be used to create a single date selector that can be used to show all dates, even those with no activity. A link table should be used to join the seven date fields from different tables, which will minimize the impact on server resources and performance. Source: Qlik

Question No. 4

Refer to the exhibit.

Refer to the exhibits.

An app is built to analyze salesperson performance by department. Departments are unique within the Departments table, but Salespeople often move between departments. A strict business rule states that a salesperson must be associated with ONLY one department at all times.

The data architect creates a summary of department performance and notices the values are incorrect. The total sales KPI shows the correct result.

How should the data architect modify the data model to correct this issue?

ACreate a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship

BCreate a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship

CJoin the Departments and Salespeople tables to resolve the many-to-many relationship

DJoin the Transactions and Salespeople tables to resolve the many-to-many relationship

Show Answer

Correct Answer: A

Question No. 5

A data architect wants to combine data on present and historic sales performance. The historic data is stored in a de-normalized archive, and the present data is maintained in a database. The output must be contained in a single table.

Which script should the data architect use?

A)