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?
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 data architect is using an Include statement to load the collection of variables from a TextFiles folder connection into an app. The data architect needs to load the data and generate an error if it fails.
Which statement should the data architect use?
The MustInclude statement provides an error if the include fails and is used when including files in Qlik Sense. The other statements do not provide an error if the include fails.
qlik-sense-certification-exam-study-guide-en.pdf
https://www.qlik.com/us/-/media/files/training/global-us/qlik-sense-certification-exam-study-guide-en.pdf?la=en&hash=9DA9DEBC7D27BF1CA8373E81F2614C85
Talk to Experts Tuesday - Migrating from QlikView to Qlik Sense FAQ
https://community.qlik.com/t5/Support-Knowledge-Base/Talk-to-Experts-Tuesday-Migrating-from-QlikView-to-Qlik-Sense/ta-p/1746935
https://www.qlik.com/us/services/training/certifications-and-qualifications
Certifications & Qualifications | Qlik
https://www.qlik.com/us/services/training/certifications-and-qualifications
The $(Must_Include) statement is used to load a file or a set of files and generate an error if the load fails. The 'Must_Include' function will stop the script execution if the file is not found or cannot be loaded. The correct syntax for using the 'Must_Include' statement is $(Must_Include=lib://TextFiles/Variables.txt);
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 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)
