Question No : 1
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.APPLYMAP ( 'Associations , EmployeeKey ) as Employeekey;
• B.MAPSUBSTRING ( 'Associations' ,EMployeekey) As Employeekey;
• C.MAP EmloyeeKey USING Associations;
• D.RENAME FIELDS USING Associations;

Show Answers

Answer:
Explanation:
The MAP function maps the EmployeeKey in the Sales system to the EmployeeKey in the HR system using the Associations table. This allows the data architect to join the data from the Sales system and the HR system using the same key, ensuring that the associations are valid.
Using the MAP function also optimizes the performance of the data model as it eliminates the need for multiple joins between the data from the Sales and HR systems.
This solution also supports multiple tables added, as the MAP function can be applied to any table that needs to be joined with the HR system data.

Question No : 2
Refer to the exhibit.






While using an app, the users report that some Sales Reps do NOT have personal details, like Division or Address Number A data architect has been called in to investigate.
The data architect uses the data model viewer to determine the relationship between the SalesRepMaster and CustomerMaster tables.
What is the cause of the issue?

• A.26 values for Sales Rep are null in CustomerMaster
• B.40.7% of the Sales Rep have CustomerMaster information
• C.59.3% of the Sales Rep have CustomerMaster information
• D.Density is 100% while Total Distinct and Present Distinct are NOT the same

Show Answers

Answer:
Explanation:
When using the data model viewer to investigate the relationship between the SalesRepMaster and CustomerMaster tables, the data architect would look at the density of the relationship. Density is a measure of how well the key fields of a table match the key fields of another table. A density of 100% means that all key fields in one table have a match in the other table.
When the density is 100% but the total distinct and present distinct values for the key fields of the related tables do not match, it means that some of the key fields in one table do not have a match in the other table, this is the cause of the issue.

Question No : 3
A data architect needs to efficiently prepare a data model for a meeting in an hour.
The data source to be used contains five date fields. The app needs to display sales trends and compare the current year to date (CYTD) to last year to date (LYTD) The appis NOT going to be published It will only be used for this meeting and a single user's ad-hoc analysis.
What should the data architect do to meet these requirements?

• A.Use the data manager
• B.Load a calendar island
• C.Create a canonical calendar
• D.Create five master calendars

Show Answers

Answer:

Question No : 4
Refer to the exhibit.
A data architect is loading two tables into a data model from a SQL database These tables are related on key fields CustomerlD and CustomerKey.
Which script is valid to load the tables and maintain the correct association?
A)



B)



C)



D)

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

Show Answers

Answer:

Question No : 5
If the file exists, upload it Otherwise, skip to the next piece of code
The script will repeat this subroutine for each source. When the script ends, all uploaded files will be removed with a batch procedure.
Which option should the data architectuse to meet these requirements?

• A.FileSize, IF, THEN, END IF
• B.FilePath, IF, THE
• C.Drop
• D.FileExists, FOR EACH, IF
• E.FilePath, FOR EACH, Peek, Drop

Show Answers

Answer:

Question No : 6
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 existin 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?

• A.Two loopswithout any conditional statement
• B.One loop and two IF statements
• C.Two loops and one IF statement
• D.One loop and one SELECT CASE statement

Show Answers

Answer:
Explanation:
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 StoreAsFilenamevalue 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.htmandSELECT CASE statement
here: https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Scripting/ScriptStatements/Select.htm

Question No : 7
A global retailer has a large database in which millions of sales transactions are added per hour.
Each regional sales manager should only see details for customers in their region. After filtering based on criteria such as region, gender, and income level, sales managers should be able to see the most current detailed transactions.
What should a data architect do to meet these requirements?

• A.Create an app for each sales manager with Qlik GeoAnalytics
• B.Use section access and include aservice account in the table
• C.Use On-Demand App Generation (ODAG) and section access
• D.Use section access to restrict sales manager access by region

Show Answers

Answer:

Question No : 8
Refer to the exhibit.



A business analyst reports that the 'CompanyAge' field does NOT display for users. The data architect examines the LOAD script and wants to place the breakpoint in the script to check the field name.
Which line number should the data architect use?

• A.242 because field name appears in the output Panel of the debugger
• B.251 because the field name appears in the Variable panel of the debugger
• C.251 because the field name appears in the Qlik Log files
• D.251 because the field name appears in the Output panel of the debugger

Show Answers

Answer:

Question No : 9
Refer to the exhibit.



A data architect needs to modify the script to ONLY load rows from Table_B when Field_1 and Field_2 are the same as in Table_A. (For example, only the row containing A, 1, 456 should be loaded from Table_B.)
Which script should the data architect use?
A)



B)



C)



D)



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

Show Answers

Answer:B

Question No : 10
Load all records from the key field from the database and use an INNER JOIN onthe previous table.

Show Answers

Answer:D