Test Online Free QlikView QSDA2022 Exam Questions and Answers
Practice a live sample before buying full access. This page keeps the free QSDA2022 question set organized by page so visitors and search engines can reach the canonical -questions.html URL directly.
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?
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 2Selectable Answer
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?
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 3Selectable Answer
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?
Answer:
Question 4Selectable Answer
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)
Answer:
Question 5Selectable Answer
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?
Answer:
Question 6Selectable Answer
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?
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 7Selectable Answer
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?
Answer:
Question 8Selectable Answer
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?
Answer:
Question 9Written Answer
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
Answer: B
Question 10Written Answer
Load all records from the key field from the database and use an INNER JOIN onthe previous table.
Answer: D
Question 11Selectable Answer
A data architect executes the following script.
Which values does the OrderDate field contain after executing the script?
Answer:
Question 12Selectable Answer
A data architect is developing an app that will generate QVDs for multiple business analysts. The field naming conventions on the source data are NOT business friendly. For every table loaded, multiple fields will require a name change.
An Excel file is maintained centrally that lists all source data field names and the appropriate names as they should appear in the QVDs
Which strategy should the data architect use to meet these requirements?
Answer: Explanation:
The Rename function allows the data architect to rename fields from the source data to the names specified in the Excel file. The mapping load allows the data architect to load the mapping between the source field names and the business-friendly names from the Excel file. The other options, Create master items using business-friendly names, Use the Alias function and a mapping load, and Load in the Excel file as a data island and use the Peek function, are not valid strategies for meeting these requirements.
Question 13Selectable Answer
Refer to the exhibit.
A data architect is loading two tables: Orders and Product. The Product table includes attributes and values for each ProductID such as Colour, Price, Category, and Description.
The business analyst can filter by the value of these attributes. For performance reasons, the Data Model will use two tables.
Which solution should the data architect apply in the Data Load Editor to build the ProductDetails table?
For performance reasons, the Data Model will use two tables a Load Editor to build the ProductDetails table?
Answer:
Question 14Selectable Answer
Refer to the exhibits.
The first table, Mastersports, contains the master list of all sport names that need to be loaded into the app. The second table, TeamMembers, containsthe teams and team members registered for specific sports.
In a Qlik Sense app, a data architect is loading the two tables that need to be linked together based on the Sport field. The table format cannot be changed in the source.
What should the dataarchitect do in the data load editor?
Answer:
Question 15Selectable Answer
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)
