Free QSDA2021 Exam Files Downloaded Instantly 100% Dumps & Practice Exam
Free Exam Updates QSDA2021 dumps with test Engine Practice
NEW QUESTION # 24
Refer to the exhibit.
A data architect is working on a Qlik Sense app the business has created to analyze the company orders and shipments. To understand the table structure, the business has given the following summary:
* Every order creates a unique orderlD and an order date in the Orders table
* An order can contain one or more order lines one for each product ID in the order details table
* Products in the order are shipped (shipment date) as soon as tliey are ready and can be shipped separately
* The dates need to be analyzed separately by Year Month, and Quarter
The data architect realizes the data model has issues that must be fixed.
Which steps should the data architect perform?
- A. 1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Shipments table
2. Delete the ShipmentID in the Orders table
3 Delete the ProductID and OrderlD in the Shipments table
4. Concatenate Orders and OrderDetails - B. 1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Orders table
2. Delete the ShipmentID in the Shipments table
3. Delete the ProductID and OrderlD in the OrderDetails table
4. Concatenate Orders and OrderDetails
5. Create a link table using the MasterCalendar table and create a concatenated field between OrderDate and ShipmentDate - C. 1. Create a key with OrderlD and ProductID in the OrderDeta Is table and in the Shipments table
2. Delete the ShipmentID in the Orders table
3. Delete the ProductID and OrderlD in the Shipmi
4. Left join Orders and OrderDetails
5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate - D. 1. Create a key with OrderlD and ProductID in the OrderDetails tab e and in the Orders table
2. Delete the ShipmentID in the Shipments table
3. Delete the ProductID and OrderlD in the OrderDetails
4. Left join Orders and OrderDetails
5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate
Answer: A
NEW QUESTION # 25
Refer to the exhibit.
Refer to the exhibit
A data architect is working on an app that contains orders, invoices, and shipping dat a. There are three different date fields within the data:
* OrderDate
* InvoiceDate
* ShippingDate
The business analyst needs to replicate the chart above to show Order and Shipping amounts on the same Month axis.
What should the data architect do?
- A. Left Join the three date fields onto one bridge table using the key field containing KeyField and Date
- B. Load the key field and the three date fields into a concatenated bridge table that contains KeyField and Date
- C. Create a Month field for each of the three dates in the fact table and use that in the chart
Answer: B
NEW QUESTION # 26
A data architect needs to write the expression for a measure on a KPI to show the sales person with the highest sales The sort order of the values of the fields is unknown When two or more sales people have sold the same amount, the expression should return all of those sales people Which expression should the data architect use?
- A. Concat (DISTINCT IF (Aggr (Rank (Sum (Sales) , 1) , Salesperson) =1, Salesperson) , ' ')
- B. Concat(DISTINCT IF (Aggr (Rank (Sum (Sales) , 4) , Salesperson) =1, Salesperson) , ' ')
- C. FirstSortedValue (Salesperson, -Aggr (Sum(Sales) , Salesperson) )
- D. FirstSortedValue (DISTINCT Salesperson, -Aggr (Sum(Sales) , Salesperson) )
Answer: A
NEW QUESTION # 27
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. MAP EmloyeeKey USING Associations;
- C. MAPSUBSTRING ( 'Associations' ,EMployeekey) As Employeekey;
- D. RENAME FIELDS USING Associations;
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 # 28
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. Use the data manager
- C. Create five master calendars
- D. Create a canonical calendar
Answer: D
NEW QUESTION # 29
A data architect needs to build an Order Fulfillment app. The business requires front-end performance is optimized.
The OrderDate and ShipmentDate are located in different tables.
The user needs to identify the data type and must be able to:
* Show trends for orders and shipments
* Use a single filter for both date fields
* Analyze data over fiscal periods
Which steps should the data architect take to build the data model?
- A. 1. Load the Shipments and Orders table via the data manager
2. Create a single filter using fields from the Orders table - B. 1. Create a link table with master calendar fields
2. Create a single filter using fields from the master calendar - C. 1. Create a master calendar and join into the Shipments and Orders table
2. Create a single filter using fields from the Shipments table - D. 1. Create a master calendar table as a data island
2. Create a single filter using fields from the master calendar
Answer: B
NEW QUESTION # 30
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 a selection app with all the master items and use an on-demand app generation method.
- B. Create a variable repository and load them using INCLUDE statements in the apps where needed
- C. Create only a single app with all the master items needed and protect it with SECTION ACCESS.
- D. Create a core app with all the master items needed and use a BINARY load in the other apps.
Answer: B
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 # 31
A data architect needs to revise an existing app.
The number of data rows has grown rapidly recently. While the app is in production, users are becoming increasingly unhappy about the response times when they make selections Which two methods should be used to improve performance? (Select two.)
- A. Denormalize the schema
- B. Use flags in the data model to simplify set analysis
- C. Create master items for all complex expressions
- D. Make sure any Ul variables are preceded by '='
- E. Use dynamic script generation with variables
Answer: B,E
NEW QUESTION # 32
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. MID ( SUBFIELD (Key , ' ', 2), 3)
- B. LTRIM (SUBFIELD (Key, ' ', 2), 2)
- C. RIGHT(SUBFIELD (Key,' ', 2), 3)
- D. LEFT(SUBFIELD(Key, ' ', 2), 2)
Answer: D
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 # 33
A data architect needs to add the UnitCost field from the ProductCost table in the Dim_Products Table.
Which script code should the data architect use?
- A.
- B.
- C.
- D.
Answer: A
NEW QUESTION # 34
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 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 - B. 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 - C. 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 - D. 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
Answer: C
NEW QUESTION # 35
A data architect needs to arrange data to create an app with a map where multiple location points consolidate into hexagonal areas based on postal codes The areas will be color coded based on the number of vendors in the location.
Which GeoAnalytics operation should the data architect use?
- A. AddressLookup
- B. Binning
- C. Intersect
- D. Simplify
Answer: B
Explanation:
Binning is a GeoAnalytics operation that can be used to arrange data into hexagonal areas based on postal codes. The areas can then be color coded based on the number of vendors in the location. Source: Qlik Binning is a GeoAnalytics operation that allows data points to be grouped into hexagonal areas based on a geographic field, such as postal codes. The data architect can use binning to group the location points by postal code and then color code the resulting hexagonal areas based on the number of vendors in each location.
This operation is useful for visualizing spatial data and identifying patterns or trends in the data.
NEW QUESTION # 36
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. Remove the rename statement (line 24) in the ProductPriceList table leaving the Product field name as is.
- B. Rename the Category field in the ProductPriceLis table to PnceCategory (line 24).
- 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: B
NEW QUESTION # 37
Refer to the exhibit.
While performing a data load from the source shown, the data architect notices it is NOT appropriate for the required analysis.
The data architect runs the following script to resolve this issue:
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
NEW QUESTION # 38
A data architect needs to load Table_A from an Excel file and sort the data by Field_2.
Which script should the data architect use?
A)
B)
C)
D)
- A. Option D
- B. Option C
- C. Option B
- D. Option A
Answer: A
NEW QUESTION # 39
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 to restrict sales manager access by region
- C. Use section access and include a service account in the table
- D. Use On-Demand App Generation (ODAG) and section access
Answer: B
NEW QUESTION # 40
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?
- A. Create a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship
- B. Create a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship
- C. Join the Departments and Salespeople tables to resolve the many-to-many relationship
- D. Join the Transactions and Salespeople tables to resolve the many-to-many relationship
Answer: B
NEW QUESTION # 41
Users of a published app report incomplete visualizations. The data architect checks the app multiple times and cannot replicate the error. The error affects only one team.
What is the most likely cause?
- A. An Omit field has been applied
- B. A security rule has been applied to the sheet object
- C. Section access restricts too many records
- D. The affected users were NOT added to the Section table
Answer: C
Explanation:
Section access restricts access to certain records, and if too many records are restricted, it can lead to incomplete visualizations. Source: Qlik Section access is used to control access to the data in an app. If the section access settings are too restrictive, they can prevent certain users or teams from seeing all of the data they need, resulting in incomplete visualizations.
It is possible that the affected team has been assigned a section access that is too restrictive, preventing them from seeing all of the necessary data. This could be a misconfiguration or an oversight in the section access settings.
NEW QUESTION # 42
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. 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
- B. OUTER JOIN the calendar with the currency conversion table
ORDER BY the date and use the PEEK function to fill in blank values - C. Use ITERNO and AUTOGENERATE to create a new calendar from max and min dates of the currency conversion table
- D. Utilize INTERVALMATCH to load the currency conversion rate between dates the conversation changed INNER JOIN the resultant table back into the master calendar
Answer: B
NEW QUESTION # 43
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 Concatenate before loading the Stores table
- B. Use where exists (ID, StorelD)
- C. Use where exists (ID)
Answer: C
NEW QUESTION # 44
......
Provide Valid Dumps To Help You Prepare For Qlik Sense Data Architect Certification Exam - February 2021 Release Exam: https://www.troytecdumps.com/QSDA2021-troytec-exam-dumps.html
Updated Verified QSDA2021 dumps Q&As - 100% Pass Guaranteed: https://drive.google.com/open?id=1M09eBAZZI6VI1fKyuKZkRD-9fm6XJRyL