A data architect needs to retrieve data from a REST API. The data architect needs to loop over a series of items that are being read using the REST connection. What should the data architect do?
Correct Answer: B
When retrieving data from a REST API, particularly when the dataset is large or the data is segmented across multiple pages (which is common in REST APIs), the REST Connector in Qlik Sense needs to be configured to handle pagination. Pagination is the process of dividing the data retrieved from the API into pages that can be loaded sequentially or as required. Qlik Sense's REST Connector supports pagination by allowing the dataarchitect to set parameters that will sequentially retrieve each page of data, ensuring that the complete dataset is retrieved. Key Steps: * REST Connector Setup: Configure the REST connector in Qlik Sense and specify the necessary API endpoint. * Pagination Mechanism: Use the built-in pagination mechanism to define how the connector should retrieve the subsequent pages (e.g., by using query parameters like page or offset).
QSDA2024 Exam Question 17
Refer to the exhibits. 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. The script runs successfully but the resulting table is not correct. What should the data architect do?
Correct Answer: D
In this scenario, the issue arises from using the applymap() function to normalize the country field values, but the result is incorrect. The reason is most likely related to the values in the source mapping table not matching the values in the Fact_Table properly. The applymap() function in Qlik Sense is designed to map one field to another using a mapping table. If the source values in the mapping table are inconsistent or incorrect, the applymap() will not function as expected, leading to incorrect results. Steps to resolve: * Review the mapping table (MAP_COUNTRY): The country field in the CountryTable contains values such as "U.S.", "US", and "United States" for the same country. To correctly normalize the country names, you need to ensure that all variations of a country's name are consistently mapped to a single value (e.g., "USA"). * Apply Mapping: Review and clean up the mapping table so that all possible variants of a country are correctly mapped to the desired normalized value. Key References: * Mapping Tables in Qlik Sense: Mapping tables allow you to substitute field values with mapped values. Any mismatches or variations in source values should be thoroughly reviewed. * Applymap() Function: This function takes a mapping table and applies it to substitute a field value with its mapped equivalent. If the mapped values are not correct or incomplete, the output will not be as expected.
QSDA2024 Exam Question 18
A data architect needs to load data from two different databases. Additional data will be added from a folder that contains QVDs, text files, and Excel files. What is the minimum number of data connections required?
Correct Answer: B
In the scenario, the data architect needs to load data from two different databases, and additional data is located in a folder containing QVDs, text files, and Excel files. Minimum Number of Data Connections Required: * Database Connections: * Each database requires a separate data connection. Therefore, two data connections are needed for the two databases. * Folder Connection: * A single folder data connection can be used to access all the QVDs, text files, and Excel files in the specified folder. Qlik Sense allows you to create a folder connection that can access multiple file types within that folder. Total Connections: * Two Database Connections: One for each database. * One Folder Connection: To access the QVDs, text files, and Excel files. Therefore, the minimum number of data connections required istwo.
