QSDA2021 Free Certification Exam Easy to Download PDF Format 2023
Get 100% Success with Latest Qlik Sense Data Architect QSDA2021 Exam Dumps
Qlik QSDA2021 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
NEW QUESTION 27
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.)
- A. The OrderDate field values in the Calendar table do not match with the values in the OrderDate field from the Orders table
- B. In 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 - C. The Month field does not exist in the Orders table and needs to be incorporated in the table using he Calendar table.
- D. In the Orders table, some values in the CustomerlD field do not exist in the Customers table.
Answer: A,D
NEW QUESTION 28
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)
B)
C)
D)
- A. Option B
- B. Option A
- C. Option C
- D. Option D
Answer: C
NEW QUESTION 29
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.
Answer: B
NEW QUESTION 30
Refer to the exhibit.
A data architect is loading the tables and a synth key is generated.
How should the data architect resolve the synthetic key?
- A. Create a composite key using OrderlD and LineNo. and remove OrderlD and LineNo from Shipments
- B. Create a composite key using OrdertD and LineNo
- C. Remove the LineNo field from Shipments and use the AutoNumber function on the
- D. Remove the LineNo field from both tables and use the AutoNumber function on the OrderlC field
Answer: A
NEW QUESTION 31
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 app is 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. Load a calendar island
- B. Create five master calendars
- C. Use the data manager
- D. Create a canonical calendar
Answer: D
NEW QUESTION 32
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. MAP EmloyeeKey USING Associations;
- C. MAPSUBSTRING ( 'Associations' ,EMployeekey) As Employeekey;
- D. APPLYMAP ( 'Associations , EmployeeKey ) as Employeekey;
Answer: B
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.
NEW QUESTION 33
Refer to the exhibits.
Some business users created an app by using the Add data functionality and loading two Excel files Orders and Customers.
The app is used to analyze the number of orders by customer. When the users create a bar chart to review the figures, the data shown is incorrect.
What should the data architect do to resolve this issue?
- A. Open the data load editor and use JOIN instead of concatenate to combine Orders and Customers by CustomerlD
- B. Open the data manager, split the Customers table, and associate both tables on CustomerlD field
- C. Open the data load editor and apply a NOCONCATENATE function in the LOAD statement on the Orders table
- D. Open the data manager, split the Customers table, and JOIN Orders and Customers on the CustomerlD field
Answer: A
NEW QUESTION 34
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.)
- A. Canonical calendar
- B. Generic load
- C. Multiple calendars
- D. Link table
- E. Data island
Answer: A,D
Explanation:
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
NEW QUESTION 35
Refer to the exhibit.
A data architect must classify each product into a price group. The price groups must be the same width by default and allow users to dynamically change the width of the bucket during analysis.
Which feature should the data architect use to meet these requirements?
- A. IntervalMatch and use variables
- B. Class function in a calculated dimension
- C. Class function in the script and use variables
- D. Nested IFs in a calculated dimension
Answer: B
NEW QUESTION 36
Refer to the exhibit.
On executing a load script of an app, the country field needs to be normalized. The developer uses a mapping table to address the issue.
What should the data architect do?
- A. Use LOAD DISTINCT on the mapping table
- B. Create two different mapping tables
- C. Use a LEFT JOIN instead of the APPLYMAP
- D. Review the values of the source mapping table
Answer: D
NEW QUESTION 37
The Marketing department is using some similar KPIs in different apps that need to be modified frequently according to the business needs. The KPIs are created using master items with the same expression.
Which method should the data architect use to manage the modifications in all apps?
- A. Create only a single app with all the master items needed and protect it with SECTION ACCESS.
- B. Create a selection app with all the master items and use an on-demand app generation method.
- C. Create a core app with all the master items needed and use a BINARY load in the other apps.
- D. Create a variable repository and load them using INCLUDE statements in the apps where needed
Answer: D
Explanation:
This method allows the data architect to store the KPIs in a single repository and then use INCLUDE statements to load them into the other apps. This makes it easy to modify the KPIs in one place and have the changes reflected in all the apps. Source: Qlik A variable repository is a central location where all of the master items used in the apps can be stored and managed. By creating a variable repository and loading the master items into each app using INCLUDE statements, the data architect can make modifications to the master items in one place, and the changes will be automatically propagated to all of the apps that use the master items.
This method allows for easy management of the master items and eliminates the need to make changes to each app individually, which can be time-consuming and prone to errors.
NEW QUESTION 38
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 section access
- B. Section access and sheet properties
- C. QMC security rules and custom properties
- D. Section access and set analysis
Answer: A
NEW QUESTION 39
Refer to the exhibits.
A business analyst needs to see the currency conversion provided by a third party process, and only contains a record when the rate changes in a chart. The currency conversion rate data is An existing master calendar exists in the data model that contains a full set of dates.
Which technique should the data architect use to meet this requirement?
- A. OUTER JOIN the calendar with the currency conversion table
ORDER BY the date and use the PEEK function to fill in blank values - B. Utilize INTERVALMATCH to load the currency conversion rate between dates the conversation changed INNER JOIN the resultant table back into the master calendar
- C. Use ITERNO and AUTOGENERATE to create a new calendar from max and min dates of the currency conversion table
- D. Leverage a FOR loop between the start date and end date of the master calendar Use the MATCH function to add the currency conversion rates to the master calendar
Answer: A
NEW QUESTION 40
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?
- A. Two loops and one IF statement
- B. One loop and one SELECT CASE statement
- C. One loop and two IF statements
- D. Two loops without any conditional statement
Answer: B
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 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
NEW QUESTION 41
Refer to the exhibit.
Refer to the exhibits.
The first table shows the source table (Original table).
This data represents the stocks stored every month for each product:
* The relevant fields are productid, qty, and date.
* The date field represents the calendar months using
* The qty field shows the product stock fluctuation from the current month versus the previous month. If there is no fluctuation between months, there are no new entries in the table.
The second table shows a Pivot table visualization the data analyst needs to create in the app displaying per each product the monthly trend of available stock.
For performance reasons, the data analyst requests the data architect to calculate the running stock quantity of each product for every month in the script.
Which approach should the data architect use?
- A. 1 Generate a Cartesian JOIN between productid and date in a Combined table
2 RIGHT JOIN the Combined table with the Original table to populate the missing qty values
3. Use PREVIOUS() and RANGESUMQ functions to create the running quantity totals for each product for every month - B. 1. Generate a Cartesian JOIN between productid and date in a Combined table
2. LEFT JOIN the Combined table with the Original table to populate the missing qty values
3. Use PREVIOUSO and SUM() functions to create the running quantity totals for each product for every month - C. 1. Generate a Calendar table with all dates between the minimum and maximum date values in an Original table
2. RIGHT JOIN the Calendar table back to the Original table to populate the missing qty values
3. Use PEEK() and RANGECOUNTO functions to create the running quantity totals for each product for every month - D. 1 Generate a Calendar table with all dates between the minimum and maximum date values in an Original table
2. LEFT JOIN the Calendar table back to the Original table to populate the missing qty values
Answer: D
NEW QUESTION 42
A data architect executes the following script:
What will Field_1 contain after this script is executed?
- A. Abcd, abcd
- B. abcd
- C. Abed, abed, ABCD
- D. Abed, abed, ABCD, ABCDABCD
Answer: C
NEW QUESTION 43
Refer to the exhibit.
A data architect is creating an app using three tables. After executing the script, a warning displays Which two steps should the data architect do to resolve this warning? (Select two.)
- A. Rename the Category field in the ProductPriceLis table to PnceCategory (line 24).
- B. Remove the rename statement (line 24) in the ProductPriceList table leaving the Product field name as is.
- C. Move the preceding Load statement in line 10 between table name (line 23) and Load statement (line 24).
- D. insert "Join (ProductDetails)" in front of the Load statement in line 24 to combine ProductPriceList with ProductDetails
Answer: A
NEW QUESTION 44
ITALY IT001 HR
GERMANY DE002 HR
SPAIN SP03 FINANCE
FRANCE FRO04 SALES
Refer to the exhibit
A company stores the employee data within a key composed of Country UserlD, and Department. These fields are separated by a blank space. The UserlD field is composed of two characters that indicate the country followed by a unique code of two or three digits. A data architect wants to retrieve only that unique code.
- A. LEFT(SUBFIELD(Key, ' ', 2), 2)
- B. RIGHT(SUBFIELD (Key,' ', 2), 3)
- C. LTRIM (SUBFIELD (Key, ' ', 2), 2)
- D. MID ( SUBFIELD (Key , ' ', 2), 3)
Answer: A
Explanation:
This expression will extract the unique code from the key by using the SUBFIELD function to separate the key into its components, and then using the LEFT function to extract the first two characters of the second component. Source: Qlik
NEW QUESTION 45
Refer to the exhibit.
Refer to the exhibit
A data architect develops an app for Coffee4all, a coffee company with stores located throughout Europe The script runs successfully, but the Stores table does not have any values.
What should the data architect do?
- A. Use where exists (ID)
- B. Use where exists (ID, StorelD)
- C. Use Concatenate before loading the Stores table
Answer: A
NEW QUESTION 46
Refer to the exhibit.
A company has different departments. Executive and Sales should always be the first values in a Department filter pane. Which script must the data architect use to meet this requirement?
A)
B)
C)
D)
- A. Option C
- B. Option B
- C. Option A
- D. Option D
Answer: D
NEW QUESTION 47
......
Get Ready to Pass the QSDA2021 exam Right Now Using Our Qlik Sense Data Architect Exam Package: https://pass4sures.free4torrent.com/QSDA2021-valid-dumps-torrent.html